Mailing lists [pgsql-performance]

1 July 2010

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

2 July 2010

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

3 July 2010

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

4 July 2010

• 02:58   Re: Highly Efficient Custom Sorting Alvaro Herrera
• 12:12   Performance issues with postgresql-8.4.0 Sachin Kumar
• 12:12   Re: Extremely high CPU usage when building tables Deborah Fuentes
• 12:38   Re: Performance issues with postgresql-8.4.0 Craig Ringer

5 July 2010

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

6 July 2010

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

7 July 2010

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

8 July 2010

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

9 July 2010

• 00:04   Re: performance on new linux box Joshua D. Drake
• 03:11   Re: Need help in performance tuning. Craig Ringer
• 04:19   Re: Need help in performance tuning. Samuel Gendler
• 04:42   Re: Need help in performance tuning. Tom Lane
• 07:52   Re: Need help in performance tuning. Craig Ringer
• 09:08   Re: performance on new linux box Russell Smith
• 09:31   Re: Need help in performance tuning. Harpreet singh Wadhwa
• 09:38   Re: performance on new linux box Samuel Gendler
• 09:54   Re: Need help in performance tuning. Craig Ringer
• 10:13   Re: Slow query with planner row strange estimation damien hostin
• 12:56   Re: Need help in performance tuning. Brad Nicholson
• 14:32   Re: Need help in performance tuning. Harpreet singh Wadhwa
• 15:10   Re: Need help in performance tuning. Kevin Grittner
• 15:30   Re: Need help in performance tuning. Matthew Wakeling
• 15:49   Re: Need help in performance tuning. Kevin Grittner
• 16:54   Re: Need help in performance tuning. Jorge Montero
• 17:04   Re: Need help in performance tuning. Matthew Wakeling
• 17:52   Re: Need help in performance tuning. Kevin Grittner
• 19:28   Re: Need help in performance tuning. Jorge Montero
• 19:32   Re: Need help in performance tuning. Kevin Grittner
• 20:25   Re: Slow query with planner row strange estimation Robert Haas
• 20:35   Re: Need help in performance tuning. Robert Haas
• 22:46   Index usage with functions in where condition Jeremy Palmer
• 22:59   Re: Need help in performance tuning. Greg Smith
• 23:20   Re: Index usage with functions in where condition Tom Lane
• 23:24   Re: [Slony1-general] WAL partition overloaded--by autovacuum? Greg Smith

10 July 2010

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

11 July 2010

• 20:03   Re: performance on new linux box Ryan Wexler
• 22:54   Re: Need help in performance tuning. Pierre C

12 July 2010

• 07:17   Re: Slow query with planner row strange estimation Dimitri
• 09:03   [Fwd: Re: Slow query with planner row strange estimation] damien hostin
• 09:05   Re: [Fwd: Re: Slow query with planner row strange estimation] damien hostin
• 09:46   Re: Pooling in Core WAS: Need help in performance tuning. Matthew Wakeling
• 10:59   Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer
• 11:09   now() gives same time within the session 
• 11:15   Re: now() gives same time within the session A. Kretschmer
• 11:24   PostgreSQL PITR - more doubts Jayadevan M
• 11:38   Re: PostgreSQL PITR - more doubts Jesper Krogh
• 12:05   Re: PostgreSQL PITR - more doubts Jayadevan M
• 12:23   Re: now() gives same time within the session 
• 12:28   Re: PostgreSQL PITR - more doubts Kevin Grittner
• 12:41   Re: Pooling in Core WAS: Need help in performance tuning. Kevin Grittner
• 13:12   Re: now() gives same time within the session Rob Wultsch
• 13:24   Re: now() gives same time within the session Thom Brown
• 13:25   Re: now() gives same time within the session A. Kretschmer
• 13:27   Re: now() gives same time within the session Kenneth Marshall
• 13:29   Exists, limit and alternate plans Віталій Тимчишин
• 14:45   Re: Exists, limit and alternate plans Tom Lane
• 14:54   Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing
• 15:38   Re: performance on new linux box Greg Smith
• 16:04   Re: Need help in performance tuning. Bruce Momjian
• 20:33   Re: Slow query with planner row strange estimation phb07

13 July 2010

• 03:01   Re: partition queries hitting all partitions even though check key is specified Josh Berkus
• 04:01   Re: partition queries hitting all partitions even though check key is specified Joshua D. Drake
• 06:52   Who are you voting for? kangayarkanni
• 08:51   Re: Slow query with planner row strange estimation damien hostin
• 11:00   Re: partition queries hitting all partitions even thoughcheck key is specified Joshua D. Drake
• 12:17   Queries with conditions using bitand operator Elias Ghanem
• 14:42   Re: Pooling in Core WAS: Need help in performance tuning. Dimitri Fontaine
• 14:44   Re: Pooling in Core WAS: Need help in performance tuning. Magnus Hagander
• 23:20   Re: Queries with conditions using bitand operator Andy Colson
• 23:26   Re: performance on new linux box Andy Colson

14 July 2010

• 01:08   Re: Queries with conditions using bitand operator Joe Conway
• 06:10   Re: Need help in performance tuning. Hannu Krosing
• 06:45   Re: Need help in performance tuning. Scott Marlowe
• 11:47   Understanding tsearch2 performance Ivan Voras
• 12:31   Re: Understanding tsearch2 performance Oleg Bartunov
• 12:55   Re: Understanding tsearch2 performance Ivan Voras
• 13:25   Re: Understanding tsearch2 performance Oleg Bartunov
• 13:38   Re: Understanding tsearch2 performance Ivan Voras
• 13:49   Re: Understanding tsearch2 performance Stephen Frost
• 13:57   Re: Understanding tsearch2 performance Ivan Voras
• 13:58   Re: Need help in performance tuning. Kevin Grittner
• 14:03   Re: Understanding tsearch2 performance Kevin Grittner
• 14:21   Re: Understanding tsearch2 performance Ivan Voras
• 14:37   Re: Understanding tsearch2 performance Oleg Bartunov
• 14:53   Re: Queries with conditions using bitand operator valgog
• 15:17   Re: Understanding tsearch2 performance Kevin Grittner
• 17:56   Re: Need help in performance tuning. Hannu Krosing
• 20:26   Re: Understanding tsearch2 performance Ivan Voras

15 July 2010

• 01:57   Re: performance on new linux box Scott Carey
• 06:39   Re: performance on new linux box Ben Chobot
• 06:39   Query optimization problem Zotov
• 06:39   Re: performance on new linux box Ryan Wexler
• 07:57   Re: Query optimization problem Yeb Havinga
• 14:48   Identical query slower on 8.4 vs 8.3 Patrick Donlin
• 14:51   Re: Identical query slower on 8.4 vs 8.3 Thom Brown
• 14:55   Re: Identical query slower on 8.4 vs 8.3 Kevin Grittner
• 15:13   Re: Identical query slower on 8.4 vs 8.3 Patrick Donlin
• 15:21   Re: Identical query slower on 8.4 vs 8.3 Alvaro Herrera
• 15:31   Re: Identical query slower on 8.4 vs 8.3 Andy Colson
• 15:43   Re: Identical query slower on 8.4 vs 8.3 Jon Nelson
• 15:53   Re: Identical query slower on 8.4 vs 8.3 Kevin Grittner
• 16:04   Re: Identical query slower on 8.4 vs 8.3 Merlin Moncure
• 17:17   Re: Identical query slower on 8.4 vs 8.3 Joshua D. Drake
• 17:32   Question of using COPY on a table with triggers Benjamin Krajmalnik
• 18:48   Re: Identical query slower on 8.4 vs 8.3 Patrick Donlin
• 21:36   Re: performance on new linux box Scott Carey
• 21:36   Re: performance on new linux box Ben Chobot
• 21:36   Re: performance on new linux box Ben Chobot
• 23:01   Re: Question of using COPY on a table with triggers Pierre C
• 23:28   Re: Question of using COPY on a table with triggers Benjamin Krajmalnik

16 July 2010

• 00:17   Re: Identical query slower on 8.4 vs 8.3 Joshua D. Drake
• 00:24   Re: Question of using COPY on a table with triggers Tom Lane
• 11:01   Re: performance on new linux box Ryan Wexler
• 11:01   Re: performance on new linux box Ben Chobot
• 11:01   Re: performance on new linux box Pierre C
• 11:01   Re: performance on new linux box Scott Marlowe
• 11:01   Re: performance on new linux box Scott Carey
• 11:01   Re: performance on new linux box Scott Carey
• 11:01   Re: performance on new linux box Ben Chobot
• 11:18   Re: performance on new linux box Craig Ringer
• 11:36   Re: performance on new linux box Craig Ringer
• 14:10   Re: Identical query slower on 8.4 vs 8.3 Igor Neyman
• 14:17   Re: Identical query slower on 8.4 vs 8.3 tv@fuzzy.cz
• 16:55   Re: performance on new linux box Greg Smith

18 July 2010

• 08:54   Re: now() gives same time within the session Heikki Linnakangas
• 16:18   Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
• 16:26   Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
• 17:09   Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
• 17:26   Re: Pooling in Core WAS: Need help in performance tuning. Greg Smith
• 17:48   Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
• 18:08   Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
• 19:00   Re: Pooling in Core WAS: Need help in performance tuning. Scott Carey

19 July 2010

• 00:04   What is the best way to optimize the query. Srikanth
• 00:05   Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing
• 00:05   Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
• 02:15   Re: Pooling in Core WAS: Need help in performance tuning. Tatsuo Ishii
• 02:36   Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
• 02:50   Re: Pooling in Core WAS: Need help in performance tuning. Tatsuo Ishii
• 06:16   Re: What is the best way to optimize the query. Sergey Konoplev
• 06:16   Re: What is the best way to optimize the query. Craig Ringer
• 12:24   IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Daniel Ferreira de Lima
• 13:28   Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Kevin Grittner
• 13:50   how to handle a big table for data log kuopo
• 14:20   Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Daniel Ferreira de Lima
• 14:38   Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Greg Smith
• 15:09   Big field, limiting and ordering Ivan Voras
• 15:35   Re: Big field, limiting and ordering Vitalii Tymchyshyn
• 15:39   Re: how to handle a big table for data log Jorge Montero
• 19:53   Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Daniel Ferreira de Lima

20 July 2010

• 15:42   dates and partitioning Kevin Kempter
• 15:55   Re: dates and partitioning Brad Nicholson
• 15:56   Re: dates and partitioning Jochen Erwied
• 16:48   potential performance gain by query planner optimization Kneringer, Armin
• 19:39   Re: potential performance gain by query planner optimization Pavel Stehule
• 22:57   Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Scott Carey

21 July 2010

• 07:31   Using more tha one index per table Elias Ghanem
• 07:54   Re: Using more tha one index per table A. Kretschmer
• 07:58   Re: Using more tha one index per table Rob Wultsch
• 08:01   Re: Using more tha one index per table Scott Marlowe
• 08:03   Re: Using more tha one index per table Scott Marlowe
• 14:14   Re: Using more tha one index per table Andy Colson
• 14:44   tune memory usage for master/slave nodes in cluster stanimir petrov
• 15:00   Re: Using more tha one index per table Greg Smith
• 15:08   Re: tune memory usage for master/slave nodes in cluster Greg Smith
• 16:48   Re: potential performance gain by query planner optimization Kneringer, Armin
• 17:22   Re: potential performance gain by query planner optimization Pavel Stehule

22 July 2010

• 00:48   Re: Using more tha one index per table Craig Ringer
• 01:03   Re: Using more tha one index per table Craig James
• 01:47   Re: Using more tha one index per table Greg Smith
• 02:00   Re: Using more tha one index per table Steve Atkins
• 02:28   Re: Using more tha one index per table Greg Smith
• 02:55   Re: Using more tha one index per table Steve Atkins
• 07:51   Strange explain on partitioned tables Philippe Rimbault
• 08:05   why index is not working in < operation? AI Rumman
• 08:11   Re: why index is not working in < operation? Szymon Guz
• 08:16   Re: why index is not working in < operation? A. Kretschmer
• 08:35   Re: Using more tha one index per table Richard Huxton
• 08:56   Re: Strange explain on partitioned tables Philippe Rimbault
• 09:09   Re: Using more tha one index per table Rob Wultsch
• 10:02   Re: Strange explain on partitioned tables Philippe Rimbault
• 13:32   Re: Strange explain on partitioned tables Greg Smith
• 14:09   Re: Strange explain on partitioned tables Philippe Rimbault
• 16:57   Re: Using more tha one index per table Craig James
• 18:09   Re: Slow query with planner row strange estimation Robert Haas
• 19:01   Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas
• 19:02   Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas
• 19:15   Re: Pooling in Core WAS: Need help in performance tuning. Joshua D. Drake
• 21:30   Re: Pooling in Core WAS: Need help in performance tuning. Andres Freund
• 21:37   Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing
• 21:37   Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing
• 21:43   Re: Pooling in Core WAS: Need help in performance tuning. Scott Carey

23 July 2010

• 00:58   Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas
• 01:01   Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas
• 02:15   Re: Pooling in Core WAS: Need help in performance tuning. Joshua D. Drake
• 06:43   Execution Plan std pik
• 07:43   Re: Execution Plan Pavel Stehule
• 09:25   Re: Using more tha one index per table Torsten Zühlsdorff
• 15:55   Re: Pooling in Core WAS: Need help in performance tuning. Joshua Tolley
• 16:53   Re: Pooling in Core WAS: Need help in performance tuning. Joshua D. Drake
• 21:25   Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing
• 21:25   Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas
• 21:47   Re: Using more tha one index per table Craig James
• 22:12   Re: Strange explain on partitioned tables Gerald Fontenay
• 22:16   Re: Strange explain on partitioned tables Joshua D. Drake
• 23:52   Re: Pooling in Core WAS: Need help in performance tuning. Joshua D. Drake

24 July 2010

• 05:12   Re: Strange explain on partitioned tables Greg Smith
• 05:14   Re: Pooling in Core WAS: Need help in performance tuning. Andres Freund
• 05:16   Re: Strange explain on partitioned tables Joshua D. Drake
• 05:23   Re: Pooling in Core WAS: Need help in performance tuning. Greg Smith
• 05:32   Re: Pooling in Core WAS: Need help in performance tuning. Andres Freund
• 05:38   Re: Strange explain on partitioned tables Gerald Fontenay
• 06:23   Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer
• 06:36   Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer
• 07:19   Testing Sandforce SSD Yeb Havinga
• 07:37   Re: Testing Sandforce SSD David Boreham
• 08:40   Re: Testing Sandforce SSD david@lang.hm
• 13:25   Re: Using more tha one index per table Torsten Zühlsdorff
• 14:59   Re: Using more tha one index per table Craig James
• 16:50   Re: Testing Sandforce SSD Ben Chobot
• 17:14   Re: Testing Sandforce SSD Greg Smith
• 18:07   Re: Testing Sandforce SSD Merlin Moncure
• 19:48   Re: Testing Sandforce SSD Yeb Havinga
• 19:53   Re: Testing Sandforce SSD Yeb Havinga
• 20:21   Re: Testing Sandforce SSD Greg Smith
• 21:09   Re: Testing Sandforce SSD Joshua D. Drake
• 21:16   Re: Testing Sandforce SSD Greg Smith
• 21:21   Re: Testing Sandforce SSD Yeb Havinga
• 22:01   Re: Testing Sandforce SSD Greg Smith

25 July 2010

• 04:09   Re: Testing Sandforce SSD Joshua D. Drake
• 08:29   Re: Using more tha one index per table Dimitri Fontaine
• 08:40   Re: Pooling in Core WAS: Need help in performance tuning. Dimitri Fontaine
• 18:33   Re: Testing Sandforce SSD Yeb Havinga
• 19:11   Re: Testing Sandforce SSD Yeb Havinga

26 July 2010

• 08:35   Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Piotr Gasidło
• 08:44   Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Piotr Gasidło
• 09:07   Explains of queries to partitioned tables Vlad Arkhipov
• 09:15   Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Craig Ringer
• 09:21   Re: Testing Sandforce SSD Yeb Havinga
• 09:25   Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Vitalii Tymchyshyn
• 09:47   Re: Testing Sandforce SSD Matthew Wakeling
• 09:57   Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Craig Ringer
• 10:04   Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Piotr Gasidło
• 10:28   Re: Testing Sandforce SSD Yeb Havinga
• 15:28   Re: Testing Sandforce SSD Greg Smith
• 15:34   Re: Testing Sandforce SSD Greg Smith
• 15:42   Re: Testing Sandforce SSD Matthew Wakeling
• 16:25   Re: Testing Sandforce SSD Yeb Havinga
• 16:27   Re: Testing Sandforce SSD Greg Spiegelberg
• 18:34   Re: Testing Sandforce SSD Greg Smith
• 18:40   Re: Testing Sandforce SSD Greg Smith
• 18:42   Re: Testing Sandforce SSD Kevin Grittner
• 19:40   Re: Testing Sandforce SSD Yeb Havinga
• 19:42   Re: Testing Sandforce SSD Yeb Havinga
• 19:45   Re: Testing Sandforce SSD Greg Smith
• 19:47   Re: Testing Sandforce SSD Scott Marlowe
• 21:23   Re: Testing Sandforce SSD Greg Spiegelberg
• 21:25   Re: Strange explain on partitioned tables Gerald Fontenay
• 22:28   Re: Testing Sandforce SSD Andres Freund
• 23:01   Re: Testing Sandforce SSD Greg Smith

27 July 2010

• 04:19   Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Tom Lane
• 05:05   Linux Filesystems again - Ubuntu this time Mark Kirkwood
• 13:49   Re: Linux Filesystems again - Ubuntu this time Kevin Grittner
• 16:57   Re: Linux Filesystems again - Ubuntu this time Whit Armstrong
• 17:11   Re: Linux Filesystems again - Ubuntu this time Kevin Grittner
• 17:19   Re: Linux Filesystems again - Ubuntu this time Kevin Grittner
• 18:11   Re: What is the best way to optimize the query. Robert Haas
• 18:20   Re: Linux Filesystems again - Ubuntu this time Whit Armstrong
• 18:25   Re: potential performance gain by query planner optimization Tom Lane
• 18:32   Re: Linux Filesystems again - Ubuntu this time Kevin Grittner
• 19:54   Re: how to handle a big table for data log kuopo
• 19:54   Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing
• 19:54   Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing
• 19:54   Slow query using the Cube contrib module. Liviu Mirea-Ghiban
• 19:54   Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas
• 19:54   Re: Testing Sandforce SSD Hannu Krosing
• 19:54   Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Lew
• 20:02   Re: how to handle a big table for data log Greg Spiegelberg
• 20:04   Re: Slow query using the Cube contrib module. Yeb Havinga
• 20:40   Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane
• 21:17   Re: how to handle a big table for data log Josh Berkus
• 22:19   Re: Slow query using the Cube contrib module. Tom Lane
• 23:34   Questions on query planner, join types, and work_mem Peter Hussey
• 23:58   Re: Questions on query planner, join types, and work_mem Andres Freund

28 July 2010

• 00:05   Re: Questions on query planner, join types, and work_mem Tom Lane
• 01:44   Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas
• 01:57   Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane
• 02:05   Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas
• 04:02   Re: Questions on query planner, join types, and work_mem Alvaro Herrera
• 04:29   Re: Questions on query planner, join types, and work_mem Jayadevan M
• 04:39   Re: Questions on query planner, join types, and work_mem Tom Lane
• 05:09   Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane
• 05:30   Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer
• 10:27   158x query improvement when removing 2 (noop) WHERE conditions Louis-David Mitterrand
• 10:49   Re: 158x query improvement when removing 2 (noop) WHERE conditions Andres Freund
• 11:04   Re: Pooling in Core WAS: Need help in performance tuning. Vitalii Tymchyshyn
• 11:07   Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Vitalii Tymchyshyn
• 13:22   Re: Testing Sandforce SSD Michael Stone
• 13:24   Re: Testing Sandforce SSD Michael Stone
• 13:43   Re: Testing Sandforce SSD Yeb Havinga
• 15:17   Re: Testing Sandforce SSD Yeb Havinga
• 19:45   Re: Pooling in Core WAS: Need help in performance tuning. Josh Berkus
• 19:52   Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas
• 20:10   Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane
• 20:19   Re: Pooling in Core WAS: Need help in performance tuning. Andres Freund

29 July 2010

• 00:51   planner index choice Chris
• 02:07   Re: Testing Sandforce SSD Greg Spiegelberg
• 03:16   Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas
• 03:53   Re: planner index choice Tom Lane
• 07:29   Re: planner index choice Chris
• 11:15   Re: planner index choice tv@fuzzy.cz
• 14:46   Re: Testing Sandforce SSD Michael Stone
• 15:21   Re: planner index choice Tom Lane
• 17:39   Re: Pooling in Core WAS: Need help in performance tuning. Josh Berkus

30 July 2010

• 14:04   Re: Questions on query planner, join types, and work_mem Tom Lane
• 15:00   Re: Testing Sandforce SSD Yeb Havinga
• 15:02   view columns and performance Eric Schwarzenbach
• 15:11   Re: view columns and performance Tom Lane
• 15:51   Re: Testing Sandforce SSD Karl Denninger

31 July 2010

• 02:21   Re: Explains of queries to partitioned tables Robert Haas