Mailing lists [pgsql-performance]
- Re: encourging bitmap AND Jim Nasby
- Re: CPU bound Jim Nasby
- Re: How to turn autovacuum prevent wrap around run faster? marc.hsiao
- Re: CPU bound Mladen Gogala
- Question: BlockSize > 8192 with FusionIO Strange, John W
- Re: Question: BlockSize > 8192 with FusionIO Greg Smith
- Re: Performance of PostgreSQL over NFS Greg Smith
- Re: adding foreign key constraint locks up table Florian Weimer
- Re: concurrent IO in postgres? Greg Smith
- Re: PostgreSQL Greg Smith
- Re: adding foreign key constraint locks up table Tom Lane
- Re: Question: BlockSize > 8192 with FusionIO Merlin Moncure
- Same stament sometime fast, something slow Fernando Mertins
- Re: Same stament sometime fast, something slow Kevin Grittner
- Re: Question: BlockSize > 8192 with FusionIO Ben Chobot
- Re: Question: BlockSize > 8192 with FusionIO Strange, John W
- Re: Question: BlockSize > 8192 with FusionIO Strange, John W
- Re: Same stament sometime fast, something slow Craig Ringer
- Re: Same stament sometime fast, something slow Greg Smith
- Re: Question: BlockSize > 8192 with FusionIO Scott Carey
- Wrong docs on wal_buffers? Josh Berkus
- Re: Wrong docs on wal_buffers? Jeff Janes
- plan question - query with order by and limit not choosing index depends on size of limit, table Mike Broers
- Re: Wrong docs on wal_buffers? Pierre C
- Re: plan question - query with order by and limit not choosing index depends on size of limit, table Kevin Grittner
- Re: Wrong docs on wal_buffers? Josh Berkus
- Re: postgres performance tunning Robert Haas
- Re: plan question - query with order by and limit not choosing index depends on size of limit, table Mike Broers
- Re: postgres performance tunning Scott Marlowe
- Re: postgres performance tunning Scott Marlowe
- Re: Wrong docs on wal_buffers? Scott Carey
- Re: Wrong docs on wal_buffers? Jeff Janes
- "SELECT .. WHERE NOT IN" query running for hours Γιωργος Βαλκανας
- Re: "SELECT .. WHERE NOT IN" query running for hours Mladen Gogala
- Re: Wrong docs on wal_buffers? Greg Smith
- Re: How to turn autovacuum prevent wrap around run faster? marc.hsiao
- Re: adding foreign key constraint locks up table kakarukeys
- Re: Major performance problem after upgrade from 8.3 to 8.4 Marc Antonio
- Re: How to turn autovacuum prevent wrap around run faster? marc47marc47
- Re: "SELECT .. WHERE NOT IN" query running for hours Γιωργος Βαλκανας
- Wrong docs on checkpoint_segments? Florian Weimer
- Re: Wrong docs on checkpoint_segments? Andres Freund
- Re: Wrong docs on checkpoint_segments? Florian Weimer
- Re: Wrong docs on checkpoint_segments? Andres Freund
- Re: plan question - query with order by and limit not choosing index depends on size of limit, table pasman pasmański
- Re: Wrong docs on wal_buffers? Samuel Gendler
- Re: Wrong docs on wal_buffers? Tom Lane
- Re: Wrong docs on wal_buffers? Samuel Gendler
- Re: Wrong docs on wal_buffers? Greg Smith
- pgbench to the MAXINT Greg Smith
- Re: adding foreign key constraint locks up table Robert Haas
- Re: MySQL HandlerSocket - Is this possible in PG? Dimitri Fontaine
- Re: pgbench to the MAXINT Euler Taveira de Oliveira
- Re: pgbench to the MAXINT Greg Smith
- Re: plan question - query with order by and limit not choosing index depends on size of limit, table Mike Broers
- Re: "SELECT .. WHERE NOT IN" query running for hours Mladen Gogala
- Re: "SELECT .. WHERE NOT IN" query running for hours Scott Carey
- Re: "SELECT .. WHERE NOT IN" query running for hours Kevin Grittner
- Re: "SELECT .. WHERE NOT IN" query running for hours Scott Carey
- Re: Problems with FTS Rauan Maemirov
- Re: pgbench to the MAXINT Euler Taveira de Oliveira
- Re: Performance of PostgreSQL over NFS Jignesh Shah
- Performance test of Oracle and PostgreSQL using same binary Divakar Singh
- Re: How to turn autovacuum prevent wrap around run faster? marc.hsiao
- Slow query + why bitmap index scan?? Laszlo Nagy
- Re: Slow query + why bitmap index scan?? Florian Weimer
- The good, old times Mladen Gogala
- Re: The good, old times Guillaume Cottenceau
- Re: Slow query + why bitmap index scan?? Laszlo Nagy
- Re: Slow query + why bitmap index scan?? Kenneth Marshall
- Re: Slow query + why bitmap index scan?? Kevin Grittner
- Re: Slow query + why bitmap index scan?? Laszlo Nagy
- Re: Slow query + why bitmap index scan?? Kevin Grittner
- Re: Performance test of Oracle and PostgreSQL using same binary Jeff Janes
- Re: Slow query + why bitmap index scan?? Cédric Villemain
- queries with lots of UNIONed relations Jon Nelson
- Re: queries with lots of UNIONed relations Tom Lane
- Re: queries with lots of UNIONed relations Jon Nelson
- Re: queries with lots of UNIONed relations Tom Lane
- Re: queries with lots of UNIONed relations Jon Nelson
- queries with lots of UNIONed relations Jon Nelson
- Re: adding foreign key constraint locks up table kakarukeys
- Re: queries with lots of UNIONed relations Robert Haas
- Re: queries with lots of UNIONed relations Tom Lane
- Re: queries with lots of UNIONed relations Robert Haas
- Re: queries with lots of UNIONed relations Robert Haas
- Re: queries with lots of UNIONed relations Andy Colson
- Re: queries with lots of UNIONed relations Robert Haas
- Re: queries with lots of UNIONed relations Andy Colson
- Re: queries with lots of UNIONed relations Jon Nelson
- Re: queries with lots of UNIONed relations Tom Lane
- Re: queries with lots of UNIONed relations Tom Lane
- Re: queries with lots of UNIONed relations Jon Nelson
- Re: queries with lots of UNIONed relations Tom Lane
- Re: queries with lots of UNIONed relations Mladen Gogala
- Re: The good, old times Craig Ringer
- Re: queries with lots of UNIONed relations Vitalii Tymchyshyn
- Re: plan question - query with order by and limit not choosing index depends on size of limit, table Mike Broers
- Re: The good, old times Mladen Gogala
- Re: plan question - query with order by and limit not choosing index depends on size of limit, table Robert Haas
- Re: "SELECT .. WHERE NOT IN" query running for hours Robert Haas
- Re: Problems with FTS Robert Haas
- "COPY TO stdout" statements occurrence in log files Fernando Mertins
- Re: queries with lots of UNIONed relations Jon Nelson
- Re: "COPY TO stdout" statements occurrence in log files Maciek Sakrejda
- Best way to get the latest revision from a table Nikolas Everett
- Re: "COPY TO stdout" statements occurrence in log files Chris Browne
- Re: Best way to get the latest revision from a table Kevin Grittner
- Re: Best way to get the latest revision from a table Nikolas Everett
- Re: "COPY TO stdout" statements occurrence in log files Marti Raudsepp
- Re: Best way to get the latest revision from a table Kevin Grittner
- Re: Best way to get the latest revision from a table Shaun Thomas
- Re: Best way to get the latest revision from a table Kevin Grittner
- Re: Best way to get the latest revision from a table Tom Lane
- Re: Best way to get the latest revision from a table Kevin Grittner
- Re: Best way to get the latest revision from a table Nikolas Everett
- Re: The good, old times Craig Ringer
- Problem with query Barbara Woolums
- Re: queries with lots of UNIONed relations Jon Nelson
- Re: Best way to get the latest revision from a table Shaun Thomas
- Re: Best way to get the latest revision from a table Shaun Thomas
- Re: The good, old times Craig Ringer
- Possible to improve query plan? Jeremy Palmer
- Re: Possible to improve query plan? Andy Colson
- Possible to improve query plan? Jeremy Palmer
- Re: Possible to improve query plan? Andy Colson
- Re: Possible to improve query plan? Jeremy Palmer
- Re: Possible to improve query plan? Jayadevan M
- Re: Possible to improve query plan? Ing. Marcos Ortiz Valmaseda
- "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Ing. Marcos Ortiz Valmaseda
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala
- Re: Possible to improve query plan? Kevin Grittner
- Bad plan when join on function Zotov
- Re: Bad plan when join on function Pavel Stehule
- Re: Possible to improve query plan? Tom Lane
- Re: Bad plan when join on function Kevin Grittner
- Re: Possible to improve query plan? Jeremy Palmer
- Re: Possible to improve query plan? Jeremy Palmer
- Re: Bad plan when join on function Pavel Stehule
- Re: Bad plan when join on function Tom Lane
- Re: Bad plan when join on function Pavel Stehule
- Re: Possible to improve query plan? Mladen Gogala
- Re: Problem with query Fernando Hevia
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios
- Re: The good, old times Devrim GÜNDÜZ
- Re: The good, old times Dave Page
- Re: Bad plan when join on function Shaun Thomas
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala
- Migrating to Postgresql and new hardware Lars
- Re: hashed subplan 5000x slower than two sequential operations masterchief
- Re: Migrating to Postgresql and new hardware Andy Colson
- Re: Migrating to Postgresql and new hardware Andy Colson
- Re: hashed subplan 5000x slower than two sequential operations Віталій Тимчишин
- Re: Migrating to Postgresql and new hardware Strange, John W
- Re: Migrating to Postgresql and new hardware Mark Felder
- Re: Migrating to Postgresql and new hardware mark
- Re: Migrating to Postgresql and new hardware Craig Ringer
- Re: Migrating to Postgresql and new hardware Scott Marlowe
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios
- Re: Migrating to Postgresql and new hardware Lars
- Re: Migrating to Postgresql and new hardware Lars
- Re: Migrating to Postgresql and new hardware Lars
- the XID question Charles.Hou
- Re: the XID question Charles.Hou
- Re: the XID question Filip Rembiałkowski
- Re: the XID question Kevin Grittner
- Re: Running PostgreSQL as fast as possible no matter the consequences Bruce Momjian
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Tom Lane
- Re: Running PostgreSQL as fast as possible no matter the consequences Fabrízio de Royes Mello
- Re: the XID question Chris Browne
- Re: the XID question Andres Freund
- Re: the XID question Kevin Grittner
- Re: anti-join chosen even when slower than old plan Bruce Momjian
- Re: anti-join chosen even when slower than old plan Bruce Momjian
- Re: anti-join chosen even when slower than old plan Bruce Momjian
- Re: the XID question Greg Smith
- Re: Migrating to Postgresql and new hardware Craig Ringer
- Re: the XID question Charles.Hou
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios
- Re: anti-join chosen even when slower than old plan Cédric Villemain
- Re: anti-join chosen even when slower than old plan Robert Haas
- Re: Migrating to Postgresql and new hardware Andy Colson
- Re: the XID question Charles.Hou
- Re: Running PostgreSQL as fast as possible no matter the consequences Robert Haas
- Re: Migrating to Postgresql and new hardware Scott Marlowe
- Re: anti-join chosen even when slower than old plan Cédric Villemain
- Re: anti-join chosen even when slower than old plan Cédric Villemain
- Re: the XID question Kevin Grittner
- copy command and blobs Madhu Ramachandran
- Re: copy command and blobs Mladen Gogala
- Re: copy command and blobs Tom Lane
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Robert Haas
- Re: Best way to get the latest revision from a table Robert Haas
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala
- Re: the XID question Robert Haas
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Robert Haas
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala
- Fun little performance IMPROVEMENT... grant@amadensor.com
- Re: Fun little performance IMPROVEMENT... Andy Colson
- Re: Best way to get the latest revision from a table Nikolas Everett
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Tom Lane
- Re: Fun little performance IMPROVEMENT... Tom Lane
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Kevin Grittner
- Re: Fun little performance IMPROVEMENT... Greg Smith
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Tom Lane
- Re: Fun little performance IMPROVEMENT... grant@amadensor.com
- Re: Fun little performance IMPROVEMENT... grant@amadensor.com
- Re: Fun little performance IMPROVEMENT... Scott Carey
- Re: Fun little performance IMPROVEMENT... grant@amadensor.com
- Re: Fun little performance IMPROVEMENT... grant@amadensor.com
- Re: copy command and blobs Madhu Ramachandran
- Re: copy command and blobs Robert Haas
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios
- Re: Possible to improve query plan? Robert Haas
- Re: Possible to improve query plan? Kevin Grittner
- Re: Possible to improve query plan? Tom Lane
- Re: Possible to improve query plan? Tom Lane
- Re: Possible to improve query plan? Kevin Grittner
- How to use indexes for GROUP BY Dimi Paun
- Re: How to use indexes for GROUP BY Shaun Thomas
- Re: How to use indexes for GROUP BY Scott Marlowe
- Re: How to use indexes for GROUP BY hubert depesz lubaczewski
- Re: Possible to improve query plan? Jeremy Palmer
- Re: Possible to improve query plan? Kevin Grittner
- Re: Possible to improve query plan? Kevin Grittner
- Re: Possible to improve query plan? Jeremy Palmer
- Bloat issue on 8.3; autovac ignores HOT page splits? Josh Berkus
- Re: How to use indexes for GROUP BY Dimi Paun
- Re: Possible to improve query plan? Cédric Villemain
- Re: Fun little performance IMPROVEMENT... Ivan Voras
- Re: Bloat issue on 8.3; autovac ignores HOT page splits? Robert Haas
- Re: Bloat issue on 8.3; autovac ignores HOT page splits? Josh Berkus
- Re: Bloat issue on 8.3; autovac ignores HOT page splits? Mark Kirkwood
- Queries becoming slow under heavy load Anne Rosset
- Re: Queries becoming slow under heavy load Andy Colson
- Re: Queries becoming slow under heavy load Kevin Grittner
- Re: Queries becoming slow under heavy load Ing. Marcos Ortiz Valmaseda
- Re: Running PostgreSQL as fast as possible no matter the consequences Bruce Momjian
- Re: Queries becoming slow under heavy load Ivan Voras
- FW: Queries becoming slow under heavy load Anne Rosset
- Re: FW: Queries becoming slow under heavy load Shaun Thomas
- Real vs Int performance David Greco
- Re: Real vs Int performance Kevin Grittner
- Re: Real vs Int performance Tom Lane
- Re: anti-join chosen even when slower than old plan Bruce Momjian
- Re: Queries becoming slow under heavy load mark
- Re: FW: Queries becoming slow under heavy load Scott Marlowe
- Re: FW: Queries becoming slow under heavy load Scott Marlowe
- High load, Michael Kohl
- Re: High load, Cédric Villemain
- Re: High load, Michael Kohl
- Re: High load, Cédric Villemain
- Why I lost the last pg_xlog file? Waldomiro
- Re: High load, Andres Freund
- Re: High load, Michael Kohl
- Re: High load, Cédric Villemain
- Re: High load, Andres Freund
- Re: High load, Justin Pitts
- Re: Real vs Int performance David Greco
- Re: Why I lost the last pg_xlog file? Shaun Thomas
- Re: Real vs Int performance Tom Lane
- Re: Real vs Int performance Shaun Thomas
- Re: Why I lost the last pg_xlog file? Kevin Grittner
- Re: High load, Andy Colson
- Re: High load, Michael Kohl
- Re: Real vs Int performance Mladen Gogala
- Postgres 9.0 has a bias against indexes Mladen Gogala
- Re: Postgres 9.0 has a bias against indexes Kenneth Marshall
- Re: Postgres 9.0 has a bias against indexes Kevin Grittner
- Re: Postgres 9.0 has a bias against indexes J Sisson
- Re: Postgres 9.0 has a bias against indexes Mladen Gogala
- Re: Postgres 9.0 has a bias against indexes Mladen Gogala
- Re: Postgres 9.0 has a bias against indexes David Wilson
- Re: Real vs Int performance Igor Neyman
- Re: Postgres 9.0 has a bias against indexes Tom Lane
- Re: Running PostgreSQL as fast as possible no matter the consequences Jeff Janes
- Re: Postgres 9.0 has a bias against indexes Mladen Gogala
- Re: High load, Scott Marlowe
- Re: Running PostgreSQL as fast as possible no matter the consequences Bruce Momjian
- Re: High load, Andy Colson
- Re: High load, Stephen Frost
- Re: High load, Scott Marlowe
- Re: High load, Scott Marlowe
- Re: High load, Andres Freund
- Re: pgbench - tps for Postgresql-9.0.2 is more than tps for Postgresql-8.4.1 DM
- Re: Postgres 9.0 has a bias against indexes Igor Neyman
- Re: High load, Ing. Marcos Ortiz Valmaseda
- Re: Postgres 9.0 has a bias against indexes Mladen Gogala
- Re: Postgres 9.0 has a bias against indexes Scott Marlowe
- Re: Postgres 9.0 has a bias against indexes Mladen Gogala
- Re: Postgres 9.0 has a bias against indexes Scott Marlowe
- Re: Postgres 9.0 has a bias against indexes Igor Neyman
- Re: Postgres 9.0 has a bias against indexes Scott Marlowe
- Re: Postgres 9.0 has a bias against indexes Igor Neyman
- Re: Postgres 9.0 has a bias against indexes Kenneth Marshall
- Re: Postgres 9.0 has a bias against indexes Scott Marlowe
- Re: Postgres 9.0 has a bias against indexes Mladen Gogala
- Re: Postgres 9.0 has a bias against indexes Igor Neyman
- Re: Postgres 9.0 has a bias against indexes Scott Marlowe
- Re: Postgres 9.0 has a bias against indexes Mladen Gogala
- Re: Postgres 9.0 has a bias against indexes Kevin Grittner
- How to best use 32 15k.7 300GB drives? Robert Schnabel
- Re: How to best use 32 15k.7 300GB drives? david@lang.hm
- Re: How to best use 32 15k.7 300GB drives? Alan Hodgson
- Re: How to best use 32 15k.7 300GB drives? Robert Schnabel
- Re: How to best use 32 15k.7 300GB drives? david@lang.hm
- Re: FW: Queries becoming slow under heavy load Anne Rosset
- Re: High load, Michael Kohl
- Re: How to best use 32 15k.7 300GB drives? Stephen Frost
- Re: High load, Mladen Gogala
- Re: How to best use 32 15k.7 300GB drives? Grant Johnson
- Re: High load, Ivan Voras
- Re: FW: Queries becoming slow under heavy load Shaun Thomas
- Re: How to best use 32 15k.7 300GB drives? Robert Schnabel
- Re: How to best use 32 15k.7 300GB drives? Scott Marlowe
- Re: How to best use 32 15k.7 300GB drives? Robert Schnabel
- Re: How to best use 32 15k.7 300GB drives? Stephen Frost
- Re: How to best use 32 15k.7 300GB drives? Stephen Frost
- Re: How to best use 32 15k.7 300GB drives? Scott Carey
- Re: How to best use 32 15k.7 300GB drives? Scott Carey
- Re: How to best use 32 15k.7 300GB drives? Scott Carey
- Re: FW: Queries becoming slow under heavy load Mladen Gogala
- Re: How to best use 32 15k.7 300GB drives? Scott Marlowe
- postgres 9 query performance yazan suleiman
- Re: postgres 9 query performance Scott Marlowe
- Re: postgres 9 query performance Kenneth Marshall
- Re: postgres 9 query performance Andres Freund
- Re: How to best use 32 15k.7 300GB drives? Robert Schnabel
- Re: How to best use 32 15k.7 300GB drives? Robert Schnabel
- Re: Migrating to Postgresql and new hardware Greg Smith
- Re: postgres 9 query performance yazan suleiman
- Re: postgres 9 query performance yazan suleiman
- Re: How to best use 32 15k.7 300GB drives? Віталій Тимчишин
- Re: pgbench - tps for Postgresql-9.0.2 is more than tps for Postgresql-8.4.1 Robert Haas
- Any experience using "shake" defragmenter? Mladen Gogala
- Re: Any experience using "shake" defragmenter? Mark Felder
- Re: postgres 9 query performance Tom Lane
- Re: Any experience using "shake" defragmenter? Marcin Mirosław
- Re: postgres 9 query performance Andres Freund
- Re: Any experience using "shake" defragmenter? Mladen Gogala
- Re: Any experience using "shake" defragmenter? Mladen Gogala
- Re: Any experience using "shake" defragmenter? Florian Weimer
- Re: Any experience using "shake" defragmenter? Florian Weimer
- Re: Bloat issue on 8.3; autovac ignores HOT new pages? Josh Berkus
- Re: Migrating to Postgresql and new hardware Lars
- Re: Any experience using "shake" defragmenter? Lew
- Re: Bloat issue on 8.3; autovac ignores HOT new pages? Mark Kirkwood
- Re: Bloat issue on 8.3; autovac ignores HOT new pages? Scott Marlowe
- Configuration for a new server. Benjamin Krajmalnik