Home > mailing lists

Mailing lists [pgsql-performance]

1 November 2008

00:14 Re: Occasional Slow Commit David Rees

4 November 2008

00:30 Re: Index bloat, reindex weekly, suggestions etc? Tory M Blue
09:56 Aggregate weirdness Martin Kjeldsen
11:25 epqa; postgres performance optimizer support tool; opensource. sathiya psql
12:39 Re: Aggregate weirdness Tom Lane
13:17 Installation Error of postgresql-8.1.5 with perl. praveen
13:43 Re: [ADMIN] Installation Error of postgresql-8.1.5 with perl. praveen

5 November 2008

10:12 PostgreSQL OR performance Віталій Тимчишин
11:38 lru_multiplier and backend page write-outs Peter Schuller
14:35 Re: PostgreSQL OR performance Tom Lane
15:31 Re: PostgreSQL OR performance Jeff Davis
17:45 Create and drop temp table in 8.3.4 Kevin Grittner
18:06 Re: Create and drop temp table in 8.3.4 Kevin Grittner
19:37 Query planner cost estimate less than the sum of its parts? Scott Carey
19:44 Re: lru_multiplier and backend page write-outs Greg Smith
20:53 Re: Query planner cost estimate less than the sum of its parts? Gregory Stark
21:19 Re: Query planner cost estimate less than the sum of its parts? Scott Carey
22:16 Re: Create and drop temp table in 8.3.4 Kevin Grittner

6 November 2008

00:35 Re: Create and drop temp table in 8.3.4 Tom Lane
02:25 Re: Occasional Slow Commit David Rees
09:19 Re: lru_multiplier and backend page write-outs Peter Schuller
09:21 Re: Occasional Slow Commit Peter Schuller
09:46 Re: PostgreSQL OR performance Віталій Тимчишин
09:51 server space increasing very fast but transaction are very low brahma tiwari
10:04 Re: server space increasing very fast but transaction are very low Richard Huxton
10:57 Re: server space increasing very fast but transaction are very low Guillaume Cottenceau
11:26 Re: PostgreSQL OR performance Helio Campos Mello de Andrade
14:57 Re: Occasional Slow Commit David Rees
15:07 Re: Occasional Slow Commit Scott Marlowe
15:33 Re: PostgreSQL OR performance Віталій Тимчишин
15:44 Re: PostgreSQL OR performance Richard Huxton
15:44 Re: PostgreSQL OR performance Helio Campos Mello de Andrade
16:47 Re: PostgreSQL OR performance Віталій Тимчишин
17:46 Re: Occasional Slow Commit David Rees
18:03 Re: Create and drop temp table in 8.3.4 Kevin Grittner
18:17 Re: Create and drop temp table in 8.3.4 Joshua D. Drake
18:35 Re: Create and drop temp table in 8.3.4 Kevin Grittner
20:05 Re: Create and drop temp table in 8.3.4 Scott Carey
20:50 Re: Create and drop temp table in 8.3.4 Kevin Grittner
21:05 Re: Create and drop temp table in 8.3.4 Scott Marlowe
21:10 Re: lru_multiplier and backend page write-outs Greg Smith
21:33 Re: Create and drop temp table in 8.3.4 Kevin Grittner
21:45 Re: Create and drop temp table in 8.3.4 Scott Marlowe
22:04 Re: lru_multiplier and backend page write-outs Peter Schuller
22:04 Re: Create and drop temp table in 8.3.4 Kevin Grittner
23:04 Re: Create and drop temp table in 8.3.4 Scott Marlowe

7 November 2008

01:22 Re: Create and drop temp table in 8.3.4 David Rees
08:21 Re: PostgreSQL OR performance Віталій Тимчишин
09:07 Re: PostgreSQL OR performance David Wilson
09:45 Re: PostgreSQL OR performance Richard Huxton

10 November 2008

05:50 Improve Seq scan performance Lutischán Ferenc
05:56 Re: Improve Seq scan performance Craig Ringer
06:37 Re: Improve Seq scan performance Vladimir Sitnikov
06:59 Re: Improve Seq scan performance Craig Ringer
07:18 Re: Improve Seq scan performance Vladimir Sitnikov
07:26 Oddity with view Jim 'Decibel!' Nasby
07:41 Re: Improve Seq scan performance Craig Ringer
12:06 Re: Oddity with view Tom Lane
15:19 Re: Improve Seq scan performance Lutischán Ferenc
15:25 Simple indexed IN query takes 40 seconds Andrus
15:29 Re: Simple indexed IN query takes 40 seconds Tom Lane
15:30 slow full table update
15:41 Re: slow full table update tv@fuzzy.cz
16:12 Re: Simple indexed IN query takes 40 seconds tv@fuzzy.cz
16:21 paging on windows Anshul Dutta
17:16 Re: Oddity with view Jim 'Decibel!' Nasby
17:21 Re: Oddity with view Richard Huxton
17:23 Re: Simple indexed IN query takes 40 seconds Andrus
17:31 Re: Oddity with view Tom Lane
17:36 Re: Oddity with view (now with test case) Jim 'Decibel!' Nasby
18:31 Re: Oddity with view (now with test case) Tom Lane
20:06 Re: Oddity with view (now with test case) Jim 'Decibel!' Nasby

11 November 2008

02:20 Re: Oddity with view (now with test case) Tom Lane
13:52 Re: Create and drop temp table in 8.3.4 Matthew Wakeling
14:07 Re: Create and drop temp table in 8.3.4 Aidan Van Dyk
17:08 Re: Oddity with view (now with test case) Jim 'Decibel!' Nasby
18:16 Re: Oddity with view (now with test case) Tom Lane
19:36 Using index for IS NULL query Andrus
19:45 Re: Using index for IS NULL query Tom Lane
19:47 Re: Using index for IS NULL query Andreas Kretschmer
19:50 Re: Using index for IS NULL query Andreas Kretschmer
20:02 Re: Using index for IS NULL query Tomas Vondra
21:43 Re: Oddity with view (now with test case) Jim 'Decibel!' Nasby
22:00 Re: Using index for IS NULL query Vladimir Sitnikov
22:34 Re: Using index for IS NULL query Scott Marlowe

12 November 2008

01:34 Re: Oddity with view (now with test case) Tom Lane
12:29 Re: Using index for IS NULL query Matthew Wakeling
12:31 Index usage with sub select or inner joins Julien Theulier
12:54 Re: Index usage with sub select or inner joins Joshua Tolley
14:42 Re: Index usage with sub select or outer joins Julien Theulier
15:26 Re: slow full table update
15:27 Performance Question - -
15:48 Re: slow full table update tv@fuzzy.cz
15:54 Re: Performance Question J Sisson
15:56 Re: Performance Question tv@fuzzy.cz
16:06 Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Andrus
16:15 Re: Performance Question Fernando Hevia
16:26 Re: slow full table update
16:26 Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Matthew Wakeling
16:29 Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Vladimir Sitnikov
16:33 Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Matthew Wakeling
16:46 Re: slow full table update Richard Huxton
16:58 Re: slow full table update Vladimir Sitnikov
17:36 Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Andrus
18:26 Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Vladimir Sitnikov
18:39 Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed hubert depesz lubaczewski
18:45 Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Andrus
19:06 Re: Increasing select max(datecol) from bilkaib wheredatecol<=date'2008-11-01' and (cr='00' or db='00') speed Andrus
19:54 Re: slow full table update Tom Lane
19:56 Re: slow full table update Scott Marlowe
19:57 Re: Performance Question Tom Lane
21:28 Disk usage question Franck Routier
21:47 Re: slow full table update
21:59 Re: slow full table update Scott Marlowe
22:44 Re: Disk usage question Scott Marlowe
23:13 Re: slow full table update Tomas Vondra
23:20 Re: slow full table update Tomas Vondra
23:27 Re: Using index for IS NULL query Tomas Vondra

13 November 2008

01:26 Re: Performance Question Scott Marlowe
07:55 Re: Performance Question Dave Page
11:10 Slow SQL query (14-15 seconds) Bruno Baguette
12:07 Re: Performance Question Merlin Moncure
12:28 Re: Slow SQL query (14-15 seconds) Matthew Wakeling
12:31 Re: Slow SQL query (14-15 seconds) Tom Lane
12:36 Re: Slow SQL query (14-15 seconds) Tomasz Myrta
13:19 Re: Slow SQL query (14-15 seconds) Bruno Baguette
13:29 Re: Slow SQL query (14-15 seconds) Vladimir Sitnikov
13:30 Re: Slow SQL query (14-15 seconds) Tom Lane
17:02 Re: Slow SQL query (14-15 seconds) Bruno Baguette
17:02 Re: Slow SQL query (14-15 seconds) Bruno Baguette
19:42 crosstab speed Jeremiah Elliott
20:41 Re: crosstab speed Scott Marlowe
22:06 Re: crosstab speed Joe Conway

14 November 2008

15:29 Difference in query plan Patrice Beliveau
15:47 Re: Difference in query plan Richard Huxton
16:07 Re: Difference in query plan Patrice Beliveau
16:14 Re: Difference in query plan Richard Huxton

15 November 2008

12:55 Re: PostgreSQL OR performance Віталій Тимчишин
12:57 Re: PostgreSQL OR performance Віталій Тимчишин
16:07 Re: PostgreSQL OR performance Tom Lane

16 November 2008

13:55 Re: Improve Seq scan performance PFC
13:56 Re: slow full table update PFC
14:19 Re: Performance Question PFC

17 November 2008

08:52 Re: PostgreSQL OR performance Віталій Тимчишин
09:51 Re: Improve Seq scan performance PFC
15:26 Bad performance on simple query Dimi Paun
15:28 Re: Bad performance on simple query Alan Hodgson
15:53 Re: Bad performance on simple query Scott Marlowe
16:07 Re: Bad performance on simple query Dimi Paun
16:16 Re: Bad performance on simple query Scott Marlowe
16:31 Re: Bad performance on simple query Dimi Paun
16:40 Re: Bad performance on simple query Scott Marlowe
16:45 Re: Bad performance on simple query ries van Twisk
17:14 Re: Bad performance on simple query Dimi Paun
19:47 Re: Bad performance on simple query Dave Page

18 November 2008

14:53 Performance and IN clauses Kynn Jones
15:12 Re: Performance and IN clauses Matthew Wakeling
15:38 Re: Performance and IN clauses tv@fuzzy.cz
22:27 Re: Performance and IN clauses Mark Roberts
23:49 Re: Performance and IN clauses Tomas Vondra

19 November 2008

10:51 PostgreSQL NOT IN performance Віталій Тимчишин
11:50 Re: PostgreSQL NOT IN performance DANIEL CRISTIAN CRUZ
12:11 Re: PostgreSQL NOT IN performance Alvaro Herrera
13:55 Re: PostgreSQL NOT IN performance Віталій Тимчишин
14:08 Re: PostgreSQL NOT IN performance Stephan Szabo
14:12 Re: PostgreSQL NOT IN performance Віталій Тимчишин
14:54 Very Urgent : Sequences Problem Kranti™ K K Parisa
15:34 Re: Very Urgent : Sequences Problem Josh Berkus
15:43 Re: Very Urgent : Sequences Problem Merlin Moncure
15:52 Re: Very Urgent : Sequences Problem tv@fuzzy.cz
19:40 Hash join on int takes 8..114 seconds Andrus
22:28 Re: Hash join on int takes 8..114 seconds PFC

20 November 2008

04:04 Re: Very Urgent : Sequences Problem Greg Smith
08:12 Re: Hash join on int takes 8..114 seconds Andrus
09:46 Re: Hash join on int takes 8..114 seconds Richard Huxton
10:14 Re: Hash join on int takes 8..114 seconds Andrus
10:22 Re: Hash join on int takes 8..114 seconds Richard Huxton
12:46 Re: Hash join on int takes 8..114 seconds PFC

21 November 2008

00:35 Re: Performance and IN clauses Tomas Vondra
12:49 Re: Hash join on int takes 8..114 seconds Andrus
14:16 Re: Hash join on int takes 8..114 seconds Andrus
15:14 Re: Hash join on int takes 8..114 seconds tv@fuzzy.cz
15:32 Re: Hash join on int takes 8..114 seconds Richard Huxton
16:51 Re: Hash join on int takes 8..114 seconds Andrus
16:57 Re: Hash join on int takes 8..114 seconds PFC
17:31 Re: Hash join on int takes 8..114 seconds PFC
18:00 Re: Hash join on int takes 8..114 seconds Andrus
18:08 Re: Hash join on int takes 8..114 seconds PFC
18:10 Re: Hash join on int takes 8..114 seconds Andrus
18:13 Re: Hash join on int takes 8..114 seconds Alan Hodgson
18:17 Re: Hash join on int takes 8..114 seconds Alvaro Herrera
18:45 Re: Hash join on int takes 8..114 seconds Andrus
18:48 Re: Hash join on int takes 8..114 seconds Alvaro Herrera
19:07 Re: Hash join on int takes 8..114 seconds Tom Lane
19:09 Re: Hash join on int takes 8..114 seconds Andrus
19:21 Re: Hash join on int takes 8..114 seconds Alvaro Herrera
19:48 Re: Hash join on int takes 8..114 seconds Tomas Vondra
20:22 Re: Hash join on int takes 8..114 seconds Tomas Vondra
20:53 Re: Hash join on int takes 8..114 seconds Andrus
22:11 Re: Hash join on int takes 8..114 seconds Scott Carey

22 November 2008

13:18 Perc 3 DC Glyn Astill
15:16 Re: Perc 3 DC Scott Marlowe
15:59 Re: Perc 3 DC Glyn Astill
16:09 Re: Hash join on int takes 8..114 seconds PFC
17:27 Re: Perc 3 DC Scott Marlowe
19:19 Re: Hash join on int takes 8..114 seconds Andrus
19:41 seq scan over 3.3 million rows instead of single key index access Andrus
19:41 Increasing pattern index query speed Andrus
21:00 Re: Perc 3 DC Glyn Astill
22:04 Re: seq scan over 3.3 million rows instead of single key index access Gregory Stark
22:59 Re: seq scan over 3.3 million rows instead of single key index access Tom Lane

23 November 2008

03:21 Re: seq scan over 3.3 million rows instead of single key index access Andrus
06:21 Re: Hash join on int takes 8..114 seconds PFC
07:10 Re: seq scan over 3.3 million rows instead of single key index access Andreas Kretschmer
07:13 Re: seq scan over 3.3 million rows instead of single key index access Andreas Kretschmer
11:20 Re: seq scan over 3.3 million rows instead of single key index access A. Kretschmer
11:41 Re: seq scan over 3.3 million rows instead of single keyindex access Andrus
13:40 Re: Hash join on int takes 8..114 seconds Andrus
17:47 Re: Hash join on int takes 8..114 seconds Tomas Vondra
20:40 Re: Hash join on int takes 8..114 seconds Scott Carey
20:41 limit clause produces wrong query plan Andrus
20:41 Re: Hash join on int takes 8..114 seconds Andrus
21:44 Re: Hash join on int takes 8..114 seconds Andrus
22:11 Re: Hash join on int takes 8..114 seconds Tomas Vondra
22:39 Re: Hash join on int takes 8..114 seconds Tomas Vondra

24 November 2008

08:36 Re: Increasing pattern index query speed Richard Huxton
12:16 Re: Hash join on int takes 8..114 seconds Andrus
12:24 Re: Perc 3 DC Steve Clark
12:39 Re: Hash join on int takes 8..114 seconds tv@fuzzy.cz
13:49 Re: Perc 3 DC Glyn Astill
13:52 Re: Perc 3 DC Scott Marlowe
14:06 Re: Perc 3 DC Glyn Astill
14:18 Re: Perc 3 DC Scott Marlowe
15:14 Re: Perc 3 DC Simon Waters
15:24 Re: Perc 3 DC Scott Marlowe
16:02 Re: Perc 3 DC PFC
17:49 Monitoring buffercache... Kevin Kempter
18:13 Re: limit clause produces wrong query plan Andrus
18:23 Re: limit clause produces wrong query plan Scott Marlowe
18:45 Re: Monitoring buffercache... Brad Nicholson
18:46 Re: Monitoring buffercache... Scott Marlowe
18:52 Re: Monitoring buffercache... Brad Nicholson
19:05 Re: limit clause produces wrong query plan Andrus
19:33 Re: Increasing pattern index query speed Andrus
20:16 Re: Hash join on int takes 8..114 seconds Andrus
20:24 Re: Monitoring buffercache... Scott Marlowe
21:20 Re: limit clause produces wrong query plan Chris
21:51 Re: Increasing pattern index query speed Scott Carey
21:58 Re: limit clause produces wrong query plan PFC
22:10 Re: limit clause produces wrong query plan Scott Carey

25 November 2008

03:34 Re: Monitoring buffercache... Greg Smith
03:48 Re: Monitoring buffercache... Greg Smith
03:54 Re: Monitoring buffercache... Scott Marlowe
11:54 Deteriorating performance when loading large objects Vegard Bønes
12:18 Re: Deteriorating performance when loading large objects Ivan Voras
12:37 Re: Deteriorating performance when loading large objects Tom Lane
18:38 Re: Monitoring buffercache... Mark Kirkwood

26 November 2008

03:07 Partition table query performance Greg Jaman
09:41 Re: Increasing pattern index query speed Richard Huxton
13:21 Re: Increasing pattern index query speed Mario Weilguni
14:38 many to many performance Chavdar Kopoev
16:40 Re: many to many performance Craig Ringer
17:57 Re: Increasing pattern index query speed Andrus
18:07 Re: Increasing pattern index query speed Richard Huxton
18:25 Re: Increasing pattern index query speed Andrus
18:40 Re: Increasing pattern index query speed Andrus
18:47 many to many performance Chavdar Kopoev
18:55 Re: Increasing pattern index query speed Richard Huxton
19:11 Re: Increasing pattern index query speed Andrus
19:21 Re: Increasing pattern index query speed Andrus
19:33 Re: Increasing pattern index query speed Richard Huxton
21:10 Memory Allocation Ryan Hansen
21:18 Re: Memory Allocation Alan Hodgson
21:27 Re: Increasing pattern index query speed Scott Carey
21:57 Re: Memory Allocation Carlos Moreno
21:58 Re: Memory Allocation Tom Lane
22:00 Re: Memory Allocation Scott Carey
22:09 Re: Memory Allocation Kevin Grittner
22:52 Re: Memory Allocation Scott Carey
23:48 Re: Partition table query performance Gregory Stark

27 November 2008

03:50 performance tuning queries Kevin Kempter
07:44 Re: performance tuning queries PFC
07:55 Re: performance tuning queries A. Kretschmer
09:09 Re: performance tuning queries Mario Weilguni
15:40 Re: many to many performance Chavdar Kopoev
16:25 Re: Partition table query performance Greg Jaman
18:05 Re: Deteriorating performance when loading large objects Vegard Bønes
20:29 Re: Deteriorating performance when loading large objects Tom Lane

28 November 2008

07:30 Re: Deteriorating performance when loading large objects Mario Weilguni
13:58 Re: Increasing pattern index query speed Andrus
14:12 Increasing GROUP BY CHAR columns speed Andrus
14:32 Re: Deteriorating performance when loading large objects Vegard Bønes
16:07 Re: Increasing GROUP BY CHAR columns speed Scott Carey
16:59 Re: Increasing GROUP BY CHAR columns speed Andrus
17:24 Re: Increasing GROUP BY CHAR columns speed Scott Marlowe
18:51 Re: Increasing GROUP BY CHAR columns speed Scott Carey
18:57 Re: Increasing GROUP BY CHAR columns speed Andrus
19:31 Re: Increasing GROUP BY CHAR columns speed Andrus
19:34 Re: Increasing GROUP BY CHAR columns speed Scott Marlowe
19:44 Re: Increasing GROUP BY CHAR columns speed Andrus
21:28 Re: Memory Allocation Kevin Grittner

29 November 2008

16:44 Re: Increasing GROUP BY CHAR columns speed Andrus

30 November 2008

12:02 Re: Increasing GROUP BY CHAR columns speed Greg Stark
18:12 Query optimization tmp
18:37 Re: Query optimization Marc Cousin
19:42 Seq scan over 3.3 millions of rows instead of using date and pattern indexes Andrus