Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2011-02 Chronological Index (1/4)
Last updated: Wed Jan 18 04:12:50 2012
541 messages
28 February 2011
Re: Query on view radically slower than query on underlying table Craig James (19:24)
Anyone tried Flashcache with PostgreSQL? Josh Berkus (19:10)
Re: Talking about optimizer, my long dream Robert Haas (19:09)
Re: Bad query plan when the wrong data type is used Robert Haas (19:05)
Re: Query on view radically slower than query on underlying table Tom Lane (18:57)
Re: inheritance: planning time vs children number vs column number Marc Cousin (18:47)
Re: Load and Stress on PostgreSQL 9.0 Josh Berkus (18:36)
Query on view radically slower than query on underlying table Craig James (18:34)
Re: optimalization Andreas Kretschmer (18:32)
Load and Stress on PostgreSQL 9.0 Selva manickaraja (16:26)
Re: inheritance: planning time vs children number vs column number Tom Lane (15:35)
Re: optimization Kevin Grittner (14:57)
Re: inheritance: planning time vs children number vs column number Marc Cousin (13:10)
Re: inheritance: planning time vs children number vs column number Heikki Linnakangas (12:58)
Re: Performance Test for PostgreSQL9 Heikki Linnakangas (11:37)
optimization croolyc (09:44)
optimalization croolyc (09:41)
inheritance: planning time vs children number vs column number Marc Cousin (09:38)
Re: Performance Test for PostgreSQL9 Selva manickaraja (09:11)
Is Query need to be optimized Adarsh Sharma (07:18)
Re: Performance Test for PostgreSQL9 Melton Low (06:57)
Re: Performance Test for PostgreSQL9 Melton Low (06:51)
Re: Performance Test for PostgreSQL9 Jochen Erwied (06:43)
Re: Performance Test for PostgreSQL9 Selva manickaraja (06:39)
Re: Performance Test for PostgreSQL9 Mark Kirkwood (05:53)
Re: Vacuum problem due to temp tables Bhakti Ghatkar (05:14)
Re: Performance Test for PostgreSQL9 Selva manickaraja (05:09)
Re: Performance Test for PostgreSQL9 Mark Kirkwood (04:18)
Performance Test for PostgreSQL9 Selva manickaraja (03:26)
27 February 2011
Re: Bad query plan when the wrong data type is used Tom Lane (18:40)
Re: Indexes with condition using immutable functions applied to column not used Robert Haas (18:21)
Re: Bad query plan when the wrong data type is used Robert Haas (18:17)
Re: Talking about optimizer, my long dream Robert Haas (17:59)
26 February 2011
Re: Picking out the most recent row using a time stamp column Florian Weimer (21:39)
Re: Picking out the most recent row using a time stamp column Dave Johansen (21:38)
Re: Index use difference betweer LIKE, LIKE ANY? Josh Berkus (21:14)
Re: Picking out the most recent row using a time stamp column Josh Berkus (21:06)
Re: Vacuum problem due to temp tables Tom Lane (17:25)
Re: Picking out the most recent row using a time stamp column Dave Johansen (13:44)
Vacuum problem due to temp tables Bhakti Ghatkar (07:07)
25 February 2011
Re: Picking out the most recent row using a time stamp column Dave Johansen (16:50)
Index use difference betweer LIKE, LIKE ANY? Sam Wong (13:31)
Re: Perl Binding affects speed? Sam Wong (13:24)
Re: Perl Binding affects speed? Martin Kjeldsen (13:09)
Re: Perl Binding affects speed? Marti Raudsepp (12:26)
Perl Binding affects speed? Sam Wong (03:09)
Re: Picking out the most recent row using a time stamp column Josh Berkus (01:52)
Re: Picking out the most recent row using a time stamp column Shaun Thomas (00:58)
Re: Possible parser bug? .... Re: Picking out the most recent row using a time stamp column Jochen Erwied (00:23)
Re: Picking out the most recent row using a time stamp column Josh Berkus (00:20)
24 February 2011
Re: Picking out the most recent row using a time stamp column Dave Crooke (23:38)
Re: Picking out the most recent row using a time stamp column Merlin Moncure (21:20)
Re: Pushing IN (subquery) down through UNION ALL? Dave Johansen (20:52)
Re: Picking out the most recent row using a time stamp column Kevin Grittner (20:24)
Re: Picking out the most recent row using a time stamp column Michael Glaesemann (20:22)
Re: Picking out the most recent row using a time stamp column Kevin Grittner (20:19)
Re: Picking out the most recent row using a time stamp column Merlin Moncure (20:11)
Re: Pushing IN (subquery) down through UNION ALL? Vik Reykja (20:00)
Re: Pushing IN (subquery) down through UNION ALL? Dave Johansen (19:56)
Picking out the most recent row using a time stamp column Dave Crooke (19:55)
Re: Unused indices Shaun Thomas (19:36)
Re: Pushing IN (subquery) down through UNION ALL? Vik Reykja (19:34)
Re: Unused indices Greg Smith (18:13)
Re: Pushing IN (subquery) down through UNION ALL? Dave Johansen (16:58)
Re: Function execution consuming lot of memory and eventually making server unresponsive Tom Lane (15:59)
Re: Function execution consuming lot of memory and eventually making server unresponsive Merlin Moncure (15:14)
Pushing IN (subquery) down through UNION ALL? Dave Johansen (15:14)
Re: Unused indices Shaun Thomas (14:25)
Re: Function execution consuming lot of memory and eventually making server unresponsive Kevin Grittner (12:29)
Re: Function execution consuming lot of memory and eventually making server unresponsive Pavel Stehule (10:30)
Function execution consuming lot of memory and eventually making server unresponsive Gnanakumar (09:56)
Re: NULLS LAST performance Mathieu De Zutter (09:47)
Re: performance issue in the fields. Pierre C (08:23)
Pushing IN (subquery) down through UNION ALL? Dave Johansen (04:10)
23 February 2011
Re: Unused indices Greg Smith (21:19)
Re: performance issue in the fields. Merlin Moncure (19:59)
Re: NULLS LAST performance Merlin Moncure (19:48)
NULLS LAST performance Mathieu De Zutter (19:27)
Unused indices Benjamin Krajmalnik (19:14)
Re: Exhaustive list of what takes what locks Robert Haas (17:59)
Re: Exhaustive list of what takes what locks Tom Lane (17:31)
Re: Exhaustive list of what takes what locks Robert Haas (17:21)
Re: Exhaustive list of what takes what locks Noah Misch (04:21)
Re: Exhaustive list of what takes what locks Tom Lane (03:34)
Re: Exhaustive list of what takes what locks Robert Haas (03:23)
Re: Query performance with disabled hashjoin and mergejoin Robert Haas (03:07)
Re: Why we don't want hints Was: Slow count(*) again... Robert Haas (02:22)
21 February 2011
20 February 2011
19 February 2011
Re: Slow query execution over high latency network Pierre C (12:30)
Slow query execution over high latency network Clemens Eisserer (10:30)
18 February 2011
Re: different clients, different query plans Kevin Grittner (14:58)
different clients, different query plans Uwe Bartels (14:29)
17 February 2011
Re: application of KNN code to US zipcode searches? Mark Stosberg (20:38)
Re: application of KNN code to US zipcode searches? Oleg Bartunov (20:18)
Re: application of KNN code to US zipcode searches? Tom Lane (19:17)
Re: application of KNN code to US zipcode searches? Tom Lane (19:13)
Re: application of KNN code to US zipcode searches? Mark Stosberg (16:42)
Re: application of KNN code to US zipcode searches? Heikki Linnakangas (16:41)
Re: application of KNN code to US zipcode searches? Mark Stosberg (15:56)
Re: application of KNN code to US zipcode searches? Stephen Frost (15:24)
Re: Really really slow select count(*) Merlin Moncure (15:22)
Re: application of KNN code to US zipcode searches? Mark Stosberg (15:21)
Re: application of KNN code to US zipcode searches? Kevin Grittner (14:49)
application of KNN code to US zipcode searches? Mark Stosberg (14:41)
Re: high user cpu, massive SELECTs, no io waiting problem Pierre C (10:17)
Re: Does exclusive locking improve performance? Stephen Frost (05:18)
Does exclusive locking improve performance? Jeremy Palmer (05:14)
16 February 2011
Re: Why we don't want hints Was: Slow count(*) again... Bruce Momjian (21:22)
Re: Estimating hot data size Tomas Vondra (21:14)
Estimating hot data size Chris Hoover (20:51)
Re: high user cpu, massive SELECTs, no io waiting problem Greg Smith (20:36)
Re: high user cpu, massive SELECTs, no io waiting problem Kevin Grittner (19:22)
Re: Really really slow select count(*) Bob Lunney (19:20)
Re: high user cpu, massive SELECTs, no io waiting problem Cédric Villemain (17:58)
Re: high user cpu, massive SELECTs, no io waiting problem Thomas Pöhler (17:11)
Re: high user cpu, massive SELECTs, no io waiting problem Strange, John W (16:32)
Re: Really really slow select count(*) Ross J. Reedstrom (16:28)
Re: high user cpu, massive SELECTs, no io waiting problem Kevin Grittner (16:09)
Re: high user cpu, massive SELECTs, no io waiting problem Scott Marlowe (16:02)
Re: high user cpu, massive SELECTs, no io waiting problem Scott Marlowe (15:43)
Re: high user cpu, massive SELECTs, no io waiting problem Justin Pitts (15:04)
Re: high user cpu, massive SELECTs, no io waiting problem Greg Smith (14:56)
Re: high user cpu, massive SELECTs, no io waiting problem Kevin Grittner (14:37)
Re: high user cpu, massive SELECTs, no io waiting problem Marti Raudsepp (13:52)
Re: high user cpu, massive SELECTs, no io waiting problem Greg Smith (07:33)
Re: LIMIT on partitioned-table!? Kim A. Brandt (07:24)
Re: high user cpu, massive SELECTs, no io waiting problem Scott Marlowe (01:19)
Re: high user cpu, massive SELECTs, no io waiting problem Ivan Voras (01:00)
15 February 2011
Re: high user cpu, massive SELECTs, no io waiting problem marcin mank (19:56)
Re: LIMIT on partitioned-table!? Kim A. Brandt (19:33)
Re: pg_dumpall affecting performance Kevin Grittner (19:13)
Re: high user cpu, massive SELECTs, no io waiting problem Strange, John W (19:09)
Re: pg_dumpall affecting performance Steve Crawford (18:56)
Re: pg_dumpall affecting performance Plugge, Joe R. (18:52)
pg_dumpall affecting performance Mark Mikulec (18:41)
Re: high user cpu, massive SELECTs, no io waiting problem Kevin Grittner (18:07)
Re: high user cpu, massive SELECTs, no io waiting problem Scott Marlowe (18:02)
high user cpu, massive SELECTs, no io waiting problem Thomas Pöhler (17:56)
Re: Checkpointing question Kevin Grittner (17:51)
Re: LIMIT on partitioned-table!? Shaun Thomas (14:49)
LIMIT on partitioned-table!? Kim A. Brandt (14:30)
Checkpointing question Strange, John W (11:52)
14 February 2011
Re: How to boost performance of queries containing pattern matching characters Greg Smith (15:16)
Re: How to boost performance of queries containing pattern matching characters Shaun Thomas (13:55)
Re: Field wise checking the performance. Heikki Linnakangas (12:30)
Field wise checking the performance. dba (12:06)
Re: performance issue in the fields. Pavel Stehule (11:37)
performance issue in the fields. dba (11:33)
Re: How to boost performance of queries containing pattern matching characters Artur Zając (08:10)
Re: How to boost performance of queries containing pattern matching characters Gnanakumar (08:06)
Re: How to boost performance of queries containing pattern matching characters Artur Zając (08:05)
Re: choosing the right RAID level for PostgresQL database david (08:02)
Re: How to boost performance of queries containing pattern matching characters Richard Huxton (07:57)
Re: How to boost performance of queries containing pattern matching characters Richard Huxton (07:50)
Re: How to boost performance of queries containing pattern matching characters Gnanakumar (07:49)
Re: How to boost performance of queries containing pattern matching characters Richard Huxton (07:39)
Re: How to boost performance of queries containing pattern matching characters Gnanakumar (07:31)
Re: How to boost performance of queries containing pattern matching characters Richard Huxton (07:18)
How to boost performance of queries containing pattern matching characters Gnanakumar (07:03)
Re: Why we don't want hints Scott Marlowe (07:01)
Re: comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan Mark Rostron (04:40)
Re: comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan Mark Rostron (04:17)
Re: comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan Greg Smith (02:33)
Re: comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan Scott Marlowe (02:12)
comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan Mark Rostron (01:57)
Re: choosing the right RAID level for PostgresQL database Dave Crooke (01:54)