Mailing lists [pgsql-performance]
- wal_sync_methods Stefan Hans
- Re: High end server and storage for a PostgreSQL OLTP system Cosimo Streppone
- Re: High end server and storage for a PostgreSQL OLTP system Tom Lane
- Inheritence versus delete from Sven Willenberger
- Re: Inheritence versus delete from Tom Lane
- Re: Inheritence versus delete from John Arbash Meinel
- Re: seq scan cache vs. index cache smackdown PFC
- multi billion row tables: possible or insane? Ramon Bastiaans
- Re: multi billion row tables: possible or insane? Jeff
- Re: multi billion row tables: possible or insane? Markus Schaber
- Re: multi billion row tables: possible or insane? John Arbash Meinel
- Re: multi billion row tables: possible or insane? Vig, Sandor (G/FI-2)
- Re: multi billion row tables: possible or insane? John Arbash Meinel
- Re: multi billion row tables: possible or insane? Andras Kadinger
- Re: multi billion row tables: possible or insane? Alan Stange
- Re: Inheritence versus delete from Sven Willenberger
- Re: multi billion row tables: possible or insane? Markus Schaber
- Re: Inheritence versus delete from John Arbash Meinel
- Re: multi billion row tables: possible or insane? John Arbash Meinel
- Confusion about locales and 'like' indexes Dan Harris
- Re: Inheritence versus delete from Gaetano Mendola
- Re: multi billion row tables: possible or insane? Josh Berkus
- Re: Confusion about locales and 'like' indexes Tom Lane
- Re: multi billion row tables: possible or insane? Alan Stange
- What is the postgres sql command for last_user_id ??? amrit@health2.moph.go.th
- Re: multi billion row tables: possible or insane? Thomas Ganss
- Help with tuning this query Ken Egervari
- Re: What is the postgres sql command for last_user_id ??? Michael Fuhr
- Re: Help with tuning this query Richard Huxton
- Re: Help with tuning this query Bricklen Anderson
- Re: Help with tuning this query Bruce Momjian
- Re: Help with tuning this query John Arbash Meinel
- Re: Help with tuning this query Ken Egervari
- Re: Help with tuning this query John Arbash Meinel
- Performance tradeoff Shawn Chisholm
- Re: Help with tuning this query Ragnar Hafstað
- Re: Help with tuning this query Ken Egervari
- Re: Help with tuning this query Ragnar Hafstað
- Re: Help with tuning this query Ken Egervari
- Re: Help with tuning this query (with explain analyze finally) Ken Egervari
- Re: Help with tuning this query (with explain analyze finally) Tom Lane
- Re: Help with tuning this query (with explain analyze finally) Ken Egervari
- Re: Help with tuning this query (with explain analyze finally) Tom Lane
- Re: Help with tuning this query (with explain analyze finally) Dave Held
- Re: Help with tuning this query (with explain analyze finally) John A Meinel
- Re: Help with tuning this query (with explain analyze finally) Ken Egervari
- Re: Help with tuning this query (more musings) Ken Egervari
- Re: Help with tuning this query (Some musings) Ken Egervari
- Re: Help with tuning this query Mark Kirkwood
- Re: Help with tuning this query (more musings) John A Meinel
- Re: Performance tradeoff Josh Berkus
- Re: Help with tuning this query Josh Berkus
- Re: Help with tuning this query (with explain analyze finally) Josh Berkus
- Re: Help with tuning this query (more musings) Ken Egervari
- Re: Help with tuning this query (with explain analyze finally) Ken Egervari
- Re: Help with tuning this query (more musings) Richard Huxton
- Re: Help with tuning this query (with explain analyze finally) Ken Egervari
- name search query speed Jeremiah Jahn
- Re: name search query speed Ken Egervari
- Re: name search query speed Jeremiah Jahn
- Re: Help with tuning this query (with explain analyze finally) Josh Berkus
- Re: name search query speed Josh Berkus
- Re: name search query speed John A Meinel
- Re: name search query speed Markus Schaber
- Re: name search query speed Jeremiah Jahn
- Re: name search query speed Jeremiah Jahn
- Re: name search query speed Dave Held
- Re: name search query speed Jeremiah Jahn
- Re: name search query speed John Arbash Meinel
- Re: name search query speed Markus Schaber
- Re: Help with tuning this query (with explain analyze finally) Ken Egervari
- Re: Help with tuning this query (with explain analyze finally) John Arbash Meinel
- Re: name search query speed William Yu
- Re: Help with tuning this query (with explain analyze finally) Ken Egervari
- Query's fast standalone - slow as a subquery. Ron Mayer
- Re: Query's fast standalone - slow as a subquery. Tom Lane
- Re: Help with tuning this query (with explain analyze finally) Richard Huxton
- Re: Help with tuning this query (with explain analyze finally) Ken
- Re: Help with tuning this query (with explain analyze finally) John Arbash Meinel
- Re: Help with tuning this query (with explain analyze finally) John Arbash Meinel
- Select in FOR LOOP Performance Charles Joseph
- Re: Select in FOR LOOP Performance Tom Lane
- Re: Help with tuning this query (with explain analyze finally) Josh Berkus
- Re: Help with tuning this query (with explain analyze finally) John A Meinel
- MAIN vs. PLAIN Dave Held
- Re: name search query speed stig erikson
- Re: What is the postgres sql command for last_user_id ??? stig erikson
- Re: multi billion row tables: possible or insane? Jim C. Nasby
- Re: multi billion row tables: possible or insane? Alex Turner
- Re: MAIN vs. PLAIN Tom Lane
- Query Optimization - Hash Join estimate off? mark.lubratt@indeq.com
- How to Partition? xsk
- Re: [pgsql-hackers-win32] Help with tuning this query (with explain analyze finally) Magnus Hagander
- Re: [pgsql-hackers-win32] Help with tuning this query (with explain analyze finally) Tom Lane
- Re: [pgsql-hackers-win32] Help with tuning this query (with explain analyze finally) Tom Lane
- Re: [pgsql-hackers-win32] Help with tuning this query (with explain analyze finally) Magnus Hagander
- Tuning, configuration for 7.3.5 on a Sun E4500
- Re: [pgsql-hackers-win32] Help with tuning this query (with John A Meinel
- Re: [pgsql-hackers-win32] Help with tuning this query (with explain analyze finally) Tom Lane
- Help trying to tune query that executes 40x slower than in SqlServer Hugo Ferreira
- Re: [pgsql-hackers-win32] Help with tuning this query (with John A Meinel
- Re: Help trying to tune query that executes 40x slower than in SqlServer Josh Berkus
- Re: Tuning, configuration for 7.3.5 on a Sun E4500 Josh Berkus
- Re: Help trying to tune query that executes 40x slower than in SqlServer Hugo Ferreira
- Re: Help trying to tune query that executes 40x slower than in SqlServer Tom Lane
- Re: [pgsql-hackers-win32] Help with tuning this query (with Greg Stark
- Re: [pgsql-hackers-win32] Help with tuning this query (with Dave Held
- Re: [pgsql-hackers-win32] Help with tuning this query (with explain analyze finally) Dave Held
- Re: [pgsql-hackers-win32] Help with tuning this query (with John A Meinel
- Re: [pgsql-hackers-win32] Help with tuning this query (with Tom Lane
- Re: [pgsql-hackers-win32] Help with tuning this query (with Greg Stark
- Re: [pgsql-hackers-win32] Help with tuning this query (with Dave Held
- Re: [pgsql-hackers-win32] Help with tuning this query (with Dave Held
- Re: [pgsql-hackers-win32] Help with tuning this query (with Steinar H. Gunderson
- Re: [pgsql-hackers-win32] Help with tuning this query (with Tom Lane
- Re: [pgsql-hackers-win32] Help with tuning this query (with Steinar H. Gunderson
- Re: [pgsql-hackers-win32] Help with tuning this query (with PFC
- adding 'limit' leads to very slow query Michael McFarland
- Help with slow running query jesse d
- Re: [pgsql-hackers-win32] Help with tuning this query (with Dave Page
- performance problems Michael Zoephel
- Re: [pgsql-hackers-win32] Help with tuning this query (with John A Meinel
- Re: adding 'limit' leads to very slow query John A Meinel
- Re: adding 'limit' leads to very slow query Stephan Szabo
- Re: Tuning, configuration for 7.3.5 on a Sun E4500
- Re: [pgsql-hackers-win32] Help with tuning this query (with Magnus Hagander
- bad plan Gaetano Mendola
- Re: bad plan Richard Huxton
- pl/pgsql faster than raw SQL? Markus Bertheau ☭
- Re: bad plan Gaetano Mendola
- Re: pl/pgsql faster than raw SQL? Richard Huxton
- Re: bad plan Richard Huxton
- Re: pl/pgsql faster than raw SQL? John A Meinel
- Re: Tuning, configuration for 7.3.5 on a Sun E4500 Josh Berkus
- Re: bad plan Gaetano Mendola
- index scan on =, but not < ? Rick Schumeyer
- Re: index scan on =, but not < ? Thomas F.O'Connell
- Re: index scan on =, but not < ? John Arbash Meinel
- Re: index scan on =, but not < ? Rick Schumeyer
- Re: index scan on =, but not < ? Dennis Bjorklund
- Re: bad plan Richard Huxton
- Re: bad plan Tom Lane
- Why would writes to pgsql_tmp bottleneck at 1mb/s? Josh Berkus
- Re: bad plan Richard Huxton
- Re: bad plan Tom Lane
- Query Optimization James G Wilkinson
- Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Josh Berkus
- Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Josh Berkus
- Re: bad plan Gaetano Mendola
- Re: pl/pgsql faster than raw SQL? Gaetano Mendola
- vacuum full, why multiple times ? Gaetano Mendola
- Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Aaron Birkland
- Re: pl/pgsql faster than raw SQL? John A Meinel
- Re: Query Optimization John A Meinel
- Re: vacuum full, why multiple times ? Michael Fuhr
- 64bit Opteron multi drive raid. Help with best config settings David B
- Re: 64bit Opteron multi drive raid. Help with best config Karim Nassar
- Re: index scan on =, but not < ? Bruno Wolff III
- Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Tom Lane
- Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Josh Berkus
- Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Tom Lane
- Re: index scan on =, but not < ? Jim C. Nasby
- Re: index scan on =, but not < ? Bruno Wolff III
- Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Josh Berkus
- Re: pl/pgsql faster than raw SQL? Gaetano Mendola
- Re: vacuum full, why multiple times ? Gaetano Mendola
- Re: Help trying to tune query that executes 40x slower than in SqlServer Hugo Ferreira
- Re: vacuum full, why multiple times ? Richard Huxton
- Re: vacuum full, why multiple times ? Gaetano Mendola
- Re: vacuum full, why multiple times ? Tom Lane
- Re: vacuum full, why multiple times ? Gaetano Mendola
- Re: index scan on =, but not < ? Jim C. Nasby
- How to speed up tsearch2 indexing Werner Bohl
- Re: How to speed up tsearch2 indexing Oleg Bartunov
- Re: How to speed up tsearch2 indexing Werner Bohl
- Re: How to speed up tsearch2 indexing Oleg Bartunov
- Re: Help trying to tune query that executes 40x slower than in SqlServer Russell Smith
- Re: index scan on =, but not < ? David Brown
- Re: index scan on =, but not < ? David Brown
- Re: Help trying to tune query that executes 40x slower Jim Johannsen
- Multi-line requests in COPY ... FROM STDIN Mischa
- What's better: Raid 0 or disk for seperate pg_xlog Karim Nassar
- Re: What's better: Raid 0 or disk for seperate pg_xlog David Brown
- Re: What's better: Raid 0 or disk for seperate pg_xlog John A Meinel
- Re: What's better: Raid 0 or disk for seperate pg_xlog Mario Weilguni
- Re: What's better: Raid 0 or disk for seperate pg_xlog Karim Nassar
- Re: What's better: Raid 0 or disk for seperate pg_xlog John Arbash Meinel
- Re: What's better: Raid 0 or disk for seperate pg_xlog Richard Huxton
- Statistics not working?? Hugo Ferreira
- Re: Statistics not working?? Oleg Bartunov
- Re: [GENERAL] more execution time Richard Huxton
- What is the number of rows in explain? Joost Kraaijeveld
- Re: What is the number of rows in explain? John A Meinel
- Performance tuning Jacques Caron
- Query performance Lou O'Quin
- Re: Query performance Tom Lane
- Re: Query performance Lou O'Quin
- Questions about 2 databases. jelle
- Re: Query performance Tom Lane
- Re: Questions about 2 databases. Tom Lane
- Re: Query performance Lou O'Quin
- Re: Questions about 2 databases. Richard_D_Levine@raytheon.com
- Postgres on RAID5 Arshavir Grigorian
- Re: Questions about 2 databases. jelle
- Re: Postgres on RAID5 Tom Lane
- Re: Postgres on RAID5 Arshavir Grigorian
- Re: Postgres on RAID5 Alvaro Herrera
- Re: Postgres on RAID5 Tom Lane
- Re: Postgres on RAID5 Arshavir Grigorian
- Re: Postgres on RAID5 Josh Berkus
- Re: Questions about 2 databases. PFC
- Re: Postgres on RAID5 PFC
- Re: Postgres on RAID5 Alex Turner
- Re: Postgres on RAID5 Joshua D. Drake
- One tuple per transaction Tambet Matiisen
- Re: One tuple per transaction Josh Berkus
- Index use and slow queries Tom Pfeifer
- Re: Index use and slow queries Russell Smith
- Re: Index use and slow queries Tom Lane
- How to read query plan Miroslav Šulc
- Re: How to read query plan John Arbash Meinel
- Re: How to read query plan Ragnar Hafstað
- Re: How to read query plan Miroslav Šulc
- Re: One tuple per transaction Tambet Matiisen
- Re: How to read query plan Miroslav Šulc
- Re: How to read query plan John Arbash Meinel
- Re: How to read query plan John Arbash Meinel
- Re: How to read query plan Miroslav Šulc
- Re: How to read query plan Miroslav Šulc
- Re: How to read query plan Tom Lane
- Re: How to read query plan John Arbash Meinel
- Re: How to read query plan Miroslav Šulc
- Re: How to read query plan Miroslav Šulc
- Re: How to read query plan Tom Lane
- Re: How to read query plan Miroslav Šulc
- Re: How to read query plan Tom Lane
- Re: How to read query plan Tom Lane
- Re: One tuple per transaction Qingqing Zhou
- Re: cpu_tuple_cost Daniel Schuchardt
- Re: Postgres on RAID5 Alexander Kirpa
- cpu_tuple_cost Daniel Schuchardt
- Re: adding 'limit' leads to very slow query Michael McFarland
- Postgres on RAID5 Arshavir Grigorian
- more execution time ALÝ ÇELÝK
- Re: Postgres on RAID5 Greg Stark
- Re: [HACKERS] How to read query plan Tom Lane
- Re: cpu_tuple_cost Tom Lane
- column name is "LIMIT" Gourish Singbal
- Re: column name is "LIMIT" Christopher Kings-Lynne
- Re: column name is "LIMIT" Russell Smith
- Re: How to read query plan Miroslav Šulc
- Re: [HACKERS] How to read query plan Miroslav Šulc
- Re: column name is "LIMIT" Gourish Singbal
- Re: column name is "LIMIT" Christopher Kings-Lynne
- Re: How to read query plan Miroslav Šulc
- Re: How to read query plan Christopher Kings-Lynne
- Re: How to read query plan PFC
- Re: How to read query plan Miroslav Šulc
- Re: How to read query plan Miroslav Šulc
- Re: Performance tuning Richard Huxton
- Re: adding 'limit' leads to very slow query Stephan Szabo
- Re: How to read query plan Tom Lane
- Re: [HACKERS] How to read query plan Tom Lane
- Re: How to read query plan Harald Fuchs
- Re: How to read query plan Miroslav Šulc
- Re: How to read query plan Miroslav Šulc
- Re: How to read query plan John Arbash Meinel
- Re: How to read query plan Greg Stark
- Re: How to read query plan Tom Lane
- Re: How to read query plan Miroslav Šulc
- Re: How to read query plan John Arbash Meinel
- Bad Performance[2] Gaetano Mendola
- Re: How to read query plan Kaloyan Iliev Iliev
- Re: How to read query plan Miroslav Šulc
- Avoiding tuple construction/deconstruction during joining Tom Lane
- Re: column name is "LIMIT" Robert Treat
- Re: Postgres on RAID5 Arshavir Grigorian
- Re: column name is "LIMIT" Jan Wieck
- Re: Avoiding tuple construction/deconstruction during joining Miroslav Šulc
- Re: Avoiding tuple construction/deconstruction during joining Tom Lane
- Re: column name is "LIMIT" Bryan Encina
- Re: column name is "LIMIT" Tom Lane
- Re: Avoiding tuple construction/deconstruction during joining Miroslav Šulc
- Re: Postgres on RAID5 Alex Turner
- Re: Postgres on RAID5 Greg Stark
- Re: Postgres on RAID5 Arshavir Grigorian
- Re: Postgres on RAID5 Arshavir Grigorian
- Re: Postgres on RAID5 Jim Buttafuoco
- Re: Postgres on RAID5 Merlin Moncure
- Re: Postgres on RAID5 Alex Turner
- Re: Postgres on RAID5 Alex Turner
- Re: column name is "LIMIT" Jan Wieck
- Re: cpu_tuple_cost Greg Sabino Mullane
- Re: cpu_tuple_cost Bruce Momjian
- Re: cpu_tuple_cost Tom Lane
- Re: cpu_tuple_cost Gregory Stark
- Re: cpu_tuple_cost Josh Berkus
- Re: One tuple per transaction Tambet Matiisen
- Re: One tuple per transaction Richard Huxton
- Re: One tuple per transaction Tambet Matiisen
- Re: Changing the random_page_cost default (was: cpu_tuple_cost) Greg Sabino Mullane
- Re: Changing the random_page_cost default (was: cpu_tuple_cost) Jeff Hoffmann
- interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync Chris Mair
- Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync Magnus Hagander
- Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync Bruce Momjian
- Re: Changing the random_page_cost default (was: cpu_tuple_cost) Tom Lane
- Slow loads when indexes added. Stef
- Re: Avoiding tuple construction/deconstruction during joining PFC
- Re: Avoiding tuple construction/deconstruction during joining PFC
- Performance problem on delete from for 10k rows. May takes 20 minutes through JDBC interface David Gagnon
- Re: One tuple per transaction Robert Treat
- Re: Changing the random_page_cost default (was: Mark Kirkwood
- Re: Performance problem on delete from for 10k rows. May takes 20 minutes through JDBC interface Michael Fuhr
- Re: cpu_tuple_cost David Brown
- Re: Performance problem on delete from for 10k rows. Rod Taylor
- Re: One tuple per transaction Tom Lane
- Re: One tuple per transaction Alvaro Herrera
- Re: Changing the random_page_cost default (was: cpu_tuple_cost) Greg Sabino Mullane
- Re: One tuple per transaction Tom Lane
- Re: cpu_tuple_cost Greg Stark
- Re: Slow loads when indexes added. Stef
- Re: cpu_tuple_cost Magnus Hagander
- Re: Performance problem on delete from for 10k rows. May David Gagnon
- Re: Performance problem on delete from for 10k rows. May Dave Cramer
- Re: Performance problem on delete from for 10k rows. May David Gagnon
- Re: Performance problem on delete from for 10k rows. May Alvaro Herrera
- Re: Performance problem on delete from for 10k rows. May Dave Cramer
- Re: Performance problem on delete from for 10k rows. May David Gagnon
- Re: cpu_tuple_cost Greg Stark
- multi-column index Daniel Crisan
- Re: Performance problem on delete from for 10k rows. May Stephan Szabo
- Re: Performance problem on delete from for 10k rows. May David Gagnon
- Speeding up select distinct Laurent Martelli
- Re: cpu_tuple_cost Josh Berkus
- Re: Speeding up select distinct PFC
- Re: multi-column index Josh Berkus
- Re: Speeding up select distinct Rod Taylor
- Re: Speeding up select distinct Merlin Moncure
- Re: Speeding up select distinct Laurent Martelli
- Re: Speeding up select distinct Laurent Martelli
- Re: Speeding up select distinct Laurent Martelli
- Re: Speeding up select distinct Rod Taylor
- Re: Speeding up select distinct Merlin Moncure
- Re: cpu_tuple_cost Greg Stark
- Help to find out problem with joined tables Rodrigo Moreno
- Re: Performance problem on delete from for 10k rows. May Stephan Szabo
- Re: cpu_tuple_cost Tom Lane
- Re: multi-column index David Brown
- Re: Speeding up select distinct Greg Stark
- Re: multi-column index Tom Lane
- Re: Help to find out problem with joined tables Michael Fuhr
- Join method influences scan method? mark.lubratt@indeq.com
- Re: Join method influences scan method? Tom Lane
- Re: index scan on =, but not < ? Manfred Koizar
- Re: cpu_tuple_cost Manfred Koizar
- Re: multi-column index Manfred Koizar
- Re: multi-column index Christopher Kings-Lynne
- Re: multi-column index Manfred Koizar
- 2 rows expected on a primary key Gaetano Mendola
- TOP 10 SQL commands and more Ales Vojacek
- queries on huge tables Lending, Rune
- Building a DB with performance in mind Alexander Ranaldi
- Re: Building a DB with performance in mind Steinar H. Gunderson
- Re: Building a DB with performance in mind John Arbash Meinel
- RES: Help to find out problem with joined tables Rodrigo Moreno
- Re: TOP 10 SQL commands and more Josh Berkus
- Re: cpu_tuple_cost Josh Berkus
- Re: cpu_tuple_cost Tom Lane
- Re: multi-column index Tom Lane
- Re: cpu_tuple_cost Michael Fuhr
- Re: One tuple per transaction Hannu Krosing
- Re: multi-column index Manfred Koizar
- Re: multi-column index Manfred Koizar
- Re: queries on huge tables Mike Rylander
- What needs to be done for real Partitioning? Josh Berkus
- Re: What needs to be done for real Partitioning? Tom Lane
- Re: What needs to be done for real Partitioning? PFC
- Re: What needs to be done for real Partitioning? Stacy White
- Re: What needs to be done for real Partitioning? Alvaro Herrera
- Re: What needs to be done for real Partitioning? Tom Lane
- Re: What needs to be done for real Partitioning? Josh Berkus
- Re: What needs to be done for real Partitioning? Steve Atkins
- Re: What needs to be done for real Partitioning? PFC
- Re: What needs to be done for real Partitioning? Tom Lane
- Re: What needs to be done for real Partitioning? Tom Lane
- Re: What needs to be done for real Partitioning? Steinar H. Gunderson
- Re: What needs to be done for real Partitioning? Alvaro Herrera
- Re: What needs to be done for real Partitioning? Rod Taylor
- Re: What needs to be done for real Partitioning? Tom Lane
- Re: What needs to be done for real Partitioning? Greg Stark
- Re: What needs to be done for real Partitioning? PFC
- Re: What needs to be done for real Partitioning? Tom Lane
- Re: What needs to be done for real Partitioning? Stacy White
- Re: What needs to be done for real Partitioning? Josh Berkus
- Re: What needs to be done for real Partitioning? Oleg Bartunov
- Re: What needs to be done for real Partitioning? Greg Stark
- Re: What needs to be done for real Partitioning? Tom Lane
- Re: What needs to be done for real Partitioning? Tom Lane
- Re: What needs to be done for real Partitioning? Greg Stark
- Re: What needs to be done for real Partitioning? Greg Stark
- View vs function Keith Worthington
- Re: What needs to be done for real Partitioning? Greg Stark
- Re: View vs function Bruno Wolff III
- Re: cpu_tuple_cost Daniel Schuchardt
- Re: Postgres on RAID5 David Dougall
- Effect of Stripe Size (was Postgres on RAID5) Ruth Ivimey-Cook
- Re: Postgres on RAID5 Michael Tokarev
- Which one is faster: one way reading ="single pass reading" Rosny
- Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync Qingqing Zhou
- Hardware impact on performances Camille Chafer
- Re: Questions about 2 databases. Mirko Zeibig
- Re: Postgres on RAID5 Michael Tokarev
- Re: column name is "LIMIT" Qingqing Zhou
- Re: Postgres on RAID5 Guy
- Re: Postgres on RAID5 (possible sync blocking read type David Greaves
- Re: What needs to be done for real Partitioning? Stacy White
- Re: View vs function Neil Conway
- Re: What needs to be done for real Partitioning? Stacy White
- Re: View vs function Tom Lane
- Re: Hardware impact on performances Richard Huxton
- What about utility to calculate planner cost constants? Tambet Matiisen
- Re: column name is "LIMIT" Jan Wieck
- Re: column name is "LIMIT" Tom Lane
- Re: What about utility to calculate planner cost constants? Josh Berkus
- Re: What needs to be done for real Partitioning? Josh Berkus
- Re: What about utility to calculate planner cost constants? Thomas F.O'Connell
- Re: What needs to be done for real Partitioning? Jim C. Nasby
- Re: What needs to be done for real Partitioning? Jim C. Nasby
- Re: What about utility to calculate planner cost constants? Josh Berkus
- Re: What needs to be done for real Partitioning? Jim C. Nasby
- Re: What about utility to calculate planner cost constants? Greg Stark
- Re: What needs to be done for real Partitioning? Simon Riggs
- best practices with index on varchar column Layet Benjamin
- Re: best practices with index on varchar column Dawid Kuroczko
- Re: What about utility to calculate planner cost constants? Dawid Kuroczko
- Re: best practices with index on varchar column PFC
- Re: What needs to be done for real Partitioning? Hannu Krosing
- Re: What needs to be done for real Partitioning? Hannu Krosing
- Re: What needs to be done for real Partitioning? Hannu Krosing
- Re: What needs to be done for real Partitioning? Hannu Krosing
- Re: What needs to be done for real Partitioning? Hannu Krosing
- Re: What about utility to calculate planner cost constants? Richard Huxton
- Tsearch2 performance on big database Rick Jansen
- Re: Tsearch2 performance on big database Oleg Bartunov
- Re: Tsearch2 performance on big database Mike Rylander
- Re: What needs to be done for real Partitioning? Alvaro Herrera
- Re: Tsearch2 performance on big database Oleg Bartunov
- Re: Tsearch2 performance on big database Rick Jansen
- Re: What about utility to calculate planner cost constants? Christopher Browne
- Planner issue Alex Turner
- Re: What about utility to calculate planner cost constants? Bruno Wolff III
- Re: Tsearch2 performance on big database Mike Rylander
- Re: Tsearch2 performance on big database Oleg Bartunov
- Re: What needs to be done for real Partitioning? Hannu Krosing
- Re: Tsearch2 performance on big database Rick Jansen
- Re: What about utility to calculate planner cost constants? Greg Stark
- Re: Planner issue Joshua D. Drake
- Re: Tsearch2 performance on big database Oleg Bartunov
- Re: What needs to be done for real Partitioning? Josh Berkus
- Re: What about utility to calculate planner cost constants? Greg Stark
- Re: What about utility to calculate planner cost constants? Richard Huxton
- Re: best practices with index on varchar column Tom Lane
- CPU 0.1% IOWAIT 99% for decisonnal queries Patrick Vedrines
- Re: CPU 0.1% IOWAIT 99% for decisonnal queries Gustavo F Nobrega - Planae
- Re: What about utility to calculate planner cost constants? Tom Lane
- Re: [ADMIN] Too slow Thomas F.O'Connell
- Re: CPU 0.1% IOWAIT 99% for decisonnal queries Richard Huxton
- Re: What about utility to calculate planner cost constants? Tom Lane
- Re: Planner issue Alex Turner
- Re: Planner issue Ragnar Hafstað
- PostgreSQL on Solaris 8 and ufs Brandon Metcalf
- Re: PostgreSQL on Solaris 8 and ufs Alan Stange
- Re: PostgreSQL on Solaris 8 and ufs Sven Willenberger
- Re: PostgreSQL on Solaris 8 and ufs Brandon Metcalf
- Re: PostgreSQL on Solaris 8 and ufs Brandon Metcalf
- Re: PostgreSQL on Solaris 8 and ufs Mark Kirkwood
- Re: What about utility to calculate planner cost constants? Greg Stark
- Re: What about utility to calculate planner cost constants? Tom Lane
- Re: What about utility to calculate planner cost constants? Dave Held
- Re: CPU 0.1% IOWAIT 99% for decisonnal queries Simon Riggs
- Re: What about utility to calculate planner cost constants? Dave Held
- Re: What about utility to calculate planner cost constants? Ron Mayer
- Re: Planner issue Ron Mayer
- Re: Planner issue Ron Mayer
- Re: What about utility to calculate planner cost constants? Chris Browne
- Re: What needs to be done for real Partitioning? Bruce Momjian
- Hardware questions Junaili Lie
- Re: Hardware questions Karim Nassar
- Re: Tsearch2 performance on big database Rick Jansen
- Re: best practices with index on varchar column Michael Ryan S. Puncia
- Re: best practices with index on varchar column Dawid Kuroczko
- Re: Tsearch2 performance on big database Oleg Bartunov
- SQL function inlining (was: View vs function) Tambet Matiisen
- Re: best practices with index on varchar column Richard Huxton
- Re: SQL function inlining (was: View vs function) Tom Lane
- Re: PostgreSQL on Solaris 8 and ufs Andrew Sullivan
- Re: PostgreSQL on Solaris 8 and ufs Brandon Metcalf
- Re: PostgreSQL on Solaris 8 and ufs Tom Arthurs
- Re: PostgreSQL on Solaris 8 and ufs Andrew Sullivan
- Re: PostgreSQL on Solaris 8 and ufs Andrew Sullivan
- Re: PostgreSQL on Solaris 8 and ufs Josh Berkus
- Re: CPU 0.1% IOWAIT 99% for decisonnal queries Patrick Vedrines
- Re: CPU 0.1% IOWAIT 99% for decisonnal queries Patrick Vedrines
- Re: CPU 0.1% IOWAIT 99% for decisonnal queries Patrick Vedrines
- Re: Tsearch2 performance on big database Rick Jansen
- Re: Tsearch2 performance on big database Oleg Bartunov
- Re: Tsearch2 performance on big database Rick Jansen
- Re: CPU 0.1% IOWAIT 99% for decisonnal queries Gustavo Franklin Nóbrega - Planae
- clear function cache (WAS: SQL function inlining) Enrico Weigelt
- Re: clear function cache (WAS: SQL function inlining) Alvaro Herrera
- Re: View columns calculated Enrico Weigelt
- Re: CPU 0.1% IOWAIT 99% for decisonnal queries Patrick Vedrines
- Re: clear function cache (WAS: SQL function inlining) Enrico Weigelt
- Re: CPU 0.1% IOWAIT 99% for decisonnal queries Gustavo Franklin Nóbrega - Planae
- Re: clear function cache (WAS: SQL function inlining) Stephan Szabo
- pg_autovacuum not having enough suction ? Otto Blomqvist
- Preventing query from hogging server Matthew Nuzum
- Re: Preventing query from hogging server Rosser Schwarz
- Re: pg_autovacuum not having enough suction ? Tom Lane
- Re: Preventing query from hogging server Tom Lane
- Re: Preventing query from hogging server Matthew Nuzum
- Re: Preventing query from hogging server Matthew Nuzum
- Re: Preventing query from hogging server Tom Lane
- Re: Preventing query from hogging server Matthew Nuzum
- Re: Preventing query from hogging server Tom Lane
- Re: CPU 0.1% IOWAIT 99% for decisonnal queries Simon Riggs
- Re: pg_autovacuum not having enough suction ? Otto Blomqvist
- Re: pg_autovacuum not having enough suction ? Matthew T. O'Connor
- Re: pg_autovacuum not having enough suction ? Matthew T. O'Connor
- Delete query takes exorbitant amount of time Karim Nassar
- Re: Delete query takes exorbitant amount of time Tom Lane
- Re: Delete query takes exorbitant amount of time Mark Lewis
- Re: Delete query takes exorbitant amount of time Karim Nassar
- Re: Delete query takes exorbitant amount of time Tom Lane
- Re: Delete query takes exorbitant amount of time Tom Lane
- Re: Delete query takes exorbitant amount of time Christopher Kings-Lynne
- Re: Delete query takes exorbitant amount of time Christopher Kings-Lynne
- Re: Delete query takes exorbitant amount of time Christopher Kings-Lynne
- Re: Delete query takes exorbitant amount of time Vivek Khera
- Re: Delete query takes exorbitant amount of time Josh Berkus
- Re: Delete query takes exorbitant amount of time Oleg Bartunov
- Re: Delete query takes exorbitant amount of time Tom Lane
- Re: Delete query takes exorbitant amount of time Tom Lane
- Re: [BUGS] BUG #1552: massive performance hit between 7.4 and 8.0.1 Simon Riggs
- Re: [BUGS] BUG #1552: massive performance hit between 7.4 and 8.0.1 Tom Lane
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Script for getting a table of reponse-time breakdown Jack Xue
- Re: Delete query takes exorbitant amount of time Tom Lane
- Re: [BUGS] BUG #1552: massive performance hit Simon Riggs
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Re: Delete query takes exorbitant amount of time Stephan Szabo
- Re: Delete query takes exorbitant amount of time Josh Berkus
- Re: Script for getting a table of reponse-time breakdown Josh Berkus
- Re: Script for getting a table of reponse-time breakdown Jack Xue
- Re: Script for getting a table of reponse-time breakdown Josh Berkus
- Re: pg_autovacuum not having enough suction ? Otto Blomqvist
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Re: Delete query takes exorbitant amount of time Tom Lane
- Re: pg_autovacuum not having enough suction ? Matthew T. O'Connor
- Re: pg_autovacuum not having enough suction ? Tom Lane
- Re: pg_autovacuum not having enough suction ? Otto Blomqvist
- lazy_update_relstats considered harmful (was Re: pg_autovacuum not having enough suction ?) Tom Lane
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Re: pg_autovacuum not having enough suction ? Otto Blomqvist
- Re: pg_autovacuum not having enough suction ? Matthew T. O'Connor
- Re: Delete query takes exorbitant amount of time Stephan Szabo
- Re: [HACKERS] lazy_update_relstats considered harmful (was Re: Matthew T. O'Connor
- Re: Delete query takes exorbitant amount of time Tom Lane
- Re: Delete query takes exorbitant amount of time Karim Nassar
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Re: lazy_update_relstats considered harmful (was Re: Simon Riggs
- Re: lazy_update_relstats considered harmful (was Re: pg_autovacuum not having enough suction ?) Tom Lane
- Re: pg_autovacuum not having enough suction ? Tom Lane
- Re: pg_autovacuum not having enough suction ? Bruce Momjian
- Re: pg_autovacuum not having enough suction ? Joshua D. Drake
- Re: pg_autovacuum not having enough suction ? Tom Lane
- Re: pg_autovacuum not having enough suction ? Bruce Momjian
- Re: pg_autovacuum not having enough suction ? Otto Blomqvist
- How to improve db performance with $7K? Steve Poe
- Re: How to improve db performance with $7K? Tom Lane
- Re: How to improve db performance with $7K? Will LaShell
- Re: How to improve db performance with $7K? Joshua D. Drake
- Re: How to improve db performance with $7K? Steve Poe
- Re: Delete query takes exorbitant amount of time Christopher Kings-Lynne
- Re: How to improve db performance with $7K? Steve Poe
- Re: How to improve db performance with $7K? Bjoern Metzdorf
- Re: Delete query takes exorbitant amount of time Stephan Szabo
- Re: Delete query takes exorbitant amount of time Karim Nassar
- Re: How to improve db performance with $7K? Josh Berkus
- Re: How to improve db performance with $7K? Steve Poe
- Re: How to improve db performance with $7K? Steve Poe
- Re: Delete query takes exorbitant amount of time Stephan Szabo
- Re: Delete query takes exorbitant amount of time Karim Nassar
- Re: Delete query takes exorbitant amount of time Stephan Szabo
- Re: How to improve db performance with $7K? Alexander Kirpa
- Configuration/Tuning of server/DB Reid Thompson
- Re: Delete query takes exorbitant amount of time Karim Nassar
- Re: [BUGS] BUG #1552: massive performance hit between 7.4 Karim Nassar
- Re: Delete query takes exorbitant amount of time Karim Nassar
- Re: pg_autovacuum not having enough suction ? Matthew T. O'Connor
- Query Optimizer Failure / Possible Bug Hannes Dorbath
- Re: Hardware questions Dave Cramer
- Re: What about utility to calculate planner cost constants? Kenneth Marshall
- Re: Delete query takes exorbitant amount of time Simon Riggs
- NFS RAID 0/5 Rudi Starcevic
- Re: Configuration/Tuning of server/DB Thomas F.O'Connell
- Re: Delete query takes exorbitant amount of time Stephan Szabo
- Re: Delete query takes exorbitant amount of time Mark Lewis
- Sluggish server performance Patrick Hatcher
- Re: Sluggish server performance Jacques Caron
- Re: Sluggish server performance Joshua D. Drake
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Re: Query Optimizer Failure / Possible Bug Josh Berkus
- Re: which dual-CPU hardware/OS is fastest for PostgreSQL? Greg Stark
- Re: which dual-CPU hardware/OS is fastest for PostgreSQL? Steve Poe
- Re: which dual-CPU hardware/OS is fastest for PostgreSQL? Joshua D. Drake
- Re: Preventing query from hogging server Jim C. Nasby
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Re: which dual-CPU hardware/OS is fastest for PostgreSQL? Greg Stark
- Re: How to improve db performance with $7K? Cott Lang
- JDBC best practice Dave Held
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Re: which dual-CPU hardware/OS is fastest for PostgreSQL? Bruce Momjian
- Re: which dual-CPU hardware/OS is fastest for PostgreSQL? Klint Gore
- Re: which dual-CPU hardware/OS is fastest for PostgreSQL? Greg Stark
- Re: JDBC best practice Kris Jurka
- Re: How to improve db performance with $7K? Steve Poe
- Re: How to improve db performance with $7K? PFC
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Re: How to improve db performance with $7K? Dave Cramer
- Re: Delete query takes exorbitant amount of time Stephan Szabo
- Re: Delete query takes exorbitant amount of time Stephan Szabo
- Re: Delete query takes exorbitant amount of time Tom Lane
- Re: Delete query takes exorbitant amount of time Tom Lane
- Re: How to improve db performance with $7K? Cott Lang
- Re: Delete query takes exorbitant amount of time Tom Lane
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Re: Delete query takes exorbitant amount of time Tom Lane
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Re: Delete query takes exorbitant amount of time Stephan Szabo
- Re: Delete query takes exorbitant amount of time Stephan Szabo
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Re: Delete query takes exorbitant amount of time Tom Lane
- Re: How to improve db performance with $7K? Greg Stark
- Million of rows Vinicius Bernardi
- Re: Delete query takes exorbitant amount of time Simon Riggs
- Re: Million of rows Michael Fuhr
- Re: Million of rows Vinicius Bernardi
- VACUUM on duplicate DB gives FSM and total pages discrepancies Karim Nassar
- Reading recommendations Marc Burgauer
- Weird index scan Tambet Matiisen
- Re: VACUUM on duplicate DB gives FSM and total pages discrepancies Alvaro Herrera
- Re: Reading recommendations Michael Fuhr
- Re: Reading recommendations Richard_D_Levine@Raytheon.com
- Re: Reading recommendations Mohan, Ross
- Re: Reading recommendations Steve Wampler
- Re: Reading recommendations Mohan, Ross
- Dynamic query perormance Keith Worthington
- Re: Weird index scan G u i d o B a r o s i o
- Re: Reading recommendations Bruno Wolff III
- Re: Dynamic query perormance John Arbash Meinel
- Re: Dynamic query perormance PFC
- Re: Reading recommendations Richard_D_Levine@raytheon.com
- Left Outer Join much faster than non-outer Join? rm_pg@cheapcomplexdevices.com
- Re: Left Outer Join much faster than non-outer Join? Ron Mayer
- Re: Reading recommendations Steve Wampler
- Re: PostgreSQL on Solaris 8 and ufs Brandon Metcalf
- Re: Reading recommendations Mohan, Ross
- fine tuning for logging server Florin Andrei
- Re: fine tuning for logging server John Arbash Meinel
- Re: fine tuning for logging server Florin Andrei
- Re: fine tuning for logging server John Arbash Meinel
- Re: fine tuning for logging server Florin Andrei
- Re: fine tuning for logging server Florin Andrei
- Re: fine tuning for logging server John Arbash Meinel
- Re: fine tuning for logging server John Arbash Meinel
- Re: Left Outer Join much faster than non-outer Join? Tom Lane
- Re: Left Outer Join much faster than non-outer Join? Ron Mayer
- Re: Left Outer Join much faster than non-outer Join? Ron Mayer
- Re: Left Outer Join much faster than non-outer Join? Patrick Vedrines
- Re: fine tuning for logging server PFC
- Re: Reading recommendations Richard_D_Levine@Raytheon.com
- Re: Reading recommendations Stefan Weiss
- Re: fine tuning for logging server Michael Adler
- Re: Reading recommendations Steve Wampler
- Re: Left Outer Join much faster than non-outer Join? Simon Riggs
- Re: Reading recommendations Richard_D_Levine@raytheon.com
- How to speed up word count with tsearch2? Yudie Pg
- Very long time to execute and Update, suggestions? Madison Kelly
- Postgresql.conf setting recommendations for 8.0.1 Pallav Kalva
- Re: Very long time to execute and Update, suggestions? Madison Kelly
- How to speed up word count in tsearch2? Yudie Pg