Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-performance - May 2009

May 1, 2009

• Re: bad plan and LIMIT Adam Ruth (08:22)
• Re: bad plan and LIMIT Grzegorz Jaśkiewicz (08:32)
• Re: bad plan and LIMIT Grzegorz Jaśkiewicz (11:12)
• Many left outer joins with limit performance Gerhard Wiesinger (13:55)
• Transparent table partitioning in future version of PG? henk de wit (14:32)
• Re: bad plan and LIMIT James Nelson (14:55)
• Re: bad plan and LIMIT Tom Lane (14:57)
• Re: bad plan and LIMIT James Nelson (15:07)
• Re: Transparent table partitioning in future version of PG? Robert Haas (15:27)
• Re: bad plan and LIMIT James Nelson (15:42)
• Re: Many left outer joins with limit performance Tom Lane (16:14)
• Re: Transparent table partitioning in future version of PG? Scott Carey (17:14)

May 2, 2009

• Re: performance for high-volume log insertion PFC (00:29)
• Re: performance for high-volume log insertion david (00:49)
• Re: performance for high-volume log insertion Glenn Maynard (04:13)

May 4, 2009

• high shared buffer and swap Laurent Laborde (08:10)
• Re: high shared buffer and swap Greg Stark (08:57)
• Re: [HACKERS] high shared buffer and swap Martijn van Oosterhout (10:15)
• Re: high shared buffer and swap Scott Marlowe (15:07)

May 5, 2009

• Limit I/O bandwidth of a certain backend Vlad Arkhipov (07:31)
• Re: [HACKERS] high shared buffer and swap PFC (09:15)
• Re: [HACKERS] high shared buffer and swap Laurent Laborde (10:20)
• Re: [HACKERS] high shared buffer and swap Matthew Wakeling (11:24)

May 6, 2009

• Re: Limit I/O bandwidth of a certain backend Bryan Murphy (00:54)
• Re: Limit I/O bandwidth of a certain backend Greg Smith (05:10)
• Any better plan for this query?.. Dimitri (07:38)
• Re: Any better plan for this query?.. Craig Ringer (08:01)
• Re: Any better plan for this query?.. Dimitri (08:14)
• Re: Any better plan for this query?.. Heikki Linnakangas (08:20)
• Re: Any better plan for this query?.. Chris (08:22)
• Re: Any better plan for this query?.. Dimitri (08:31)
• Re: Any better plan for this query?.. Dimitri (08:33)
• Re: Any better plan for this query?.. Richard Huxton (08:40)
• Re: Any better plan for this query?.. Dimitri (08:49)
• Re: Any better plan for this query?.. Richard Huxton (09:02)
• Re: Any better plan for this query?.. Matthew Wakeling (09:35)
• Re: Any better plan for this query?.. Merlin Moncure (11:46)
• Re: Any better plan for this query?.. Merlin Moncure (11:47)
• Re: Any better plan for this query?.. Albe Laurenz (11:57)
• Re: Any better plan for this query?.. Dimitri (12:33)
• Re: Any better plan for this query?.. Dimitri (12:49)
• Re: Any better plan for this query?.. Richard Huxton (12:53)
• Re: Any better plan for this query?.. Kenneth Marshall (12:58)
• Re: Any better plan for this query?.. Kenneth Marshall (13:05)
• Re: Any better plan for this query?.. Ries van Twisk (13:08)
• Re: Any better plan for this query?.. Dimitri (14:03)
• Re: Any better plan for this query?.. Craig Ringer (14:04)
• Re: Any better plan for this query?.. Kenneth Marshall (14:26)
• Re: Any better plan for this query?.. Matthew Wakeling (14:28)
• Re: Any better plan for this query?.. Dimitri (14:31)
• Re: Any better plan for this query?.. Kenneth Marshall (14:34)
• Re: Any better plan for this query?.. Dimitri (14:48)
• Re: Any better plan for this query?.. Kenneth Marshall (15:49)
• Re: Any better plan for this query?.. Simon Riggs (21:23)
• Re: Transparent table partitioning in future version ofPG? Simon Riggs (21:34)
• Re: Transparent table partitioning in future version of PG? Tom Lane (21:55)
• Re: GiST index performance Tom Lane (22:07)
• Re: Transparent table partitioning in future version ofPG? Simon Riggs (22:08)

May 7, 2009

• Re: Transparent table partitioning in future version ofPG? Alvaro Herrera (02:16)
• Re: Transparent table partitioning in future version of PG? Tom Lane (02:27)
• Re: Transparent table partitioning in future version of PG? Craig Ringer (02:56)
• Re: Any better plan for this query?.. Dimitri (08:20)
• Re: Any better plan for this query?.. Dimitri (08:41)
• Re: Transparent table partitioning in future version ofPG? Simon Riggs (08:54)
• Re: GiST index performance Oleg Bartunov (11:09)
• Re: Any better plan for this query?.. Merlin Moncure (11:34)
• Re: Any better plan for this query?.. Gregory Stark (11:58)
• Re: Any better plan for this query?.. Simon Riggs (12:21)
• Re: GiST index performance Matthew Wakeling (12:31)
• Slow select performance despite seemingly reasonable query plan David Brain (14:14)
• Re: Slow select performance despite seemingly reasonable query plan Scott Mead (14:26)
• Re: Slow select performance despite seemingly reasonable query plan David Brain (14:48)
• Re: Slow select performance despite seemingly reasonable query plan Matthew Wakeling (14:53)
• Re: Slow select performance despite seemingly reasonable query plan David Brain (15:11)
• Re: Slow select performance despite seemingly reasonable query plan Nikolas Everett (15:18)
• Re: Slow select performance despite seemingly reasonable query plan Matthew Wakeling (15:19)
• Re: Any better plan for this query?.. Alvaro Herrera (15:26)
• Re: Slow select performance despite seemingly reasonable query plan Nikolas Everett (15:37)
• Bad Plan for Questionnaire-Type Query David Blewett (16:53)
• Re: Bad Plan for Questionnaire-Type Query David Blewett (17:28)
• Re: Transparent table partitioning in future version of PG? Scott Carey (17:36)
• Re: Any better plan for this query?.. Dimitri (18:36)
• Re: Any better plan for this query?.. Simon Riggs (19:32)
• Re: Bad Plan for Questionnaire-Type Query Tom Lane (20:31)
• Indexes not used in DELETE Viktor Rosenfeld (22:38)
• Re: Bad Plan for Questionnaire-Type Query David Blewett (22:41)
• Re: Bad Plan for Questionnaire-Type Query Tom Lane (22:44)
• Re: Bad Plan for Questionnaire-Type Query David Blewett (22:56)
• Re: Indexes not used in DELETE Tom Lane (23:06)

May 8, 2009

• Re: Transparent table partitioning in future version of PG? Robert Haas (02:20)
• Re: Transparent table partitioning in future version of PG? david (02:52)
• Rohan Pethkar sent you a Friend Request on Yaari Rohan Pethkar (05:32)
• Re: Indexes not used in DELETE Viktor Rosenfeld (10:17)
• Statistics use with functions Matthew Wakeling (13:46)
• Re: Statistics use with functions Tom Lane (15:48)
• PostgreSQL with PostGIS on embedded hardware Paolo Rizzi (16:06)
• Re: Statistics use with functions Matthew Wakeling (16:11)
• Re: Statistics use with functions Tom Lane (16:16)
• Re: Transparent table partitioning in future version of PG? Robert Haas (16:47)
• Re: PostgreSQL with PostGIS on embedded hardware Joshua D. Drake (16:56)
• Re: Transparent table partitioning in future version of PG? Scott Carey (17:09)
• Re: PostgreSQL with PostGIS on embedded hardware Paolo Rizzi (17:50)
• Re: Transparent table partitioning in future version of PG? david (18:20)
• Re: PostgreSQL with PostGIS on embedded hardware Fernando Hevia (19:04)
• Re: Transparent table partitioning in future version of PG? Scott Carey (19:40)
• Re: Transparent table partitioning in future version of PG? Robert Haas (20:53)
• Re: Transparent table partitioning in future version of PG? Tom Lane (21:03)
• Re: PostgreSQL with PostGIS on embedded hardware Paolo Rizzi (23:10)
• Re: PostgreSQL with PostGIS on embedded hardware PFC (23:50)

May 9, 2009

• Re: PostgreSQL with PostGIS on embedded hardware Paolo Rizzi (00:02)
• Re: Bad Plan for Questionnaire-Type Query Tom Lane (00:08)
• Re: PostgreSQL with PostGIS on embedded hardware Tom Lane (00:17)
• Re: Transparent table partitioning in future version of PG? Craig Ringer (01:25)
• Re: Bad Plan for Questionnaire-Type Query Tom Lane (02:00)
• Re: Slow select performance despite seemingly reasonable query plan Laurent Wandrebeck (09:43)
• Re: Bad Plan for Questionnaire-Type Query David Blewett (15:15)
• Re: Bad Plan for Questionnaire-Type Query Tom Lane (15:52)

May 10, 2009

• Re: Bad Plan for Questionnaire-Type Query David Blewett (20:36)

May 11, 2009

• Reminder: Please Respond to Rohan's Invitation Rohan Pethkar (05:47)
• Re: PostgreSQL with PostGIS on embedded hardware Paolo Rizzi (11:41)
• Re: PostgreSQL with PostGIS on embedded hardware PFC (12:48)
• Re: Any better plan for this query?.. Dimitri (15:18)
• Re: Any better plan for this query?.. Tom Lane (15:23)
• Re: PostgreSQL with PostGIS on embedded hardware Stefan Kaltenbrunner (16:05)
• What is the most optimal config parameters to keep stable write TPS ?.. Dimitri (16:15)
• Re: What is the most optimal config parameters tokeep stable write TPS ?.. Kevin Grittner (16:19)
• Re: Any better plan for this query?.. Dimitri (16:22)
• Re: What is the most optimal config parameters to keep stable write TPS ?.. Dimitri (16:31)
• Re: What is the most optimal config parameters tokeep stable write TPS ?.. Kevin Grittner (16:45)
• Re: What is the most optimal config parameters to keep stable write TPS ?.. Dimitri (17:02)
• Re: What is the most optimal config parameters tokeep stable write TPS ?.. Kevin Grittner (17:13)
• Re: What is the most optimal config parameters to keep stable write TPS ?.. Scott Marlowe (17:15)
• Re: What is the most optimal config parameters to keep stable write TPS ?.. Dimitri (17:31)
• Re: What is the most optimal config parameters to keep stable write TPS ?.. Dimitri (17:36)
• Re: Any better plan for this query?.. Merlin Moncure (17:46)
• Re: Any better plan for this query?.. Simon Riggs (18:26)
• Re: Any better plan for this query?.. Simon Riggs (19:03)
• Re: Any better plan for this query?.. Aidan Van Dyk (19:46)
• Query planner making bad decisions Cory Coager (21:03)
• Re: Any better plan for this query?.. Dimitri (22:30)
• Re: Any better plan for this query?.. Dimitri (22:46)
• Re: Any better plan for this query?.. Alvaro Herrera (22:54)
• Re: Query planner making bad decisions Tom Lane (23:02)

May 12, 2009

• Re: What is the most optimal config parameters to keep stable write TPS ?.. Greg Smith (02:15)
• Re: What is the most optimal config parameters to keep stable write TPS ?.. Scott Marlowe (02:38)
• Re: Any better plan for this query?.. Heikki Linnakangas (05:11)
• Re: Any better plan for this query?.. Dimitri (07:29)
• Re: Any better plan for this query?.. Dimitri (07:36)
• Re: Any better plan for this query?.. Andres Freund (07:43)
• Re: Any better plan for this query?.. Dimitri Fontaine (08:44)
• Timestamp index not used in some cases Евгений Василев (09:00)
• Re: What is the most optimal config parameters to keep stable write TPS ?.. Laurent Laborde (09:23)
• Re: What is the most optimal config parameters to keep stable write TPS ?.. Dimitri (09:36)
• Re: Timestamp index not used in some cases Scott Marlowe (09:55)
• Re: Any better plan for this query?.. Dimitri (10:19)
• Re: Any better plan for this query?.. Simon Riggs (10:48)
• Re: Any better plan for this query?.. Dimitri (11:16)
• Re: Any better plan for this query?.. Simon Riggs (11:33)
• Re: Any better plan for this query?.. Heikki Linnakangas (11:35)
• Re: Any better plan for this query?.. Simon Riggs (11:49)
• Re: Query planner making bad decisions Cory Coager (12:05)
• Re: Any better plan for this query?.. Dimitri (12:28)
• Re: Any better plan for this query?.. Stefan Kaltenbrunner (12:36)
• Re: Any better plan for this query?.. Dimitri (12:59)
• Re: What is the most optimal config parameters to keep stable write TPS ?.. Julian v. Bock (13:15)
• Re: Any better plan for this query?.. Dimitri (13:25)
• Re: Any better plan for this query?.. Robert Haas (14:21)
• Re: Any better plan for this query?.. Stefan Kaltenbrunner (14:34)
• Re: Any better plan for this query?.. Matthew Wakeling (15:00)
• Re: Any better plan for this query?.. Simon Riggs (15:04)
• Re: Any better plan for this query?.. Matthew Wakeling (15:05)
• Re: Any better plan for this query?.. Stefan Kaltenbrunner (15:14)
• Re: Any better plan for this query?.. Tom Lane (15:18)
• Re: Any better plan for this query?.. Dimitri (15:22)
• Re: Any better plan for this query?.. Dimitri (15:37)
• Re: What is the most optimal config parameters to keep stable write TPS ?.. Dimitri (15:41)
• Re: Any better plan for this query?.. Kevin Grittner (15:46)
• Re: Any better plan for this query?.. Joshua D. Drake (16:07)
• Re: Any better plan for this query?.. Dimitri (16:16)
• Re: Any better plan for this query?.. Robert Haas (16:26)
• Re: Any better plan for this query?.. Robert Haas (16:32)
• Re: Any better plan for this query?.. Tom Lane (16:49)
• Re: Any better plan for this query?.. Dimitri (17:00)
• Re: Any better plan for this query?.. Alvaro Herrera (17:53)
• Re: Any better plan for this query?.. Robert Haas (17:57)
• Re: Any better plan for this query?.. Scott Carey (18:30)
• Re: Any better plan for this query?.. Simon Riggs (18:46)
• AMD Shanghai versus Intel Nehalem Scott Marlowe (18:47)
• Re: Any better plan for this query?.. Greg Stark (19:15)
• Re: Any better plan for this query?.. Robert Haas (19:52)
• Re: Any better plan for this query?.. Simon Riggs (20:24)
• Re: Any better plan for this query?.. Robert Haas (20:37)
• Re: Any better plan for this query?.. Dimitri Fontaine (21:21)
• Re: Query planner making bad decisions Rafael Martinez (21:25)
• Re: Any better plan for this query?.. Glenn Maynard (21:52)
• increase index performance Thomas Finneid (21:52)
• superlative missuse Angel Alvarez (21:53)
• Re: Any better plan for this query?.. Joshua D. Drake (22:41)
• Re: Any better plan for this query?.. Alvaro Herrera (23:54)

May 13, 2009

• Re: superlative missuse David Wilson (00:12)