Peripheral Links

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

pgsql-performance - July 2010

2010-07-01

• Re: Analysis Function Bruce Momjian (00:42)
• What is the best way to optimize this query Srikanth Kata (05:19)
• how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer Rajesh Kumar Mallah (09:41)
• Re: Extremely high CPU usage when building tables Rajesh Kumar Mallah (09:49)
• Re: PostgreSQL as a local in-memory cache Greg Smith (10:00)
• Re: What is the best way to optimize this query Rajesh Kumar Mallah (12:40)
• Re: What is the best way to optimize this query Thom Brown (12:51)
• optimal ZFS filesystem on JBOD layout Joachim Worringen (13:14)
• Re: optimal ZFS filesystem on JBOD layout Greg Smith (14:15)
• Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer Craig Ringer (16:37)
• Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer Rajesh Kumar Mallah (17:59)
• big data - slow select (speech search) Michal Fapso (22:34)

2010-07-02

• Highly Efficient Custom Sorting Eliot Gable (00:46)
• Re: No hash join across partitioned tables? Bruce Momjian (03:00)
• Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer Craig Ringer (03:00)
• Re: Highly Efficient Custom Sorting Craig Ringer (03:04)
• Re: No hash join across partitioned tables? Tom Lane (04:05)
• Re: Highly Efficient Custom Sorting Tom Lane (04:08)
• Re: big data - slow select (speech search) Michal Fapso (05:23)
• Performance issues with postgresql-8.4.0: Query gets stuck sometimes Sachin Kumar (05:40)
• Re: Performance issues with postgresql-8.4.0: Query gets stuck sometimes Scott Marlowe (05:50)
• Slow query with planner row strange estimation damien hostin (08:48)
• Re: Highly Efficient Custom Sorting Merlin Moncure (13:59)
• Re: Highly Efficient Custom Sorting Eliot Gable (13:59)
• using dbt2 postgresql 8.4 - rampup time issue MUHAMMAD ASIF (14:38)
• Re: Highly Efficient Custom Sorting Matthew Wakeling (14:50)
• Re: Highly Efficient Custom Sorting Merlin Moncure (14:56)
• Question about partitioned query behavior Ranga Gopalan (15:28)
• Re: Highly Efficient Custom Sorting Craig James (16:36)
• Re: Question about partitioned query behavior Benjamin Krajmalnik (16:40)
• Re: Low perfomance SUM and Group by large databse Robert Haas (17:21)
• Re: Extremely high CPU usage when building tables Deborah Fuentes (19:07)
• Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer Rajesh Kumar Mallah (19:22)
• Re: Extremely high CPU usage when building tables Rajesh Kumar Mallah (19:53)
• Re: No hash join across partitioned tables? Bruce Momjian (20:53)
• Re: No hash join across partitioned tables? Tom Lane (20:58)
• Re: No hash join across partitioned tables? Robert Haas (21:10)
• Re: No hash join across partitioned tables? Bruce Momjian (21:12)
• Re: using dbt2 postgresql 8.4 - rampup time issue Mark Wong (23:56)

2010-07-03

• Re: Highly Efficient Custom Sorting Craig Ringer (01:44)
• Re: Highly Efficient Custom Sorting Eliot Gable (03:17)
• Re: Highly Efficient Custom Sorting Merlin Moncure (18:08)
• Re: Highly Efficient Custom Sorting Eliot Gable (20:17)
• Re: Highly Efficient Custom Sorting Merlin Moncure (22:53)

2010-07-04

• Re: Highly Efficient Custom Sorting Alvaro Herrera (02:47)
• Re: Performance issues with postgresql-8.4.0 Craig Ringer (12:38)

2010-07-05

• Two "equivalent" WITH RECURSIVE queries, one of them slow. Octavio Alvarez (06:07)
• Re: Slow query with planner row strange estimation damien hostin (07:28)
• Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer Matthew Wakeling (09:55)
• SeqScans on boolen values / How to speed this up? Jens Hoffrichter (11:36)
• Re: SeqScans on boolen values / How to speed this up? Stephen Frost (13:47)
• Re: using dbt2 postgresql 8.4 - rampup time issue MUHAMMAD ASIF (17:24)

2010-07-06

• Re: big data - slow select (speech search) Robert Haas (00:25)
• Re: Performance issues with postgresql-8.4.0: Query gets stuck sometimes Robert Haas (00:34)
• Re: SeqScans on boolen values / How to speed this up? Craig Ringer (02:42)
• Re: SeqScans on boolen values / How to speed this up? Scott Marlowe (03:19)
• Re: Slow query with planner row strange estimation damien hostin (12:48)
• Re: Extremely high CPU usage when building tables Deborah Fuentes (15:59)
• Re: Question about partitioned query behavior Ranga Gopalan (16:30)
• Re: Extremely high CPU usage when building tables Kevin Grittner (17:43)
• Re: Highly Efficient Custom Sorting Robert Haas (19:01)
• Re: Two "equivalent" WITH RECURSIVE queries, one of them slow. Robert Haas (19:21)
• Re: Question about partitioned query behavior Robert Haas (19:30)
• Re: Highly Efficient Custom Sorting Eliot Gable (19:42)
• Re: Highly Efficient Custom Sorting Joe Conway (20:00)
• Re: Highly Efficient Custom Sorting Eliot Gable (20:17)
• Re: Question about partitioned query behavior Stephen Frost (20:26)
• Re: Question about partitioned query behavior Ranga Gopalan (21:02)
• Re: Highly Efficient Custom Sorting Eliot Gable (21:53)
• Re: Highly Efficient Custom Sorting Tom Lane (22:21)

2010-07-07

• Re: using dbt2 postgresql 8.4 - rampup time issue Mark Wong (00:35)
• WAL partition overloaded--by autovacuum? Richard Yen (01:10)
• Re: WAL partition overloaded--by autovacuum? Scott Marlowe (03:25)
• Re: WAL partition overloaded--by autovacuum? Scott Marlowe (03:27)
• Re: WAL partition overloaded--by autovacuum? Scott Marlowe (04:13)
• Invitation to connect on LinkedIn Gourish Singbal (06:33)
• Two different execution plan for the same request JOUANIN Nicolas (44) (07:55)
• Re: Two different execution plan for the same request Yeb Havinga (08:27)
• Re: Two different execution plan for the same request JOUANIN Nicolas (44) (08:47)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Mark Kirkwood (08:58)
• Re: Two different execution plan for the same request Yeb Havinga (08:59)
• Re: Two different execution plan for the same request Guillaume Smet (08:59)
• Re: Two different execution plan for the same request JOUANIN Nicolas (44) (11:27)
• Re: WAL partition overloaded--by autovacuum? Kevin Grittner (11:58)
• Re: Two different execution plan for the same request Matthew Wakeling (12:34)
• Re: Two "equivalent" WITH RECURSIVE queries, one of them slow. Merlin Moncure (13:14)
• Re: big data - slow select (speech search) Michal Fapso (13:31)
• Re: Slow query with planner row strange estimation damien hostin (14:39)
• Re: Weird XFS WAL problem Bruce Momjian (14:42)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Richard Yen (16:39)
• Re: Highly Efficient Custom Sorting Eliot Gable (19:23)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Richard Yen (19:32)
• Re: Highly Efficient Custom Sorting Kenneth Marshall (19:42)
• Re: big data - slow select (speech search) Robert Haas (20:49)
• Logarithmic data frequency distributions and the query planner Jerry Gamache (20:54)
• Re: Logarithmic data frequency distributions and the query planner Tom Lane (21:22)
• performance on new linux box Ryan Wexler (23:06)

2010-07-08

• Re: performance on new linux box Tom Lane (00:39)
• Re: performance on new linux box Rob Wultsch (00:39)
• Re: performance on new linux box Andy Colson (02:07)
• Re: performance on new linux box Pierre C (08:56)
• Re: performance on new linux box Eliot Gable (13:45)
• Re: performance on new linux box Kevin Grittner (13:53)
• Re: performance on new linux box Eliot Gable (14:38)
• Re: performance on new linux box Kevin Grittner (15:02)
• Re: performance on new linux box Ryan Wexler (16:31)
• Re: performance on new linux box Joshua D. Drake (17:04)
• Re: performance on new linux boxeradmin(11983)i: STATEMENT: update license set expires= '2010-06-15' where lic John Rouillard (17:05)
• Re: performance on new linux box Craig James (17:10)
• Fwd: performance on new linux box Ryan Wexler (17:16)
• Re: Slow query with planner row strange estimation Robert Haas (18:42)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Robert Haas (18:51)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Kevin Grittner (19:04)
• Re: performance on new linux box Jochen Erwied (19:13)
• Re: performance on new linux box Ryan Wexler (19:18)
• Need help in performance tuning. Harpreet singh Wadhwa (19:20)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Richard Yen (19:25)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Tom Lane (19:27)
• Re: performance on new linux box Kevin Grittner (19:28)
• Re: performance on new linux box Jochen Erwied (19:32)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Richard Yen (19:34)
• Re: performance on new linux box Ryan Wexler (19:37)
• Re: performance on new linux box Ben Chobot (19:40)
• Re: performance on new linux box Kevin Grittner (19:46)
• Re: performance on new linux box Ryan Wexler (19:47)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Kevin Grittner (19:50)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Tom Lane (19:50)
• Re: performance on new linux box David Boreham (19:50)
• Re: performance on new linux box Kevin Grittner (19:59)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Richard Yen (20:06)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Richard Yen (20:06)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Kevin Grittner (20:14)
• Re: Need help in performance tuning. Kevin Grittner (20:22)
• Re: performance on new linux box Craig James (21:01)
• Re: performance on new linux box Ryan Wexler (21:02)
• Re: performance on new linux box Timothy.Noonan (21:18)
• Re: performance on new linux box Jochen Erwied (21:39)
• Re: performance on new linux box Craig James (21:42)
• Re: performance on new linux box David Boreham (21:43)

2010-07-09

• Re: Need help in performance tuning. Craig Ringer (03:11)
• Re: Need help in performance tuning. Samuel Gendler (04:19)
• Re: Need help in performance tuning. Tom Lane (04:42)
• Re: Need help in performance tuning. Hannu Krosing (05:48)
• Re: Need help in performance tuning. Craig Ringer (07:52)
• Re: Need help in performance tuning. Harpreet singh Wadhwa (08:55)
• Re: performance on new linux box Russell Smith (09:08)
• Re: Need help in performance tuning. Harpreet singh Wadhwa (09:31)
• Re: performance on new linux box Samuel Gendler (09:38)
• Queries about PostgreSQL PITR Jayadevan M (09:47)
• Re: Need help in performance tuning. Craig Ringer (09:53)
• Re: Slow query with planner row strange estimation damien hostin (10:13)
• Re: Need help in performance tuning. Brad Nicholson (12:56)
• Re: Need help in performance tuning. Kevin Grittner (15:09)
• Re: Need help in performance tuning. Matthew Wakeling (15:30)
• Re: Need help in performance tuning. Kevin Grittner (15:49)
• Re: Need help in performance tuning. Jorge Montero (16:44)
• Re: Need help in performance tuning. Matthew Wakeling (17:03)
• Re: Need help in performance tuning. Kevin Grittner (17:52)
• Re: Need help in performance tuning. Jorge Montero (19:27)
• Re: Need help in performance tuning. Kevin Grittner (19:31)
• Re: Slow query with planner row strange estimation Robert Haas (20:25)
• Re: Need help in performance tuning. Robert Haas (20:35)
• Index usage with functions in where condition Jeremy Palmer (22:36)
• Re: Need help in performance tuning. Greg Smith (22:59)
• Re: Index usage with functions in where condition Tom Lane (23:19)
• Re: [Slony1-general] WAL partition overloaded--by autovacuum? Greg Smith (23:23)

2010-07-10

• Re: Index usage with functions in where condition Jeremy Palmer (00:25)
• Re: Need help in performance tuning. Kevin Grittner (00:31)
• Re: Need help in performance tuning. Mark Kirkwood (01:01)
• Re: Pooling in Core WAS: Need help in performance tuning. Josh Berkus (01:25)
• Re: Pooling in Core WAS: Need help in performance tuning. Samuel Gendler (03:29)
• Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer (03:33)
• Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas (03:47)
• Re: Need help in performance tuning. Jesper Krogh (06:33)
• Re: Need help in performance tuning. Greg Smith (12:30)
• Re: Pooling in Core WAS: Need help in performance tuning. Josh Berkus (18:42)
• Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane (18:51)

2010-07-11

• Re: performance on new linux box Ryan Wexler (20:02)
• Re: Need help in performance tuning. Pierre C (22:47)

2010-07-12

• Re: Queries about PostgreSQL PITR Fujii Masao (06:25)
• Re: Slow query with planner row strange estimation Dimitri (07:17)
• Re: Queries about PostgreSQL PITR Jayadevan M (08:29)
• [Fwd: Re: Slow query with planner row strange estimation] damien hostin (09:03)
• Re: [Fwd: Re: Slow query with planner row strange estimation] damien hostin (09:04)
• Re: Pooling in Core WAS: Need help in performance tuning. Matthew Wakeling (09:45)
• Re: Queries about PostgreSQL PITR Fujii Masao (10:05)
• Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer (10:58)
• now() gives same time within the session Atul.Goel (11:00)
• Re: now() gives same time within the session A. Kretschmer (11:15)
• PostgreSQL PITR - more doubts Jayadevan M (11:23)
• Re: PostgreSQL PITR - more doubts Jesper Krogh (11:38)
• Re: PostgreSQL PITR - more doubts Jayadevan M (12:04)
• Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing (12:22)
• Re: now() gives same time within the session Atul.Goel (12:23)
• Re: PostgreSQL PITR - more doubts Kevin Grittner (12:28)
• Re: Pooling in Core WAS: Need help in performance tuning. Kevin Grittner (12:41)
• Re: now() gives same time within the session Rob Wultsch (13:11)
• Re: now() gives same time within the session Thom Brown (13:23)
• Re: now() gives same time within the session A. Kretschmer (13:24)
• Re: now() gives same time within the session Kenneth Marshall (13:26)