Postgresql Performance
[Prev Page][Next Page]
Performance improvements/regressions from 8.4 to 9.0?,
Andy
Wrong index choice,
Fabrício dos Anjos Silva
How does PG know if data is in memory?,
Fabrício dos Anjos Silva
Running 9 in production? Sticking with 8.4.4 for a while?,
Tory M Blue
Clean up of archived Xlogs in postgres-9.,
Nimesh Satam
Odd behaviour with redundant CREATE statement,
Dave Crooke
postgresql-9.0 Windows service stops after database transaction,
adrian . kitchingman
Memory usage - indexes,
Tobias Brox
how to enforce index sub-select over filter+seqscan,
Dmitry Teslenko
Query much faster with enable_seqscan=0,
Ogden
Memory speed testing,
Greg Smith
Auto ANALYZE criteria,
Joe Miller
Need PostgreSQL data warehousing user, on the record,
Josh Berkus
cleanup on pg_ system tables?,
mark
Performance degradation, index bloat and planner estimates,
Daniele Varrazzo
3ware trivia overload,
Greg Smith
Problem with mergejoin performance (some bug?),
azajac
Is disableing nested_loops a bad idea ?,
Franck Routier
Performance problem with joined aggregate query,
Anssi Kääriäinen
POSTGRES error,
Timothy.Noonan
locking issue on simple selects?,
Tobias Brox
Held idle connections vs use of a Pooler,
mark
Where does data in pg_stat_user_tables come from?,
Josh Berkus
Useless sort by,
Gaetano Mendola
Problem with mergejoin performance,
azajac
Slow SQL lookup due to every field being listed in SORT KEY,
Mason Harding
pgbench could not send data to client: Broken pipe,
David Kerr
Question about LEFT JOIN and query plan,
Kaloyan Iliev Iliev
Odd estimation issue with user-defined type,
Florian Weimer
slow DDL creation,
Kevin Kempter
GPU Accelerated Sorting,
Eliot Gable
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,
Pavel Stehule
- 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: 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: 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: 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: 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: 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,
Gerhard Wiesinger
- Re: Major performance problem after upgrade from 8.3 to 8.4,
Merlin Moncure
- 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,
Merlin Moncure
- 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,
Merlin Moncure
- 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,
Merlin Moncure
- 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,
Marc Antonio
- 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
array can be slow when joining?,
Volodymyr Kostyrko
Using Between,
Ozer, Pam
[Fwd: postgres 8.4.1 number of connections],
Maria L. Wilson
turn off caching for performance test,
Willy-Bas Loos
SubQuery Performance,
mike
New servers, need suggestions for sensible tuning settings,
Bob Branch
PARSE WAITING,
David Kerr
Triggers or code?,
DM
Inefficient query plan,
Jann Röder
Performance on new 64bit server compared to my 32bit desktop,
Philippe Rimbault
yet another q,
Samuel Gendler
in-memory sorting,
Samuel Gendler
Copy performance issues,
Saadat Anwar
write barrier question,
Samuel Gendler
Are Indices automatically generated for primary keys?,
Clemens Eisserer
Vacuum Full + Cluster + Vacuum full = non removable dead rows,
Alexandre de Arruda Paes
Search query is curious,
fiala_marek
Quesion on the use of indexes,
Benjamin Krajmalnik
Very poor performance,
Aaron Burnett
Can WINDOW be used?,
Greg Spiegelberg
Very bad plan when using VIEW and IN (SELECT...*),
Carlo Stonebanks
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD,
gnuoytr
32 vs 64 bit build on Solaris Sparc,
Joseph Conway
Sorted group by,
Matthew Wakeling
Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD,
Michael March
Advice configuring ServeRAID 8k for performance,
Kenneth Cox
vacuum performance on insert,
Sean Chen
LIKE without wildcard different from =,
Kevin Grittner
How to improve: performance of query on postgresql 8.3 takes days,
Dino Vliet
performance sol10 zone (fup),
Heiko L.
Optimizing NOT IN plans / verify rewrite,
Maciek Sakrejda
what does "initplan" operation in explain output mean?,
Mark Rostron
view columns and performance,
Eric Schwarzenbach
planner index choice,
Chris
158x query improvement when removing 2 (noop) WHERE conditions,
Louis-David Mitterrand
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,
Tom Lane
- Re: Questions on query planner, join types, and work_mem,
Alvaro Herrera
- Message not available
- Re: Questions on query planner, join types, and work_mem,
Tom Lane
- Re: Questions on query planner, join types, and work_mem,
Peter Hussey
- 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: Questions on query planner, join types, and work_mem,
Hannu Krosing
- Re: Questions on query planner, join types, and work_mem,
Robert Haas
- 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,
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,
Bruce Momjian
- Re: Questions on query planner, join types, and work_mem,
Kevin Grittner
Re: Questions on query planner, join types, and work_mem,
Jayadevan M
Slow query using the Cube contrib module.,
Liviu Mirea-Ghiban
Linux Filesystems again - Ubuntu this time,
Mark Kirkwood
Explains of queries to partitioned tables,
Vlad Arkhipov
Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...,
Piotr Gasidło
Testing Sandforce SSD,
Yeb Havinga
[Index of Archives]
[Postgresql Home]
[Postgresql General]
[PHP on Windows]
[Yosemite News]
