Mailing lists [pgsql-performance]
- Re: Feature Request --- was: PostgreSQL Performance Tuning Josh Berkus
- Re: sytem log audit/reporting and psql Andreas Haumer
- Re: index structure for 114-dimension vector Andrew Lazarus
- Re: index structure for 114-dimension vector Alexander Staubo
- Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno
- Re: Feature Request --- was: PostgreSQL Performance Tuning david@lang.hm
- Re: Feature Request --- was: PostgreSQL Performance Tuning Greg Smith
- Re: Feature Request --- was: PostgreSQL Performance Tuning Greg Smith
- Re: Feature Request --- was: PostgreSQL Performance Tuning david@lang.hm
- Intermitent slow queries Parks, Aaron B.
- Re: Intermitent slow queries Dave Cramer
- Re: Intermitent slow queries Ron
- Re: Intermitent slow queries Steinar H. Gunderson
- Re: Intermitent slow queries Parks, Aaron B.
- Re: Intermitent slow queries Parks, Aaron B.
- Join vs Subquery Brian Herlihy
- Re: Intermitent slow queries Ron
- Re: Join vs Subquery Gregory Stark
- Re: Join vs Subquery Tom Lane
- pg_stat_* collection Greg Smith
- Re: pg_stat_* collection Alexander Staubo
- Re: Query performance problems with partitioned tables Fei Liu
- Re: pg_stat_* collection Magnus Hagander
- Re: pg_stat_* collection Tobias Brox
- Re: pg_stat_* collection Jeff Davis
- Re: Feature Request --- was: PostgreSQL Performance Tuning Ron
- Re: Feature Request --- was: PostgreSQL Performance Tuning Josh Berkus
- Re: Feature Request --- was: PostgreSQL Performance Tunin g Dave Page
- Re: Feature Request --- was: PostgreSQL Performance Tuning david@lang.hm
- Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno
- Re: Feature Request --- was: PostgreSQL Performance Tuning david@lang.hm
- Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno
- Re: Feature Request --- was: PostgreSQL Performance Tuning david@lang.hm
- Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno
- Re: Feature Request --- was: PostgreSQL Performance Tuning david@lang.hm
- Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno
- Re: Feature Request --- was: PostgreSQL Performance Tuning david@lang.hm
- Re: Query performance problems with partitioned tables Merlin Moncure
- Re: Feature Request --- was: PostgreSQL Performance Tuning Greg Smith
- Re: pg_stat_* collection Greg Smith
- Re: pg_stat_* collection Tobias Brox
- Re: Feature Request --- was: PostgreSQL Performance Tuning Michael Stone
- Re: pg_stat_* collection Michael Stone
- Index not being used in sorting of simple table Paul Smith
- Re: Query performance problems with partitioned tables Scott Marlowe
- Re: Index not being used in sorting of simple table Heikki Linnakangas
- Re: Index not being used in sorting of simple table Tom Lane
- Re: Index not being used in sorting of simple table Paul Smith
- Re: Feature Request --- was: PostgreSQL Performance Tuning Sebastian Hennebrueder
- Re: Query performance problems with partitioned tables Merlin Moncure
- Re: Feature Request --- was: PostgreSQL Performance Tuning Josh Berkus
- Re: Feature Request --- was: PostgreSQL Performance Tuning Sebastian Hennebrueder
- Re: Feature Request --- was: PostgreSQL Performance Tuning Greg Smith
- Re: Feature Request --- was: PostgreSQL Performance Tuning Mark Kirkwood
- Re: Feature Request --- was: PostgreSQL Performance Tuning Steinar H. Gunderson
- Re: Feature Request --- was: PostgreSQL Performance Tuning Sebastian Hennebrueder
- How to Find Cause of Long Vacuum Times - NOOB Question Yudhvir Singh Sidhu
- Re: How to Find Cause of Long Vacuum Times - NOOB Question Steinar H. Gunderson
- Re: How to Find Cause of Long Vacuum Times - NOOB Question Yudhvir Singh Sidhu
- Re: Feature Request --- was: PostgreSQL Performance Tuning Jim Nasby
- Re: Feature Request --- was: PostgreSQL Performance Tuning Andreas Kostyrka
- Re: How to Find Cause of Long Vacuum Times - NOOB Question Heikki Linnakangas
- Re: How to Find Cause of Long Vacuum Times - NOOB Question Steinar H. Gunderson
- Re: How to Find Cause of Long Vacuum Times - NOOB Question Yudhvir Singh Sidhu
- Re: Index not being used in sorting of simple table Robins
- Re: Index not being used in sorting of simple table Tom Lane
- Merging large volumes of data Ambrus Wagner (IJ/ETH)
- Re: Merging large volumes of data Andreas Kostyrka
- Re: Merging large volumes of data Gregory Stark
- Re: Merging large volumes of data Tom Lane
- Re: How to Find Cause of Long Vacuum Times - NOOB Question Jim Nasby
- Best OS for Postgres 8.2 David Levy
- Re: Best OS for Postgres 8.2 Joshua D. Drake
- Re: Best OS for Postgres 8.2 Bill Moran
- Re: Best OS for Postgres 8.2 Joshua D. Drake
- Re: Best OS for Postgres 8.2 Steve Atkins
- Re: Best OS for Postgres 8.2 Chris
- Re: Best OS for Postgres 8.2 david@lang.hm
- Re: Best OS for Postgres 8.2 Chris
- Re: Best OS for Postgres 8.2 Ron
- Re: Best OS for Postgres 8.2 Greg Smith
- Re: How to Find Cause of Long Vacuum Times - NOOB Question Yudhvir Singh Sidhu
- Re: Best OS for Postgres 8.2 Tom Lane
- Re: Best OS for Postgres 8.2 李彦 Ian Li
- Re: Best OS for Postgres 8.2 david@lang.hm
- Re: Best OS for Postgres 8.2 Claus Guttesen
- Re: Best OS for Postgres 8.2 Heikki Linnakangas
- Re: Best OS for Postgres 8.2 Claus Guttesen
- Re: Best OS for Postgres 8.2 david@lang.hm
- Re: Best OS for Postgres 8.2 Trygve Laugstøl
- Re: Best OS for Postgres 8.2 Steinar H. Gunderson
- truncate a table instead of vaccum full when count(*) is 0 Pomarede Nicolas
- Re: Best OS for Postgres 8.2 Alexander Staubo
- Re: Best OS for Postgres 8.2 Steinar H. Gunderson
- Re: truncate a table instead of vaccum full when count(*) is 0 Guillaume Cottenceau
- Re: truncate a table instead of vaccum full when count(*) is 0 Heikki Linnakangas
- Re: truncate a table instead of vaccum full when count(*) is 0 Pomarede Nicolas
- Re: truncate a table instead of vaccum full when count(*) is 0 Pomarede Nicolas
- Re: Best OS for Postgres 8.2 david@lang.hm
- Re: truncate a table instead of vaccum full when count(*) is 0 Gregory Stark
- Re: truncate a table instead of vaccum full when count(*) is 0 Pomarede Nicolas
- Re: truncate a table instead of vaccum full when count(*) is 0 ismo.tuononen@solenovo.fi
- Re: Best OS for Postgres 8.2 david@lang.hm
- Re: truncate a table instead of vaccum full when count(*) is 0 Heikki Linnakangas
- Re: Best OS for Postgres 8.2 Trygve Laugstøl
- Re: truncate a table instead of vaccum full when count(*) is 0 Gregory Stark
- Re: truncate a table instead of vaccum full when count(*) is 0 Pomarede Nicolas
- Re: truncate a table instead of vaccum full when count(*) is 0 Heikki Linnakangas
- Re: [OT] Best OS for Postgres 8.2 C. Bergström
- Re: truncate a table instead of vaccum full when count(*) is 0 Guillaume Cottenceau
- Re: truncate a table instead of vaccum full when count(*) is 0 Heikki Linnakangas
- Re: Best OS for Postgres 8.2 Luke Lonergan
- estimating the need for VACUUM FULL and REINDEX Guillaume Cottenceau
- Re: [OT] Best OS for Postgres 8.2 Adam Tauno Williams
- Re: estimating the need for VACUUM FULL and REINDEX Heikki Linnakangas
- Re: estimating the need for VACUUM FULL and REINDEX Bill Moran
- Re: [PERFORM] specific query (not all) on Pg8 MUCH slower than Pg7 Steinar H. Gunderson
- specific query (not all) on Pg8 MUCH slower than Pg7 Susan Russo
- Re: specific query (not all) on Pg8 MUCH slower than Pg7 Tom Lane
- Re: specific query (not all) on Pg8 MUCH slower than Pg7 Steinar H. Gunderson
- Re: specific query (not all) on Pg8 MUCH slower than Pg7 Richard Broersma Jr
- Re: specific query (not all) on Pg8 MUCH slower than Pg7 Alexander Staubo
- Re: specific query (not all) on Pg8 MUCH slower than Pg7 Bill Moran
- Re: specific query (not all) on Pg8 MUCH slower than Pg7 Tom Lane
- Nested loops overpriced Peter Eisentraut
- Re: specific query (not all) on Pg8 MUCH slower than Pg7 Susan Russo
- Re: specific query (not all) on Pg8 MUCH slower than Pg7 Alvaro Herrera
- Re: Nested loops overpriced Tom Lane
- Re: Best OS for Postgres 8.2 Ron
- Re: specific query (not all) on Pg8 MUCH slower than Pg7 Tom Lane
- Re: Best OS for Postgres 8.2 李彦 Ian Li
- Re: truncate a table instead of vaccum full when count(*) is 0 Pomarede Nicolas
- Re: Query performance problems with partitioned tables Fei Liu
- Re: Query performance problems with partitioned tables Scott Marlowe
- DISTINCT Question Y Sidhu
- Re: DISTINCT Question Steinar H. Gunderson
- Re: DISTINCT Question Joshua D. Drake
- Re: DISTINCT Question Scott Marlowe
- Throttling PostgreSQL's CPU usage Daniel Griscom
- Re: Best OS for Postgres 8.2 Charles Sprickman
- Re: Throttling PostgreSQL's CPU usage Steinar H. Gunderson
- Re: Throttling PostgreSQL's CPU usage Bill Moran
- Re: Throttling PostgreSQL's CPU usage david@lang.hm
- Re: Throttling PostgreSQL's CPU usage Mark Lewis
- What's The Difference Between VACUUM and VACUUM ANALYZE? Y Sidhu
- Re: [PERFORM] specific query (not all) on Pg8 MUCH slower than Pg7 Steinar H. Gunderson
- Re: [PERFORM] specific query (not all) on Pg8 MUCH slower than Pg7 Steinar H. Gunderson
- Re: What's The Difference Between VACUUM and VACUUM ANALYZE? david@lang.hm
- Re: What's The Difference Between VACUUM and VACUUM ANALYZE? Alvaro Herrera
- Re: What's The Difference Between VACUUM and VACUUM ANALYZE? Steinar H. Gunderson
- Re: What's The Difference Between VACUUM and VACUUM ANALYZE? Alvaro Herrera
- Re: Throttling PostgreSQL's CPU usage Carlos Moreno
- Re: Throttling PostgreSQL's CPU usage Joshua D. Drake
- Re: Throttling PostgreSQL's CPU usage Steinar H. Gunderson
- Re: Throttling PostgreSQL's CPU usage Carlos Moreno
- Re: Throttling PostgreSQL's CPU usage Daniel Griscom
- Re: Throttling PostgreSQL's CPU usage Steinar H. Gunderson
- Re: Throttling PostgreSQL's CPU usage Carlos Moreno
- Re: Throttling PostgreSQL's CPU usage david@lang.hm
- Re: Throttling PostgreSQL's CPU usage david@lang.hm
- Orhan Aglagul
- Re: Dan Harris
- Re: Joshua D. Drake
- Re: Carlos Moreno
- Re: Scott Marlowe
- Re: Scott Marlowe
- Re: Orhan Aglagul
- FW: Orhan Aglagul
- FW: Orhan Aglagul
- FW: Orhan Aglagul
- Re: FW: david@lang.hm
- Re: Best OS for Postgres 8.2 Greg Smith
- Re: Best OS for Postgres 8.2 Greg Smith
- Re: Throttling PostgreSQL's CPU usage Luke Lonergan
- Re: Greg Smith
- Re: Robert Treat
- Re: Throttling PostgreSQL's CPU usage Magnus Hagander
- Re: Best OS for Postgres 8.2 david@lang.hm
- Re: estimating the need for VACUUM FULL and REINDEX Guillaume Cottenceau
- Re: Best OS for Postgres 8.2 Steinar H. Gunderson
- Re: Best OS for Postgres 8.2 david@lang.hm
- Re: What's The Difference Between VACUUM and VACUUM ANALYZE? Gregory Stark
- Re: FW: Gregory Stark
- Re: Nested loops overpriced Peter Eisentraut
- Apparently useless bitmap scans Peter Eisentraut
- Cannot make GIN intarray index be used by the planner Valentine Gogichashvili
- Poor performance with queries using clause: sth IN (...) Andrzej Zawadzki
- Re: Cannot make GIN intarray index be used by the planner Oleg Bartunov
- Re: Cannot make GIN intarray index be used by the planner Valentine Gogichashvili
- Re: Nested loops overpriced Daniel Cristian Cruz
- Re: Throttling PostgreSQL's CPU usage Daniel Griscom
- Re: Cannot make GIN intarray index be used by the planner Oleg Bartunov
- Re: Nested loops overpriced Tom Lane
- Re: Throttling PostgreSQL's CPU usage Carlos Moreno
- Re: Apparently useless bitmap scans Alvaro Herrera
- Re: Poor performance with queries using clause: sth IN (...) Gregory Stark
- Re: Nested loops overpriced Gregory Stark
- Re: Apparently useless bitmap scans Tom Lane
- Re: Nested loops overpriced Daniel Cristian Cruz
- Re: Apparently useless bitmap scans Peter Eisentraut
- Re: Apparently useless bitmap scans Tom Lane
- Re: Nested loops overpriced Peter Eisentraut
- ZFS and Postgresql - WASRe: Best OS for Postgres 8.2 Jignesh Shah
- Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2 Alvaro Herrera
- Re: Best OS for Postgres 8.2 Jim Nasby
- Re: How to Find Cause of Long Vacuum Times - NOOB Question Jim Nasby
- Re: Nested loops overpriced Tom Lane
- Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2 Jignesh Shah
- Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2 david@lang.hm
- Re: Cannot make GIN intarray index be used by the planner Valentine Gogichashvili
- Re: Cannot make GIN intarray index be used by the planner Tom Lane
- Vacuum Times - Verbose and maintenance_work_mem Y Sidhu
- Performance Woes Ralph Mason
- Re: Performance Woes CAJ CAJ
- Re: Performance Woes Joshua D. Drake
- Re: Performance Woes Ralph Mason
- Re: Performance Woes Joshua D. Drake
- Re: Performance Woes Jeff Davis
- Re: Performance Woes Ralph Mason
- Re: Performance Woes Scott Mohekey
- Re: Performance Woes Alvaro Herrera
- Re: Performance Woes Tom Lane
- Background vacuum Daniel Haensse
- Re: Background vacuum Dan Harris
- Re: Cannot make GIN intarray index be used by the planner Valentine Gogichashvili
- Re: [PERFORM] REVISIT specific query (not all) on Pg8 MUCH slower than Pg7 Bill Moran
- REVISIT specific query (not all) on Pg8 MUCH slower than Pg7 Susan Russo
- Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7 Steinar H. Gunderson
- Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7 Bill Moran
- Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7 Susan Russo
- Re: Nested loops overpriced Peter Eisentraut
- Re: Nested loops overpriced Peter Eisentraut
- Re: Nested loops overpriced Tom Lane
- Re: [PERFORM] REVISIT specific query (not all) on Pg8 MUCH slowerthan Pg7 Bill Moran
- Re: [PERFORM] REVISIT specific query (not all) on Pg8 MUCH slowerthan Pg7 Bill Moran
- Re: Background vacuum Ron Mayer
- Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7 Susan Russo
- Re: Best OS for Postgres 8.2 Adam Witney
- Re: estimating the need for VACUUM FULL and REINDEX Guillaume Cottenceau
- Re: estimating the need for VACUUM FULL and REINDEX Alvaro Herrera
- Re: BUG #3270: limit < 16 optimizer behaviour Bruno Wolff III
- Re: Best OS for Postgres 8.2 Robert Treat
- 500 requests per second Tarhon-Onu Victor
- Kernel cache vs shared_buffers Michael van Rooyen
- Re: Kernel cache vs shared_buffers Heikki Linnakangas
- Re: estimating the need for VACUUM FULL and REINDEX Jim C. Nasby
- Re: Kernel cache vs shared_buffers Jim C. Nasby
- Re: Best OS for Postgres 8.2 Andrew McMillan
- Re: Kernel cache vs shared_buffers Harald Armin Massa
- Re: Kernel cache vs shared_buffers Heikki Linnakangas
- Re: Kernel cache vs shared_buffers Harald Armin Massa
- Re: Kernel cache vs shared_buffers Magnus Hagander
- pg_stats how-to? Yudhvir Singh Sidhu
- Re: pg_stats how-to? Adam Tauno Williams
- Re: 500 requests per second Richard Huxton
- Re: pg_stats how-to? Y Sidhu
- Re: pg_stats how-to? Jim C. Nasby
- Re: Transaction prioritization from java possible? Josh Berkus
- Re: pg_stats how-to? Jim C. Nasby
- Re: pg_stats how-to? Y Sidhu
- Re: pg_stats how-to? Jim C. Nasby
- Re: pg_stats how-to? Y Sidhu
- Re: pg_stats how-to? Jim C. Nasby
- Re: pg_stats how-to? Y Sidhu
- Re: pg_stats how-to? Bill Moran
- Re: pg_stats how-to? Y Sidhu
- Re: pg_stats how-to? Tom Lane
- Re: 500 requests per second Tarhon-Onu Victor
- Re: 500 requests per second Richard Huxton
- Many to many join seems slow? Drew Wilson
- Re: Many to many join seems slow? Alvaro Herrera
- Re: Many to many join seems slow? Drew Wilson
- Re: Many to many join seems slow? Heikki Linnakangas
- bitmap index and IS NULL predicate Jason Pinnix
- Re: bitmap index and IS NULL predicate Alexander Staubo
- Re: Many to many join seems slow? Daniel Cristian Cruz
- [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal Guillaume Cottenceau
- Re: Many to many join seems slow? Drew Wilson
- Re: Many to many join seems slow? Drew Wilson
- Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal Michael Stone
- Disk Fills Up and fsck "Compresses" it Y Sidhu
- How to Run a pg_stats Query Y Sidhu
- Re: How to Run a pg_stats Query Alvaro Herrera
- Re: 500 requests per second Jim C. Nasby
- Re: pg_stats how-to? Jim C. Nasby
- Re: Disk Fills Up and fsck "Compresses" it Jim C. Nasby
- Re: [PATCHES] Automatic adjustment of bgwriter_lru_maxpages Greg Smith
- New performance documentation released Greg Smith
- Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal Guillaume Cottenceau
- Re: Disk Fills Up and fsck "Compresses" it Y Sidhu
- Re: New performance documentation released Luke Lonergan
- Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal Jim C. Nasby
- Re: Disk Fills Up and fsck "Compresses" it Jim C. Nasby
- Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal Guillaume Cottenceau
- Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal Alvaro Herrera
- Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal Jim C. Nasby
- Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal Michael Stone
- Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal Chris Browne
- Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal Michael Stone
- Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal Alvaro Herrera
- Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal Tom Lane
- Re: Disk Fills Up and fsck "Compresses" it Mark Kirkwood
- Re: Background vacuum Andrew Sullivan
- WAL log performance/efficiency question Keaton Adams
- Re: WAL log performance/efficiency question Heikki Linnakangas
- Re: WAL log performance/efficiency question Tom Lane
- Re: WAL log performance/efficiency question Keaton Adams
- Re: WAL log performance/efficiency question Heikki Linnakangas
- Re: WAL log performance/efficiency question Keaton Adams
- Ever Increasing IOWAIT Ralph Mason
- Re: Ever Increasing IOWAIT Joshua D. Drake
- Re: Ever Increasing IOWAIT Ralph Mason
- Re: Background vacuum Ron Mayer
- Re: Background vacuum Greg Smith
- Re: Background vacuum Ron Mayer
- Re: Background vacuum Tom Lane
- Re: Ever Increasing IOWAIT Richard Huxton
- performance drop on 8.2.4, reverting to 8.1.4 Liviu Ionescu
- Re: performance drop on 8.2.4, reverting to 8.1.4 Steinar H. Gunderson
- Re: performance drop on 8.2.4, reverting to 8.1.4 Liviu Ionescu
- Re: performance drop on 8.2.4, reverting to 8.1.4 Steinar H. Gunderson
- Re: performance drop on 8.2.4, reverting to 8.1.4 Liviu Ionescu
- Re: performance drop on 8.2.4, reverting to 8.1.4 Steinar H. Gunderson
- Re: performance drop on 8.2.4, reverting to 8.1.4 Liviu Ionescu
- Re: performance drop on 8.2.4, reverting to 8.1.4 Steinar H. Gunderson
- Re: performance drop on 8.2.4, reverting to 8.1.4 Liviu Ionescu
- Re: Ever Increasing IOWAIT Mark Lewis
- Re: performance drop on 8.2.4, reverting to 8.1.4 George Pavlov
- Re: performance drop on 8.2.4, reverting to 8.1.4 Liviu Ionescu
- Re: performance drop on 8.2.4, reverting to 8.1.4 Tom Lane
- CPU Intensive query Abu Mushayeed
- Re: CPU Intensive query Steinar H. Gunderson
- Re: performance drop on 8.2.4, reverting to 8.1.4 Liviu Ionescu
- reading large BYTEA type is slower than expected Mark Harris
- Re: reading large BYTEA type is slower than expected Tom Lane
- Re: reading large BYTEA type is slower than expected Y Sidhu
- 121+ million record table perf problems cyber-postgres@midnightfantasy.com
- Re: 121+ million record table perf problems Andrew Sullivan
- Re: 121+ million record table perf problems Joshua D. Drake
- Re: reading large BYTEA type is slower than expected Mark Harris
- Re: 121+ million record table perf problems Brian Hurt
- choosing fillfactor Gene Hart
- Slow queries on big table Tyrrill, Ed
- Re: 121+ million record table perf problems Alan Hodgson
- Re: Background vacuum Ron Mayer
- Re: Slow queries on big table Scott Marlowe
- Re: reading large BYTEA type is slower than expected Mark Harris
- Re: 121+ million record table perf problems Tom Lane
- Re: Slow queries on big table Tom Lane
- Re: Slow queries on big table Andrew Kroeger
- Re: Slow queries on big table Tom Lane
- Re: choosing fillfactor Heikki Linnakangas
- Re: Slow queries on big table Tyrrill, Ed
- Re: Slow queries on big table Steinar H. Gunderson
- Re: Slow queries on big table Tom Lane
- Re: CPU Intensive query Abu Mushayeed
- Re: CPU Intensive query Tom Lane
- Re: CPU Intensive query Abu Mushayeed
- Re: CPU Intensive query Steinar H. Gunderson
- Re: CPU Intensive query Steinar H. Gunderson
- Re: 121+ million record table perf problems Craig James
- Re: Slow queries on big table Tyrrill, Ed
- Re: 121+ million record table perf problems Alvaro Herrera
- Re: pg_stats how-to? Y Sidhu
- Re: 121+ million record table perf problems Greg Smith
- Re: Background vacuum Greg Smith
- Re: CPU Intensive query Andrew Sullivan
- Re: Diminishing bandwidth performance with multiple quad core X5355s jlmarin
- Re: pg_stats how-to? Shoaib Mir
- any way to get rid of Bitmap Heap Scan recheck? Sergei Shelukhin
- Re: performance drop on 8.2.4, reverting to 8.1.4 Kenneth Marshall
- Efficient recursion C Storm
- Re: any way to get rid of Bitmap Heap Scan recheck? Sergei Shelukhin
- Re: any way to get rid of Bitmap Heap Scan recheck? Heikki Linnakangas
- Re: any way to get rid of Bitmap Heap Scan recheck? Tom Lane
- Re: Efficient recursion Tom Lane
- Re: performance drop on 8.2.4, reverting to 8.1.4 Guido Neitzer
- QP Problem s d
- Re: Background vacuum Ron Mayer
- Re: QP Problem Tom Lane
- Postgres Benchmark Results PFC
- Re: Postgres Benchmark Results Arjen van der Meijden
- Re: Postgres Benchmark Results PFC
- Re: Diminishing bandwidth performance with multiple quad core X5355s Arjen van der Meijden
- Re: Postgres Benchmark Results Arjen van der Meijden
- Re: Postgres Benchmark Results Tom Lane
- Re: Postgres Benchmark Results Zoltan Boszormenyi
- Re: Postgres Benchmark Results PFC
- Re: Postgres Benchmark Results Andreas Kostyrka
- Re: Ever Increasing IOWAIT Ralph Mason
- Re: Ever Increasing IOWAIT Ralph Mason
- Re: Ever Increasing IOWAIT Tom Lane
- Rewriting DISTINCT and losing performance Chuck D.
- Re: Ever Increasing IOWAIT Ralph Mason
- Re: Rewriting DISTINCT and losing performance Josh Berkus
- Re: Rewriting DISTINCT and losing performance Richard Huxton
- Increasing Shared_buffers = slow commits? Chris Hoover
- Re: Rewriting DISTINCT and losing performance Chuck D.
- Re: Rewriting DISTINCT and losing performance Chuck D.
- Re: pg_stats how-to? Jim C. Nasby
- Re: Rewriting DISTINCT and losing performance Richard Huxton
- Re: Rewriting DISTINCT and losing performance Chuck D.
- Re: Increasing Shared_buffers = slow commits? Merlin Moncure
- Re: 500 requests per second Merlin Moncure
- Re: pg_stats how-to? Y Sidhu
- Re: 500 requests per second PFC
- Re: 500 requests per second Jim C. Nasby
- Re: Postgres Benchmark Results Jim C. Nasby
- Re: Postgres Benchmark Results Jim C. Nasby
- Re: 121+ million record table perf problems Vivek Khera
- Re: Rewriting DISTINCT and losing performance Tom Lane
- Re: Postgres Benchmark Results PFC
- Re: Postgres Benchmark Results PFC
- Re: Postgres Benchmark Results Guido Neitzer
- Re: Postgres Benchmark Results Rich
- Re: Postgres Benchmark Results Scott Marlowe
- Re: Postgres Benchmark Results Alvaro Herrera
- Re: 500 requests per second Dave Cramer
- Re: Postgres Benchmark Results Greg Smith
- Re: Postgres Benchmark Results Guido Neitzer
- Re: Postgres Benchmark Results Zoltan Boszormenyi
- Re: Postgres Benchmark Results Zoltan Boszormenyi
- Re: Postgres Benchmark Results Peter Schuller
- Feature suggestion : FAST CLUSTER PFC
- Re: Postgres Benchmark Results Gregory Stark
- Re: Postgres Benchmark Results Gregory Stark
- Key/Value reference table generation: INSERT/UPDATE performance valgog
- Re: Key/Value reference table generation: INSERT/UPDATE performance Peter Childs
- Re: Key/Value reference table generation: INSERT/UPDATE performance Richard Huxton
- is file size relevant in choosing index or table scan? Joost Kraaijeveld
- Re: is file size relevant in choosing index or table scan? Richard Huxton
- Re: Key/Value reference table generation: INSERT/UPDATE performance valgog
- Re: Postgres Benchmark Results PFC
- Re: Key/Value reference table generation: INSERT/UPDATE performance PFC
- Re: Key/Value reference table generation: INSERT/UPDATE performance valgog
- Re: Key/Value reference table generation: INSERT/UPDATE performance valgog
- Performace comparison of indexes over timestamp fields Arnau
- Re: Key/Value reference table generation: INSERT/UPDATE performance cedric
- Re: Performace comparison of indexes over timestamp fields Alexander Staubo
- Re: Performace comparison of indexes over timestamp fields Steinar H. Gunderson
- Re: Performace comparison of indexes over timestamp fields Alexander Staubo
- Tips & Tricks for validating hardware/os Stephane Bailliez
- Re: Tips & Tricks for validating hardware/os Alexander Staubo
- Re: Tips & Tricks for validating hardware/os PFC
- Re: Performace comparison of indexes over timestamp fields Tom Lane
- Domains versus Check Constraints Chander Ganesan
- Drop table vs Delete record Orhan Aglagul
- Re: Drop table vs Delete record Andreas Kostyrka
- Re: Drop table vs Delete record Orhan Aglagul
- Re: Postgres Benchmark Results Greg Smith
- Re: Tips & Tricks for validating hardware/os Greg Smith
- Re: Tips & Tricks for validating hardware/os Andreas Kostyrka
- Re: Key/Value reference table generation: INSERT/UPDATE performance Guillaume Smet
- Re: Postgres Benchmark Results Gregory Stark
- Re: [PERFORM] does VACUUM ANALYZE complete with this error? Tom Lane
- does VACUUM ANALYZE complete with this error? Susan Russo
- Re: does VACUUM ANALYZE complete with this error? Tom Lane
- LIKE search and performance Andy
- Re: performance drop on 8.2.4, reverting to 8.1.4 Vivek Khera
- Re: Tips & Tricks for validating hardware/os Vivek Khera
- Re: LIKE search and performance Richard Huxton
- Re: does VACUUM ANALYZE complete with this error? Vivek Khera
- Re: LIKE search and performance Guido Neitzer
- Re: LIKE search and performance Alexander Staubo
- Re: LIKE search and performance Rigmor Ukuhe
- max_fsm_pages, shared_buffers and checkpoint_segments Y Sidhu
- Re: max_fsm_pages, shared_buffers and checkpoint_segments Ben
- Re: max_fsm_pages, shared_buffers and checkpoint_segments Y Sidhu
- Re: max_fsm_pages, shared_buffers and checkpoint_segments Ben
- Re: [PERFORM] does VACUUM ANALYZE complete with this error? Tom Lane
- Re: max_fsm_pages, shared_buffers and checkpoint_segments PFC
- Re: does VACUUM ANALYZE complete with this error? Susan Russo
- Re: does VACUUM ANALYZE complete with this error? Tom Lane
- Simulate database fragmentation Y Sidhu
- Re: does VACUUM ANALYZE complete with this error? Susan Russo
- Re: Drop table vs Delete record Chris Mair
- Re: max_fsm_pages, shared_buffers and checkpoint_segments Peter Schuller
- Re: [PERFORM] does VACUUM ANALYZE complete with this error? Tom Lane
- Re: [PERFORM] does VACUUM ANALYZE complete with this error? Tom Lane
- Re: does VACUUM ANALYZE complete with this error? Scott Marlowe
- Auto-ANALYZE? Craig James
- Re: Auto-ANALYZE? Tom Lane
- Re: [PERFORM] does VACUUM ANALYZE complete with this error? Tom Lane
- Re: [PERFORM] does VACUUM ANALYZE complete with this error? Tom Lane
- Memory allocation and Vacuum abends Leandro Guimarães dos Santos
- Re: max_fsm_pages, shared_buffers and checkpoint_segments Heikki Linnakangas
- Re: LIKE search and performance Andy
- Re: LIKE search and performance James Mansion
- Re: LIKE search and performance Magnus Hagander
- Re: LIKE search and performance James Mansion
- Re: LIKE search and performance Mark Lewis
- Re: LIKE search and performance Craig James
- Re: LIKE search and performance Alvaro Herrera
- Re: LIKE search and performance mark@mark.mielke.cc
- Re: LIKE search and performance Craig James
- Re: LIKE search and performance PFC
- Re: LIKE search and performance Richard Huxton
- general PG network slowness (possible cure) (repost) Peter T. Breuer
- Performance Problem with Vacuum of bytea table (PG 8.0.13) Bastian Voigt
- How PostgreSQL handles multiple DDBB instances? Arnau
- Big problem with sql update operation Michal Szymanski
- Re: general PG network slowness (possible cure) (repost) Richard Huxton
- Re: Performance Problem with Vacuum of bytea table (PG 8.0.13) Richard Huxton
- Re: Performance Problem with Vacuum of bytea table (PG 8.0.13) Bastian Voigt
- Re: Performance Problem with Vacuum of bytea table (PG 8.0.13) Richard Huxton
- Re: Performance Problem with Vacuum of bytea table (PG 8.0.13) Bastian Voigt
- Re: Performance Problem with Vacuum of bytea table (PG 8.0.13) Richard Huxton
- My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)) Bastian Voigt
- Re: general PG network slowness (possible cure) (repost) Steinar H. Gunderson
- Re: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)) Richard Huxton
- Re: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)) Kristo Kaiv
- Re: general PG network slowness (possible cure) (repost) Peter T. Breuer
- Re: general PG network slowness (possible cure) (repost) Peter T. Breuer
- Re: general PG network slowness (possible cure) (repost) Richard Huxton
- Re: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)) Alvaro Herrera
- Re: general PG network slowness (possible cure) (repost) Peter T. Breuer
- Re: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)) Bastian Voigt
- Re: general PG network slowness (possible cure) (repost) Tom Lane
- Re: general PG network slowness (possible cure) (repost) Richard Huxton
- Re: general PG network slowness (possible cure) (repost) Alvaro Herrera
- Re: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)) Bastian Voigt
- Re: LIKE search and performance mark@mark.mielke.cc
- Re: Performance Problem with Vacuum of bytea table (PG 8.0.13) Tom Lane
- Re: How PostgreSQL handles multiple DDBB instances? Tom Lane
- Re: Big problem with sql update operation Tom Lane
- Re: general PG network slowness (possible cure) (repost) Peter T. Breuer
- Re: general PG network slowness (possible cure) (repost) Tom Lane
- Re: My quick and dirty "solution" (Re: Performance P roblem with Vacuum of bytea table (PG 8.0.13)) Andreas Kostyrka
- Re: LIKE search and performance Richard Huxton
- Re: general PG network slowness (possible cure) (repost) Peter T. Breuer
- Re: general PG network slowness (possible cure) (repost) Tom Lane
- Re: general PG network slowness (possible cure) (repost) Peter T. Breuer
- Re: LIKE search and performance PFC
- Re: LIKE search and performance mark@mark.mielke.cc
- Re: LIKE search and performance Joshua D. Drake
- Re: LIKE search and performance Richard Huxton
- Re: How PostgreSQL handles multiple DDBB instances? Arnau
- Re: LIKE search and performance PFC
- Re: LIKE search and performance Richard Huxton
- Re: LIKE search and performance Richard Huxton
- Re: LIKE search and performance Gregory Stark
- Re: How PostgreSQL handles multiple DDBB instances? Tom Lane
- Re: LIKE search and performance Richard Huxton
- Re: How PostgreSQL handles multiple DDBB instances? Arnau
- Re: How PostgreSQL handles multiple DDBB instances? Tom Lane
- Performance problem on 8.2.4, but not 8.2.3 Dave Pirotte
- Re: general PG network slowness (possible cure) (repost) Peter T. Breuer
- Re: Performance problem on 8.2.4, but not 8.2.3 Kristo Kaiv
- Re: Performance problem on 8.2.4, but not 8.2.3 Tom Lane
- Re: Performance problem on 8.2.4, but not 8.2.3 Steinar H. Gunderson
- Re: Performance problem on 8.2.4, but not 8.2.3 Tom Lane
- Re: Performance problem on 8.2.4, but not 8.2.3 Dave Pirotte
- Adding disks/xlog & index lists@on-track.ca
- Re: general PG network slowness (possible cure) (repost) Peter T. Breuer
- Re: Big problem with sql update operation Michal Szymanski
- Re: Big problem with sql update operation Alvaro Herrera
- Re: Adding disks/xlog & index Tom Lane
- Re: Adding disks/xlog & index Tom Lane
- Re: general PG network slowness (possible cure) (repost) Tom Lane
- Re: Adding disks/xlog & index Gregory Stark
- ECC RAM really needed? Craig James
- Re: ECC RAM really needed? Bruno Wolff III
- Re: ECC RAM really needed? Greg Smith
- Re: ECC RAM really needed? Tom Lane
- Re: general PG network slowness (possible cure) (repost) Peter T. Breuer
- Re: Performance problem on 8.2.4, but not 8.2.3 Kristo Kaiv
- Re: ECC RAM really needed? Michael Stone
- Re: ECC RAM really needed? mark@mark.mielke.cc
- Re: general PG network slowness (possible cure) (repost) Tom Lane
- Re: ECC RAM really needed? Andrew Sullivan
- Re: Feature suggestion : FAST CLUSTER Jim C. Nasby
- Re: Domains versus Check Constraints Jim C. Nasby
- Re: Simulate database fragmentation Jim C. Nasby
- Re: Memory allocation and Vacuum abends Jim C. Nasby
- Re: Performance Problem with Vacuum of bytea table (PG 8.0.13) Jim C. Nasby
- Re: Domains versus Check Constraints Stefan Kaltenbrunner
- Re: Feature suggestion : FAST CLUSTER PFC
- Re: Feature suggestion : FAST CLUSTER Alexander Staubo
- Re: Feature suggestion : FAST CLUSTER PFC
- Re: Postgres Benchmark Results Chris
- Re: Postgres Benchmark Results PFC
- PITR performance costs Dave Cramer
- Re: PITR performance costs Bill Moran
- Re: PITR performance costs A. Kretschmer
- Re: PITR performance costs Heikki Linnakangas
- Re: PITR performance costs Dave Cramer
- Re: PITR performance costs Stephen Frost
- Re: PITR performance costs Simon Riggs
- Re: general PG network slowness (possible cure) (repost) Bruce Momjian
- Re: Feature suggestion : FAST CLUSTER PFC
- Re: Feature suggestion : FAST CLUSTER Jim Nasby
- Re: Feature suggestion : FAST CLUSTER PFC
- Re: PITR performance costs Merlin Moncure
- Re: general PG network slowness (possible cure) (repost) Merlin Moncure
- Vacuum takes forever Joost Kraaijeveld
- Re: Vacuum takes forever PFC
- Re: Vacuum takes forever Joost Kraaijeveld
- Re: Big problem with sql update operation Alvaro Herrera
- Re: Vacuum takes forever Dave Page
- Re: Vacuum takes forever Joshua D. Drake
- setting up raid10 with more than 4 drives Rajesh Kumar Mallah
- Re: setting up raid10 with more than 4 drives Luke Lonergan
- Re: How PostgreSQL handles multiple DDBB instances? Jeff Davis
- Very slow left outer join Tyrrill, Ed
- Re: How PostgreSQL handles multiple DDBB instances? Craig James
- Re: Very slow left outer join Michael Glaesemann
- Re: Very slow left outer join Klint Gore
- Re: setting up raid10 with more than 4 drives Rajesh Kumar Mallah
- Re: Very slow left outer join Tom Lane
- Re: setting up raid10 with more than 4 drives Luke Lonergan
- Re: setting up raid10 with more than 4 drives Stephen Frost
- Re: setting up raid10 with more than 4 drives Luke Lonergan
- Re: Vacuum takes forever Joost Kraaijeveld
- Re: setting up raid10 with more than 4 drives Jonah H. Harris
- Re: setting up raid10 with more than 4 drives david@lang.hm
- Re: setting up raid10 with more than 4 drives Peter Childs
- Re: Vacuum takes forever Dave Page
- Bad RAID1 read performance Albert Cervera Areny
- Re: setting up raid10 with more than 4 drives Stephen Frost
- Re: setting up raid10 with more than 4 drives Gregory Stark
- Re: setting up raid10 with more than 4 drives Luke Lonergan
- Re: Bad RAID1 read performance Luke Lonergan
- Re: Vacuum takes forever Andrew Sullivan
- Re: setting up raid10 with more than 4 drives Michael Stone
- Re: setting up raid10 with more than 4 drives Luke Lonergan
- Re: Bad RAID1 read performance Albert Cervera Areny
- Re: setting up raid10 with more than 4 drives Michael Stone
- Re: setting up raid10 with more than 4 drives Luke Lonergan
- Re: setting up raid10 with more than 4 drives Gregory Stark
- Re: setting up raid10 with more than 4 drives PFC
- Re: setting up raid10 with more than 4 drives PFC
- Re: setting up raid10 with more than 4 drives Luke Lonergan
- Re: setting up raid10 with more than 4 drives mark@mark.mielke.cc
- Re: Very slow left outer join Tyrrill, Ed
- Re: Very slow left outer join Tyrrill, Ed
- Re: Very slow left outer join Tom Lane
- Re: Bad RAID1 read performance Dimitri
- Re: setting up raid10 with more than 4 drives Rajesh Kumar Mallah
- Re: Bad RAID1 read performance Luke Lonergan
- Re: setting up raid10 with more than 4 drives Luke Lonergan
- Re: setting up raid10 with more than 4 drives mark@mark.mielke.cc
- Database connection for Tbl_B established Y Sidhu
- Re: Database connection for Tbl_B established Tom Lane
- Re: Database connection for Tbl_B established Y Sidhu
- Re: setting up raid10 with more than 4 drives Rajesh Kumar Mallah
- Re: Append table Hanu Kurubar
- Re: Bad RAID1 read performance Albert Cervera Areny
- DB cluster sharing between 32 and 64 bit software versions Ireneusz Pluta
- Re: DB cluster sharing between 32 and 64 bit software versions Bill Moran
- Some info to share: db_STRESS Benchmark results Dimitri
- Re: Some info to share: db_STRESS Benchmark results Alexander Staubo
- Re: Some info to share: db_STRESS Benchmark results Dimitri
- Re: max_fsm_pages, shared_buffers and checkpoint_segments Vivek Khera
- Re: setting up raid10 with more than 4 drives Steinar H. Gunderson
- Re: setting up raid10 with more than 4 drives Sander Steffann