Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance - September 2010

Prev | Next

Jump to day: 1 2 3 4 7 8 9 10 11 12 13 14 15 16 18 20 21 22 23 24 25 26 27 28 29 30

2010-09-02

Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (05:53)
Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane (13:14)

2010-09-03

Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (05:03)
Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (05:07)
Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane (14:14)
Odd estimation issue with user-defined type Florian Weimer (14:15)
Re: Odd estimation issue with user-defined type Tom Lane (15:14)
Re: Odd estimation issue with user-defined type Florian Weimer (15:28)
Question about LEFT JOIN and query plan Kaloyan Iliev Iliev (16:16)
Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (16:38)
Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane (16:47)
Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (16:57)
Re: Question about LEFT JOIN and query plan Tom Lane (17:14)
Re: Question about LEFT JOIN and query plan Kevin Grittner (17:16)
Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane (17:16)
Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (17:57)
Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane (18:09)
Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (18:27)
Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane (18:44)
Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (19:34)
Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane (21:10)

2010-09-04

Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (06:58)

2010-09-07

Re: Question about LEFT JOIN and query plan Kaloyan Iliev Iliev (07:19)
Re: Question about LEFT JOIN and query plan Kaloyan Iliev Iliev (13:13)
Re: Question about LEFT JOIN and query plan Kaloyan Iliev Iliev (13:28)
Re: Question about LEFT JOIN and query plan Kevin Grittner (14:29)
Re: Question about LEFT JOIN and query plan Kevin Grittner (16:54)

2010-09-08

pgbench could not send data to client: Broken pipe David Kerr (17:46)
Re: pgbench could not send data to client: Broken pipe Tom Lane (19:10)
Re: pgbench could not send data to client: Broken pipe Greg Smith (19:27)
Re: pgbench could not send data to client: Broken pipe Tom Lane (19:44)
Re: pgbench could not send data to client: Broken pipe David Kerr (19:56)
Re: pgbench could not send data to client: Broken pipe David Kerr (19:58)
Re: pgbench could not send data to client: Broken pipe Tom Lane (20:35)
Re: pgbench could not send data to client: Broken pipe David Kerr (20:44)
Re: pgbench could not send data to client: Broken pipe Kevin Grittner (20:56)
Re: pgbench could not send data to client: Broken pipe David Kerr (21:20)
Re: pgbench could not send data to client: Broken pipe Kevin Grittner (21:51)
Re: pgbench could not send data to client: Broken pipe David Kerr (22:00)
Re: pgbench could not send data to client: Broken pipe Kevin Grittner (22:27)
Re: pgbench could not send data to client: Broken pipe David Kerr (22:29)

2010-09-09

Re: pgbench could not send data to client: Broken pipe Alvaro Herrera (14:38)
Re: pgbench could not send data to client: Broken pipe David Kerr (15:12)
Re: pgbench could not send data to client: Broken pipe Greg Smith (16:05)
Re: pgbench could not send data to client: Broken pipe Kevin Grittner (17:24)
Re: pgbench could not send data to client: Broken pipe Greg Smith (18:07)

2010-09-10

Slow SQL lookup due to every field being listed in SORT KEY Mason Harding (22:35)

2010-09-11

Re: Slow SQL lookup due to every field being listed inSORT KEY Stephen Frost (01:59)
Re: Slow SQL lookup due to every field being listed in SORT KEY Tom Lane (02:00)
Re: Slow SQL lookup due to every field being listed inSORT KEY Stephen Frost (02:03)

2010-09-12

Problem with mergejoin performance (some bug?) azajac (17:34)

2010-09-13

Problem with mergejoin performance azajac (05:49)
Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (06:39)
Useless sort by Gaetano Mendola (09:47)
Re: Problem with mergejoin performance Tom Lane (14:26)
Re: Useless sort by Tom Lane (14:44)
Re: Problem with mergejoin performance Tom Lane (15:16)
Re: Useless sort by Gaetano Mendola (15:55)
Re: Useless sort by Tom Lane (16:48)
Re: Useless sort by Gaetano Mendola (17:09)
Re: Useless sort by Maciek Sakrejda (17:24)
Re: Major performance problem after upgrade from 8.3 to 8.4 Merlin Moncure (18:32)
Re: Useless sort by Scott Marlowe (19:08)
Where does data in pg_stat_user_tables come from? Josh Berkus (23:06)
Re: Where does data in pg_stat_user_tables come from? Joshua D. Drake (23:41)
Re: Where does data in pg_stat_user_tables come from? Josh Berkus (23:47)

2010-09-14

Re: Where does data in pg_stat_user_tables come from? Joshua D. Drake (00:12)
Re: Where does data in pg_stat_user_tables come from? Josh Berkus (00:53)
Re: Where does data in pg_stat_user_tables come from? Tom Lane (01:40)
Re: Where does data in pg_stat_user_tables come from? Alvaro Herrera (03:57)
Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (06:07)
Re: Useless sort by Heikki Linnakangas (07:10)
Re: Major performance problem after upgrade from 8.3 to 8.4 Merlin Moncure (12:01)
Re: Useless sort by Maciek Sakrejda (15:09)
Held idle connections vs use of a Pooler mark (16:10)
Re: Useless sort by Dave Crooke (16:15)
Re: Held idle connections vs use of a Pooler Craig James (16:44)
Re: Held idle connections vs use of a Pooler Joshua D. Drake (16:58)
Re: Held idle connections vs use of a Pooler Merlin Moncure (17:01)
Re: Useless sort by Gaetano Mendola (17:06)
Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (19:59)

2010-09-15

Performance problem with joined aggregate query Anssi Kääriäinen (06:26)
Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (06:32)
locking issue on simple selects? Tobias Brox (10:05)
POSTGRES error Timothy.Noonan (11:07)
Re: Major performance problem after upgrade from 8.3 to 8.4 Merlin Moncure (11:52)
Re: POSTGRES error Kevin Grittner (13:38)
Re: locking issue on simple selects? Tom Lane (13:39)
Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger (18:39)
Re: locking issue on simple selects? Tobias Brox (19:07)
Re: locking issue on simple selects? Tom Lane (19:21)
Re: locking issue on simple selects? Greg Smith (19:28)
Re: locking issue on simple selects? Brad Nicholson (19:32)
Re: turn off caching for performance test Merlin Moncure (21:10)
Re: locking issue on simple selects? Tobias Brox (21:33)
Re: Performance problem with joined aggregate query Merlin Moncure (22:25)

2010-09-16

Re: locking issue on simple selects? Greg Smith (00:32)
Re: Performance problem with joined aggregate query Anssi Kääriäinen (05:51)
Is disableing nested_loops a bad idea ? Franck Routier (08:23)
Re: Is disableing nested_loops a bad idea ? Samuel Gendler (09:55)
Re: Is disableing nested_loops a bad idea ? Kevin Grittner (13:49)
Re: Is disableing nested_loops a bad idea ? Franck Routier (14:13)
Re: Is disableing nested_loops a bad idea ? Kevin Grittner (14:25)
Re: Performance problem with joined aggregate query Merlin Moncure (14:52)
Re: Where does data in pg_stat_user_tables come from? Josh Berkus (18:39)
Re: Where does data in pg_stat_user_tables come from? Guillaume Lelarge (19:02)
Re: Where does data in pg_stat_user_tables come from? Tom Lane (19:14)
Re: Where does data in pg_stat_user_tables come from? Josh Berkus (19:34)

2010-09-18

3ware trivia overload Greg Smith (07:50)

2010-09-20

Performance degradation, index bloat and planner estimates Daniele Varrazzo (11:59)
cleanup on pg_ system tables? mark (17:25)
Need PostgreSQL data warehousing user, on the record Josh Berkus (18:47)
Re: cleanup on pg_ system tables? Josh Kupershmidt (19:24)
Auto ANALYZE criteria Joe Miller (20:38)
Re: 3ware trivia overload George Sexton (21:54)
Re: 3ware trivia overload David Rees (22:09)
Re: Auto ANALYZE criteria Kevin Grittner (22:28)

2010-09-21

Re: Auto ANALYZE criteria Tom Lane (02:12)
Memory speed testing Greg Smith (04:20)
Re: Auto ANALYZE criteria Joe Miller (13:33)
Re: Auto ANALYZE criteria Joe Miller (14:59)
Query much faster with enable_seqscan=0 Ogden (17:32)
Re: Query much faster with enable_seqscan=0 Kenneth Marshall (18:06)
Re: Query much faster with enable_seqscan=0 Ogden (18:21)
Re: Query much faster with enable_seqscan=0 Jesper Krogh (18:51)
Re: Query much faster with enable_seqscan=0 Ogden (19:02)
Re: Query much faster with enable_seqscan=0 Joshua D. Drake (19:07)
Re: Query much faster with enable_seqscan=0 Greg Smith (19:16)
Re: GPU Accelerated Sorting Robert Haas (19:27)
Re: Query much faster with enable_seqscan=0 Ogden (19:34)
Re: Using Between Robert Haas (19:35)
Re: slow DDL creation Robert Haas (19:38)
Re: Using Between Ozer, Pam (20:04)
Re: Auto ANALYZE criteria Tom Lane (20:44)
Re: Query much faster with enable_seqscan=0 Tom Lane (23:24)
Re: Query much faster with enable_seqscan=0 Tom Lane (23:30)

2010-09-22

Re: Performance degradation, index bloat and planner estimates Craig Ringer (04:09)
Re: Performance degradation, index bloat and planner estimates Tom Lane (04:20)
Re: Using Between Robert Haas (10:51)
Re: Query much faster with enable_seqscan=0 Ogden (13:36)
Re: Using Between Ozer, Pam (15:18)
Re: Using Between Robert Haas (16:27)
Re: Using Between Ozer, Pam (16:28)

2010-09-23

Re: Using Between mark (00:51)
Re: Useless sort by Robert Haas (00:54)
Re: Useless sort by gnuoytr (03:05)
Re: Useless sort by Greg Smith (04:01)
Re: Useless sort by Scott Marlowe (04:18)
Re: Useless sort by Robert Haas (04:46)
Re: Useless sort by gnuoytr (13:51)
how to enforce index sub-select over filter+seqscan Dmitry Teslenko (14:26)
Re: how to enforce index sub-select over filter+seqscan Kevin Grittner (15:43)
Re: Useless sort by Scott Marlowe (17:11)
Re: how to enforce index sub-select over filter+seqscan Merlin Moncure (19:41)
Re: locking issue on simple selects? Tobias Brox (20:47)
Re: locking issue on simple selects? Kevin Grittner (20:55)
Memory usage - indexes Tobias Brox (21:50)
Re: Memory usage - indexes Mark Kirkwood (22:12)
Re: locking issue on simple selects? Tobias Brox (22:25)
Re: locking issue on simple selects? Kevin Grittner (22:50)

2010-09-24

postgresql-9.0 Windows service stops after database transaction adrian.kitchingman (04:39)
Re: postgresql-9.0 Windows service stops after database transaction Thom Brown (07:05)
Re: Memory usage - indexes Kevin Grittner (14:17)
Re: Memory usage - indexes Bob Lunney (16:23)
Re: Memory usage - indexes Tobias Brox (16:46)
Re: Memory usage - indexes Tobias Brox (16:52)
Re: Memory usage - indexes Brad Nicholson (17:16)
Re: Query much faster with enable_seqscan=0 Scott Carey (17:34)
Re: Memory usage - indexes Tobias Brox (17:41)
Re: Memory usage - indexes Kevin Grittner (17:50)
Re: Memory usage - indexes Greg Smith (18:01)
Re: Memory usage - indexes Greg Smith (18:05)
Re: Memory usage - indexes Brad Nicholson (18:34)
Re: Memory usage - indexes Bob Lunney (19:06)
Re: Memory usage - indexes Brad Nicholson (19:24)
Re: Memory usage - indexes Tobias Brox (19:58)
Re: Memory usage - indexes Tobias Brox (20:00)
Re: Memory usage - indexes Tobias Brox (20:08)
Re: Memory usage - indexes Tobias Brox (20:50)
Re: Memory usage - indexes Greg Smith (22:00)

2010-09-25

Re: Memory usage - indexes Tobias Brox (10:29)

2010-09-26

Re: turn off caching for performance test Robert Haas (03:36)
Re: Is disableing nested_loops a bad idea ? Robert Haas (04:02)
Re: postgresql-9.0 Windows service stops after database transaction adrian.kitchingman (23:18)

2010-09-27

Re: postgresql-9.0 Windows service stops after database transaction adrian.kitchingman (00:06)
Re: Memory speed testing Greg Smith (16:53)
Re: how to enforce index sub-select over filter+seqscan Robert Haas (17:30)
Odd behaviour with redundant CREATE statement Dave Crooke (18:50)
Re: Odd behaviour with redundant CREATE statement Gurjeet Singh (19:27)

2010-09-28

Re: postgresql-9.0 Windows service stops after database transaction Craig Ringer (09:11)
Clean up of archived Xlogs in postgres-9. Nimesh Satam (10:01)
Re: Clean up of archived Xlogs in postgres-9. Erik Rijkers (12:29)
Re: Query much faster with enable_seqscan=0 Robert Haas (16:03)
Running 9 in production? Sticking with 8.4.4 for a while? Tory M Blue (19:22)
Re: Running 9 in production? Sticking with 8.4.4 for a while? Michael Gould (19:50)
Re: Running 9 in production? Sticking with 8.4.4 for a while? Greg Smith (20:45)
Re: Running 9 in production? Sticking with 8.4.4 for a while? Guy Rouillier (22:14)
Re: Running 9 in production? Sticking with 8.4.4 for a while? Tory M Blue (22:52)

2010-09-29

Re: Memory usage - indexes Tobias Brox (06:41)
Re: Memory usage - indexes Mark Kirkwood (08:03)

Prev | Next

Jump to day: 1 2 3 4 7 8 9 10 11 12 13 14 15 16 18 20 21 22 23 24 25 26 27 28 29 30

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group