Mailing lists [pgsql-performance]
- what does "initplan" operation in explain output mean? Mark Rostron
- Re: what does "initplan" operation in explain output mean? Tom Lane
- Re: Testing Sandforce SSD Merlin Moncure
- Re: Testing Sandforce SSD Yeb Havinga
- Re: what does "initplan" operation in explain output mean? Mark Rostron
- Re: what does "initplan" operation in explain output mean? Tom Lane
- Optimizing NOT IN plans / verify rewrite Maciek Sakrejda
- Re: Optimizing NOT IN plans / verify rewrite Kevin Grittner
- Re: Optimizing NOT IN plans / verify rewrite Maciek Sakrejda
- Re: Optimizing NOT IN plans / verify rewrite Kevin Grittner
- Re: Optimizing NOT IN plans / verify rewrite Andres Freund
- Re: Optimizing NOT IN plans / verify rewrite Maciek Sakrejda
- Re: Optimizing NOT IN plans / verify rewrite Dave Crooke
- Re: Optimizing NOT IN plans / verify rewrite Andres Freund
- Re: Optimizing NOT IN plans / verify rewrite Maciek Sakrejda
- Re: Optimizing NOT IN plans / verify rewrite Kevin Grittner
- Re: Questions on query planner, join types, and work_mem Peter Hussey
- Re: Optimizing NOT IN plans / verify rewrite Kevin Grittner
- Re: Optimizing NOT IN plans / verify rewrite Kevin Grittner
- Re: Optimizing NOT IN plans / verify rewrite Andres Freund
- Re: Testing Sandforce SSD Josh Berkus
- Re: Optimizing NOT IN plans / verify rewrite Maciek Sakrejda
- Re: Testing Sandforce SSD Greg Smith
- Re: Testing Sandforce SSD Scott Marlowe
- Re: Questions on query planner, join types, and work_mem Robert Haas
- Re: Questions on query planner, join types, and work_mem Tom Lane
- Re: Testing Sandforce SSD Yeb Havinga
- Re: Testing Sandforce SSD Yeb Havinga
- Re: Testing Sandforce SSD Greg Smith
- Re: Testing Sandforce SSD Yeb Havinga
- Re: Testing Sandforce SSD Merlin Moncure
- Re: Execution Plan Rodrigo E. De León Plicet
- performance sol10 zone (fup) Heiko L.
- How to improve: performance of query on postgresql 8.3 takes days Dino Vliet
- Re: [GENERAL] How to improve: performance of query on postgresql 8.3 takes days John R Pierce
- what does "initplan" operation in explain output mean? Mark Rostron
- Re: [GENERAL] How to improve: performance of query on postgresql 8.3 takes days Alban Hertroys
- Re: Testing Sandforce SSD Hannu Krosing
- Re: Questions on query planner, join types, and work_mem Hannu Krosing
- Re: Questions on query planner, join types, and work_mem Robert Haas
- Re: Strange explain on partitioned tables Robert Haas
- Re: Questions on query planner, join types, and work_mem Kevin Grittner
- LIKE without wildcard different from = Kevin Grittner
- Re: LIKE without wildcard different from = Tom Lane
- Re: LIKE without wildcard different from = Kevin Grittner
- Re: LIKE without wildcard different from = Tom Lane
- Re: LIKE without wildcard different from = Kevin Grittner
- Re: Questions on query planner, join types, and work_mem Hannu Krosing
- Re: Questions on query planner, join types, and work_mem Tom Lane
- Re: Questions on query planner, join types, and work_mem Hannu Krosing
- Re: Questions on query planner, join types, and work_mem Hannu Krosing
- Re: Questions on query planner, join types, and work_mem Greg Smith
- Re: Questions on query planner, join types, and work_mem Greg Smith
- Re: Questions on query planner, join types, and work_mem Tom Lane
- Re: Testing Sandforce SSD Scott Carey
- Re: Testing Sandforce SSD Scott Carey
- Re: Testing Sandforce SSD Scott Carey
- Re: Questions on query planner, join types, and work_mem Kevin Grittner
- Re: Questions on query planner, join types, and work_mem Hannu Krosing
- Re: Questions on query planner, join types, and work_mem Greg Smith
- Re: Questions on query planner, join types, and work_mem Greg Smith
- Re: Questions on query planner, join types, and work_mem Kevin Grittner
- Re: Questions on query planner, join types, and work_mem Kevin Grittner
- Re: Questions on query planner, join types, and work_mem Hannu Krosing
- Re: Questions on query planner, join types, and work_mem Hannu Krosing
- Re: Testing Sandforce SSD Chris Browne
- Re: Testing Sandforce SSD Chris Browne
- Re: Testing Sandforce SSD Brad Nicholson
- vacuum performance on insert Sean Chen
- Re: vacuum performance on insert Kevin Grittner
- Re: vacuum performance on insert Tom Lane
- Advice configuring ServeRAID 8k for performance Kenneth Cox
- Two fast searches turn slow when used with OR clause Craig James
- Re: Advice configuring ServeRAID 8k for performance Alan Hodgson
- Re: Advice configuring ServeRAID 8k for performance Scott Marlowe
- Re: Advice configuring ServeRAID 8k for performance Greg Smith
- Re: Advice configuring ServeRAID 8k for performance Pierre C
- Re: Advice configuring ServeRAID 8k for performance Craig James
- Re: Advice configuring ServeRAID 8k for performance Scott Marlowe
- Re: Advice configuring ServeRAID 8k for performance Dave Crooke
- Re: Advice configuring ServeRAID 8k for performance Scott Marlowe
- Re: Advice configuring ServeRAID 8k for performance Mark Kirkwood
- Re: Advice configuring ServeRAID 8k for performance Alan Hodgson
- Re: Advice configuring ServeRAID 8k for performance Mark Kirkwood
- Re: Advice configuring ServeRAID 8k for performance Mark Kirkwood
- Re: Advice configuring ServeRAID 8k for performance Matthew Wakeling
- Re: Advice configuring ServeRAID 8k for performance Scott Marlowe
- Re: Advice configuring ServeRAID 8k for performance Scott Marlowe
- Re: vacuum performance on insert Sean Chen
- Re: Advice configuring ServeRAID 8k for performance Justin Pitts
- Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Michael March
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Carey
- Re: Advice configuring ServeRAID 8k for performance Scott Carey
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Michael March
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Marlowe
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Michael March
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Marlowe
- Re: Advice configuring ServeRAID 8k for performance Scott Marlowe
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Yeb Havinga
- Re: vacuum performance on insert Kevin Grittner
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Carey
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Jeff Davis
- Sorted group by Matthew Wakeling
- Re: Sorted group by Thomas Kellerer
- Re: Sorted group by Matthew Wakeling
- Re: Sorted group by Thom Brown
- Re: Sorted group by hubert depesz lubaczewski
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Greg Smith
- Re: Sorted group by Thomas Kellerer
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Greg Smith
- Re: Sorted group by Thom Brown
- Re: Sorted group by Kevin Grittner
- Re: Sorted group by Jonathan Blitz
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Brad Nicholson
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Karl Denninger
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Marlowe
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Greg Smith
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Karl Denninger
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Brad Nicholson
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Brad Nicholson
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Karl Denninger
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Brad Nicholson
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Marlowe
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Christopher Browne
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Marlowe
- Re: Sorted group by Matthew Wakeling
- 32 vs 64 bit build on Solaris Sparc Joseph Conway
- Re: 32 vs 64 bit build on Solaris Sparc Tom Lane
- Re: Sorted group by Alvaro Herrera
- Re: Testing Sandforce SSD Bruce Momjian
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Carey
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Carey
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Carey
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Karl Denninger
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
- Re: Questions on query planner, join types, and work_mem Bruce Momjian
- Re: Questions on query planner, join types, and work_mem Robert Haas
- Re: performance sol10 zone (fup) Robert Haas
- Re: performance sol10 zone (fup) Scott Marlowe
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Greg Smith
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Greg Smith
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Arjen van der Meijden
- Re: 32 vs 64 bit build on Solaris Sparc Dimitri
- Re: Advice configuring ServeRAID 8k for performance Justin Pitts
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Brad Nicholson
- Re: Slow function in queries SELECT clause. Davor J.
- Very bad plan when using VIEW and IN (SELECT...*) Carlo Stonebanks
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Carey
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Arjen van der Meijden
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Michael March
- Re: Very bad plan when using VIEW and IN (SELECT...*) Kevin Grittner
- Re: Very bad plan when using VIEW and IN (SELECT...*) Carlo Stonebanks
- Can WINDOW be used? Greg Spiegelberg
- Re: Advice configuring ServeRAID 8k for performance Bruce Momjian
- Re: Advice configuring ServeRAID 8k for performance Greg Smith
- Re: Can WINDOW be used? Josh Berkus
- Re: Advice configuring ServeRAID 8k for performance Scott Carey
- Re: Advice configuring ServeRAID 8k for performance Greg Smith
- Re: Advice configuring ServeRAID 8k for performance Andres Freund
- Re: Advice configuring ServeRAID 8k for performance Greg Smith
- Re: Advice configuring ServeRAID 8k for performance Andres Freund
- Re: Advice configuring ServeRAID 8k for performance Greg Smith
- Re: Advice configuring ServeRAID 8k for performance Andres Freund
- Very poor performance Aaron Burnett
- Re: Advice configuring ServeRAID 8k for performance Bruce Momjian
- Re: Very poor performance Mark Rostron
- Re: Very poor performance Aaron Burnett
- Quesion on the use of indexes Benjamin Krajmalnik
- Re: Quesion on the use of indexes Tom Lane
- Re: Advice configuring ServeRAID 8k for performance Greg Smith
- Re: Advice configuring ServeRAID 8k for performance Greg Smith
- Re: Advice configuring ServeRAID 8k for performance Andres Freund
- Search query is curious
- Re: Search query is curious Thom Brown
- Re: Search query is curious Pavel Stehule
- Re: Very poor performance Kevin Grittner
- Re: Quesion on the use of indexes Alvaro Herrera
- Re: Search query is curious Maciek Sakrejda
- Re: Quesion on the use of indexes
- Re: Very poor performance Kevin Grittner
- Re: Very poor performance Tom Lane
- Re: Very poor performance Mark Rostron
- Re: Very poor performance Aaron Burnett
- Re: Very poor performance Kevin Grittner
- Vacuum Full + Cluster + Vacuum full = non removable dead rows Alexandre de Arruda Paes
- Re: Vacuum Full + Cluster + Vacuum full = non removable dead rows Scott Marlowe
- Re: Very poor performance Mark Kirkwood
- Re: Very poor performance Kevin Grittner
- Re: Two fast searches turn slow when used with OR clause Robert Haas
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD david@lang.hm
- Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
- Re: Very poor performance Hannes Frederic Sowa
- Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Alexandre de Arruda Paes
- Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Tom Lane
- Are Indices automatically generated for primary keys? Clemens Eisserer
- Re: Are Indices automatically generated for primary keys? hubert depesz lubaczewski
- Re: Are Indices automatically generated for primary keys? Kevin Grittner
- Re: Are Indices automatically generated for primary keys? Clemens Eisserer
- Re: Are Indices automatically generated for primary keys? Kevin Grittner
- Re: Are Indices automatically generated for primary keys? Kevin Grittner
- Re: Are Indices automatically generated for primary keys? Justin Graf
- Re: Are Indices automatically generated for primary keys? Thom Brown
- write barrier question Samuel Gendler
- Re: write barrier question Craig James
- Copy performance issues s anwar
- Re: write barrier question Yeb Havinga
- Re: write barrier question Samuel Gendler
- Re: write barrier question Samuel Gendler
- Copy performance issues Saadat Anwar
- Re: Copy performance issues Tom Lane
- Re: Copy performance issues Greg Smith
- Re: Copy performance issues s anwar
- in-memory sorting Samuel Gendler
- Re: in-memory sorting Samuel Gendler
- Re: in-memory sorting Pavel Stehule
- yet another q Samuel Gendler
- Re: in-memory sorting Scott Marlowe
- Re: in-memory sorting Samuel Gendler
- Re: yet another q Samuel Gendler
- Re: yet another q Samuel Gendler
- Re: in-memory sorting Scott Marlowe
- Re: in-memory sorting Samuel Gendler
- Re: in-memory sorting Samuel Gendler
- Re: in-memory sorting Scott Marlowe
- Performance on new 64bit server compared to my 32bit desktop Philippe Rimbault
- Re: Performance on new 64bit server compared to my 32bit desktop Scott Marlowe
- Re: Performance on new 64bit server compared to my 32bit desktop Philippe Rimbault
- Re: Performance on new 64bit server compared to my 32bit desktop Philippe Rimbault
- Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Alexandre de Arruda Paes
- Re: in-memory sorting Tom Lane
- Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Kevin Grittner
- Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Tom Lane
- Re: yet another q Tom Lane
- Re: Performance on new 64bit server compared to my 32bit desktop Scott Marlowe
- Re: Performance on new 64bit server compared to my 32bit desktop Greg Smith
- Re: Performance on new 64bit server compared to my 32bit desktop Greg Smith
- Re: Copy performance issues Sergey Konoplev
- Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Dimitri
- Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Scott Marlowe
- Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Dimitri
- Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Alexandre de Arruda Paes
- Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Robert Haas
- Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Dimitri
- Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Greg Smith
- Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Greg Smith
- Inefficient query plan Jann Röder
- Re: Inefficient query plan Scott Marlowe
- Re: Inefficient query plan Scott Marlowe
- Re: Inefficient query plan Jann Röder
- Re: Inefficient query plan Scott Marlowe
- Re: Inefficient query plan Jann Röder
- Re: Inefficient query plan Kevin Grittner
- Re: Inefficient query plan Kevin Grittner
- Re: Inefficient query plan Jann Röder
- Re: Inefficient query plan Grzegorz Jaśkiewicz
- Re: Inefficient query plan Kevin Grittner
- Re: Inefficient query plan Kevin Grittner
- Re: Inefficient query plan Grzegorz Jaśkiewicz
- Re: Inefficient query plan Kevin Grittner
- Re: Inefficient query plan Alvaro Herrera
- Re: Inefficient query plan Grzegorz Jaśkiewicz
- Re: Inefficient query plan Grzegorz Jaśkiewicz
- Re: Inefficient query plan Kevin Grittner
- Re: Inefficient query plan Tom Lane
- Re: Inefficient query plan
- Re: Inefficient query plan Scott Marlowe
- Triggers or code? DM
- Re: Triggers or code? André Fernandes
- PARSE WAITING David Kerr
- Re: PARSE WAITING David Kerr
- Re: PARSE WAITING Alvaro Herrera
- Re: PARSE WAITING David Kerr
- Re: PARSE WAITING Alvaro Herrera
- Re: Inefficient query plan Jann Röder
- Re: Inefficient query plan Jann Röder
- Re: Are Indices automatically generated for primary keys? Guillaume Lelarge
- Re: Triggers or code? Bob Lunney
- New servers, need suggestions for sensible tuning settings Bob Branch
- Re: New servers, need suggestions for sensible tuning settings Kevin Grittner
- SubQuery Performance mike
- Re: SubQuery Performance A. Kretschmer
- turn off caching for performance test Willy-Bas Loos
- Re: turn off caching for performance test Arjen van der Meijden
- Re: turn off caching for performance test Pierre C
- [Fwd: postgres 8.4.1 number of connections] Maria L. Wilson
- Re: [Fwd: postgres 8.4.1 number of connections] Scott Marlowe
- Slow Query Ozer, Pam
- Re: Slow Query Scott Marlowe
- Re: Slow Query Bob Lunney
- Re: [Fwd: postgres 8.4.1 number of connections] Josh Berkus
- Re: Performance on new 64bit server compared to my 32bit desktop Scott Carey
- Re: [Fwd: postgres 8.4.1 number of connections] Magnus Hagander
- Re: turn off caching for performance test Willy-Bas Loos
- Re: Slow Query Kevin Grittner
- Re: Performance on new 64bit server compared to my 32bit desktop Greg Smith
- Re: turn off caching for performance test Greg Smith
- Re: Slow Query Greg Smith
- Re: Slow Query Ozer, Pam
- Re: turn off caching for performance test Scott Marlowe
- Using Between Ozer, Pam
- Re: Using Between Craig James
- Re: write barrier question Cédric Villemain
- Re: Performance on new 64bit server compared to my 32bit desktop Jose Ildefonso Camargo Tolosa
- array can be slow when joining? Volodymyr Kostyrko
- Re: array can be slow when joining? Pavel Stehule
- Re: Performance on new 64bit server compared to my 32bit desktop Greg Smith
- Re: Performance on new 64bit server compared to my 32bit desktop Greg Smith
- Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
- Re: Major performance problem after upgrade from 8.3 to 8.4 Scott Marlowe
- Re: Major performance problem after upgrade from 8.3 to 8.4 Andreas Kretschmer
- Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
- Re: Major performance problem after upgrade from 8.3 to 8.4 Scott Marlowe
- Re: Major performance problem after upgrade from 8.3 to 8.4 Pavel Stehule
- Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
- Re: Performance on new 64bit server compared to my 32bit desktop Yeb Havinga
- Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
- Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
- Re: Major performance problem after upgrade from 8.3 to 8.4 Pavel Stehule
- Re: Performance on new 64bit server compared to my 32bit desktop Scott Carey
- Re: Performance on new 64bit server compared to my 32bit desktop Scott Marlowe
- Re: Performance on new 64bit server compared to my 32bit desktop Yeb Havinga
- GPU Accelerated Sorting Eliot Gable
- Re: GPU Accelerated Sorting Greg Smith
- Re: Performance on new 64bit server compared to my 32bit desktop Greg Smith
- Re: Performance on new 64bit server compared to my 32bit desktop Greg Smith
- Re: GPU Accelerated Sorting gael@pilotsystems.net (Gaël Le Mignot)
- GPU Accelerated Sorting Eliot Gable
- Re: [Fwd: postgres 8.4.1 number of connections] Maria L. Wilson
- Re: Performance on new 64bit server compared to my 32bit desktop Jose Ildefonso Camargo Tolosa
- Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
- Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane
- Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
- Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane
- Re: Using Between Ozer, Pam
- Re: GPU Accelerated Sorting Eliot Gable
- Re: GPU Accelerated Sorting Yeb Havinga
- Re: Performance on new 64bit server compared to my 32bit desktop Clemens Eisserer
- Re: GPU Accelerated Sorting Scott Marlowe
- Re: GPU Accelerated Sorting David Boreham
- Re: GPU Accelerated Sorting Jeff Davis
- Re: GPU Accelerated Sorting Chris Browne
- slow DDL creation Kevin Kempter
- Re: Performance on new 64bit server compared to my 32bit desktop Greg Smith
- Re: GPU Accelerated Sorting David Boreham
- Re: slow DDL creation bricklen
- Re: slow DDL creation David Fetter
- Re: GPU Accelerated Sorting Scott Carey
- Re: Performance on new 64bit server compared to my 32bit desktop Jose Ildefonso Camargo Tolosa
- Re: GPU Accelerated Sorting Tom Lane
- Re: Performance on new 64bit server compared to my 32bit desktop Yeb Havinga
- Re: slow DDL creation Kevin Kempter
- Re: Performance on new 64bit server compared to my 32bit desktop Greg Smith
- Re: Performance on new 64bit server compared to my 32bit desktop Jose Ildefonso Camargo Tolosa
- Re: Performance on new 64bit server compared to my 32bit desktop Yeb Havinga
- Re: Performance on new 64bit server compared to my 32bit desktop Jose Ildefonso Camargo Tolosa
- Re: Performance on new 64bit server compared to my 32bit desktop Scott Marlowe
- Re: Performance on new 64bit server compared to my 32bit desktop Scott Marlowe
- Re: Performance on new 64bit server compared to my 32bit desktop Greg Smith
- Re: Performance on new 64bit server compared to my 32bit desktop Yeb Havinga
- Re: Performance on new 64bit server compared to my 32bit desktop Scott Marlowe