Архив рассылок [pgsql-performance]
Re: PostgreSQL as a local in-memory cache Greg Smith
Extremely high CPU usage when building tables Deborah Fuentes
how to (temporarily) disable/minimize benefits of disk block cache or
postgresql shared buffer Rajesh Kumar Mallah
Re: Extremely high CPU usage when building tables Rajesh Kumar Mallah
What is the best way to optimize this query Srikanth Kata
Re: What is the best way to optimize this query Rajesh Kumar Mallah
optimal ZFS filesystem on JBOD layout Joachim Worringen
Re: optimal ZFS filesystem on JBOD layout Greg Smith
Re: how to (temporarily) disable/minimize benefits of disk
block cache or postgresql shared buffer Craig Ringer
Re: how to (temporarily) disable/minimize benefits of disk
block cache or postgresql shared buffer Rajesh Kumar Mallah
big data - slow select (speech search) Michal Fapso
Highly Efficient Custom Sorting Eliot Gable
Re: No hash join across partitioned tables? Bruce Momjian
Re: how to (temporarily) disable/minimize benefits of disk
block cache or postgresql shared buffer Craig Ringer
Re: Highly Efficient Custom Sorting Craig Ringer
Re: Highly Efficient Custom Sorting Tom Lane
Re: big data - slow select (speech search) Michal Fapso
Slow query with planner row strange estimation damien hostin
Re: Highly Efficient Custom Sorting Merlin Moncure
Re: Highly Efficient Custom Sorting Eliot Gable
using dbt2 postgresql 8.4 - rampup time issue MUHAMMAD ASIF
Re: Highly Efficient Custom Sorting Matthew Wakeling
Re: Highly Efficient Custom Sorting Merlin Moncure
Question about partitioned query behavior Ranga Gopalan
Re: Highly Efficient Custom Sorting Craig James
Re: Question about partitioned query behavior Benjamin Krajmalnik
Re: how to (temporarily) disable/minimize benefits of disk
block cache or postgresql shared buffer Rajesh Kumar Mallah
Re: Extremely high CPU usage when building tables Rajesh Kumar Mallah
Re: No hash join across partitioned tables? Bruce Momjian
Re: No hash join across partitioned tables? Robert Haas
Re: No hash join across partitioned tables? Bruce Momjian
Re: Highly Efficient Custom Sorting Craig Ringer
Re: Highly Efficient Custom Sorting Eliot Gable
Re: Highly Efficient Custom Sorting Merlin Moncure
Re: Highly Efficient Custom Sorting Eliot Gable
Re: Highly Efficient Custom Sorting Merlin Moncure
Re: Highly Efficient Custom Sorting Alvaro Herrera
Performance issues with postgresql-8.4.0 Sachin Kumar
Re: Extremely high CPU usage when building tables Deborah Fuentes
Re: Performance issues with postgresql-8.4.0 Craig Ringer
Re: Slow query with planner row strange estimation damien hostin
Two "equivalent" WITH RECURSIVE queries, one of them slow. Octavio Alvarez
Re: how to (temporarily) disable/minimize benefits of disk
block cache or postgresql shared buffer Matthew Wakeling
SeqScans on boolen values / How to speed this up? Jens Hoffrichter
Re: SeqScans on boolen values / How to speed this up? Stephen Frost
Re: using dbt2 postgresql 8.4 - rampup time issue MUHAMMAD ASIF
Re: big data - slow select (speech search) Robert Haas
Re: SeqScans on boolen values / How to speed this up? Scott Marlowe
Re: Slow query with planner row strange estimation damien hostin
Re: Question about partitioned query behavior Ranga Gopalan
Re: Extremely high CPU usage when building tables Deborah Fuentes
Re: Extremely high CPU usage when building tables Kevin Grittner
Re: Highly Efficient Custom Sorting Robert Haas
Re: Question about partitioned query behavior Robert Haas
Re: Highly Efficient Custom Sorting Eliot Gable
Re: Highly Efficient Custom Sorting Joe Conway
Re: Highly Efficient Custom Sorting Eliot Gable
Re: Question about partitioned query behavior Stephen Frost
Re: Question about partitioned query behavior Ranga Gopalan
Re: Highly Efficient Custom Sorting Eliot Gable
Re: Highly Efficient Custom Sorting Tom Lane
WAL partition overloaded--by autovacuum? Richard Yen
Re: WAL partition overloaded--by autovacuum? Scott Marlowe
Re: WAL partition overloaded--by autovacuum? Scott Marlowe
Re: WAL partition overloaded--by autovacuum? Scott Marlowe
Invitation to connect on LinkedIn Gourish Singbal
Two different execution plan for the same request JOUANIN Nicolas (44)
Re: Two different execution plan for the same request JOUANIN Nicolas (44)
Re: Two different execution plan for the same request Guillaume Smet
Re: Two different execution plan for the same request JOUANIN Nicolas (44)
Re: WAL partition overloaded--by autovacuum? Kevin Grittner
Re: Two different execution plan for the same request Matthew Wakeling
Re: big data - slow select (speech search) Michal Fapso
Re: Slow query with planner row strange estimation damien hostin
Re: Weird XFS WAL problem Bruce Momjian
Re: Highly Efficient Custom Sorting Eliot Gable
Re: Highly Efficient Custom Sorting Kenneth Marshall
Re: big data - slow select (speech search) Robert Haas
performance on new linux box Ryan Wexler
Re: performance on new linux box Tom Lane
Re: performance on new linux box Rob Wultsch
Re: performance on new linux box Andy Colson
Re: performance on new linux box Pierre C
Re: performance on new linux box Eliot Gable
Re: performance on new linux box Kevin Grittner
Re: performance on new linux box Eliot Gable
Re: performance on new linux box Kevin Grittner
Re: performance on new linux box Ryan Wexler
Re: performance on new linux box Joshua D. Drake
Re: performance on new linux boxeradmin(11983)i:
STATEMENT: update license set expires= '2010-06-15' where lic John Rouillard
Re: performance on new linux box Craig James
Fwd: performance on new linux box Ryan Wexler
Re: performance on new linux box Jochen Erwied
Re: performance on new linux box Ryan Wexler
Need help in performance tuning. Harpreet singh Wadhwa
Re: performance on new linux box Kevin Grittner
Re: performance on new linux box Jochen Erwied
Re: performance on new linux box Ryan Wexler
Re: performance on new linux box Ben Chobot
Re: performance on new linux box Kevin Grittner
Re: performance on new linux box Ryan Wexler
Re: performance on new linux box David Boreham
Re: performance on new linux box Kevin Grittner
Re: Need help in performance tuning. Kevin Grittner
Re: performance on new linux box Craig James
Re: performance on new linux box Ryan Wexler
Re: performance on new linux box Jochen Erwied
Re: performance on new linux box Craig James
Re: performance on new linux box David Boreham
Re: performance on new linux box Joshua D. Drake
Re: Need help in performance tuning. Craig Ringer
Re: Need help in performance tuning. Samuel Gendler
Re: Need help in performance tuning. Tom Lane
Re: Need help in performance tuning. Craig Ringer
Re: performance on new linux box Russell Smith
Re: Need help in performance tuning. Harpreet singh Wadhwa
Re: performance on new linux box Samuel Gendler
Re: Need help in performance tuning. Craig Ringer
Re: Slow query with planner row strange estimation damien hostin
Re: Need help in performance tuning. Brad Nicholson
Re: Need help in performance tuning. Harpreet singh Wadhwa
Re: Need help in performance tuning. Kevin Grittner
Re: Need help in performance tuning. Matthew Wakeling
Re: Need help in performance tuning. Kevin Grittner
Re: Need help in performance tuning. Jorge Montero
Re: Need help in performance tuning. Matthew Wakeling
Re: Need help in performance tuning. Kevin Grittner
Re: Need help in performance tuning. Jorge Montero
Re: Need help in performance tuning. Kevin Grittner
Re: Need help in performance tuning. Robert Haas
Index usage with functions in where condition Jeremy Palmer
Re: Need help in performance tuning. Greg Smith
Re: Index usage with functions in where condition Jeremy Palmer
Re: Need help in performance tuning. Kevin Grittner
Re: Need help in performance tuning. Mark Kirkwood
Re: Pooling in Core WAS: Need help in performance tuning. Samuel Gendler
Re: Need help in performance tuning. Jesper Krogh
Re: Need help in performance tuning. Greg Smith
Re: Pooling in Core WAS: Need help in performance tuning. Matthew Wakeling
Re: now() gives same time within the session A. Kretschmer
PostgreSQL PITR - more doubts Jayadevan M
Re: PostgreSQL PITR - more doubts Jesper Krogh
Re: PostgreSQL PITR - more doubts Jayadevan M
Re: PostgreSQL PITR - more doubts Kevin Grittner
Re: Pooling in Core WAS: Need help in performance
tuning. Kevin Grittner
Re: now() gives same time within the session Rob Wultsch
Re: now() gives same time within the session Thom Brown
Re: now() gives same time within the session A. Kretschmer
Re: now() gives same time within the session Kenneth Marshall
Exists, limit and alternate plans Віталій Тимчишин
Re: performance on new linux box Greg Smith
Re: Need help in performance tuning. Bruce Momjian
Who are you voting for? kangayarkanni
Re: Slow query with planner row strange estimation damien hostin
Queries with conditions using bitand operator Elias Ghanem
Re: Pooling in Core WAS: Need help in performance tuning. Dimitri Fontaine
Re: Pooling in Core WAS: Need help in performance tuning. Magnus Hagander
Re: performance on new linux box Andy Colson
Re: Need help in performance tuning. Hannu Krosing
Re: Need help in performance tuning. Scott Marlowe
Understanding tsearch2 performance Ivan Voras
Re: Understanding tsearch2 performance Oleg Bartunov
Re: Understanding tsearch2 performance Ivan Voras
Re: Understanding tsearch2 performance Oleg Bartunov
Re: Understanding tsearch2 performance Ivan Voras
Re: Understanding tsearch2 performance Stephen Frost
Re: Understanding tsearch2 performance Ivan Voras
Re: Need help in performance tuning. Kevin Grittner
Re: Understanding tsearch2 performance Kevin Grittner
Re: Understanding tsearch2 performance Ivan Voras
Re: Understanding tsearch2 performance Oleg Bartunov
Re: Understanding tsearch2 performance Kevin Grittner
Re: Need help in performance tuning. Hannu Krosing
Re: Understanding tsearch2 performance Ivan Voras
Re: performance on new linux box Scott Carey
Re: performance on new linux box Ben Chobot
Re: performance on new linux box Ryan Wexler
Re: Query optimization problem Yeb Havinga
Identical query slower on 8.4 vs 8.3 Patrick Donlin
Re: Identical query slower on 8.4 vs 8.3 Thom Brown
Re: Identical query slower on 8.4 vs 8.3 Kevin Grittner
Re: Identical query slower on 8.4 vs 8.3 Patrick Donlin
Re: Identical query slower on 8.4 vs 8.3 Alvaro Herrera
Re: Identical query slower on 8.4 vs 8.3 Andy Colson
Re: Identical query slower on 8.4 vs 8.3 Jon Nelson
Re: Identical query slower on 8.4 vs 8.3 Kevin Grittner
Re: Identical query slower on 8.4 vs 8.3 Merlin Moncure
Re: Identical query slower on 8.4 vs 8.3 Joshua D. Drake
Question of using COPY on a table with triggers Benjamin Krajmalnik
Re: Identical query slower on 8.4 vs 8.3 Patrick Donlin
Re: performance on new linux box Scott Carey
Re: performance on new linux box Ben Chobot
Re: performance on new linux box Ben Chobot
Re: Question of using COPY on a table with triggers Benjamin Krajmalnik
Re: Identical query slower on 8.4 vs 8.3 Joshua D. Drake
Re: performance on new linux box Ryan Wexler
Re: performance on new linux box Ben Chobot
Re: performance on new linux box Pierre C
Re: performance on new linux box Scott Marlowe
Re: performance on new linux box Scott Carey
Re: performance on new linux box Scott Carey
Re: performance on new linux box Ben Chobot
Re: performance on new linux box Craig Ringer
Re: performance on new linux box Craig Ringer
Re: Identical query slower on 8.4 vs 8.3 Igor Neyman
Re: Identical query slower on 8.4 vs 8.3 tv@fuzzy.cz
Re: performance on new linux box Greg Smith
Re: now() gives same time within the session Heikki Linnakangas
Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah
Re: What is the best way to optimize the query. Sergey Konoplev
Re: What is the best way to optimize the query. Craig Ringer
IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Daniel Ferreira de Lima
Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller
performance problem Daniel Ferreira de Lima
Big field, limiting and ordering Ivan Voras
Re: Big field, limiting and ordering Vitalii Tymchyshyn
Re: how to handle a big table for data log Jorge Montero
Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller
performance problem Daniel Ferreira de Lima
dates and partitioning Kevin Kempter
Re: dates and partitioning Brad Nicholson
Re: dates and partitioning Jochen Erwied
potential performance gain by query planner optimization Kneringer, Armin
Using more tha one index per table Elias Ghanem
Re: Using more tha one index per table A. Kretschmer
Re: Using more tha one index per table Rob Wultsch
Re: Using more tha one index per table Scott Marlowe
Re: Using more tha one index per table Scott Marlowe
Re: Using more tha one index per table Andy Colson
tune memory usage for master/slave nodes in cluster stanimir petrov
Re: Using more tha one index per table Greg Smith
Re: potential performance gain by query planner
optimization Kneringer, Armin
Re: Using more tha one index per table Craig Ringer
Re: Using more tha one index per table Craig James
Re: Using more tha one index per table Greg Smith
Re: Using more tha one index per table Steve Atkins
Re: Using more tha one index per table Greg Smith
Re: Using more tha one index per table Steve Atkins
Strange explain on partitioned tables Philippe Rimbault
why index is not working in < operation? AI Rumman
Re: why index is not working in < operation? Szymon Guz
Re: why index is not working in < operation? A. Kretschmer
Re: Using more tha one index per table Richard Huxton
Re: Strange explain on partitioned tables Philippe Rimbault
Re: Using more tha one index per table Rob Wultsch
Re: Strange explain on partitioned tables Philippe Rimbault
Re: Strange explain on partitioned tables Greg Smith
Re: Strange explain on partitioned tables Philippe Rimbault
Re: Using more tha one index per table Craig James
Re: Pooling in Core WAS: Need help in performance tuning. Joshua D. Drake
Re: Pooling in Core WAS: Need help in performance tuning. Joshua D. Drake
Execution Plan std pik
Re: Execution Plan Pavel Stehule
Re: Using more tha one index per table Torsten Zühlsdorff
Re: Pooling in Core WAS: Need help in performance tuning. Joshua D. Drake
Re: Using more tha one index per table Craig James
Re: Strange explain on partitioned tables Gerald Fontenay
Re: Strange explain on partitioned tables Joshua D. Drake
Re: Pooling in Core WAS: Need help in performance tuning. Joshua D. Drake
Re: Strange explain on partitioned tables Greg Smith
Re: Strange explain on partitioned tables Joshua D. Drake
Re: Strange explain on partitioned tables Gerald Fontenay
Testing Sandforce SSD Yeb Havinga
Re: Testing Sandforce SSD David Boreham
Re: Testing Sandforce SSD david@lang.hm
Re: Using more tha one index per table Torsten Zühlsdorff
Re: Using more tha one index per table Craig James
Re: Testing Sandforce SSD Ben Chobot
Re: Testing Sandforce SSD Greg Smith
Re: Testing Sandforce SSD Merlin Moncure
Re: Testing Sandforce SSD Yeb Havinga
Re: Testing Sandforce SSD Yeb Havinga
Re: Testing Sandforce SSD Greg Smith
Re: Testing Sandforce SSD Joshua D. Drake
Re: Testing Sandforce SSD Greg Smith
Re: Testing Sandforce SSD Yeb Havinga
Re: Testing Sandforce SSD Greg Smith
Re: Testing Sandforce SSD Joshua D. Drake
Re: Using more tha one index per table Dimitri Fontaine
Re: Pooling in Core WAS: Need help in performance tuning. Dimitri Fontaine
Re: Testing Sandforce SSD Yeb Havinga
Re: Testing Sandforce SSD Yeb Havinga
Explains of queries to partitioned tables Vlad Arkhipov
Re: Testing Sandforce SSD Yeb Havinga
Re: Testing Sandforce SSD Matthew Wakeling
Re: Testing Sandforce SSD Yeb Havinga
Re: Testing Sandforce SSD Greg Smith
Re: Testing Sandforce SSD Greg Smith
Re: Testing Sandforce SSD Matthew Wakeling
Re: Testing Sandforce SSD Yeb Havinga
Re: Testing Sandforce SSD Greg Spiegelberg
Re: Testing Sandforce SSD Greg Smith
Re: Testing Sandforce SSD Greg Smith
Re: Testing Sandforce SSD Kevin Grittner
Re: Testing Sandforce SSD Yeb Havinga
Re: Testing Sandforce SSD Yeb Havinga
Re: Testing Sandforce SSD Greg Smith
Re: Testing Sandforce SSD Scott Marlowe
Re: Testing Sandforce SSD Greg Spiegelberg
Re: Strange explain on partitioned tables Gerald Fontenay
Re: Testing Sandforce SSD Andres Freund
Re: Testing Sandforce SSD Greg Smith
Linux Filesystems again - Ubuntu this time Mark Kirkwood
Re: Linux Filesystems again - Ubuntu this time Kevin Grittner
Re: Linux Filesystems again - Ubuntu this time Whit Armstrong
Re: Linux Filesystems again - Ubuntu this time Kevin Grittner
Re: Linux Filesystems again - Ubuntu this time Kevin Grittner
Re: What is the best way to optimize the query. Robert Haas
Re: Linux Filesystems again - Ubuntu this time Whit Armstrong
Re: Linux Filesystems again - Ubuntu this time Kevin Grittner
Slow query using the Cube contrib module. Liviu Mirea-Ghiban
Re: Testing Sandforce SSD Hannu Krosing
Re: how to handle a big table for data log Greg Spiegelberg
Re: Slow query using the Cube contrib module. Yeb Havinga
Re: how to handle a big table for data log Josh Berkus
Questions on query planner, join types, and work_mem Peter Hussey
Re: Questions on query planner, join types, and work_mem Andres Freund
Re: Questions on query planner, join types, and work_mem Alvaro Herrera
158x query improvement when removing 2 (noop) WHERE conditions Louis-David Mitterrand
Re: Pooling in Core WAS: Need help in performance tuning. Vitalii Tymchyshyn
Re: Testing Sandforce SSD Michael Stone
Re: Testing Sandforce SSD Michael Stone
Re: Testing Sandforce SSD Yeb Havinga
Re: Testing Sandforce SSD Yeb Havinga
planner index choice Chris
Re: Testing Sandforce SSD Greg Spiegelberg
Re: planner index choice Tom Lane
Re: planner index choice Chris
Re: planner index choice tv@fuzzy.cz
Re: Testing Sandforce SSD Michael Stone
Re: planner index choice Tom Lane
Re: Testing Sandforce SSD Yeb Havinga
view columns and performance Eric Schwarzenbach
Re: view columns and performance Tom Lane
Re: Testing Sandforce SSD Karl Denninger
Re: Explains of queries to partitioned tables Robert Haas
