Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2009-09 Chronological Index (1/2)
Last updated: Wed Jan 18 04:14:34 2012
344 messages
29 September 2009
Re: Speed while runnning large transactions. Robert Haas (21:28)
FullTextSearch - UNION individual indexes or concatenated columns index ? Jeremy Ferrante (20:10)
Re: Performance problems with DISTINCT ON Scott Carey (17:53)
Re: Using OProfile Tom Lane (14:19)
Re: Performance problems with DISTINCT ON hubert depesz lubaczewski (12:53)
Re: Performance problems with DISTINCT ON Sgarbossa Domenico (12:47)
Using OProfile Reydan Cankur (11:08)
Re: Performance problems with DISTINCT ON Richard Huxton (08:28)
Performance problems with DISTINCT ON Sgarbossa Domenico (06:57)
28 September 2009
Re: PG 8.3 and large shared buffer settings Josh Berkus (17:36)
Re: Postgres performance Andy Colson (14:11)
Re: LIMIT confuses the planner (again) Robert Haas (11:39)
LIMIT confuses the planner (again) Kouber Saparev (08:49)
27 September 2009
Re: Slow query after upgrade to 8.4 Robert Haas (18:45)
Re: query memory consumption Robert Haas (18:40)
Re: Regarding Sequential Scans count increase each time we press refresh . Robert Haas (18:38)
Re: Many left outer joins with limit performance Gerhard Wiesinger (07:10)
Re: Bad performance of SELECT ... where id IN (...) Xia Qingran (06:13)
Re: Bad performance of SELECT ... where id IN (...) Xia Qingran (06:11)
26 September 2009
Re: PG 8.3 and large shared buffer settings Jeff Janes (19:17)
Re: PG 8.3 and large shared buffer settings Jeff Janes (18:59)
Re: Bad performance of SELECT ... where id IN (...) Grzegorz Jaśkiewicz (17:58)
Re: PG 8.3 and large shared buffer settings Pierre Frédéric Caillau d (17:21)
Re: Bad performance of SELECT ... where id IN (...) Tom Lane (17:04)
Re: PG 8.3 and large shared buffer settings Gerhard Wiesinger (16:58)
Re: Bad performance of SELECT ... where id IN (...) Paul Ooi (15:33)
Re: Bad performance of SELECT ... where id IN (...) Craig James (15:22)
Re: PG 8.3 and large shared buffer settings Greg Smith (15:20)
Re: PG 8.3 and large shared buffer settings Greg Smith (14:59)
Re: Bad performance of SELECT ... where id IN (...) Claus Guttesen (14:16)
Bad performance of SELECT ... where id IN (...) Xia Qingran (13:05)
Re: query memory consumption Jeff Janes (03:06)
Re: PG 8.3 and large shared buffer settings Jeff Janes (02:54)
25 September 2009
Re: PG 8.3 and large shared buffer settings Scott Carey (15:57)
Re: High CPU load on Postgres Server during Peak times!!!! Craig James (15:29)
Re: PG 8.3 and large shared buffer settings Aidan Van Dyk (13:33)
Re: High CPU load on Postgres Server during Peak times!!!! Gerhard Wiesinger (13:20)
Re: PG 8.3 and large shared buffer settings Dan Sugalski (10:06)
Re: High CPU load on Postgres Server during Peak times!!!! Grzegorz Jaśkiewicz (09:03)
Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman (08:55)
Re: High CPU load on Postgres Server during Peak times!!!! Grzegorz Jaśkiewicz (08:16)
Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman (08:07)
Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman (07:17)
Re: PG 8.3 and large shared buffer settings Tom Lane (04:36)
PG 8.3 and large shared buffer settings Dan Sugalski (03:28)
Re: Regarding Sequential Scans count increase each time we press refresh . Josh Berkus (00:25)
24 September 2009
Re: High CPU load on Postgres Server during Peak times!!!! Karl Denninger (17:56)
Regarding Sequential Scans count increase each time we press refresh . keshav upadhyaya (17:33)
Re: High CPU load on Postgres Server during Peak times!!!! Dave Dutcher (17:08)
Re: Use of sequence rather than index scan for one text column on one instance of a database Tom Lane (16:26)
Re: High CPU load on Postgres Server during Peak times!!!! Karl Denninger (15:49)
Re: Use of sequence rather than index scan for one text column on one instance of a database Tom Lane (15:35)
Re: High CPU load on Postgres Server during Peak times!!!! Andy Colson (15:32)
Re: High CPU load on Postgres Server during Peak times!!!! Praveen DS (13:36)
Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman (12:50)
Re: Slow query after upgrade to 8.4 Jared Beck (12:23)
Re: Speed while runnning large transactions. jesper (11:39)
Re: Speed while runnning large transactions. jesper (11:36)
Re: Slow query after upgrade to 8.4 tv (09:57)
Re: Index row requires 9324 bytes maximum size is 8191 solAris23 (09:49)
Re: Speed while runnning large transactions. Scott Marlowe (09:07)
Re: Speed while runnning large transactions. Grzegorz Jaśkiewicz (08:44)
Re: Speed while runnning large transactions. Claus Guttesen (08:41)
Speed while runnning large transactions. jesper (08:34)
Re: Different query plans for the same query Hell, Robert (06:41)
Re: Use of sequence rather than index scan for one text column on one instance of a database Tom Lane (02:53)
Re: Slow query after upgrade to 8.4 Tom Lane (02:35)
23 September 2009
Use of sequence rather than index scan for one text column on one instance of a database Bill Kirtley (22:37)
Slow query after upgrade to 8.4 Jared Beck (21:00)
Re: High CPU load on Postgres Server during Peak times!!!! Scott Marlowe (20:55)
Re: High CPU load on Postgres Server during Peak times!!!! Karl Denninger (20:53)
Re: High CPU load on Postgres Server during Peak times!!!! Fernando Hevia (20:49)
Re: High CPU load on Postgres Server during Peak times!!!! Andy Colson (18:53)
Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman (18:28)
Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman (18:25)
Slow query after upgrade to 8.4 Jared Beck (17:38)
Re: statement stats extra load? Magnus Hagander (08:05)
22 September 2009
Re: session servers in ram Scott Marlowe (18:22)
Re: session servers in ram Ron Mayer (18:01)
Re: session servers in ram Alan Hodgson (16:04)
Re: High CPU load on Postgres Server during Peak times!!!! Fernando Hevia (15:28)
Re: Hunting Unused Indexes .. is it this simple ? Andy Colson (14:38)
Re: Hunting Unused Indexes .. is it this simple ? Gurjeet Singh (14:36)
Re: High CPU load on Postgres Server during Peak times!!!! Andy Colson (14:35)
Re: High CPU load on Postgres Server during Peak times!!!! Andy Colson (14:19)
Re: High CPU load on Postgres Server during Peak times!!!! Merlin Moncure (14:18)
Hunting Unused Indexes .. is it this simple ? Stef Telford (14:12)
High CPU load on Postgres Server during Peak times!!!! Shiva Raman (13:54)
Re: statement stats extra load? Alan McKay (13:20)
Re: session servers in ram Aidan Van Dyk (13:16)
Re: session servers in ram Pavel Stehule (13:05)
Re: query memory consumption Grzegorz Jaśkiewicz (12:51)
Re: session servers in ram Greg Spiegelberg (12:49)
Re: query memory consumption Alan McKay (12:46)
Re: query memory consumption Grzegorz Jaśkiewicz (12:41)
Re: query memory consumption Alan McKay (12:37)
Re: Slow select times on select with xpath Dimitri Fontaine (11:40)
Re: query memory consumption Matthew Wakeling (10:58)
Re: statement stats extra load? Magnus Hagander (06:50)
Re: Slow select times on select with xpath Ron Mayer (05:12)
21 September 2009
Re: statement stats extra load? Bruce Momjian (21:41)
Re: statement stats extra load? Alan McKay (21:28)
Re: Planner question - wrong row count estimation Josh Berkus (21:21)
Re: statement stats extra load? Bruce Momjian (21:19)
Re: query memory consumption Robert Haas (20:08)
Re: Slow select times on select with xpath astro77 (19:52)
Re: Slow select times on select with xpath astro77 (19:13)
Re: Slow select times on select with xpath astro77 (19:02)
Re: How to post Performance Questions Alvaro Herrera (18:23)
Re: slow query : very simple delete, 100% cpu, nearly no disk activity Vincent de Phily (16:06)
Re: slow query : very simple delete, 100% cpu, nearly no disk activity Vincent de Phily (15:13)
Re: slow query : very simple delete, 100% cpu, nearly no disk activity Vincent de Phily (15:01)
Re: slow query : very simple delete, 100% cpu, nearly no disk activity Merlin Moncure (15:00)
query memory consumption Alan McKay (14:48)
Re: Index row requires 9324 bytes maximum size is 8191 Florian Weimer (08:51)
Re: Index row requires 9324 bytes maximum size is 8191 Grzegorz Jaśkiewicz (08:38)
20 September 2009
Re: Index row requires 9324 bytes maximum size is 8191 Euler Taveira de Oliveira (03:06)
Planner question - wrong row count estimation Michael Korbakov (00:08)
18 September 2009
Index row requires 9324 bytes maximum size is 8191 solAris23 (16:06)
Re: Different query plans for the same query Tom Lane (15:42)
Planner question - wrong row count estimation Michael Korbakov (14:28)
Re: Use of BETWEEN with identical values Robert Haas (14:01)
Re: Database performance post-VACUUM FULL Robert Haas (13:40)
Database performance post-VACUUM FULL Karl Wright (13:11)
Re: Different query plans for the same query Hell, Robert (09:51)
Re: Different query plans for the same query tv (09:20)
Different query plans for the same query Hell, Robert (08:06)
Re: Planner question - "bit" data types Karl Denninger (03:50)
Re: Planner question - "bit" data types Bruce Momjian (03:19)
Re: Planner question - "bit" data types Bruce Momjian (03:13)
Re: Planner question - "bit" data types Karl Denninger (03:10)
Re: Planner question - "bit" data types Bruce Momjian (02:29)
17 September 2009
Re: noapic option christian.storm (18:32)
Re: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Vlad Romascanu (16:49)
Use of BETWEEN with identical values André Volpato (15:26)
Re: optimizing for temporal data behind a view हृषीकेश मेहेंदळ े (14:54)
Re: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Andy Colson (13:45)
Re: statistical table Joshua Tolley (13:43)
Re: statistical table Lennin Caro (13:43)
optimizing for temporal data behind a view Richard Henwood (13:02)
Re: noapic option Craig Ringer (08:02)
Re: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Richard Huxton (07:58)
16 September 2009
15 September 2009
statement stats extra load? Alan McKay (18:13)
Re: View vs Stored Proc Performance Ivan Voras (16:13)
Re: disable heavily updated (but small) table auto-vecuuming Robert Haas (15:45)
Re: View vs Stored Proc Performance Tom Lane (15:26)
Re: View vs Stored Proc Performance Ivan Voras (15:15)
Re: How to post Performance Questions Kevin Grittner (14:50)
Problem with partitionning and orderby query plans Gaël Le Mignot (12:58)
Re: CLUSTER and a problem Andrzej Zawadzki (11:13)
Re: possible wrong query plan on pg 8.3.5, zz_11 (10:10)
statistical table std pik (09:32)
disable heavily updated (but small) table auto-vecuuming Ludwik Dylag (08:06)
Re: CLUSTER and a problem Andrzej Zawadzki (07:36)
Re: possible wrong query plan on pg 8.3.5, Віталій Тимчишин (06:32)
14 September 2009
Re: CLUSTER and a problem Tom Lane (23:13)
noapic option C Storm (22:01)
Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Vlad Romascanu (21:54)
Re: CLUSTER and a problem Andrzej Zawadzki (21:08)
How to post Performance Questions Josh Berkus (20:56)