Mailing lists [pgsql-performance]
- Re: High end server and storage for a PostgreSQL OLTP system Tom Lane
- Index Slowing Insert >50x Trevor Ball
- Very important choice Lago, Bruno Almeida do
- Re: Automagic tuning Jim C. Nasby
- Re: High end server and storage for a PostgreSQL OLTP system Jim C. Nasby
- Re: Automagic tuning Tom Lane
- Re: Index Slowing Insert >50x Tom Lane
- Re: Automagic tuning Jim C. Nasby
- Re: High end server and storage for a PostgreSQL OLTP system Cosimo Streppone
- Re: High end server and storage for a PostgreSQL OLTP system Cosimo Streppone
- Re: Very important choice Richard Huxton
- Re: [SQL] OFFSET impact on Performance??? PFC
- Very important choice Bruno Almeida do Lago
- Re: High end server and storage for a PostgreSQL OLTP system Jim C. Nasby
- Performance of count(*) on large tables vs SQL Server Andrew Mayo
- Re: Performance of count(*) on large tables vs SQL Server Shridhar Daithankar
- Re: Performance of count(*) on large tables vs SQL Server Stef
- Re: Performance of count(*) on large tables vs SQL Server PFC
- Re: High end server and storage for a PostgreSQL OLTP system Alex Turner
- Re: High end server and storage for a PostgreSQL OLTP system Merlin Moncure
- Why the difference in query plan and performance pg 7.4.6? Joost Kraaijeveld
- Re: Why the difference in query plan and performance pg John Arbash Meinel
- Re: High end server and storage for a PostgreSQL OLTP system Cosimo Streppone
- Re: Ideal disk setup for Postgresql 7.4? Bruce Momjian
- Re: High end server and storage for a PostgreSQL OLTP system Cosimo Streppone
- horizontal partition Gaetano Mendola
- Re: High end server and storage for a PostgreSQL OLTP system William Yu
- Re: High end server and storage for a PostgreSQL OLTP system Alex Turner
- Accessing insert values in triggers Hasnul Fadhly bin Hasan
- Re: Swapping on Solaris Bruce Momjian
- Re: Bitmap indexes Bruce Momjian
- Bad query optimizer misestimation because of TOAST tables Markus Schaber
- Re: High end server and storage for a PostgreSQL OLTP system Bruce Momjian
- Re: Bad query optimizer misestimation because of TOAST tables Tom Lane
- Re: High end server and storage for a PostgreSQL OLTP system William Yu
- Re: Bad query optimizer misestimation because of TOAST Markus Schaber
- Re: High end server and storage for a PostgreSQL OLTP system Bruce Momjian
- Re: High end server and storage for a PostgreSQL OLTP system Merlin Moncure
- Re: High end server and storage for a PostgreSQL OLTP system William Yu
- Re: horizontal partition Josh Berkus
- Re: High end server and storage for a PostgreSQL OLTP system Cosimo Streppone
- Re: Bitmap indexes Daniel Ceregatti
- Re: Bad query optimizer misestimation because of TOAST Tom Lane
- Re: horizontal partition Gaetano Mendola
- Re: horizontal partition Josh Berkus
- Re: horizontal partition Klint Gore
- Re: High end server and storage for a PostgreSQL OLTP system Christopher Browne
- GiST indexes and concurrency (tsearch2) Marinos J. Yannikos
- Re: GiST indexes and concurrency (tsearch2) Tom Lane
- Effect of database encoding on performance Igor Postelnik
- Re: [SQL] OFFSET impact on Performance??? Sean Davis
- Re: horizontal partition Josh Berkus
- Re: horizontal partition Tom Lane
- Re: Accessing insert values in triggers Michael Fuhr
- Re: GiST indexes and concurrency (tsearch2) Christopher Kings-Lynne
- Tunning postgresql on linux (fedora core 3) Din Adrian
- Re: GiST indexes and concurrency (tsearch2) Oleg Bartunov
- Re: Bad query optimizer misestimation because of TOAST Markus Schaber
- Re: horizontal partition Gaetano Mendola
- Re: Tunning postgresql on linux (fedora core 3) Richard Huxton
- Re: GiST indexes and concurrency (tsearch2) Marinos J. Yannikos
- Planner really hates nested loops David Brown
- Re: GiST indexes and concurrency (tsearch2) PFC
- Re: GiST indexes and concurrency (tsearch2) Oleg Bartunov
- Re: GiST indexes and concurrency (tsearch2) Marinos J. Yannikos
- Re: Tunning postgresql on linux (fedora core 3) Richard Huxton
- Re: [postgis-users] Bad query optimizer misestimation because of Markus Schaber
- Re: Tunning postgresql on linux (fedora core 3) Richard Huxton
- Re: Planner really hates nested loops Tom Lane
- Re: GiST indexes and concurrency (tsearch2) Tom Lane
- Re: Planner really hates nested loops Magnus Hagander
- Re: Planner really hates nested loops Merlin Moncure
- Re: GiST indexes and concurrency (tsearch2) Marinos J. Yannikos
- Re: GiST indexes and concurrency (tsearch2) Oleg Bartunov
- Re: Planner really hates nested loops David Brown
- Re: Planner really hates nested loops Bruce Momjian
- Re: Flattening a kind of 'dynamic' table Merlin Moncure
- Re: Flattening a kind of 'dynamic' table Alexandre Leclerc
- Re: GiST indexes and concurrency (tsearch2) Marinos Yannikos
- query produces 1 GB temp file Dirk Lutzebaeck
- Re: GiST indexes and concurrency (tsearch2) Tom Lane
- Re: query produces 1 GB temp file John A Meinel
- Re: GiST indexes and concurrency (tsearch2) Tom Lane
- Re: query produces 1 GB temp file Greg Stark
- Re: query produces 1 GB temp file Tom Lane
- Re: query produces 1 GB temp file Greg Stark
- Re: query produces 1 GB temp file Tom Lane
- Re: query produces 1 GB temp file John A Meinel
- Re: horizontal partition Gaetano Mendola
- Re: query produces 1 GB temp file Greg Stark
- Re: PostgreSQL clustering VS MySQL clustering Jan Wieck
- Re: query produces 1 GB temp file John A Meinel
- Are JOINs allowed with DELETE FROM Steven Rosenstein
- Re: query produces 1 GB temp file Tom Lane
- Re: Are JOINs allowed with DELETE FROM Gaetano Mendola
- Re: Are JOINs allowed with DELETE FROM Michael Fuhr
- Re: Are JOINs allowed with DELETE FROM John Arbash Meinel
- Re: Are JOINs allowed with DELETE FROM Steven Rosenstein
- Re: Are JOINs allowed with DELETE FROM Tom Lane
- Can the V7.3 EXPLAIN ANALYZE be trusted? Steven Rosenstein
- Re: Are JOINs allowed with DELETE FROM Steven Rosenstein
- Re: Can the V7.3 EXPLAIN ANALYZE be trusted? Leeuw van der, Tim
- Re: Can the V7.3 EXPLAIN ANALYZE be trusted? Greg Stark
- Re: Can the V7.3 EXPLAIN ANALYZE be trusted? Tom Lane
- Re: PostgreSQL clustering VS MySQL clustering Jan Wieck
- Re: Can the V7.3 EXPLAIN ANALYZE be trusted? Steven Rosenstein
- Index not used with or condition Antony Paul
- Re: Index not used with or condition Antony Paul
- Is this possible / slow performance? Joost Kraaijeveld
- Re: Index not used with or condition Steinar H. Gunderson
- Re: Index not used with or condition Jan Poslusny
- Re: Index not used with or condition Antony Paul
- Re: Index not used with or condition Antony Paul
- Re: Bad query optimizer misestimation because of TOAST Markus Schaber
- Re: Can the V7.3 EXPLAIN ANALYZE be trusted? Markus Schaber
- Retry: Is this possible / slow performance? Joost Kraaijeveld
- Re: Retry: Is this possible / slow performance? Tom Lane
- Re: Are JOINs allowed with DELETE FROM Gaetano Mendola
- Re: Retry: Is this possible / slow performance? PFC
- Re: Retry: Is this possible / slow performance? Joost Kraaijeveld
- Re: Retry: Is this possible / slow performance? Merlin Moncure
- Solaris 9 tuning Paul Johnson
- Re: Solaris 9 tuning Josh Berkus
- Slow Restoration of a template1 Database (ALTER GROUP) Ben Young
- Re: Slow Restoration of a template1 Database (ALTER GROUP) Tom Lane
- Re: Slow Restoration of a template1 Database (ALTER GROUP) Tom Lane
- Re: Slow Restoration of a template1 Database (ALTER GROUP) Ben Young
- Re: Slow Restoration of a template1 Database (ALTER GROUP) Tom Lane
- Re: query produces 1 GB temp file Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck)
- Re: query produces 1 GB temp file Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck)
- Re: query produces 1 GB temp file Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck)
- Postgres odbc performance on windows Sanketh Indarapu
- Re: query produces 1 GB temp file Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck)
- Re: query produces 1 GB temp file Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck)
- Re: query produces 1 GB temp file Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck)
- Re: query produces 1 GB temp file Christopher Kings-Lynne
- How can I make use of both CPUs in a dual processor machine Alex
- Re: How can I make use of both CPUs in a dual processor John A Meinel
- Re: How can I make use of both CPUs in a dual processor Alex
- Re: How can I make use of both CPUs in a dual processor Merlin Moncure
- Re: How can I make use of both CPUs in a dual processor John A Meinel
- Tell postgres which index to use? Silke Trissl
- Re: Tell postgres which index to use? Josh Berkus
- Re: Tell postgres which index to use? Silke Trissl
- Re: Tell postgres which index to use? John Arbash Meinel
- Re: Solaris 9 tuning Paul Johnson
- Re: GiST indexes and concurrency (tsearch2) Marinos J. Yannikos
- Re: Solaris 9 tuning Tom Arthurs
- Performance Tuning Chris Kratz
- Re: Performance Tuning John Arbash Meinel
- Re: Solaris 9 tuning Paul Johnson
- Re: Tell postgres which index to use? Greg Stark
- Re: Performance Tuning Greg Stark
- Re: Performance Tuning Chris Kratz
- annotated PostgreSQL.conf now up Josh Berkus
- Re: Performance Tuning Merlin Moncure
- Re: Solaris 9 tuning Tom Arthurs
- Re: Performance Tuning Chris Kratz
- Re: Performance Tuning Chris Kratz
- Re: Performance Tuning Chris Kratz
- Re: Performance Tuning PFC
- Re: GiST indexes and concurrency (tsearch2) Marinos J. Yannikos
- Re: GiST indexes and concurrency (tsearch2) Neil Conway
- Re: Performance Tuning Mike Rylander
- Re: How can I make use of both CPUs in a dual processor Iain
- Re: Performance Tuning PFC
- Re: Performance Tuning Christopher Browne
- Re: Performance Tuning Rod Taylor
- Re: Solaris 9 tuning Tom Arthurs
- Benchmark Jaime Casanova
- Re: How can I make use of both CPUs in a dual processor Alex
- Re: Benchmark Jeff
- Large time difference between explain analyze and normal run Chris Kratz
- Re: Large time difference between explain analyze and normal run Tom Lane
- Re: Large time difference between explain analyze and normal run Chris Kratz
- Re: Large time difference between explain analyze and normal run Darcy Buskermolen
- Re: Large time difference between explain analyze and normal run Chris Kratz
- Re: Benchmark Mitch Pirtle
- Re: Benchmark Tom Lane
- Re: Benchmark Mitch Pirtle
- Re: Benchmark Jaime Casanova
- How to interpret this explain analyse? Joost Kraaijeveld
- Re: How to interpret this explain analyse? Richard Huxton
- Re: Benchmark Bruno Wolff III
- Re: Benchmark Richard Huxton
- Re: Benchmark Jeff
- Re: Benchmark Greg Stark
- Re: How to interpret this explain analyse? Tom Lane
- Re: Benchmark Mike Benoit
- Re: Benchmark (slightly off topic but oh well) PFC
- Re: Benchmark PFC
- Re: Benchmark Tom Lane
- Re: How to interpret this explain analyse? Joost Kraaijeveld
- Re: How to interpret this explain analyse? Tom Lane
- Re: Benchmark Merlin Moncure
- Re: How to interpret this explain analyse? Joost Kraaijeveld
- Re: Benchmark Christopher Browne
- Re: Benchmark Ron Mayer
- Re: Benchmark Greg Stark
- Re: Benchmark Patrick Meylemans
- estimated rows vs. actual rows Jaime Casanova
- Re: estimated rows vs. actual rows Josh Berkus
- Re: estimated rows vs. actual rows Jaime Casanova
- Re: estimated rows vs. actual rows Tom Lane
- Re: estimated rows vs. actual rows Mark Kirkwood
- Autocommit Hasnul Fadhly bin Hasan
- Re: Autocommit Michael Fuhr
- Re: Autocommit Hasnul Fadhly bin Hasan
- Re: Autocommit Michael Fuhr
- Re: Benchmark Harald Fuchs
- Re: estimated rows vs. actual rows Christopher Browne
- String matching Ivan Voras
- Re: String matching PFC
- Re: String matching Ivan Voras
- Re: String matching Stephan Szabo
- Re: String matching Ivan Voras
- Re: String matching Stephan Szabo
- Re: String matching Ivan Voras
- Re: String matching Stephan Szabo
- seq scan cache vs. index cache smackdown Mark Aufflick
- Re: How to interpret this explain analyse? Kevin Brown
- VACCUM FULL ANALYZE PROBLEM Michael Ryan S. Puncia
- Re: VACCUM FULL ANALYZE PROBLEM Iain
- Re: VACCUM FULL ANALYZE PROBLEM Michael Ryan S. Puncia
- Re: VACCUM FULL ANALYZE PROBLEM Rod Taylor
- Re: VACCUM FULL ANALYZE PROBLEM Iain
- Re: seq scan cache vs. index cache smackdown Iain
- Re: seq scan cache vs. index cache smackdown Rod Taylor
- Re: VACCUM FULL ANALYZE PROBLEM Tom Lane
- Re: seq scan cache vs. index cache smackdown Christopher Browne
- Re: VACCUM FULL ANALYZE PROBLEM Iain
- Re: seq scan cache vs. index cache smackdown Iain
- Re: seq scan cache vs. index cache smackdown Greg Stark
- Re: seq scan cache vs. index cache smackdown Tom Lane
- Re: How to interpret this explain analyse? Greg Stark
- Re: seq scan cache vs. index cache smackdown Greg Stark
- Re: VACCUM FULL ANALYZE PROBLEM PFC
- Re: seq scan cache vs. index cache smackdown Merlin Moncure
- Re: How to interpret this explain analyse? Bricklen Anderson
- Re: seq scan cache vs. index cache smackdown Josh Berkus
- Re: seq scan cache vs. index cache smackdown Tom Lane
- Re: seq scan cache vs. index cache smackdown Merlin Moncure
- Re: seq scan cache vs. index cache smackdown Greg Stark
- Re: seq scan cache vs. index cache smackdown Magnus Hagander
- Re: seq scan cache vs. index cache smackdown Christopher Browne
- Re: seq scan cache vs. index cache smackdown PFC
- Re: seq scan cache vs. index cache smackdown Greg Stark
- disagreeing query planners lcham02
- Re: How to interpret this explain analyse? Kevin Brown
- Re: seq scan cache vs. index cache smackdown Ron Mayer
- PG proper configuation for a php forum JM
- VACUUM ANALYZE slows down query werner fraga
- Re: VACUUM ANALYZE slows down query John Arbash Meinel
- Re: VACUUM ANALYZE slows down query Tom Lane
- Effects of IDLE processes JM
- Degradation of postgres 7.4.5 on FreeBSD/CygWin Rodrigo Moreno
- Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin Steinar H. Gunderson
- Re: Effects of IDLE processes Tom Lane
- Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin Tom Lane
- Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin Steinar H. Gunderson
- RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin Rodrigo Moreno
- Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin Christopher Kings-Lynne
- Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin Christopher Kings-Lynne
- Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin Tom Lane
- Re: [HACKERS] win32 performance - fsync question Merlin Moncure
- RES: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin Rodrigo Moreno
- Re: PostgreSQL clustering VS MySQL clustering Gaetano Mendola
- Re: PostgreSQL clustering VS MySQL clustering Gaetano Mendola
- Re: seq scan cache vs. index cache smackdown Bruce Momjian
- RES: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin Rodrigo Moreno
- bad performances using hashjoin Gaetano Mendola
- Problem with 7.4.5 and webmin 1.8 in grant function amrit@health2.moph.go.th
- Re: seq scan cache vs. index cache smackdown Magnus Hagander
- Re: bad performances using hashjoin Tom Lane
- Re: Problem with 7.4.5 and webmin 1.8 in grant function Mark Kirkwood
- Re: bad performances using hashjoin Gaetano Mendola
- Re: Effects of IDLE processes Gaetano Mendola
- Re: bad performances using hashjoin Klint Gore
- Re: Problem with 7.4.5 and webmin 1.8 in grant function amrit@health2.moph.go.th
- Re: bad performances using hashjoin Tom Lane
- Re: bad performances using hashjoin David Brown
- Re: Effects of IDLE processes Christopher Browne
- Re: bad performances using hashjoin Tom Lane
- Re: bad performances using hashjoin Gaetano Mendola
- Re: Effects of IDLE processes Gaetano Mendola
- Re: seq scan cache vs. index cache smackdown Merlin Moncure
- Re: bad performances using hashjoin David Brown
- Re: seq scan cache vs. index cache smackdown Tom Lane
- Re: bad performances using hashjoin Mischa
- Re: Problem with 7.4.5 and webmin 1.8 in grant function Mark Kirkwood
- Re: Problem with 7.4.5 and webmin 1.8 in grant function Mark Kirkwood
- Re: seq scan cache vs. index cache smackdown Ron Mayer
- Re: Problem with 7.4.5 and webmin 1.8 in grant function amrit@health2.moph.go.th
- Re: Problem with 7.4.5 and webmin 1.8 in grant function Mark Kirkwood
- PostgreSQL is extremely slow on Windows Vig, Sandor (G/FI-2)
- Re: Problem with 7.4.5 and webmin 1.8 in grant function amrit@health2.moph.go.th
- Re: PostgreSQL is extremely slow on Windows Mitch Pirtle
- Re: PostgreSQL is extremely slow on Windows Magnus Hagander
- is pg_autovacuum so effective ? Gaetano Mendola
- Re: Problem with 7.4.5 and webmin 1.8 in grant function Mark Kirkwood
- Re: is pg_autovacuum so effective ? Matthew T. O'Connor
- Re: is pg_autovacuum so effective ? Tom Lane
- Re: VACUUM ANALYZE slows down query Tom Lane
- Re: is pg_autovacuum so effective ? Gaetano Mendola
- Re: is pg_autovacuum so effective ? Gaetano Mendola
- Re: PostgreSQL is extremely slow on Windows Neil Conway
- Re: is pg_autovacuum so effective ? Christopher Browne
- Re: is pg_autovacuum so effective ? Christopher Browne
- Joins, Deletes and Indexes Butkus_Charles@emc.com
- Inefficient Query Plans Luke Chambers
- PostgreSQL is extremely slow on Windows Vig, Sandor (G/FI-2)
- subquery vs join on 7.4.5 David Haas
- Help me please ! Asatryan, Anahit
- join vs. subquery David Haas
- Re: Help me please ! Richard Huxton
- Re: Joins, Deletes and Indexes Richard Huxton
- Re: PostgreSQL is extremely slow on Windows Vig, Sandor (G/FI-2)
- Re: Joins, Deletes and Indexes Butkus_Charles@emc.com
- Re: Joins, Deletes and Indexes Richard Huxton
- Re: PostgreSQL is extremely slow on Windows Markus Schaber
- Re: Help me please ! Markus Schaber
- Re: PostgreSQL is extremely slow on Windows Magnus Hagander
- Re: PostgreSQL is extremely slow on Windows Magnus Hagander
- Re: Problem with 7.4.5 and webmin 1.8 in grant function amrit@health2.moph.go.th
- Re: is pg_autovacuum so effective ? Gaetano Mendola
- Peformance Tuning Opterons/ Hard Disk Layout John Allgood
- Re: Inefficient Query Plans Tom Lane
- Re: subquery vs join on 7.4.5 Tom Lane
- Re: Problem with 7.4.5 and webmin 1.8 in grant function G u i d o B a r o s i o
- Re: Peformance Tuning Opterons/ Hard Disk Layout Michael Adler
- Re: Peformance Tuning Opterons/ Hard Disk Layout Bruno Almeida do Lago
- Re: Peformance Tuning Opterons/ Hard Disk Layout Rod Taylor
- Re: Peformance Tuning Opterons/ Hard Disk Layout Tom Lane
- Re: Peformance Tuning Opterons/ Hard Disk Layout Tom Lane
- Re: Peformance Tuning Opterons/ Hard Disk Layout John Allgood
- Re: is pg_autovacuum so effective ? Matthew T. O'Connor
- Re: Peformance Tuning Opterons/ Hard Disk Layout John Arbash Meinel
- Re: Peformance Tuning Opterons/ Hard Disk Layout Michael Adler
- Re: Peformance Tuning Opterons/ Hard Disk Layout John Allgood
- Re: Peformance Tuning Opterons/ Hard Disk Layout John Arbash Meinel
- Re: Problem with 7.4.5 and webmin 1.8 in grant function Mark Kirkwood
- Re: Peformance Tuning Opterons/ Hard Disk Layout John Allgood
- Re: Peformance Tuning Opterons/ Hard Disk Layout Josh Berkus
- Re: Peformance Tuning Opterons/ Hard Disk Layout John Arbash Meinel
- Re: PostgreSQL is extremely slow on Windows Neil Conway
- Re: PostgreSQL is extremely slow on Windows Tom Lane
- Re: Peformance Tuning Opterons/ Hard Disk Layout Christopher Browne
- Re: Peformance Tuning Opterons/ Hard Disk Layout Vig, Sandor (G/FI-2)
- Re: is pg_autovacuum so effective ? Gaetano Mendola
- Re: is pg_autovacuum so effective ? Markus Schaber
- Re: Peformance Tuning Opterons/ Hard Disk Layout Bruno Almeida do Lago
- Peformance Tuning Opterons/ Hard Disk Layout John Allgood
- Re: Peformance Tuning Opterons/ Hard Disk Layout Joel Fradkin
- Re: Peformance Tuning Opterons/ Hard Disk Layout John Arbash Meinel
- Re: PostgreSQL is extremely slow on Windows Bruce Momjian
- Re: PostgreSQL is extremely slow on Windows Greg Stark
- gah! sudden slowdown?? SpaceBallOne
- IS NULL vs IS NOT NULL Vig, Sandor (G/FI-2)
- Re: Peformance Tuning Opterons/ Hard Disk Layout Vig, Sandor (G/FI-2)
- Re: gah! sudden slowdown?? Steinar H. Gunderson
- Possible interesting extra information for explain analyze? Jeff
- Re: IS NULL vs IS NOT NULL Stephan Szabo
- Re: Possible interesting extra information for explain analyze? Tom Lane
- Re: Peformance Tuning Opterons/ Hard Disk Layout Jim C. Nasby
- Re: is pg_autovacuum so effective ? Markus Schaber
- PostgreSQL 7.4.3 Performance issues on OpenBSD Glenn Kusardi
- Re: is pg_autovacuum so effective ? Gaetano Mendola
- PG block sizes Tom Arthurs
- Re: is pg_autovacuum so effective ? Markus Schaber
- Re: is pg_autovacuum so effective ? Matthew T. O'Connor
- Re: Peformance Tuning Opterons/ Hard Disk Layout Markus Schaber
- Re: Possible interesting extra information for explain Simon Riggs
- Re: is pg_autovacuum so effective ? Bruno Wolff III