Home > mailing lists

Mailing lists [pgsql-performance]

1 March 2009

01:51 "slow" queries Brian Cox
02:15 Re: "slow" queries Robert Haas
02:33 Re: Bad plan for nested loop + limit Robert Haas
16:05 Re: "slow" queries Tom Lane
16:32 Re: TCP network cost Linos
16:43 Re: TCP network cost Tom Lane
16:57 Re: TCP network cost Linos
17:10 Re: TCP network cost Tom Lane
17:20 Re: TCP network cost Linos
17:28 Re: TCP network cost Tom Lane
17:40 Re: TCP network cost Magnus Hagander
17:52 Re: TCP network cost Linos
18:34 Re: "slow" queries Cox, Brian

2 March 2009

00:57 Re: "slow" queries Tom Lane
17:23 Re: "slow" queries Brian Cox
17:58 Re: "slow" queries Scott Carey
18:04 Re: "slow" queries Robert Haas
18:29 Re: "slow" queries Tom Lane
18:56 Re: "slow" queries Brian Cox
19:14 Re: "slow" queries Tom Lane
19:36 Re: "slow" queries Brian Cox
20:24 Re: "slow" queries Tim Bunce
20:59 Re: "slow" queries Scott Marlowe
23:18 Postgres 8.3, four times slower queries? Aaron Guyon

3 March 2009

02:24 Re: Postgres 8.3, four times slower queries? Tom Lane
11:12 Substring search using "exists" with a space in the search term Hans Liebenberg
16:05 Problems with ordering (can't force query planner to use an index) Sebastjan Trepca
16:12 Re: Problems with ordering (can't force query planner to use an index) Robert Haas
16:21 Re: Problems with ordering (can't force query planner to use an index) Sebastjan Trepca
16:31 Re: Postgres 8.3, four times slower queries? Aaron Guyon
16:35 Re: Problems with ordering (can't force query planner to use an index) David Wilson
16:39 Re: Postgres 8.3, four times slower queries? david@lang.hm
16:40 Re: Problems with ordering (can't force query planner to use an index) Sebastjan Trepca
16:41 Re: Problems with ordering (can't force query planner to use an index) Robert Haas
16:52 Re: Postgres 8.3, four times slower queries? Aaron Guyon
18:05 Re: Problems with ordering (can't force query planner to use an index) Sebastjan Trepca
18:24 Re: Problems with ordering (can't force query planner to use an index) Sebastjan Trepca
19:27 Re: Problems with ordering (can't force query planner to use an index) Robert Haas
20:27 Re: Problems with ordering (can't force query planner to use an index) Tom Lane
21:34 Re: Postgres 8.3, four times slower queries? Tom Lane
23:29 work_mem in high transaction rate database Flavio Henrique Araque Gurgel

4 March 2009

00:37 Re: work_mem in high transaction rate database Scott Marlowe
06:05 Re: work_mem in high transaction rate database Akos Gabriel
08:18 Re: work_mem in high transaction rate database Dimitri Fontaine
11:46 Re: work_mem in high transaction rate database Flavio Henrique Araque Gurgel
15:19 Long Running Commits Brad Nicholson
19:09 Re: work_mem in high transaction rate database Scott Carey
20:49 Re: work_mem in high transaction rate database Scott Marlowe
22:21 Re: Postgres 8.3, four times slower queries? Aaron Guyon
22:42 Re: Postgres 8.3, four times slower queries? Aaron Guyon
22:42 Re: Postgres 8.3, four times slower queries? Aaron Guyon

5 March 2009

12:22 Re: Postgres 8.3, four times slower queries? Robert Haas
17:14 Re: Postgres 8.3, four times slower queries? Robert Haas
17:17 Index scan plan estimates way off. Jonathan Hseu
17:21 Re: Postgres 8.3, four times slower queries? Aaron Guyon
17:33 Re: Index scan plan estimates way off. Tom Lane
17:57 Re: Postgres 8.3, four times slower queries? Kevin Grittner
18:15 Re: Postgres 8.3, four times slower queries? Robert Haas
18:58 Re: Postgres 8.3, four times slower queries? Aaron Guyon

6 March 2009

00:42 Re: Index scan plan estimates way off. Jonathan Hseu
01:33 Re: Index scan plan estimates way off. Robert Haas
14:50 Re: Postgres 8.3, four times slower queries? Aaron Guyon

9 March 2009

13:36 Query much slower when run from postgres function Mario Splivalo
14:28 DBT Presentation Location? Lee Hughes
16:31 Re: Query much slower when run from postgres function Tom Lane
16:51 Re: Query much slower when run from postgres function Guillaume Cottenceau
17:04 Re: [JDBC] Query much slower when run from postgres function Guillaume Smet
17:16 Re: [JDBC] Query much slower when run from postgres function Tom Lane
17:45 Re: [JDBC] Query much slower when run from postgres function Andreas Wenk
19:20 Re: Query much slower when run from postgres function Mario Splivalo
19:26 Re: Query much slower when run from postgres function Mario Splivalo
19:52 Re: Query much slower when run from postgres function Tom Lane
19:57 Re: [JDBC] Query much slower when run from postgres function Dave Cramer
20:45 Re: [JDBC] Query much slower when run from postgres function James Mansion
20:56 Re: [JDBC] Query much slower when run from postgres function Scott Carey
22:13 Re: Query much slower when run from postgres function Mario Splivalo
23:36 Re: Query much slower when run from postgres function Tom Lane

10 March 2009

00:57 Re: DBT Presentation Location? Mark Wong
03:39 Re: [JDBC] Query much slower when run from postgres function Scott Carey
14:09 When does sequential performance matter in PG? henk de wit
14:28 Re: When does sequential performance matter in PG? Matthew Wakeling
14:51 Re: Query much slower when run from postgres function fche@redhat.com (Frank Ch. Eigler)
14:57 Re: When does sequential performance matter in PG? henk de wit
17:20 Re: Query much slower when run from postgres function Tom Lane
17:50 Re: When does sequential performance matter in PG? Greg Smith
18:01 Re: When does sequential performance matter in PG? Scott Carey
21:17 Query performance over a large proportion of data Steve McLellan
21:57 Re: Query performance over a large proportion of data Scott Marlowe
22:06 Re: Query performance over a large proportion of data Kevin Grittner
23:19 Re: Query performance over a large proportion of data Scott Marlowe

11 March 2009

00:09 Re: Query performance over a large proportion of data Tom Lane
00:19 Re: Query performance over a large proportion of data Tom Lane
03:21 Re: Query performance over a large proportion of data Steve McLellan
03:23 Re: Query performance over a large proportion of data Steve McLellan
03:37 Re: Query performance over a large proportion of data Steve McLellan
04:54 Re: Query performance over a large proportion of data Scott Marlowe
14:56 random_page_cost vs ssd? Jeff
15:38 Re: random_page_cost vs ssd? Grzegorz Jaśkiewicz
17:06 Re: random_page_cost vs ssd? Scott Carey
19:04 Re: random_page_cost vs ssd? Andrej
19:27 Full statement logging problematic on larger machines? Frank Joerdens
19:29 Re: random_page_cost vs ssd? Scott Carey
19:32 Re: random_page_cost vs ssd? hubert depesz lubaczewski
19:41 Re: random_page_cost vs ssd? Kevin Grittner
19:41 Re: Full statement logging problematic on larger machines? Scott Marlowe
20:31 Re: random_page_cost vs ssd? Scott Carey
20:46 Re: Full statement logging problematic on larger machines? Tom Lane
21:48 Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
22:27 Re: Proposal of tunable fix for scalability of 8.4 Kevin Grittner
22:42 Re: Full statement logging problematic on larger machines? Frank Joerdens
23:59 Re: Full statement logging problematic on larger machines? Guillaume Smet

12 March 2009

00:55 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
01:32 Re: Proposal of tunable fix for scalability of 8.4 Tom Lane
01:47 Re: Full statement logging problematic on larger machines? Tom Lane
02:02 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
02:20 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
02:51 Re: Proposal of tunable fix for scalability of 8.4 Tom Lane
03:48 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
07:56 Re: Full statement logging problematic on larger machines? Guillaume Smet
10:55 Entry point for Postgresql Performance Nagalingam, Karthikeyan
11:10 Re: Entry point for Postgresql Performance Ashish Karalkar
13:39 Re: Full statement logging problematic on larger machines? Frank Joerdens
13:48 Re: Full statement logging problematic on larger machines? Dimitri Fontaine
14:08 Re: Proposal of tunable fix for scalability of 8.4 Kevin Grittner
15:01 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
15:13 Re: Proposal of tunable fix for scalability of 8.4 Kevin Grittner
15:31 Re: Proposal of tunable fix for scalability of 8.4 Grzegorz Jaśkiewicz
15:44 Re: Proposal of tunable fix for scalability of 8.4 Kevin Grittner
17:09 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
17:10 Re: Proposal of tunable fix for scalability of 8.4 Gregory Stark
17:39 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
17:41 Re: Entry point for Postgresql Performance Rajesh Kumar Mallah
17:48 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
17:53 Re: Proposal of tunable fix for scalability of 8.4 Tom Lane
17:53 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
18:08 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
18:09 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
18:28 Re: Proposal of tunable fix for scalability of 8.4 Tom Lane
18:33 Re: Proposal of tunable fix for scalability of 8.4 Ron
18:41 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
19:11 Re: Proposal of tunable fix for scalability of 8.4 Alvaro Herrera
19:26 Re: Proposal of tunable fix for scalability of 8.4 Kevin Grittner
19:26 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
20:35 Re: Proposal of tunable fix for scalability of 8.4 Greg Smith
21:33 Re: Full statement logging problematic on larger machines? Laurent Laborde
21:46 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
22:16 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
22:57 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey

13 March 2009

01:30 Re: Proposal of tunable fix for scalability of 8.4 Robert Haas
03:00 Re: Proposal of tunable fix for scalability of 8.4 Greg Smith
04:23 Re: Proposal of tunable fix for scalability of 8.4 Greg Smith
08:28 Re: Full statement logging problematic on larger machines? sathiya psql
10:21 Re: Full statement logging problematic on larger machines? Laurent Laborde
12:38 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
12:44 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
13:05 Re: Proposal of tunable fix for scalability of 8.4 Gregory Stark
13:28 Re: Proposal of tunable fix for scalability of 8.4 Gregory Stark
13:37 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
13:43 Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 Gregory Stark
13:54 Re: Proposal of tunable fix for scalability of 8.4 Gregory Stark
13:57 Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 Gregory Stark
14:56 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
15:37 Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 Alan Stange
15:56 Re: Proposal of tunable fix for scalability of 8.4 Kevin Grittner
16:18 Re: Proposal of tunable fix for scalability of 8.4 Kevin Grittner
16:42 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
16:54 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
17:15 Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 Greg Smith
17:16 Re: Proposal of tunable fix for scalability of 8.4 Tom Lane
17:21 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
17:23 Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 Tom Lane
17:30 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
17:34 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
17:48 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
18:02 Re: Proposal of tunable fix for scalability of 8.4 Kevin Grittner
18:39 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
18:48 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
20:02 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
21:15 Hash Join performance Vamsidhar Thummala
21:34 Re: Hash Join performance Tom Lane
22:11 Re: Hash Join performance Vamsidhar Thummala
23:08 Re: Hash Join performance Tom Lane

14 March 2009

01:59 Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 Gregory Stark
02:06 Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 Tom Lane
02:10 Re: Hash Join performance Vamsidhar Thummala
02:37 Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 Robert Haas
04:03 Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 Gregory Stark
04:29 Re: Proposal of tunable fix for scalability of 8.4 david@lang.hm
08:24 Re: Proposal of tunable fix for scalability of 8.4 Heikki Linnakangas
13:30 Re: Proposal of tunable fix for scalability of 8.4 Simon Riggs
16:02 Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 Tom Lane
16:10 Re: Proposal of tunable fix for scalability of 8.4 Tom Lane
16:49 Re: Query much slower when run from postgres function decibel
16:49 Re: Query much slower when run from postgres function decibel
16:49 Re: Query performance over a large proportion of data decibel
16:49 Re: Proposal of tunable fix for scalability of 8.4 decibel
16:50 Re: Proposal of tunable fix for scalability of 8.4 decibel
16:50 Re: Proposal of tunable fix for scalability of 8.4 decibel
16:50 Re: Proposal of tunable fix for scalability of 8.4 decibel

15 March 2009

02:38 Re: Query performance over a large proportion of data Matteo Beccati
19:25 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
20:37 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
20:40 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
20:42 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah

16 March 2009

13:05 Re: Query much slower when run from postgres function Віталій Тимчишин
13:17 deployment query Nagalingam, Karthikeyan
14:36 Postgres benchmarking with pgbench ml@bortal.de
15:04 Re: Postgres benchmarking with pgbench Greg Smith
15:08 Re: Proposal of tunable fix for scalability of 8.4 Gregory Stark
15:28 Re: Postgres benchmarking with pgbench Gregory Stark
15:48 Re: Proposal of tunable fix for scalability of 8.4 Kevin Grittner
16:12 Performance of archive logging in a PITR restore Mark Steben
16:21 Re: Performance of archive logging in a PITR restore Joshua D. Drake
16:26 Re: Proposal of tunable fix for scalability of 8.4 Matthew Wakeling
16:39 Re: Postgres benchmarking with pgbench Greg Smith
16:53 Re: Proposal of tunable fix for scalability of 8.4 Kevin Grittner
18:45 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
18:49 High CPU Utilization Joe Uhl
19:13 Re: [ADMIN] deployment query Scott Marlowe
19:43 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
19:52 Re: High CPU Utilization Alan Hodgson
20:10 Re: High CPU Utilization Joe Uhl
20:35 Re: High CPU Utilization Greg Smith
20:50 Re: High CPU Utilization Joe Uhl
22:09 Re: High CPU Utilization Scott Marlowe

17 March 2009

00:18 Re: Postgres benchmarking with pgbench Gregory Stark
00:30 Re: High CPU Utilization Gregory Stark
04:12 Re: High CPU Utilization Greg Smith
04:17 Re: Postgres benchmarking with pgbench Greg Smith
04:19 Re: High CPU Utilization Greg Smith
05:33 Re: Postgres benchmarking with pgbench Scott Marlowe
09:17 Re: Proposal of tunable fix for scalability of 8.4 Simon Riggs
13:18 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
16:00 Confused ! when insert with Preimary key, Freebsd 7.1 is slower thrice times then Debian5 luo roger
17:09 Extremely slow intarray index creation and inserts. Ron Mayer
18:28 Re: Extremely slow intarray index creation and inserts. Ron Mayer
21:46 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
22:15 parallelizing slow queries for multiple cores (PostgreSQL + Gearman) Marinos Yannikos
22:39 Re: parallelizing slow queries for multiple cores (PostgreSQL + Gearman) Greg Smith
22:59 Re: Proposal of tunable fix for scalability of 8.4 Simon Riggs

18 March 2009

00:14 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
00:43 Re: Proposal of tunable fix for scalability of 8.4 Simon Riggs
03:25 Re: Extremely slow intarray index creation and inserts. Tom Lane
07:48 Re: Proposal of tunable fix for scalability of 8.4 Simon Riggs
07:54 Re: Proposal of tunable fix for scalability of 8.4 Simon Riggs
11:34 Re: Performance of archive logging in a PITR restore Heikki Linnakangas
11:36 Re: Proposal of tunable fix for scalability of 8.4 Gregory Stark
11:46 Re: Proposal of tunable fix for scalability of 8.4 Matthew Wakeling
11:49 Re: Proposal of tunable fix for scalability of 8.4 Heikki Linnakangas
11:49 Re: Proposal of tunable fix for scalability of 8.4 Matthew Wakeling
12:07 Re: Proposal of tunable fix for scalability of 8.4 Simon Riggs
12:33 Re: Proposal of tunable fix for scalability of 8.4 Matthew Wakeling
12:53 parallelizing slow queries for multiple cores (PostgreSQL + Gearman) henk de wit
13:42 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
13:49 Re: Proposal of tunable fix for scalability of 8.4 Matthew Wakeling
16:12 Re: Extremely slow intarray index creation and inserts. Ron Mayer
17:43 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
20:21 Re: Extremely slow intarray index creation and inserts. Tom Lane
20:26 Re: Proposal of tunable fix for scalability of 8.4 Tom Lane
21:16 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
21:25 Re: Proposal of tunable fix for scalability of 8.4 Robert Haas
22:01 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
22:15 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
23:07 Re: Proposal of tunable fix for scalability of 8.4 Simon Riggs
23:07 Re: Proposal of tunable fix for scalability of 8.4 Simon Riggs

19 March 2009

07:02 Re: Extremely slow intarray index creation and inserts. Oleg Bartunov
11:32 Prepared statement does not exist Nimesh Satam
11:37 Re: Prepared statement does not exist Glyn Astill
12:25 Re: Extremely slow intarray index creation and inserts. Tom Lane
12:38 Re: Extremely slow intarray index creation and inserts. Oleg Bartunov
12:45 Re: Extremely slow intarray index creation and inserts. Oleg Bartunov
17:38 Re: Proposal of tunable fix for scalability of 8.4 Bruce Momjian
20:47 Need help with one query Anne Rosset
20:49 Re: Proposal of tunable fix for scalability of 8.4 Robert Haas
20:57 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
20:58 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
21:29 Re: Postgres benchmarking with pgbench ml@bortal.de
21:43 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
21:45 Re: Postgres benchmarking with pgbench Scott Marlowe
21:59 Re: Postgres benchmarking with pgbench Scott Carey
23:12 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah
23:27 Re: Proposal of tunable fix for scalability of 8.4 Bruce Momjian
23:28 Re: Postgres benchmarking with pgbench Jignesh K. Shah

20 March 2009

03:45 Re: Proposal of tunable fix for scalability of 8.4 Robert Haas
06:05 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
06:31 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
09:04 Re: Prepared statement does not exist Nimesh Satam
09:21 Re: Need help with one query Richard Huxton
09:31 current transaction in productive database ml@bortal.de
12:08 Re: Prepared statement does not exist Glyn Astill
15:28 Re: Need help with one query Tom Lane
15:28 Re: Proposal of tunable fix for scalability of 8.4 Matthew Wakeling
15:46 Re: Proposal of tunable fix for scalability of 8.4 Alvaro Herrera
15:55 Re: Proposal of tunable fix for scalability of 8.4 Tom Lane
17:02 Re: current transaction in productive database Jeff
17:16 Re: Need help with one query Anne Rosset
17:34 Re: current transaction in productive database Greg Smith
17:51 Re: current transaction in productive database Euler Taveira de Oliveira
18:54 Re: Proposal of tunable fix for scalability of 8.4 Scott Carey
19:02 Re: Full statement logging problematic on larger machines? Frank Joerdens
19:05 Re: Need help with one query Robert Haas
19:15 Re: Need help with one query Alvaro Herrera
19:47 Re: Full statement logging problematic on larger machines? Frank Joerdens
20:26 Re: High CPU Utilization Joe Uhl
20:29 Re: Need help with one query Anne Rosset
20:29 Re: High CPU Utilization Scott Marlowe
20:49 Re: High CPU Utilization Joe Uhl
20:58 Re: High CPU Utilization Scott Marlowe
21:16 Re: High CPU Utilization Joe Uhl
21:58 Re: Proposal of tunable fix for scalability of 8.4 Alvaro Herrera
22:05 Re: Proposal of tunable fix for scalability of 8.4 Alvaro Herrera
22:15 Re: Full statement logging problematic on larger machines? Frank Joerdens
23:39 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah

21 March 2009

00:37 Re: Need help with one query Tom Lane
00:38 Re: Need help with one query Robert Haas
00:45 Re: Proposal of tunable fix for scalability of 8.4 Robert Haas
04:17 "iowait" bug? M. Edward (Ed) Borasky
08:50 Re: Proposal of tunable fix for scalability of 8.4 Simon Riggs
23:02 Re: Proposal of tunable fix for scalability of 8.4 Jignesh K. Shah

22 March 2009

10:15 Re: "iowait" bug? Laurent Wandrebeck
15:29 Re: "iowait" bug? Laurent Laborde
20:17 Re: "iowait" bug? Greg Smith
21:29 Re: LIMIT confuses the planner Tom Lane
23:15 Re: "iowait" bug? Laurent Wandrebeck

23 March 2009

00:13 Re: LIMIT confuses the planner marcin mank
00:57 Re: LIMIT confuses the planner marcin mank
02:19 Re: LIMIT confuses the planner Tom Lane
04:05 Re: "iowait" bug? Greg Smith
13:53 Slower query after psql changed it's execution plan Romuald Brunet
14:21 Re: Slower query after psql changed it's execution plan Kevin Grittner
14:29 Re: Slower query after psql changed it's execution plan Tom Lane
17:09 Re: Need help with one query Anne Rosset
17:15 Re: Need help with one query Robert Haas
19:36 multiple threads inserting into the same table Brian Cox
19:49 Re: multiple threads inserting into the same table David Wilson
19:56 Re: Need help with one query Anne Rosset
19:58 Re: multiple threads inserting into the same table Tom Lane
20:26 Re: multiple threads inserting into the same table Brian Cox
20:39 Re: multiple threads inserting into the same table Scott Marlowe
20:52 Re: multiple threads inserting into the same table Brian Cox
21:05 Re: multiple threads inserting into the same table Brian Cox
22:57 Re: multiple threads inserting into the same table Tom Lane
23:02 Re: multiple threads inserting into the same table Tom Lane

24 March 2009

01:00 Why creating GIN table index is so slow than inserting data into empty table with the same index? Sergey Burladyan
03:49 Re: Why creating GIN table index is so slow than inserting data into empty table with the same index? Tom Lane
10:58 Re: LIMIT confuses the planner Kouber Saparev
11:11 Re: Why creating GIN table index is so slow than inserting data into empty table with the same index? Heikki Linnakangas
13:45 Re: Why creating GIN table index is so slow than inserting data into empty table with the same index? Tom Lane
18:47 Re: High CPU Utilization Joe Uhl
19:29 Re: High CPU Utilization Greg Smith
20:51 Re: High CPU Utilization Scott Marlowe
22:22 Re: Help Me Understand Why I'm Getting a Bad Query Plan Bryan Murphy
22:28 Re: Help Me Understand Why I'm Getting a Bad Query Plan Bryan Murphy
22:58 Re: High CPU Utilization Ron
23:16 Re: High CPU Utilization Scott Marlowe

25 March 2009

00:36 Re: High CPU Utilization Scott Carey
01:25 Raid 10 chunksize Mark Kirkwood
01:48 Re: Raid 10 chunksize Scott Carey
02:04 Re: Raid 10 chunksize David Rees
02:11 Re: Raid 10 chunksize Scott Marlowe
02:30 Re: Help Me Understand Why I'm Getting a Bad Query Plan Josh Berkus
03:06 Re: Help Me Understand Why I'm Getting a Bad Query Plan marcin mank
03:30 Re: Raid 10 chunksize Greg Smith
03:47 Re: Help Me Understand Why I'm Getting a Bad Query Plan Bryan Murphy
03:49 Re: Help Me Understand Why I'm Getting a Bad Query Plan Bryan Murphy
03:51 Re: Raid 10 chunksize Mark Kirkwood
08:08 Re: Raid 10 chunksize Greg Smith
10:47 Re: Raid 10 chunksize Jerry Champlin
13:41 Re: Help Me Understand Why I'm Getting a Bad Query Plan Robert Haas
16:16 Re: Raid 10 chunksize Scott Carey
18:30 Re: Help Me Understand Why I'm Getting a Bad Query Plan Bryan Murphy
21:56 Re: Help Me Understand Why I'm Getting a Bad Query Plan Josh Berkus
22:14 Re: Help Me Understand Why I'm Getting a Bad Query Plan Bryan Murphy

26 March 2009

00:58 Re: Raid 10 chunksize Stef Telford
02:15 Re: Help Me Understand Why I'm Getting a Bad Query Plan Tom Lane
03:19 Re: Help Me Understand Why I'm Getting a Bad Query Plan Bryan Murphy
03:28 Re: Help Me Understand Why I'm Getting a Bad Query Plan Tom Lane
04:08 Re: Help Me Understand Why I'm Getting a Bad Query Plan Bryan Murphy
04:37 Re: Raid 10 chunksize Mark Kirkwood
05:45 Re: Raid 10 chunksize Mark Kirkwood
06:12 Re: Raid 10 chunksize Mark Kirkwood
12:48 I have a fusion IO drive available for testing Dave Cramer
13:30 Re: I have a fusion IO drive available for testing Luke Lonergan
13:51 Re: I have a fusion IO drive available for testing Kenny Gorman
14:31 Very specialised query Matthew Wakeling
14:47 Re: Very specialised query Kevin Grittner
15:50 Re: Very specialised query Tom Lane
16:06 Re: Very specialised query Matthew Wakeling
17:39 Re: Raid 10 chunksize Greg Smith
21:45 Re: Raid 10 chunksize Scott Carey
21:49 Re: Raid 10 chunksize Scott Carey
22:02 Re: Raid 10 chunksize Scott Carey

27 March 2009

12:46 Re: Very specialised query Matthew Wakeling
14:30 Re: Very specialised query Tom Lane
16:36 Re: Very specialised query Віталій Тимчишин
17:23 Re: I have a fusion IO drive available for testing Jeff
17:31 Re: I have a fusion IO drive available for testing david@lang.hm
17:34 Re: Very specialised query Matthew Wakeling
17:55 Re: I have a fusion IO drive available for testing Jeff
18:43 Re: Very specialised query Tom Lane
20:08 Re: Very specialised query Dimitri Fontaine
20:33 Re: I have a fusion IO drive available for testing David Rees
22:55 Re: Very specialised query Marc Mamin

29 March 2009

21:33 Re: Proposal of tunable fix for scalability of 8.4 Josh Berkus

30 March 2009

10:24 Re: Very specialised query Matthew Wakeling
10:26 Re: Very specialised query Matthew Wakeling
10:28 Re: Very specialised query Matthew Wakeling
12:06 Re: Bad plan for nested loop + limit Alexander Staubo
14:08 Forcing seq_scan off for large table joined with tiny table yeilds improved performance Mario Splivalo
14:16 Re: Forcing seq_scan off for large table joined with tiny table yeilds improved performance Tom Lane
15:34 Re: Forcing seq_scan off for large table joined with tiny table yeilds improved performance Mario Splivalo
15:36 Re: Very specialised query Marc Mamin
15:57 Re: Very specialised query Matthew Wakeling
15:59 Re: Very specialised query Matthew Wakeling
16:22 Re: Very specialised query Matthew Wakeling
16:33 Re: Forcing seq_scan off for large table joined with tiny table yeilds improved performance Scott Marlowe
17:29 Re: Very specialised query Віталій Тимчишин
17:48 Re: Very specialised query Marc Mamin
17:57 Trying to track down weird query stalls dan@sidhe.org
18:15 Re: Very specialised query Віталій Тимчишин
18:31 Re: Trying to track down weird query stalls Robert Haas
18:42 Re: Trying to track down weird query stalls dan@sidhe.org
19:20 Re: Trying to track down weird query stalls Robert Haas
19:35 Re: Trying to track down weird query stalls dan@sidhe.org
19:42 Re: Trying to track down weird query stalls dan@sidhe.org
19:45 Re: Trying to track down weird query stalls Scott Marlowe
19:47 Re: Trying to track down weird query stalls Scott Marlowe
20:02 Re: Trying to track down weird query stalls dan@sidhe.org
20:13 Re: Trying to track down weird query stalls Robert Haas
20:33 Re: Trying to track down weird query stalls dan@sidhe.org
20:39 Re: Trying to track down weird query stalls Alvaro Herrera
20:49 Re: Trying to track down weird query stalls dan@sidhe.org
21:00 Re: Trying to track down weird query stalls Alvaro Herrera
21:07 Re: Trying to track down weird query stalls dan@sidhe.org
21:22 Re: Trying to track down weird query stalls Alvaro Herrera
21:34 Re: Trying to track down weird query stalls dan@sidhe.org
21:38 Re: Trying to track down weird query stalls Alvaro Herrera
21:55 Re: Trying to track down weird query stalls Scott Carey

31 March 2009

11:54 Re: Very specialised query Matthew Wakeling
12:26 Re: I have a fusion IO drive available for testing Dave Cramer
14:10 Re: I have a fusion IO drive available for testing Craig James
15:23 Re: I have a fusion IO drive available for testing Chris Browne
17:08 Re: Very specialised query Matthew Wakeling
21:12 Re: Very specialised query Віталій Тимчишин
21:36 Re: Strange behavior: pgbench and new Linux kernels Kevin Grittner
23:00 How to get parallel restore in PG 8.4 to work? henk de wit
23:17 Re: How to get parallel restore in PG 8.4 to work? Tom Lane
23:35 Re: Strange behavior: pgbench and new Linux kernels Greg Smith