pgsql-performance - July 2013

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 5 7 8 9 10 11 12 13 15 16 17 18 19 20 23 25 29 30 31

July 1, 2013

Thread Author Time
Re: 9.2.2 - semop hanging Rafael Domiciano 18:06

July 2, 2013

Thread Author Time
Fillfactor in postgresql 9.2 Niels Kristian Schjødt 11:27
Re: Fillfactor in postgresql 9.2 Albe Laurenz 11:45
Re: Fillfactor in postgresql 9.2 Pavan Deolasee 12:09

July 3, 2013

Thread Author Time
[OT] A flash filesystem tuning guide Andrea Suisani 07:01
My changes in the postgresql.conf does not work David Carpio 15:10
Re: My changes in the postgresql.conf does not work David Johnston 17:40

July 5, 2013

Thread Author Time
Dynamic queries in stored procedure Greg Jaskiewicz 13:57
Re: Dynamic queries in stored procedure Andrew Dunstan 14:26
Re: Dynamic queries in stored procedure Misa Simic 14:46
Re: Dynamic queries in stored procedure Scott Barney 14:50

July 7, 2013

Thread Author Time
How to properly index hstore tags column to faster search for keys Radu-Stefan Zugravu 07:28

July 8, 2013

Thread Author Time
Re: How to properly index hstore tags column to faster search for keys Richard Huxton 07:44
Re: How to properly index hstore tags column to faster search for keys Radu-Stefan Zugravu 08:31
Re: How to properly index hstore tags column to faster search for keys Richard Huxton 08:53
Re: How to properly index hstore tags column to faster search for keys Radu-Stefan Zugravu 09:20
Re: How to properly index hstore tags column to faster search for keys Richard Huxton 10:27
Re: How to properly index hstore tags column to faster search for keys Radu-Stefan Zugravu 11:01
Re: How to properly index hstore tags column to faster search for keys idc danny 12:16
Re: How to properly index hstore tags column to faster search for keys Yuri Levinsky 15:34
Performance autovaccum Jeison Bedoya 16:14
8.4 to 9.2 migration performance Tom Harkaway 16:21
Process in state BIND, authentication, PARSE Jeison Bedoya 16:22
Re: 8.4 to 9.2 migration performance bricklen 16:31
Re: Process in state BIND, authentication, PARSE Andrew Dunstan 16:40
Re: Process in state BIND, authentication, PARSE Jeison Bedoya 17:01
Re: [PERFORM] In progress INSERT wrecks plans on table Josh Berkus 17:11
Re: Performance autovaccum Michael Paquier 22:21
Re: Process in state BIND, authentication, PARSE Michael Paquier 22:35

July 9, 2013

Thread Author Time
Re: Process in state BIND, authentication, PARSE Merlin Moncure 13:23
Re: Performance autovaccum Josh Berkus 22:14

July 10, 2013

Thread Author Time
Re: Performance autovaccum Joshua D. Drake 00:41
Re: Performance autovaccum Rick Otten 13:12
Re: Process in state BIND, authentication, PARSE Kevin Grittner 13:37
Re: [PERFORM] In progress INSERT wrecks plans on table Josh Berkus 16:47

July 11, 2013

Thread Author Time
how to speed up the index creation in GP? Huang, Suya 02:03
Re: [PERFORM] In progress INSERT wrecks plans on table Abhijit Menon-Sen 05:09
Trying to eliminate union and sort Brian Fehrle 18:27

July 12, 2013

Thread Author Time
Re: Trying to eliminate union and sort Josh Berkus 00:46
Re: [PERFORM] In progress INSERT wrecks plans on table Josh Berkus 00:47
Re: [PERFORM] In progress INSERT wrecks plans on table Abhijit Menon-Sen 06:18
Re: Trying to eliminate union and sort Brian Fehrle 22:27
Re: Trying to eliminate union and sort Josh Berkus 22:43
Re: In progress INSERT wrecks plans on table Jeff Janes 22:47
Re: [PERFORM] In progress INSERT wrecks plans on table Jeff Janes 23:25

July 13, 2013

Thread Author Time
Re: [PERFORM] In progress INSERT wrecks plans on table Abhijit Menon-Sen 08:49
Re: [PERFORM] In progress INSERT wrecks plans on table 📎 Abhijit Menon-Sen 09:11
Re: In progress INSERT wrecks plans on table Ants Aasma 13:41
Re: In progress INSERT wrecks plans on table Jeff Janes 21:29

July 15, 2013

Thread Author Time
Re: how to speed up the index creation in GP? Sergey Konoplev 04:33
Re: Trying to eliminate union and sort Brian Fehrle 16:12
Thought you'd find this interesting Marcos Luis 17:00
Re: Trying to eliminate union and sort Marc Mamin 18:26

July 16, 2013

Thread Author Time
Hstore VS. JSON Niels Kristian Schjødt 15:05
Re: Hstore VS. JSON Andrew Dunstan 15:33
Re: Hstore VS. JSON Merlin Moncure 15:47
General key issues when comparing performance between PostgreSQL and oracle Brian Fehrle 16:51

July 17, 2013

Thread Author Time
Re: General key issues when comparing performance between PostgreSQL and oracle Samuel Gendler 03:01
Re: General key issues when comparing performance between PostgreSQL and oracle Scott Marlowe 04:14
Re: General key issues when comparing performance between PostgreSQL and oracle Tom Lane 04:51
Distributed transactions and asynchronous commit Xenofon Papadopoulos 07:18
Re: Trying to eliminate union and sort Vitalii Tymchyshyn 08:24
Re: Distributed transactions and asynchronous commit Vasilis Ventirozos 09:28
Re: Distributed transactions and asynchronous commit Giuseppe Broccolo 10:09
Re: Distributed transactions and asynchronous commit Xenofon Papadopoulos 10:52
Re: Distributed transactions and asynchronous commit Giuseppe Broccolo 11:16
Re: Distributed transactions and asynchronous commit Vasilis Ventirozos 11:21
Re: Distributed transactions and asynchronous commit Vasilis Ventirozos 11:26
Re: Distributed transactions and asynchronous commit Xenofon Papadopoulos 12:18
Seq Scan vs Index on Identical Tables in Two Different Databases Ellen Rothman 19:50
Re: Seq Scan vs Index on Identical Tables in Two Different Databases bricklen 20:11
Re: Seq Scan vs Index on Identical Tables in Two Different Databases David Johnston 21:14
Re: Seq Scan vs Index on Identical Tables in Two Different Databases David Kerr 21:40
Re: Seq Scan vs Index on Identical Tables in Two Different Databases Ellen Rothman 21:54
bgwriter autotuning might be unnecessarily penalizing bursty workloads Josh Berkus 22:46

July 18, 2013

Thread Author Time
Re: bgwriter autotuning might be unnecessarily penalizing bursty workloads Greg Smith 01:15
Re: PostgreSQL settings for running on an SSD drive Greg Smith 02:04
Re: Re: bgwriter autotuning might be unnecessarily penalizing bursty workloads Josh Berkus 17:40
Re: Re: bgwriter autotuning might be unnecessarily penalizing bursty workloads Jeff Janes 19:24
Re: PostgreSQL settings for running on an SSD drive Shaun Thomas 20:42
FTS performance issue - planner problem identified (but only partially resolved) Stefan Keller 23:39

July 19, 2013

Thread Author Time
Re: How to properly index hstore tags column to faster search for keys Stefan Keller 10:03
Re: FTS performance issue - planner problem identified (but only partially resolved) Stefan Keller 13:38
Fwd: Relatively high planner overhead on partitions? Skarsol 13:52
Re: Fwd: Relatively high planner overhead on partitions? Pavel Stehule 16:16
Re: FTS performance issue - planner problem identified (but only partially resolved) Marc Mamin 19:57
Re: FTS performance issue - planner problem identified (but only partially resolved) Stefan Keller 23:55

July 20, 2013

Thread Author Time
Re: FTS performance issue - planner problem identified (but only partially resolved) Marc Mamin 08:46

July 23, 2013

Thread Author Time
Fw: [osdldbt-general] Running DBT5 on remote database server amul sul 02:13

July 25, 2013

Thread Author Time
Re: Fw: [osdldbt-general] Running DBT5 on remote database server Samrat Revagade 13:03
How is memory allocated/used by Postgresql Database connections McKinzie, Alan (Alan) 13:23
Re: Fw: [osdldbt-general] Running DBT5 on remote database server sachin kotwal 13:26
Re: How is memory allocated/used by Postgresql Database connections Tom Lane 13:41
Re: How is memory allocated/used by Postgresql Database connections Jeff Janes 17:32

July 29, 2013

Thread Author Time
Re: FTS performance issue - planner problem identified (but only partially resolved) Kevin Grittner 20:28
Re: FTS performance issue - planner problem identified (but only partially resolved) Stefan Keller 23:29

July 30, 2013

Thread Author Time
to many locks held Jeison Bedoya 10:52
Re: to many locks held bricklen 14:48

July 31, 2013

Thread Author Time
Re: to many locks held Michael Paquier 05:18
PG performance issues related to storage I/O waits Tasos Petalas 11:58
Re: PG performance issues related to storage I/O waits Tomas Vondra 12:40
Re: Fw: [osdldbt-general] Running DBT5 on remote database server Greg Smith 16:02

Browse Archives

Prev | Next
Jump to day: 1 2 3 5 7 8 9 10 11 12 13 15 16 17 18 19 20 23 25 29 30 31