Архив рассылок [pgsql-performance]
- Re: SELECT is slow on smaller table? Ao Jianwang
- Processing of subqueries in union Markus Hervén
- hardware upgrade, performance degrade? Steven Crandell
- Re: hardware upgrade, performance degrade? Guillaume Smet
- New server setup Niels Kristian Schjødt
- Re: xmlconcat performance Merlin Moncure
- Re: New server setup Craig James
- Re: hardware upgrade, performance degrade? Craig James
- Re: hardware upgrade, performance degrade? Steven Crandell
- Re: New server setup Wales Wang
- Re: hardware upgrade, performance degrade? Scott Marlowe
- Re: hardware upgrade, performance degrade? Jesper Krogh
- Re: hardware upgrade, performance degrade? Josh Berkus
- Re: hardware upgrade, performance degrade? Jean-David Beyer
- Re: New server setup Niels Kristian Schjødt
- What setup would you choose for postgresql 9.2 installation? Niels Kristian Schjødt
- Re: What setup would you choose for postgresql 9.2 installation? AJ Weber
- Re: What setup would you choose for postgresql 9.2 installation? Richard Neill
- Re: pgbench intriguing results: better tps figures for larger scale factor Merlin Moncure
- Re: What setup would you choose for postgresql 9.2 installation? Scott Marlowe
- Re: What setup would you choose for postgresql 9.2 installation? AJ Weber
- Re: What setup would you choose for postgresql 9.2 installation? Scott Marlowe
- Re: What setup would you choose for postgresql 9.2 installation? Niels Kristian Schjødt
- Schema obfuscator for performance question Joseph Pravato
- Re: Schema obfuscator for performance question Victor Yegorov
- Re: Schema obfuscator for performance question Claudio Freire
- Re: pgbench intriguing results: better tps figures for larger scale factor Greg Smith
- Re: hardware upgrade, performance degrade? Steven Crandell
- Re: hardware upgrade, performance degrade? Mark Kirkwood
- Re: hardware upgrade, performance degrade? Sergey Konoplev
- Re: hardware upgrade, performance degrade? John Rouillard
- Re: hardware upgrade, performance degrade? Scott Marlowe
- Re: hardware upgrade, performance degrade? Steven Crandell
- Re: hardware upgrade, performance degrade? Scott Marlowe
- Re: hardware upgrade, performance degrade? Steven Crandell
- Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Niels Kristian Schjødt
- Re: Poor performance after update from SLES11 SP1 to SP2 Mark Smith
- Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Julien Cigar
- Re: New server setup Kevin Grittner
- Re: New server setup Scott Marlowe
- Re: New server setup Niels Kristian Schjødt
- Re: Are bitmap index scans slow to start? Jeff Janes
- Re: New server setup Benjamin Krajmalnik
- Re: New server setup Niels Kristian Schjødt
- sniff test on some PG 8.4 numbers Jon Nelson
- Re: Are bitmap index scans slow to start? Jeff Janes
- Re: New server setup Jeff Janes
- Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Niels Kristian Schjødt
- Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Joshua D. Drake
- Re: sniff test on some PG 8.4 numbers Josh Berkus
- Re: sniff test on some PG 8.4 numbers Jon Nelson
- Re: sniff test on some PG 8.4 numbers Jon Nelson
- Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Julien Cigar
- Poor plan when joining against a union containing a join David Leverton
- Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Jeff Janes
- Re: Poor plan when joining against a union containing a join Josh Berkus
- Re: Poor plan when joining against a union containing a join Tom Lane
- Re: Poor plan when joining against a union containing a join David Leverton
- Re: Poor plan when joining against a union containing a join Tom Lane
- Anyone running Intel S3700 SSDs? CSS
- Re: Anyone running Intel S3700 SSDs? Yeb Havinga
- PostgreSQL 9.2.3 performance problem caused Exclusive locks Emre Hasegeli
- Re: Poor plan when joining against a union containing a join David Leverton
- Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks Emre Hasegeli
- Re: Are bitmap index scans slow to start? Carlo Stonebanks
- Re: New server setup Gregg Jaskiewicz
- Re: sniff test on some PG 8.4 numbers Greg Smith
- Re: New server setup Greg Smith
- Re: sniff test on some PG 8.4 numbers Jon Nelson
- Re: sniff test on some PG 8.4 numbers Scott Marlowe
- Re: sniff test on some PG 8.4 numbers Greg Smith
- Large Table - Slow Window Functions (Better Approach?) Jeff Adams - NOAA Affiliate
- Re: sniff test on some PG 8.4 numbers Jon Nelson
- Re: Large Table - Slow Window Functions (Better Approach?) Pavel Stehule
- Re: Large Table - Slow Window Functions (Better Approach?) Jeff Adams - NOAA Affiliate
- Re: Large Table - Slow Window Functions (Better Approach?) Pavel Stehule
- Re: Large Table - Slow Window Functions (Better Approach?) Jeff Adams - NOAA Affiliate
- The dreaded semwait on FreeBSD Benjamin Krajmalnik
- Slow query when used in a view Shaun Thomas
- Re: Slow query when used in a view Tom Lane
- Slow concurrent processing Misa Simic
- Re: Large Table - Slow Window Functions (Better Approach?) Jeff Adams - NOAA Affiliate
- Re: Large Table - Slow Window Functions (Better Approach?) Victor Yegorov
- Re: Slow query when used in a view Shaun Thomas
- Re: Slow concurrent processing Misa Simic
- Re: Slow concurrent processing Steve Crawford
- Re: Slow concurrent processing Misa Simic
- Re: Slow concurrent processing Steve Crawford
- Re: Slow concurrent processing Jeff Janes
- Re: Slow concurrent processing Misa Simic
- Re: Slow concurrent processing Misa Simic
- Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks Emre Hasegeli
- Re: New server setup Gregg Jaskiewicz
- Risk of data corruption/loss? Niels Kristian Schjødt
- Re: New server setup John Lister
- Re: New server setup Greg Jaskiewicz
- Re: New server setup John Lister
- Re: Risk of data corruption/loss? Jeff Janes
- Re: Risk of data corruption/loss? Niels Kristian Schjødt
- Setup of four 15k SAS disk with LSI raid controller Niels Kristian Schjødt
- Re: Setup of four 15k SAS disk with LSI raid controller Vasilis Ventirozos
- Re: Setup of four 15k SAS disk with LSI raid controller Niels Kristian Schjødt
- Re: Setup of four 15k SAS disk with LSI raid controller Vasilis Ventirozos
- Re: Setup of four 15k SAS disk with LSI raid controller Joshua D. Drake
- Re: New server setup Steve Crawford
- Re: Setup of four 15k SAS disk with LSI raid controller Niels Kristian Schjødt
- Re: New server setup Karl Denninger
- Re: New server setup CSS
- Re: New server setup John Lister
- Re: New server setup David Boreham
- Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks Joshua Berkus
- Re: Risk of data corruption/loss? Joshua Berkus
- Re: New server setup Mark Kirkwood
- Re: New server setup David Boreham
- PostgreSQL 9.2.3 performance problem caused Exclusive locks Jeff Janes
- Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks Emre Hasegeli
- Re: New server setup Bruce Momjian
- Speed of EXCECUTE in PL/PGSQL Artur Zając
- Re: Speed of EXCECUTE in PL/PGSQL Merlin Moncure
- Re: Speed of EXCECUTE in PL/PGSQL Andrew Dunstan
- Re: New server setup Mark Kirkwood
- Re: New server setup Mark Kirkwood
- Re: New server setup Bruce Momjian
- Re: New server setup Mark Kirkwood
- Re: New server setup David Boreham
- Join the master table with other table is very slow (partitioning) Ao Jianwang
- Re: Join the master table with other table is very slow (partitioning) Ao Jianwang
- Re: Join the master table with other table is very slow (partitioning) AI Rumman
- Re: Join the master table with other table is very slow (partitioning) Ao Jianwang
- Re: Join the master table with other table is very slow (partitioning) Ao Jianwang
- Re: Join the master table with other table is very slow (partitioning) Tom Lane
- Re: Join the master table with other table is very slow (partitioning) Ao Jianwang
- Pre-sorting COPY FROM input Florian Weimer
- Re: New server setup Rick Otten
- Re: Pre-sorting COPY FROM input Heikki Linnakangas
- Re: New server setup Bruce Momjian
- Re: New server setup Scott Marlowe
- Re: New server setup Mark Kirkwood
- Why is my pg_xlog directory so huge? Niels Kristian Schjødt
- Re: Why is my pg_xlog directory so huge? Magnus Hagander
- Re: Why is my pg_xlog directory so huge? Niels Kristian Schjødt
- Re: Why is my pg_xlog directory so huge? Magnus Hagander
- Re: Why is my pg_xlog directory so huge? Niels Kristian Schjødt
- effective_cache_size on 32-bits postgres Rodrigo Barboza
- Re: effective_cache_size on 32-bits postgres Rob Wultsch
- Re: effective_cache_size on 32-bits postgres Pavel Stehule
- Re: effective_cache_size on 32-bits postgres Rodrigo Barboza
- Re: effective_cache_size on 32-bits postgres Pavel Stehule
- Re: effective_cache_size on 32-bits postgres Rodrigo Barboza
- Re: effective_cache_size on 32-bits postgres Pavel Stehule
- Re: effective_cache_size on 32-bits postgres Kevin Grittner
- Re: effective_cache_size on 32-bits postgres Claudio Freire
- Re: effective_cache_size on 32-bits postgres Pavel Stehule
- Re: effective_cache_size on 32-bits postgres Rodrigo Barboza
- Index usage for tstzrange? Josh Berkus
- Re: New server setup David Rees
- Re: New server setup David Boreham
- Re: New server setup Karl Denninger
- Re: New server setup Scott Marlowe
- Re: New server setup Mark Kirkwood
- Re: Index usage for tstzrange? Tom Lane
- Re: Index usage for tstzrange? Vasilis Ventirozos
- Re: Index usage for tstzrange? Heikki Linnakangas
- Re: Index usage for tstzrange? Josh Berkus
- Performance of query Cindy Makarowsky
- Re: Performance of query Josh Berkus
- Re: Index usage for tstzrange? Heikki Linnakangas
- Re: Performance of query Cindy Makarowsky
- Re: Performance of query Misa Simic
- Re: Performance of query Cindy Makarowsky
- Re: Index usage for tstzrange? Heikki Linnakangas
- Re: Index usage for tstzrange? Josh Berkus
- Re: Index usage for tstzrange? Tom Lane
- Re: Performance of query Jeff Janes
- Re: Performance of query Misa Simic
- PostgreSQL planner Misa Simic
- Re: Performance of query Roman Konoval
- 9.2.3 upgrade reduced pgbench performance by 60% Colin Currie
- Re: Performance of query Jeff Janes
- Re: Performance of query Cindy Makarowsky
- Proof of concept: Evolving postgresql.conf using genetic algorithm Greg Jaskiewicz
- Setting vacuum_freeze_min_age really low Josh Berkus
- Re: 9.2.3 upgrade reduced pgbench performance by 60% Josh Berkus
- [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability Andrea Suisani
- Re: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability Shaun Thomas
- Re: 9.2.3 upgrade reduced pgbench performance by 60% Nicholson, Brad (Toronto, ON, CA)
- Reg: Slow query Prakash Chinnakannan
- Re: Reg: Slow query Vasilis Ventirozos
- Re: 9.2.3 upgrade reduced pgbench performance by 60% Josh Berkus
- how to help the planner Marty Frasier
- Re: how to help the planner Tom Lane
- Question about postmaster's CPU usage kelphet xiong
- Re: how to help the planner Marty Frasier
- Re: Question about postmaster's CPU usage Kevin Grittner
- Re: Question about postmaster's CPU usage ktm@rice.edu
- Re: how to help the planner Stephen Frost
- Postgresql performance degrading... how to diagnose the root cause Franck Routier
- Re: Postgresql performance degrading... how to diagnose the root cause Julien Cigar
- Re: Postgresql performance degrading... how to diagnose the root cause Guillaume Cottenceau
- Re: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability Andrea Suisani
- Re: Postgresql performance degrading... how to diagnose the root cause Franck Routier
- Re: how to help the planner Igor Neyman
- Re: Postgresql performance degrading... how to diagnose the root cause Jeff Janes
- Re: Postgresql performance degrading... how to diagnose the root cause Guillaume Cottenceau
- Re: Postgresql performance degrading... how to diagnose the root cause Cédric Villemain
- Re: Postgresql performance degrading... how to diagnose the root cause Jeff Janes
- Re: Question about postmaster's CPU usage Ants Aasma
- Re: Question about postmaster's CPU usage Kelphet Xiong
- Re: 9.2.3 upgrade reduced pgbench performance by 60% Jeff Janes