Mailing lists [pgsql-performance]
- Deleting millions of rows Brian Cox
- Re: Deleting millions of rows Robert Haas
- Re: Deleting millions of rows Jerry Champlin
- Re: Deleting millions of rows Brian Cox
- Re: Deleting millions of rows Robert Haas
- Re: Deleting millions of rows David Wilson
- Re: Deleting millions of rows Dave Dutcher
- Re: Deleting millions of rows Brian Cox
- Re: Deleting millions of rows David Wilson
- Re: Deleting millions of rows Scott Marlowe
- Re: Deleting millions of rows Tom Lane
- Re: Deleting millions of rows Brian Cox
- Re: Deleting millions of rows Scott Marlowe
- Re: Deleting millions of rows Robert Haas
- Re: SSD performance Jeff
- Re: Deleting millions of rows Alvaro Herrera
- Re: SSD performance David Rees
- Re: SSD performance Scott Carey
- Re: SSD performance Scott Marlowe
- Re: Deleting millions of rows Tom Lane
- Re: Deleting millions of rows Andrew Lazarus
- Re: Deleting millions of rows Robert Haas
- Getting error while running DBT2 test for PostgreSQL Rohan Pethkar
- Re: Deleting millions of rows Gregory Stark
- Re: SSD performance david@lang.hm
- Re: Deleting millions of rows Robert Haas
- Re: SSD performance Jeff
- suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Marlowe
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Gary Doades
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Arjen van der Meijden
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Marlowe
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller justin
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Matt Burke
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Glyn Astill
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Ivan Voras
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Matt Burke
- Number of occurrence of characters? Ivan Voras
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Gregory Stark
- Re: Number of occurrence of characters? hubert depesz lubaczewski
- Re: Number of occurrence of characters? Heikki Linnakangas
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Joshua D. Drake
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey
- bitmap heap scan recheck on full text search with gin index Hal Roberts
- Re: bitmap heap scan recheck on full text search with gin index Oleg Bartunov
- Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong
- Re: dbt-2 tuning results with postgresql-8.3.5 Greg Smith
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Matt Burke
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Matt Burke
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Marlowe
- Re: Number of occurrence of characters? Ivan Voras
- Can't locate Test/Parser/Dbt2.pm in DBT2 tests Rohan Pethkar
- Re: Can't locate Test/Parser/Dbt2.pm in DBT2 tests Richard Huxton
- Re: Number of occurrence of characters? Grzegorz Jaśkiewicz
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Bruce Momjian
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Glyn Astill
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Matt Burke
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Bruce Momjian
- Postgres not willing to use an index? Mario Splivalo
- Re: Postgres not willing to use an index? Grzegorz Jaśkiewicz
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller justin
- Re: Postgres not willing to use an index? Tom Lane
- Re: Postgres not willing to use an index? Robert Haas
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Marlowe
- Re: Postgres not willing to use an index? Kevin Grittner
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Arjen van der Meijden
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey
- inheritance, and plans Grzegorz Jaśkiewicz
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Arjen van der Meijden
- Re: Postgres not willing to use an index? Robert Haas
- Re: inheritance, and plans Robert Haas
- Re: inheritance, and plans Grzegorz Jaśkiewicz
- Re: inheritance, and plans Grzegorz Jaśkiewicz
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Greg Smith
- Re: inheritance, and plans Tom Lane
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey
- explanation of some configs Thomas Finneid
- Re: explanation of some configs Joshua D. Drake
- Re: Getting error while running DBT2 test for PostgreSQL Mark Wong
- Re: Can't locate Test/Parser/Dbt2.pm in DBT2 tests Mark Wong
- Re: explanation of some configs Thomas Finneid
- Re: inheritance, and plans Grzegorz Jaśkiewicz
- Re: inheritance, and plans Grzegorz Jaśkiewicz
- Re: explanation of some configs justin
- Re: explanation of some configs Robert Haas
- Re: inheritance, and plans Grzegorz Jaśkiewicz
- Re: inheritance, and plans Tom Lane
- Re: inheritance, and plans Grzegorz Jaśkiewicz
- Re: inheritance, and plans Grzegorz Jaśkiewicz
- Re: inheritance, and plans Andrew Gierth
- Re: inheritance, and plans Tom Lane
- Re: inheritance, and plans Andrew Gierth
- Re: inheritance, and plans Grzegorz Jaśkiewicz
- Re: Postgres not willing to use an index? Mario Splivalo
- Re: Postgres not willing to use an index? Mario Splivalo
- Re: Postgres not willing to use an index? Mario Splivalo
- Re: explanation of some configs Matthew Wakeling
- Re: explanation of some configs justin
- Re: explanation of some configs Robert Haas
- query slow only after reboot Wei Yan
- Re: query slow only after reboot Steve Crawford
- Re: query slow only after reboot Scott Carey
- query becomes fas on 'SET enable_hashjoin TO off;' Rajesh Kumar Mallah
- Re: explanation of some configs Matthew Wakeling
- ERROR: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/site_perl/5.8.8/Test/Parser/Dbt2.pm line 521. Rohan Pethkar
- Re: query becomes fas on 'SET enable_hashjoin TO off;' Robert Haas
- Re: query becomes fas on 'SET enable_hashjoin TO off;' Rajesh Kumar Mallah
- Re: ERROR: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/site_perl/5.8.8/Test/Parser/Dbt2.pm line 521. Rajesh Kumar Mallah
- Re: query slow only after reboot Kevin Grittner
- Re: query becomes fas on 'SET enable_hashjoin TO off;' Tom Lane
- Re: query becomes fas on 'SET enable_hashjoin TO off;' Rajesh Kumar Mallah
- Re: explanation of some configs justin
- Re: explanation of some configs Greg Smith
- Re: explanation of some configs justin
- Re: explanation of some configs Greg Smith
- Re: explanation of some configs justin
- View performance degraded between 8.1 and 8.3 Mark Roghelia
- Re: View performance degraded between 8.1 and 8.3 Tom Lane
- please help with the explain analyze plan Rajesh Kumar Mallah
- Re: please help with the explain analyze plan Glyn Astill
- Re: please help with the explain analyze plan Rajesh Kumar Mallah
- Re: please help with the explain analyze plan Rajesh Kumar Mallah
- scheduling autovacuum at lean hours only. Rajesh Kumar Mallah
- Re: scheduling autovacuum at lean hours only. Glyn Astill
- Re: scheduling autovacuum at lean hours only. Guillaume Cottenceau
- Re: scheduling autovacuum at lean hours only. Rajesh Kumar Mallah
- Re: scheduling autovacuum at lean hours only. Alvaro Herrera
- Re: scheduling autovacuum at lean hours only. Grzegorz Jaśkiewicz
- Re: scheduling autovacuum at lean hours only. Ben
- Re: scheduling autovacuum at lean hours only. Scott Carey
- Re: scheduling autovacuum at lean hours only. Rajesh Kumar Mallah
- Re: scheduling autovacuum at lean hours only. Ben Chobot
- Re: scheduling autovacuum at lean hours only. Brad Nicholson
- Re: scheduling autovacuum at lean hours only. Rajesh Kumar Mallah
- Re: scheduling autovacuum at lean hours only. Guillaume Cottenceau
- col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%' milos d
- Re: col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%' Richard Huxton
- Re: col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%' Scott Carey
- GIST versus GIN indexes for intarrays Rusty Conover
- Re: GIST versus GIN indexes for intarrays Tom Lane
- Re: GIST versus GIN indexes for intarrays Rusty Conover
- Re: GIST versus GIN indexes for intarrays Tom Lane
- Re: col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%' milos d
- Re: GIST versus GIN indexes for intarrays Rusty Conover
- I/O increase after upgrading to 8.3.5 Alexander Staubo
- dissimilar drives in Raid10 , does it make difference ? Rajesh Kumar Mallah
- Re: [HACKERS] GIST versus GIN indexes for intarrays Kenneth Marshall
- Re: dissimilar drives in Raid10 , does it make difference ? Matthew Wakeling
- Re: I/O increase after upgrading to 8.3.5 Kevin Grittner
- Re: I/O increase after upgrading to 8.3.5 Alexander Staubo
- Re: I/O increase after upgrading to 8.3.5 Alexander Staubo
- Re: I/O increase after upgrading to 8.3.5 Kevin Grittner
- Re: I/O increase after upgrading to 8.3.5 Alexander Staubo
- Re: [HACKERS] GIST versus GIN indexes for intarrays Tom Lane
- Re: I/O increase after upgrading to 8.3.5 Kevin Grittner
- Re: dissimilar drives in Raid10 , does it make difference ? Craig Ringer
- Re: I/O increase after upgrading to 8.3.5 Craig Ringer
- Re: scheduling autovacuum at lean hours only. Chris Browne
- Re: scheduling autovacuum at lean hours only. Rajesh Kumar Mallah
- Retrieving data from PostgreSQL to .NET application – performance test – surprising results Peter G.
- Slow queries from information schema Octavio Alvarez
- Re: I/O increase after upgrading to 8.3.5 Alexander Staubo
- Re: I/O increase after upgrading to 8.3.5 Alexander Staubo
- Re: I/O increase after upgrading to 8.3.5 Tom Lane
- Re: Slow queries from information schema Tom Lane
- Re: I/O increase after upgrading to 8.3.5 Alexander Staubo
- Re: Slow queries from information schema Octavio Alvarez
- Bad plan for nested loop + limit Alexander Staubo
- Re: Bad plan for nested loop + limit David Wilson
- Re: Bad plan for nested loop + limit Alexander Staubo
- Re: I/O increase after upgrading to 8.3.5 Greg Smith
- Re: I/O increase after upgrading to 8.3.5 Greg Smith
- Partial index usage Laszlo Nagy
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Gregory Stark
- Re: I/O increase after upgrading to 8.3.5 Alexander Staubo
- Re: Partial index usage Craig Ringer
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah
- TCP network cost Ross J. Reedstrom
- Re: TCP network cost Rusty Conover
- Re: TCP network cost david@lang.hm
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Matthew Wakeling
- Query composite index range in an efficient way Havasvölgyi Ottó
- Re: Query composite index range in an efficient way Matthew Wakeling
- Re: Query composite index range in an efficient way Gregory Stark
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah
- Cannot interpret EXPLAIN Jörg Kiegeland
- Re: Query composite index range in an efficient way Tom Lane
- Re: Query composite index range in an efficient way Kevin Grittner
- Call of function inside trigger much slower than explicit function call Alexander Gorban
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey
- Re: Call of function inside trigger much slower than explicit function call Robert Haas
- Re: Call of function inside trigger much slower than explicit function call Alexander Gorban
- Re: TCP network cost Aaron Turner
- Re: Query composite index range in an efficient way Havasvölgyi Ottó
- Re: Call of function inside trigger much slower than explicit function call Robert Haas
- Re: TCP network cost Ross J. Reedstrom
- Re: TCP network cost Rusty Conover
- Re: TCP network cost Ross J. Reedstrom
- Re: TCP network cost Ross J. Reedstrom
- Re: TCP network cost Aaron Turner
- Re: Call of function inside trigger much slower than explicit function call ivo nascimento
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Marlowe
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Marlowe
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Grzegorz Jaśkiewicz
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah
- Re: Call of function inside trigger much slower than explicit function call Alexander Gorban
- Re: TCP network cost Gregory Stark
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Grzegorz Jaśkiewicz
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah
- not in(subselect) in 8.4 Grzegorz Jaśkiewicz
- Re: not in(subselect) in 8.4 Grzegorz Jaśkiewicz
- Re: not in(subselect) in 8.4 marcin mank
- Re: SSD performance Matthew Wakeling
- Re: not in(subselect) in 8.4 Tom Lane
- Re: not in(subselect) in 8.4 Grzegorz Jaśkiewicz
- Benchmark comparing PostgreSQL, MySQL and Oracle Sergio Lopez
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Alan Hodgson
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Sergio Lopez
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Jonah H. Harris
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Sergio Lopez
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Robert Haas
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Jonah H. Harris
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Jonah H. Harris
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Jonah H. Harris
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Merlin Moncure
- postgreSQL performance 8.2.6 vs 8.3.3 Battle Mage
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Jonah H. Harris
- Re: postgreSQL performance 8.2.6 vs 8.3.3 Kenneth Marshall
- Re: postgreSQL performance 8.2.6 vs 8.3.3 David Rees
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Robert Haas
- Re: postgreSQL performance 8.2.6 vs 8.3.3 Scott Marlowe
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Scott Marlowe
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Mark Kirkwood
- Re: not in(subselect) in 8.4 Rodrigo E. De León Plicet
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Sergio Lopez
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Sergio Lopez
- how the hdd read speed is related to the query execution speed. sathiya psql
- Re: how the hdd read speed is related to the query execution speed. Andreas Kretschmer
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Denis Lussier
- Re: not in(subselect) in 8.4 Grzegorz Jaśkiewicz
- Re: Partial index usage decibel
- Re: not in(subselect) in 8.4 Tom Lane
- Re: not in(subselect) in 8.4 Grzegorz Jaśkiewicz
- Re: not in(subselect) in 8.4 Tom Lane
- Re: not in(subselect) in 8.4 Scott Carey
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Jonah H. Harris
- Re: not in(subselect) in 8.4 Tom Lane
- Re: not in(subselect) in 8.4 Robert Haas
- Re: not in(subselect) in 8.4 Grzegorz Jaśkiewicz
- Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong
- LIMIT confuses the planner Kouber Saparev
- Re: LIMIT confuses the planner Richard Huxton
- Re: LIMIT confuses the planner Robert Haas
- Re: LIMIT confuses the planner Tom Lane
- Re: LIMIT confuses the planner Kouber Saparev
- Re: LIMIT confuses the planner Tom Lane
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Sergio Lopez
- Re: LIMIT confuses the planner Kouber Saparev
- Re: TCP network cost Ross J. Reedstrom
- Re: TCP network cost Ross J. Reedstrom
- Re: postgreSQL performance 8.2.6 vs 8.3.3 david@lang.hm
- Re: TCP network cost Tom Lane
- Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Gregory Stark
- Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Guillaume Smet
- Re: postgreSQL performance 8.2.6 vs 8.3.3 Scott Marlowe
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe
- Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe
- Re: Abnormal performance difference between Postgres and MySQL Tom Lane
- Re: Abnormal performance difference between Postgres and MySQL Tom Lane
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Claus Guttesen
- planner's midjudge number of rows resulting, despite pretty obvious join Grzegorz Jaśkiewicz
- Re: planner's midjudge number of rows resulting, despite pretty obvious join Pavel Stehule
- will 8.4 be able to optmize rank() windows ? Grzegorz Jaśkiewicz
- Re: TCP network cost Ross J. Reedstrom
- Re: LIMIT confuses the planner Kouber Saparev
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Claus Guttesen
- Re: Abnormal performance difference between Postgres and MySQL Robert Haas
- full text search - dictionary caching Tomasz Myrta
- PostgreSQL block size for SSD RAID setup? henk de wit
- Re: PostgreSQL block size for SSD RAID setup? Gregory Stark
- Re: PostgreSQL block size for SSD RAID setup? henk de wit
- Re: full text search - dictionary caching Tom Lane
- Re: PostgreSQL block size for SSD RAID setup? PFC
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Robert Haas
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: PostgreSQL block size for SSD RAID setup? Scott Carey
- Re: Abnormal performance difference between Postgres and MySQL Robert Haas
- Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle Rodrigo E. De León Plicet
- Re: Abnormal performance difference between Postgres and MySQL Robert Haas
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe
- Re: Abnormal performance difference between Postgres and MySQL Robert Haas
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Claus Guttesen
- Re: Abnormal performance difference between Postgres and MySQL Robert Haas
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Akos Gabriel
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Kevin Grittner
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Kevin Grittner
- Re: Abnormal performance difference between Postgres and MySQL Scott Carey
- Re: Abnormal performance difference between Postgres and MySQL Robert Haas
- Re: Abnormal performance difference between Postgres and MySQL Claus Guttesen
- Re: Abnormal performance difference between Postgres and MySQL Akos Gabriel
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL Kevin Grittner
- Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe
- Re: Abnormal performance difference between Postgres and MySQL Steve Clark
- Re: Bad plan for nested loop + limit Alexander Staubo
- Re: Bad plan for nested loop + limit Robert Haas
- Re: Bad plan for nested loop + limit Alexander Staubo