Mailing lists [pgsql-performance]

1 May 2012

• 09:52   Re: Tuning Postgres 9.1 on Windows Walker, James Les
• 10:06   Re: Tuning Postgres 9.1 on Windows Merlin Moncure
• 10:14   Re: Tuning Postgres 9.1 on Windows Walker, James Les
• 10:42   Re: Tuning Postgres 9.1 on Windows Andy Colson
• 10:43   Re: Tuning Postgres 9.1 on Windows Merlin Moncure
• 11:34   Any disadvantages of using =ANY(ARRAY()) instead of IN? Clemens Eisserer
• 11:44   Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? Tom Lane
• 11:44   Re: Tuning Postgres 9.1 on Windows Walker, James Les
• 12:05   Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? Clemens Eisserer
• 13:45   Re: Tuning Postgres 9.1 on Windows Merlin Moncure
• 14:00   Re: Tuning Postgres 9.1 on Windows Thomas Kellerer
• 16:13   Re: Tuning Postgres 9.1 on Windows Walker, James Les
• 18:47   Re: Tuning Postgres 9.1 on Windows Walker, James Les

2 May 2012

• 10:19   Several optimization options (config/hardware) Martin Grotzke
• 11:57   Re: Several optimization options (config/hardware) Tomas Vondra
• 23:10   Re: Configuration Recommendations Jan Nielsen

3 May 2012

• 04:20   Re: query optimization Richard Kojedzinszky
• 04:20   Re: scale up (postgresql vs mssql) Eyal Wilde
• 04:20   Result Set over Network Question Ronald Hahn, DOCFOCUS INC.
• 04:20   Query got slow from 9.0 to 9.1 upgrade Josh Turmel
• 04:21   Re: Configuration Recommendations John Lister
• 04:26   Re: Several optimization options (config/hardware) Albe Laurenz
• 04:28   Re: Configuration Recommendations Robert Klemme
• 09:15   Re: Query got slow from 9.0 to 9.1 upgrade Ants Aasma
• 10:02   Re: Several optimization options (config/hardware) Martin Grotzke
• 10:05   Re: Query got slow from 9.0 to 9.1 upgrade Jonathan
• 10:14   Re: Configuration Recommendations Jan Nielsen
• 10:31   Re: Configuration Recommendations Jan Nielsen
• 10:40   Re: scale up (postgresql vs mssql) Merlin Moncure
• 10:42   Re: Configuration Recommendations Jan Nielsen
• 11:28   Re: Result Set over Network Question Claudio Freire
• 12:01   Re: Result Set over Network Question Merlin Moncure
• 12:28   Re: Result Set over Network Question Ronald Hahn, DOCFOCUS INC.
• 12:40   Re: Result Set over Network Question Merlin Moncure
• 12:42   Re: Query got slow from 9.0 to 9.1 upgrade Rural Hunter
• 12:46   Re: Configuration Recommendations Craig James
• 19:09   Re: Configuration Recommendations Scott Carey
• 19:17   Re: Configuration Recommendations Scott Carey

4 May 2012

• 04:58   Re: Several optimization options (config/hardware) Albe Laurenz
• 08:58   Re: Configuration Recommendations Shaun Thomas
• 08:58   Re: Configuration Recommendations Shaun Thomas
• 08:59   Re: scale up (postgresql vs mssql) Eyal Wilde
• 08:59   Re: Configuration Recommendations John Lister
• 10:04   Re: scale up (postgresql vs mssql) Merlin Moncure
• 10:19   Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? Clemens Eisserer
• 11:24   Unexpected sequence scan Dan Fairs
• 11:40   Re: Unexpected sequence scan Kevin Grittner
• 11:43   Re: Unexpected sequence scan Tom Lane
• 11:56   Re: Unexpected sequence scan Dan Fairs
• 12:01   Partitioned/inherited tables with check constraints causing slower query plans Richard Jones
• 12:07   Re: Configuration Recommendations Jan Nielsen
• 12:34   Re: Configuration Recommendations Kevin Grittner
• 13:31   Re: Configuration Recommendations Jeff Janes
• 13:39   Re: Partitioned/inherited tables with check constraints causing slower query plans Tom Lane
• 14:01   Re: Partitioned/inherited tables with check constraints causing slower query plans Richard Jones

7 May 2012

• 06:37   Re: Several optimization options (config/hardware) Martin Grotzke
• 09:04   Re: Result Set over Network Question Robert Klemme
• 09:10   Re: Result Set over Network Question Thomas Kellerer
• 10:44   Re: Result Set over Network Question Robert Klemme
• 11:24   Re: Result Set over Network Question Thomas Kellerer

8 May 2012

• 06:55   Re: Result Set over Network Question Robert Klemme
• 13:18   Re: Sudden Query slowdown on our Postgresql Server Robert Haas

9 May 2012

• 04:12   Re: scale up (postgresql vs mssql) Robert Klemme
• 09:53   Re: scale up (postgresql vs mssql) Merlin Moncure
• 10:07   Could synchronous streaming replication really degrade the performance of the primary? MauMau
• 10:27   Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? Clemens Eisserer
• 10:58   Re: Could synchronous streaming replication really degrade the performance of the primary? Merlin Moncure
• 12:41   Re: Could synchronous streaming replication really degrade the performance of the primary? Robert Klemme
• 12:46   Re: Could synchronous streaming replication really degrade the performance of the primary? Claudio Freire
• 14:03   Re: Could synchronous streaming replication really degrade the performance of the primary? Robert Klemme
• 15:58   Re: Could synchronous streaming replication really degrade the performance of the primary? Merlin Moncure
• 19:36   Re: Could synchronous streaming replication really degrade the performance of the primary? MauMau
• 19:47   Re: Could synchronous streaming replication really degrade the performance of the primary? Claudio Freire

10 May 2012

• 05:21   Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? Noah Misch
• 08:36   Re: Could synchronous streaming replication really degrade the performance of the primary? MauMau
• 09:09   Re: Could synchronous streaming replication really degrade the performance of the primary? Thomas Kellerer
• 09:20   Re: Could synchronous streaming replication really degrade the performance of the primary? Tomas Vondra
• 10:24   Re: Could synchronous streaming replication really degrade the performance of the primary? Merlin Moncure
• 12:12   Re: Could synchronous streaming replication really degrade the performance of the primary? MauMau
• 15:03   Re: Could synchronous streaming replication really degrade the performance of the primary? Fujii Masao

11 May 2012

• 07:50   Maximum number of sequences that can be created Vidhya Bondre
• 07:56   Re: Maximum number of sequences that can be created Robert Klemme
• 10:21   Re: Could synchronous streaming replication really degrade the performance of the primary? MauMau

12 May 2012

• 10:01   ... Jessica Richard

13 May 2012

• 05:13   Re: Maximum number of sequences that can be created Віталій Тимчишин
• 07:56   Re: Maximum number of sequences that can be created Robert Klemme
• 11:35   Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? Clemens Eisserer
• 13:01   Re: Maximum number of sequences that can be created Craig James
• 19:01   Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? Noah Misch

14 May 2012

• 19:50   Re: Maximum number of sequences that can be created Jeff Janes

15 May 2012

• 03:29   Re: Maximum number of sequences that can be created Віталій Тимчишин
• 07:58   Re: Maximum number of sequences that can be created Andres Freund
• 08:46   Re: Maximum number of sequences that can be created Robert Klemme
• 12:21   SSD selection Віталій Тимчишин
• 14:08   Re: SSD selection David Boreham
• 14:22   Re: SSD selection Merlin Moncure
• 14:59   Re: Configuration Recommendations Greg Sabino Mullane
• 15:16   Re: SSD selection Rosser Schwarz
• 17:00   Re: SSD selection David Boreham
• 18:10   Re: [pgsql-performance] Daily digest v1.3606 (10 messages) John Lister
• 18:52   Re: [pgsql-performance] Daily digest v1.3606 (10 messages) Merlin Moncure

16 May 2012

• 06:36   Re: Configuration Recommendations Robert Klemme
• 14:01   Re: SSD selection Merlin Moncure
• 14:46   Re: SSD selection David Boreham
• 15:53   Re: SSD selection Merlin Moncure
• 16:01   Re: SSD selection Alejandro Carrillo

17 May 2012

• 14:55   Re: Configuration Recommendations Jan Nielsen

19 May 2012

• 12:48   Re: Configuration Recommendations Jan Nielsen
• 16:12   Re: Configuration Recommendations Jan Nielsen

21 May 2012

• 11:18   local-storage versus SAN sequential read performance comparison Jan Nielsen
• 12:41   Re: local-storage versus SAN sequential read performance comparison Scott Marlowe
• 12:50   Re: local-storage versus SAN sequential read performance comparison Shaun Thomas

24 May 2012

• 00:39   High load average in 64-core server , no I/O wait and CPU is idle Rajesh Kumar. Mallah
• 00:54   Re: High load average in 64-core server , no I/O wait and CPU is idle Claudio Freire
• 02:00   Re: Configuration Recommendations Mark Kirkwood
• 02:27   Re: High load average in 64-core server , no I/O wait and CPU is idle Rajesh Kumar. Mallah
• 02:44   Re: High load average in 64-core server , no I/O wait and CPU is idle Claudio Freire
• 03:54   Re: High load average in 64-core server , no I/O wait and CPU is idle Rajesh Kumar. Mallah
• 04:07   pg_dump and thousands of schemas Hugo
• 09:48   Re: High load average in 64-core server , no I/O wait and CPU is idle Andy Colson
• 09:58   Re: High load average in 64-core server , no I/O wait and CPU is idle Rajesh Kumar. Mallah
• 12:21   Re: pg_dump and thousands of schemas Craig James
• 12:54   Re: High load average in 64-core server , no I/O wait and CPU is idle Steve Crawford
• 12:57   Re: High load average in 64-core server , no I/O wait and CPU is idle Stephen Frost
• 13:40   Re: High load average in 64-core server , no I/O wait and CPU is idle Rajesh Kumar. Mallah
• 14:00   Re: High load average in 64-core server , no I/O wait and CPU is idle Rajesh Kumar. Mallah
• 14:09   Re: High load average in 64-core server , no I/O wait and CPU is idle Stephen Frost
• 15:23   Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? geirB
• 15:23   Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? geirB
• 17:10   Re: heavly load system spec Robert Haas
• 18:04   Re: heavly load system spec Stephen Frost
• 18:25   Re: heavly load system spec Merlin Moncure
• 18:30   Re: High load average in 64-core server , no I/O wait and CPU is idle Claudio Freire

25 May 2012

• 00:20   Re: pg_dump and thousands of schemas Jeff Janes
• 00:55   Re: pg_dump and thousands of schemas Bruce Momjian
• 01:54   Re: pg_dump and thousands of schemas Hugo
• 02:13   Re: pg_dump and thousands of schemas Ondrej Ivanič
• 08:58   Re: Maximum number of sequences that can be created Greg Spiegelberg
• 11:41   Re: pg_dump and thousands of schemas Tom Lane
• 12:04   Re: Maximum number of sequences that can be created Craig James
• 12:19   Re: pg_dump and thousands of schemas Bruce Momjian
• 12:40   Re: pg_dump and thousands of schemas Jeff Janes
• 12:52   Millions of relations (from Maximum number of sequences that can be created) Greg Spiegelberg
• 12:54   Re: pg_dump and thousands of schemas Jeff Janes
• 13:56   Re: pg_dump and thousands of schemas Tom Lane
• 14:41   Re: pg_dump and thousands of schemas Jeff Janes
• 17:03   Re: pg_dump and thousands of schemas Tom Lane
• 18:28   Re: pg_dump and thousands of schemas Jeff Janes
• 19:05   Parallel (concurrent) inserts? Ivan Voras
• 20:14   Re: Parallel (concurrent) inserts? Josh Berkus
• 20:37   Re: Parallel (concurrent) inserts? Jeff Janes
• 20:57   Re: Parallel (concurrent) inserts? Ivan Voras
• 22:19   Re: pg_dump and thousands of schemas Tatsuo Ishii

26 May 2012

• 18:39   Seqscan slowness and stored procedures Ivan Voras

27 May 2012

• 00:29   Re: Seqscan slowness and stored procedures Pavel Stehule
• 01:12   Re: pg_dump and thousands of schemas Hugo
• 12:58   Re: Seqscan slowness and stored procedures Ivan Voras
• 13:08   Re: Seqscan slowness and stored procedures Pavel Stehule

28 May 2012

• 09:14   Re: SSD selection Greg Smith
• 15:24   Recover rows deleted Alejandro Carrillo
• 18:24   Re: pg_dump and thousands of schemas Jeff Janes
• 19:26   Re: pg_dump and thousands of schemas Tom Lane

29 May 2012

• 02:21   Re: pg_dump and thousands of schemas Hugo
• 06:52   Re: pg_dump and thousands of schemas Tatsuo Ishii
• 11:54   Strong slowdown on huge tables Job
• 12:52   Re: pg_dump and thousands of schemas Tom Lane
• 14:43   Re: Strong slowdown on huge tables Tom Lane
• 17:53   Re: Recover rows deleted Jeff Davis
• 18:33   Re: Recover rows deleted hubert depesz lubaczewski
• 19:17   Re: Recover rows deleted Alejandro Carrillo
• 19:34   Re: Recover rows deleted Alejandro Carrillo
• 21:58   Re: pg_dump and thousands of schemas Tatsuo Ishii

30 May 2012

• 06:06   Re: pg_dump and thousands of schemas Tatsuo Ishii
• 14:58   does the query planner consider work_mem? Murat Tasan
• 15:26   Re: does the query planner consider work_mem? Ants Aasma
• 17:30   Re: does the query planner consider work_mem? Murat Tasan
• 21:21   Re: pg_dump and thousands of schemas Tatsuo Ishii

31 May 2012

• 00:54   Re: pg_dump and thousands of schemas Tom Lane
• 01:02   Re: pg_dump and thousands of schemas Stephen Frost
• 01:18   Re: pg_dump and thousands of schemas Tom Lane
• 02:29   Re: pg_dump and thousands of schemas Tatsuo Ishii
• 05:46   Re: pg_dump and thousands of schemas Tatsuo Ishii
• 10:38   Re: pg_dump and thousands of schemas Robert Klemme
• 11:08   Re: pg_dump and thousands of schemas Tatsuo Ishii
• 11:17   Re: pg_dump and thousands of schemas Robert Klemme
• 11:22   Re: pg_dump and thousands of schemas Claudio Freire
• 11:31   Re: [HACKERS] pg_dump and thousands of schemas Tom Lane
• 11:41   Re: [HACKERS] pg_dump and thousands of schemas Robert Haas
• 11:51   Re: [HACKERS] pg_dump and thousands of schemas Tom Lane
• 12:01   Re: [HACKERS] pg_dump and thousands of schemas Bruce Momjian
• 12:02   Re: [HACKERS] pg_dump and thousands of schemas Claudio Freire
• 12:04   Re: [HACKERS] pg_dump and thousands of schemas Robert Haas
• 12:07   Re: [HACKERS] pg_dump and thousands of schemas Bruce Momjian
• 12:25   Re: [HACKERS] pg_dump and thousands of schemas Tom Lane
• 12:34   Re: [HACKERS] pg_dump and thousands of schemas Claudio Freire
• 19:30   Trouble with plan statistics for behaviour for query. Trevor Campbell
• 19:55   Re: Trouble with plan statistics for behaviour for query. Craig James
• 19:59   Re: does the query planner consider work_mem? Mark Kirkwood
• 20:01   Re: Trouble with plan statistics for behaviour for query. Trevor Campbell
• 20:08   Re: Trouble with plan statistics for behaviour for query. Craig James
• 20:34   Re: Trouble with plan statistics for behaviour for query. Trevor Campbell
• 21:09   Re: Trouble with plan statistics for behaviour for query. Craig James