Home > mailing lists

Mailing lists [pgsql-performance]

1 May 2012

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

2 May 2012

13:19 Several optimization options (config/hardware) Martin Grotzke
14:57 Re: Several optimization options (config/hardware) Tomas Vondra

3 May 2012

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

4 May 2012

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

7 May 2012

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

8 May 2012

09:55 Re: Result Set over Network Question Robert Klemme
16:18 Re: Sudden Query slowdown on our Postgresql Server Robert Haas

9 May 2012

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

10 May 2012

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

11 May 2012

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

12 May 2012

13:01 ... Jessica Richard

13 May 2012

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

14 May 2012

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

15 May 2012

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

16 May 2012

09:36 Re: Configuration Recommendations Robert Klemme
17:01 Re: SSD selection Merlin Moncure
17:46 Re: SSD selection David Boreham
18:53 Re: SSD selection Merlin Moncure
19:01 Re: SSD selection Alejandro Carrillo

17 May 2012

17:55 Re: Configuration Recommendations Jan Nielsen

19 May 2012

15:48 Re: Configuration Recommendations Jan Nielsen
19:12 Re: Configuration Recommendations Jan Nielsen

21 May 2012

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

24 May 2012

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

25 May 2012

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

26 May 2012

01:19 Re: pg_dump and thousands of schemas Tatsuo Ishii
21:39 Seqscan slowness and stored procedures Ivan Voras

27 May 2012

03:29 Re: Seqscan slowness and stored procedures Pavel Stehule
04:12 Re: pg_dump and thousands of schemas Hugo
15:58 Re: Seqscan slowness and stored procedures Ivan Voras
16:08 Re: Seqscan slowness and stored procedures Pavel Stehule

28 May 2012

12:14 Re: SSD selection Greg Smith
18:24 Recover rows deleted Alejandro Carrillo
21:24 Re: pg_dump and thousands of schemas Jeff Janes
22:26 Re: pg_dump and thousands of schemas Tom Lane

29 May 2012

05:21 Re: pg_dump and thousands of schemas Hugo
09:52 Re: pg_dump and thousands of schemas Tatsuo Ishii
14:54 Strong slowdown on huge tables Job
15:52 Re: pg_dump and thousands of schemas Tom Lane
17:43 Re: Strong slowdown on huge tables Tom Lane
20:53 Re: Recover rows deleted Jeff Davis
21:33 Re: Recover rows deleted hubert depesz lubaczewski
22:17 Re: Recover rows deleted Alejandro Carrillo
22:34 Re: Recover rows deleted Alejandro Carrillo

30 May 2012

00:58 Re: pg_dump and thousands of schemas Tatsuo Ishii
09:06 Re: pg_dump and thousands of schemas Tatsuo Ishii
17:58 does the query planner consider work_mem? Murat Tasan
18:26 Re: does the query planner consider work_mem? Ants Aasma
20:30 Re: does the query planner consider work_mem? Murat Tasan

31 May 2012

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