Postgres Performance Date Index

• Thread Index

• Non-optimal query plan with 8.2
  • From: Tyrrill, Ed
• [no subject]
  • From: Tyrrill, Ed
• startup caching suggestions
  • From: Bryan Murphy
• Re: PITR Backups
  • From: Tom Lane
• Re: PITR Backups
  • From: Dan Gorman
• Re: PITR Backups
  • From: Tom Lane
• Re: PITR Backups
  • From: Gregory Stark
• Re: PITR Backups
  • From: Dan Gorman
• Re: PITR Backups
  • From: Simon Riggs
• Re: PITR Backups
  • From: Tom Lane
• Re: PITR Backups
  • From: Simon Riggs
• Re: PITR Backups
  • From: Dan Gorman
• Re: PITR Backups
  • From: Gregory Stark
• Re: PITR Backups
  • From: Dan Gorman
• Re: PITR Backups
  • From: Dan Gorman
• Re: PITR Backups
  • From: Gregory Stark
• Re: PITR Backups
  • From: Tom Lane
• Re: Slow indexscan
  • From: Tom Lane
• Re: PITR Backups
  • From: Simon Riggs
• Re: Performance query about large tables, lots of concurrent access
  • From: Jean-David Beyer
• Re: PostgreSQL Configuration Tool for Dummies - feedback adjustable control
  • From: Sabin Coanda
• Re: Performance query about large tables, lots of concurrent access
  • From: Michael Stone
• Re: PITR Backups
  • From: Koichi Suzuki
• Is AIX Concurrent IO safe with PostgreSQL?
  • From: Dawid Kuroczko
• Re: Slow indexscan
  • From: Mikko Partio
• Re: PREPARE and stuff
  • From: PFC
• Re: PREPARE and stuff
  • From: Gregory Stark
• Re: PREPARE and stuff
  • From: Andreas Kostyrka
• Re: PREPARE and stuff
  • From: Heikki Linnakangas
• PREPARE and stuff
  • From: PFC
• Re: PostgreSQL Configuration Tool for Dummies - feedback adjustable control
  • From: Greg Smith
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Greg Smith
• Re: Volunteer to build a configuration tool
  • From: Greg Smith
• Re: Slow join query
  • From: Scott Marlowe
• Re: Slow join query
  • From: Tom Tamulewicz
• Re: Data transfer very slow when connected via DSL
  • From: Rainer Bauer
• Re: Slow join query
  • From: Michael Glaesemann
• Re: Slow join query
  • From: Tom Tamulewicz
• Re: Slow join query
  • From: Michael Glaesemann
• Re: PostgreSQL Configuration Tool for Dummies - feedback adjustable control
  • From: david
• Slow join query
  • From: Tom Tamulewicz
• Re: PITR Backups
  • From: Tom Lane
• Re: PITR Backups
  • From: Simon Riggs
• Re: PITR Backups
  • From: Tom Lane
• Re: Data transfer very slow when connected via DSL
  • From: Dimitri
• Re: PITR Backups
  • From: Gregory Stark
• Re: Data transfer very slow when connected via DSL
  • From: Rainer Bauer
• Re: Data transfer very slow when connected via DSL
  • From: Joshua D. Drake
• Re: Data transfer very slow when connected via DSL
  • From: Rainer Bauer
• Re: Database-wide VACUUM ANALYZE
  • From: Alvaro Herrera
• Re: PITR Backups
  • From: Joshua D. Drake
• Re: PITR Backups
  • From: Joshua D. Drake
• Re: PostgreSQL Configuration Tool for Dummies - feedback adjustable control
  • From: Sabin Coanda
• Re: Data transfer very slow when connected via DSL
  • From: Harald Armin Massa
• Re: Data transfer very slow when connected via DSL
  • From: Dimitri
• Re: Hardware suggestions
  • From: Francisco Reyes
• Re: PITR Backups
  • From: Simon Riggs
• Re: PITR Backups
  • From: Andreas Kostyrka
• Re: PITR Backups
  • From: Kurt Overberg
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Adam Tauno Williams
• Re: PITR Backups
  • From: Dan Gorman
• Re: PITR Backups
  • From: Simon Riggs
• Re: PITR Backups
  • From: Dan Gorman
• Re: PITR Backups
  • From: Simon Riggs
• Re: Data transfer very slow when connected via DSL
  • From: PFC
• Re: Data transfer very slow when connected via DSL
  • From: Harald Armin Massa
• Re: Data transfer very slow when connected via DSL
  • From: Dave Page
• Re: Data transfer very slow when connected via DSL
  • From: Dave Page
• Re: Data transfer very slow when connected via DSL
  • From: Rainer Bauer
• Re: Data transfer very slow when connected via DSL
  • From: Dimitri
• Re: Data transfer very slow when connected via DSL
  • From: Rainer Bauer
• Re: Data transfer very slow when connected via DSL
  • From: Rainer Bauer
• Re: PITR Backups
  • From: Toru SHIMOGAKI
• Re: Data transfer very slow when connected via DSL
  • From: Dimitri
• Re: PITR Backups
  • From: Dan Gorman
• Re: PITR Backups
  • From: Toru SHIMOGAKI
• Re: PITR Backups
  • From: Toru SHIMOGAKI
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Greg Smith
• Re: Hardware suggestions
  • From: Greg Smith
• Re: PITR Backups
  • From: Steve Atkins
• Re: PITR Backups
  • From: Joshua D. Drake
• Re: PITR Backups
  • From: Toru SHIMOGAKI
• Re: Data transfer very slow when connected via DSL
  • From: Tom Lane
• Re: PITR Backups
  • From: Tom Lane
• PITR Backups
  • From: Dan Gorman
• Re: Performance query about large tables, lots of concurrent access
  • From: Joshua D. Drake
• Re: Data transfer very slow when connected via DSL
  • From: Scott Marlowe
• Re: Performance query about large tables, lots of concurrent access
  • From: Scott Marlowe
• Re: Performance query about large tables, lots of concurrent access
  • From: Scott Marlowe
• Re: Data transfer very slow when connected via DSL
  • From: Dimitri
• Re: Hardware suggestions
  • From: Scott Marlowe
• Re: Data transfer very slow when connected via DSL
  • From: Rainer Bauer
• Re: Data transfer very slow when connected via DSL
  • From: Dimitri
• Re: Data transfer very slow when connected via DSL
  • From: Rainer Bauer
• Re: Very long SQL strings
  • From: Tom Lane
• Re: Database-wide VACUUM ANALYZE
  • From: Steven Flatt
• Re: Very long SQL strings
  • From: Steven Flatt
• Re: Database-wide VACUUM ANALYZE
  • From: Bill Moran
• Re: Very long SQL strings
  • From: Chris Browne
• Re: Database-wide VACUUM ANALYZE
  • From: Larry Rosenman
• Re: Database-wide VACUUM ANALYZE
  • From: Steven Flatt
• Re: Database-wide VACUUM ANALYZE
  • From: Francisco Reyes
• Re: Very long SQL strings
  • From: Andreas Kretschmer
• Re: Very long SQL strings
  • From: Tom Lane
• Re: Very long SQL strings
  • From: Heikki Linnakangas
• Re: Database-wide VACUUM ANALYZE
  • From: Heikki Linnakangas
• Very long SQL strings
  • From: Steven Flatt
• Re: Data transfer very slow when connected via DSL
  • From: Rainer Bauer
• Re: Data transfer very slow when connected via DSL
  • From: Rainer Bauer
• Re: vacuum a lot of data when insert only
  • From: Andrew Sullivan
• Re: Performance query about large tables, lots of concurrent access
  • From: Andrew Sullivan
• Database-wide VACUUM ANALYZE
  • From: Steven Flatt
• vacuum a lot of data when insert only
  • From: Sabin Coanda
• Re: Volunteer to build a configuration tool
  • From: Campbell, Lance
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: Volunteer to build a configuration tool
  • From: Andrew Sullivan
• Re: Performance query about large tables, lots of concurrent access
  • From: Scott Marlowe
• Re: Data transfer very slow when connected via DSL
  • From: Tom Lane
• Re: Replication
  • From: Markus Schiltknecht
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Scott Marlowe
• Re: Volunteer to build a configuration tool
  • From: Dave Page
• Re: Data transfer very slow when connected via DSL
  • From: Harald Armin Massa
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Ben Trewern
• Re: Volunteer to build a configuration tool
  • From: Tom Lane
• Data transfer very slow when connected via DSL
  • From: Rainer Bauer
• Re: Hardware suggestions
  • From: Francisco Reyes
• Re: Volunteer to build a configuration tool
  • From: Greg Smith
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Stefan Kaltenbrunner
• Re: Maintenance question / DB size anomaly...
  • From: Kurt Overberg
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: Performance query about large tables, lots of concurrent access
  • From: Scott Marlowe
• Re: Hardware suggestions
  • From: Scott Marlowe
• Re: [GENERAL] [ADMIN] Postgres VS Oracle
  • From: Scott Marlowe
• Re: any way to get rid of Bitmap Heap Scan recheck?
  • From: Scott Marlowe
• Re: Performance query about large tables, lots of concurrent access
  • From: Andrew Sullivan
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: Maintenance question / DB size anomaly...
  • From: Tom Lane
• Re: Volunteer to build a configuration tool
  • From: Greg Smith
• Re: Maintenance question / DB size anomaly...
  • From: Kurt Overberg
• Re: Performance query about large tables, lots of concurrent access
  • From: Shaun Thomas
• Re: Slow indexscan
  • From: Tom Lane
• Re: Maintenance question / DB size anomaly...
  • From: Tom Lane
• Re: Performance query about large tables, lots of concurrent access
  • From: Michael Stone
• Re: Performance query about large tables, lots of concurrent access
  • From: Andrew Sullivan
• Re: Performance query about large tables, lots of concurrent access
  • From: Joshua D. Drake
• Re: Maintenance question / DB size anomaly...
  • From: Kurt Overberg
• Re: Performance query about large tables, lots of concurrent access
  • From: Michael Stone
• Re: Performance query about large tables, lots of concurrent access
  • From: Alvaro Herrera
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: Performance query about large tables, lots of concurrent access
  • From: Alvaro Herrera
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: Slow indexscan
  • From: Oleg Bartunov
• Re: Performance query about large tables, lots of concurrent access
  • From: Francisco Reyes
• Re: Performance query about large tables, lots of concurrent access
  • From: Alvaro Herrera
• Re: Performance query about large tables, lots of concurrent access
  • From: Heikki Linnakangas
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: Volunteer to build a configuration tool
  • From: Mark Lewis
• Re: Volunteer to build a configuration tool
  • From: Heikki Linnakangas
• Re: Slow indexscan
  • From: Michael Glaesemann
• Re: Slow indexscan
  • From: Mikko Partio
• Re: Volunteer to build a configuration tool
  • From: Campbell, Lance
• Re: Slow indexscan
  • From: Tom Lane
• Re: Slow indexscan
  • From: Joshua D. Drake
• Re: Slow indexscan
  • From: Mikko Partio
• Re: [PG 8.1.0 / AIX 5.3] Vacuum processes freezing
  • From: RESTOUX, Loïc
• Re: Maintenance question / DB size anomaly...
  • From: Tom Lane
• Re: Volunteer to build a configuration tool
  • From: Greg Smith
• Re: Slow indexscan
  • From: Tom Lane
• Re: Replication
  • From: Andrew Sullivan
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Kevin Hunter
• Slow indexscan
  • From: Mikko Partio
• Re: Maintenance question / DB size anomaly...
  • From: Andreas Kostyrka
• Re: Maintenance question / DB size anomaly...
  • From: Bill Moran
• Re: Maintenance question / DB size anomaly...
  • From: Kurt Overberg
• Re: cached entities
  • From: Bill Moran
• cached entities
  • From: Sergey Konoplev
• Re: Short row header
  • From: Gregory Stark
• Re: Short row header
  • From: Heikki Linnakangas
• Short row header
  • From: PFC
• Re: Volunteer to build a configuration tool
  • From: PFC
• Re: Volunteer to build a configuration tool
  • From: Tom Lane
• Re: Volunteer to build a configuration tool
  • From: Greg Smith
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Greg Smith
• Re: Volunteer to build a configuration tool
  • From: Tom Lane
• Re: Volunteer to build a configuration tool
  • From: Greg Smith
• Re: Maintenance question / DB size anomaly...
  • From: Tom Lane
• Re: Maintenance question / DB size anomaly...
  • From: Kurt Overberg
• Re: Volunteer to build a configuration tool
  • From: Mike Benoit
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Francisco Reyes
• Re: Maintenance question / DB size anomaly...
  • From: Bill Moran
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Charles Sprickman
• Re: Maintenance question / DB size anomaly...
  • From: Tom Lane
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Josh Berkus
• Re: Maintenance question / DB size anomaly...
  • From: Kurt Overberg
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Tom Lane
• Re: Maintenance question / DB size anomaly...
  • From: Tom Lane
• Re: Replication
  • From: Jeff Davis
• Re: [ADMIN] Postgres VS Oracle
  • From: Simon Riggs
• PostgreSQL Configuration Tool for Dummies
  • From: Campbell, Lance
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Ray Stell
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Josh Berkus
• Re: Best use of second controller with faster disks?
  • From: Francisco Reyes
• Re: PostgreSQL Configuration Tool for Dummies
  • From: david
• Re: PostgreSQL Configuration Tool for Dummies
  • From: david
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Francisco Reyes
• Re: Performance query about large tables, lots of concurrent access
  • From: Francisco Reyes
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Y Sidhu
• PostgreSQL Configuration Tool for Dummies
  • From: Campbell, Lance
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Campbell, Lance
• Re: PostgreSQL Configuration Tool for Dummies
  • From: D'Arcy J.M. Cain
• Re: Performance query about large tables, lots of concurrent access
  • From: Heikki Linnakangas
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Campbell, Lance
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Y Sidhu
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Francisco Reyes
• Re: Maintenance question / DB size anomaly...
  • From: Kurt Overberg
• Re: PostgreSQL Configuration Tool for Dummies
  • From: PFC
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Richard Huxton
• Re: Maintenance question / DB size anomaly...
  • From: Richard Huxton
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Campbell, Lance
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Francisco Reyes
• Re: PostgreSQL Configuration Tool for Dummies
  • From: Richard Huxton
• Re: Maintenance question / DB size anomaly...
  • From: Kurt Overberg
• PostgreSQL Configuration Tool for Dummies
  • From: Campbell, Lance
• Re: Regarding Timezone
  • From: Tom Lane
• Re: Performance query about large tables, lots of concurrent access
  • From: Gregory Stark
• Re: Maintenance question / DB size anomaly...
  • From: Tom Lane
• Re: Performance query about large tables, lots of concurrent access
  • From: Alvaro Herrera
• Re: Performance query about large tables, lots of concurrent access
  • From: Francisco Reyes
• Re: Performance query about large tables, lots of concurrent access
  • From: Tom Lane
• Re: Performance query about large tables, lots of concurrent access
  • From: Gregory Stark
• Re: Performance query about large tables, lots of concurrent access
  • From: Francisco Reyes
• Re: Performance query about large tables, lots of concurrent access
  • From: Francisco Reyes
• Re: Hardware suggestions
  • From: Francisco Reyes
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: Maintenance question / DB size anomaly...
  • From: Chris Browne
• Re: Performance query about large tables, lots of concurrent access
  • From: Tom Lane
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: Performance query about large tables, lots of concurrent access
  • From: Tom Lane
• Re: Performance query about large tables, lots of concurrent access
  • From: Kurt Overberg
• Re: Performance query about large tables, lots of concurrent access
  • From: Gregory Stark
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: Performance query about large tables, lots of concurrent access
  • From: Bill Moran
• Re: Maintenance question / DB size anomaly...
  • From: Richard Huxton
• Re: Maintenance question / DB size anomaly...
  • From: Tom Lane
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Maintenance question / DB size anomaly...
  • From: Kurt Overberg
• Re: Performance query about large tables, lots of concurrent access
  • From: Mark Lewis
• Re: Performance query about large tables, lots of concurrent access
  • From: Alvaro Herrera
• Re: Performance query about large tables, lots of concurrent access
  • From: Gregory Stark
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: Performance query about large tables, lots of concurrent access
  • From: Alvaro Herrera
• Re: [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: Jim Nasby
• Re: Volunteer to build a configuration tool
  • From: Ray Stell
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: dbt2 NOTPM numbers
  • From: Jim Nasby
• Re: Hardware suggestions
  • From: Claus Guttesen
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Hardware suggestions
  • From: christian . braun
• Re: Regarding Timezone
  • From: A. Kretschmer
• Re: Regarding Timezone
  • From: Heikki Linnakangas
• Regarding Timezone
  • From: soni de
• Re: Performance query about large tables, lots of concurrent access
  • From: PFC
• Re: Performance query about large tables, lots of concurrent access
  • From: Tom Lane
• Re: Volunteer to build a configuration tool
  • From: Greg Smith
• Re: Volunteer to build a configuration tool
  • From: Steve Atkins
• Re: Volunteer to build a configuration tool
  • From: david
• Re: Volunteer to build a configuration tool
  • From: Greg Smith
• Re: Parsing VACUUM VERBOSE
  • From: Guillaume Smet
• Re: Parsing VACUUM VERBOSE
  • From: Guillaume Smet
• Re: Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Performance query about large tables, lots of concurrent access
  • From: Karl Wright
• Re: Volunteer to build a configuration tool
  • From: James Neethling
• Re: Replication
  • From: Markus Schiltknecht
• Re: [GENERAL] [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: Andrew Sullivan
• Re: [GENERAL] [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: Andrew Sullivan
• Re: [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: Andreas Kostyrka
• Re: Replication
  • From: Craig James
• Re: [GENERAL] [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: Jonah H. Harris
• Re: [DOCS] Volunteer to build a configuration tool
  • From: Y Sidhu
• Re: [GENERAL] [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: Andrew Sullivan
• Re: Parsing VACUUM VERBOSE
  • From: Y Sidhu
• Re: [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: Andreas Kostyrka
• Re: [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: Jonah H. Harris
• Re: [GENERAL] [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: Andreas Kostyrka
• Re: [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: Joshua D. Drake
• Re: [ADMIN] Postgres VS Oracle
  • From: Andreas Kostyrka
• Re: Replication
  • From: Markus Schiltknecht
• Re: [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: Jonah H. Harris
• Re: [GENERAL] [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: Joshua D. Drake
• Re: [DOCS] Volunteer to build a configuration tool
  • From: Campbell, Lance
• Re: [GENERAL] [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: PFC
• Re: [pgsql-advocacy] [ADMIN] Postgres VS Oracle
  • From: Joshua D. Drake
• Re: [ADMIN] Postgres VS Oracle
  • From: Jonah H. Harris
• Re: [ADMIN] Postgres VS Oracle
  • From: Andreas Kostyrka
• Re: [ADMIN] Postgres VS Oracle
  • From: Jonah H. Harris
• Volunteer to build a configuration tool
  • From: Campbell, Lance
• Re: Parsing VACUUM VERBOSE
  • From: Sabin Coanda
• Re: Database size
  • From: J6M
• Re: determining maxsize for character varying
  • From: Tom Lane
• Re: determining maxsize for character varying
  • From: Ragnar
• Re: determining maxsize for character varying
  • From: okparanoid
• Re: determining maxsize for character varying
  • From: Andreas Kretschmer
• determining maxsize for character varying
  • From: okparanoid
• Re: Variable (degrading) perfomance
  • From: Merlin Moncure
• Re: Replication
  • From: Gábriel Ákos
• Re: Database size
  • From: Francisco Reyes
• Re: Replication
  • From: Devrim GÜNDÜZ
• Re: Replication
  • From: Merlin Moncure
• Re: Replication
  • From: Alexander Staubo
• Re: Replication
  • From: Andreas Kostyrka
• Re: Database size
  • From: A. Kretschmer
• Re: Replication
  • From: Eugene Ogurtsov
• Re: Replication
  • From: Joshua D. Drake
• Re: Replication
  • From: Craig James
• Re: Replication
  • From: Andreas Kostyrka
• Re: Replication
  • From: Craig James
• Re: Replication
  • From: Kevin Grittner
• Re: Replication
  • From: Alexander Staubo
• Re: Replication
  • From: Ben
• Re: Replication
  • From: Joshua D. Drake
• Replication
  • From: Craig James
• Replication
  • From: Craig A. James
• Re: Parsing VACUUM VERBOSE
  • From: Y Sidhu
• Re: Parsing VACUUM VERBOSE
  • From: Guillaume Smet
• Re: Parsing VACUUM VERBOSE
  • From: Y Sidhu
• Re: Parsing VACUUM VERBOSE
  • From: Sabin Coanda
• Re: [PG 8.1.0 / AIX 5.3] Vacuum processes freezing
  • From: Simon Riggs
• Re: Parsing VACUUM VERBOSE
  • From: Dimitri Fontaine
• Re: Parsing VACUUM VERBOSE
  • From: Guillaume Smet
• Re: Best use of second controller with faster disks?
  • From: Vivek Khera
• Parsing VACUUM VERBOSE
  • From: Sabin Coanda
• Re: Best use of second controller with faster disks?
  • From: Francisco Reyes
• Re: Update table performance problem
  • From: Mark Makarowsky
• Re: Performance Testing Utility
  • From: Vivek Khera
• Re: Update table performance problem
  • From: Tom Lane
• Re: [PG 8.1.0 / AIX 5.3] Vacuum processes freezing
  • From: Tom Lane
• Update table performance problem
  • From: Mark Makarowsky
• Re: dbt2 NOTPM numbers
  • From: Mark Wong
• [PG 8.1.0 / AIX 5.3] Vacuum processes freezing
  • From: RESTOUX, Loïc
• Re: dbt2 NOTPM numbers
  • From: Markus Schiltknecht
• Re: dbt2 NOTPM numbers
  • From: Mark Wong
• Re: WAL shipping and ever expanding pg_xlog
  • From: Michael Dengler
• Re: WAL shipping and ever expanding pg_xlog
  • From: Merlin Moncure
• Re: VACUUM vs auto-vacuum daemon
  • From: Joshua D. Drake
• Re: VACUUM vs auto-vacuum daemon
  • From: Bill Moran
• Re: Best use of second controller with faster disks?
  • From: Vivek Khera
• Re: WAL shipping and ever expanding pg_xlog
  • From: Michael Dengler
• WAL shipping and ever expanding pg_xlog
  • From: Michael Dengler
• Re: Optimize slow query
  • From: Cédric Villemain
• Re: Optimize slow query
  • From: Tyler Durden
• Optimize slow query
  • From: Tyler Durden
• Re: Performance Testing Utility
  • From: Tobias Brox
• Re: Performance Testing Utility
  • From: Heikki Linnakangas
• Performance Testing Utility
  • From: Christo Du Preez
• Re: Best use of second controller with faster disks?
  • From: Francisco Reyes
• Re: test / live environment, major performance difference
  • From: Tom Lane
• Re: performance drop on 8.2.4, reverting to 8.1.4
  • From: Steven Flatt
• Re: Best use of second controller with faster disks?
  • From: Vivek Khera
• Re: Variable (degrading) performance
  • From: Heikki Linnakangas
• Re: test / live environment, major performance difference
  • From: Christo Du Preez
• Re: test / live environment, major performance difference
  • From: Tom Lane
• Re: test / live environment, major performance difference
  • From: Christo Du Preez
• Re: VACUUM vs auto-vacuum daemon
  • From: Sabin Coanda
• Re: VACUUM vs auto-vacuum daemon
  • From: Bill Moran
• Re: test / live environment, major performance difference
  • From: Tom Lane
• Re: VACUUM vs auto-vacuum daemon
  • From: Alvaro Herrera
• Re: Best way to delete unreferenced rows?
  • From: Tyrrill, Ed
• VACUUM vs auto-vacuum daemon
  • From: Sabin Coanda
• Re: Variable (degrading) performance
  • From: Vladimir Stankovic
• Re: test / live environment, major performance difference
  • From: Steinar H. Gunderson
• Re: How much memory PostgreSQL is going to use?
  • From: Bill Moran
• Re: test / live environment, major performance difference
  • From: Steinar H. Gunderson
• Re: test / live environment, major performance difference
  • From: Dave Dutcher
• How much memory PostgreSQL is going to use?
  • From: Arnau
• Re: test / live environment, major performance difference
  • From: Alvaro Herrera
• Re: test / live environment, major performance difference
  • From: Christo Du Preez
• Re: test / live environment, major performance difference
  • From: Gregory Stark
• Re: test / live environment, major performance difference
  • From: Michael Glaesemann
• Re: test / live environment, major performance difference
  • From: Reid Thompson
• Re: test / live environment, major performance difference
  • From: Christo Du Preez
• Re: test / live environment, major performance difference
  • From: Christo Du Preez
• Re: test / live environment, major performance difference
  • From: Christo Du Preez
• Best use of second controller with faster disks?
  • From: Francisco Reyes
• Re: Best way to delete unreferenced rows?
  • From: Ed Tyrrill
• Re: test / live environment, major performance difference
  • From: Craig James
• Re: How much ram is too much
  • From: Dave Cramer
• Re: Variable (degrading) performance
  • From: Heikki Linnakangas
• Re: How much ram is too much
  • From: Dave Cramer
• Variable (degrading) performance
  • From: Vladimir Stankovic
• Re: test / live environment, major performance difference
  • From: Dave Dutcher
• Re: test / live environment, major performance difference
  • From: Ansgar -59cobalt- Wiechers
• Re: dbt2 NOTPM numbers
  • From: Markus Schiltknecht
• Re: Best way to delete unreferenced rows?
  • From: Craig James
• test / live environment, major performance difference
  • From: Christo Du Preez
• Re: dbt2 NOTPM numbers
  • From: Heikki Linnakangas
• Re: How much ram is too much
  • From: Andrew Sullivan
• Re: dbt2 NOTPM numbers
  • From: Markus Schiltknecht
• Re: How much ram is too much
  • From: Dave Cramer
• Re: Vacuum takes forever
  • From: Jim Nasby
• Re: How much ram is too much
  • From: Jim Nasby
• Re: dbt2 NOTPM numbers
  • From: Jim Nasby
• Re: pg_statistic doesnt contain details for specific table
  • From: Michael Fuhr
• Variable (degrading) perfomance
  • From: Vladimir Stankovic
• Re: pg_statistic doesnt contain details for specific table
  • From: Nimesh Satam
• Re: pg_statistic doesnt contain details for specific table
  • From: Michael Fuhr
• Re: How much ram is too much
  • From: Dave Cramer
• Re: pg_statistic doesnt contain details for specific table
  • From: Nimesh Satam
• Re: pg_statistic doesnt contain details for specific table
  • From: Heikki Linnakangas
• pg_statistic doesnt contain details for specific table
  • From: Nimesh Satam
• Re: [OT] Re: How much ram is too much
  • From: Andreas Kostyrka
• Re: How much ram is too much
  • From: Guy Rouillier
• Re: [OT] Re: How much ram is too much
  • From: Zoltan Boszormenyi
• Re: [OT] Re: How much ram is too much
  • From: mark
• Re: [OT] Re: How much ram is too much
  • From: Zoltan Boszormenyi
• Re: [OT] Re: How much ram is too much
  • From: Dave Cramer
• Re: [OT] Re: How much ram is too much
  • From: Joshua D. Drake
• Re: Please help me understand these numbers
  • From: Chris Hoover
• Re: How much ram is too much
  • From: Joshua D. Drake
• [OT] Re: How much ram is too much
  • From: Zoltan Boszormenyi
• Re: Please help me understand these numbers
  • From: Bill Moran
• Re: How much ram is too much
  • From: david
• Re: How much ram is too much
  • From: Dave Cramer
• Re: Please help me understand these numbers
  • From: Chris Hoover
• Re: dbt2 NOTPM numbers
  • From: Mark Wong
• Re: How much ram is too much
  • From: Ben
• Re: Best way to delete unreferenced rows?
  • From: Tyrrill, Ed
• Re: How much ram is too much
  • From: Guy Rouillier
• How much ram is too much
  • From: Dave Cramer
• Re: Please help me understand these numbers
  • From: Bill Moran
• Please help me understand these numbers
  • From: Chris Hoover
• Re: [ADMIN] reclaiming disk space after major updates
  • From: Andrew Sullivan
• Re: [ADMIN] reclaiming disk space after major updates
  • From: Dan Harris
• Re: VERY slow queries at random
  • From: Kristo Kaiv
• Database size
  • From: choksi
• Re: Getting Slow
  • From: Alvaro Herrera
• Re: Getting Slow
  • From: Tom Lane
• Re: performance drop on 8.2.4, reverting to 8.1.4
  • From: Tom Lane
• Re: performance drop on 8.2.4, reverting to 8.1.4
  • From: Alvaro Herrera
• Re: performance drop on 8.2.4, reverting to 8.1.4
  • From: Tom Lane
• Re: Weird 8.2.4 performance
  • From: Joshua D. Drake
• Re: Weird 8.2.4 performance
  • From: Mark Kirkwood
• Re: Best way to delete unreferenced rows?
  • From: Craig James
• Best way to delete unreferenced rows?
  • From: Tyrrill, Ed
• Re: VERY slow queries at random
  • From: Greg Smith
• Re: Getting Slow
  • From: Greg Smith
• Re: Getting Slow
  • From: Alvaro Herrera
• Re: Getting Slow
  • From: Steinar H. Gunderson
• Re: Getting Slow
  • From: Andrew Sullivan
• Getting Slow
  • From: Joe Lester
• Re: performance drop on 8.2.4, reverting to 8.1.4
  • From: Steven Flatt
• How Are The Variables Related?
  • From: Y Sidhu
• Re: VERY slow queries at random
  • From: Alvaro Herrera
• Re: VERY slow queries at random
  • From: Andrew Sullivan
• Re: VERY slow queries at random
  • From: Gunther Mayer
• Re: VERY slow queries at random
  • From: Gunther Mayer
• Re: VERY slow queries at random
  • From: Gunther Mayer
• Re: {Spam} Re: Weird 8.2.4 performance
  • From: Dimitri Fontaine
• Re: Weird 8.2.4 performance
  • From: Tom Lane
• Re: Weird 8.2.4 performance
  • From: Steinar H. Gunderson
• Re: Weird 8.2.4 performance
  • From: Kurt Overberg
• Re: Weird 8.2.4 performance
  • From: Mark Kirkwood
• Re: Weird 8.2.4 performance
  • From: Steinar H. Gunderson
• copy from performance on large tables with indexes
  • From: Marc Mamin
• Re: Weird 8.2.4 performance
  • From: Steinar H. Gunderson
• Re: Weird 8.2.4 performance
  • From: Richard Huxton
• Re: VERY slow queries at random
  • From: Kristo Kaiv
• Re: Thousands of tables versus on table?
  • From: david
• Re: LIKE search and performance
  • From: mark
• Re: Weird 8.2.4 performance
  • From: Michael Glaesemann
• Re: Weird 8.2.4 performance
  • From: Mark Kirkwood
• Weird 8.2.4 performance
  • From: Kurt Overberg
• Re: LIKE search and performance
  • From: James Mansion
• Re: Is this true?
  • From: Jeff Davis
• Re: VERY slow queries at random
  • From: Scott Marlowe
• Is this true?
  • From: Chris Hoover
• Re: Thousands of tables versus on table?
  • From: Jonah H. Harris
• Re: Thousands of tables versus on table?
  • From: Craig James
• Re: control of benchmarks (was: Thousands of tables)
  • From: Jonah H. Harris
• Re: VERY slow queries at random
  • From: Andrew Sullivan
• control of benchmarks (was: Thousands of tables)
  • From: Andrew Sullivan
• Re: Thousands of tables versus on table?
  • From: Jonah H. Harris
• Re: Thousands of tables versus on table?
  • From: Andrew Sullivan
• VERY slow queries at random
  • From: Gunther Mayer
• Re: Thousands of tables versus on table?
  • From: Andrew Sullivan
• Re: Thousands of tables versus on table?
  • From: Jonah H. Harris
• Re: Thousands of tables versus on table?
  • From: Jonah H. Harris
• Re: Thousands of tables versus on table?
  • From: Craig James
• Re: Thousands of tables versus on table?
  • From: Scott Marlowe
• Re: Thousands of tables versus on table?
  • From: Craig James
• Re: Thousands of tables versus on table?
  • From: Scott Marlowe
• Re: Thousands of tables versus on table?
  • From: Scott Marlowe
• Re: weird query plan
  • From: Tom Lane
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Douglas J Hunley
• Re: different query plan because different limit # (Re: weird query plan)
  • From: Gregory Stark
• Re: different query plan because different limit # (Re: weird query plan)
  • From: weiping
• Re: Thousands of tables versus on table?
  • From: Heikki Linnakangas
• different query plan because different limit # (Re: weird query plan)
  • From: weiping
• Re: weird query plan
  • From: weiping
• weird query plan
  • From: weiping
• Re: Thousands of tables versus on table?
  • From: david
• Re: Thousands of tables versus on table?
  • From: david
• Re: performance drop on 8.2.4, reverting to 8.1.4
  • From: Tom Lane
• Re: Thousands of tables versus on table?
  • From: Steinar H. Gunderson
• Re: Thousands of tables versus on table?
  • From: Tom Lane
• Re: performance drop on 8.2.4, reverting to 8.1.4
  • From: Steinar H. Gunderson
• Re: performance drop on 8.2.4, reverting to 8.1.4
  • From: Steven Flatt
• Re: Thousands of tables versus on table?
  • From: david
• Re: Append table
  • From: Chander Ganesan
• Re: Thousands of tables versus on table?
  • From: Scott Marlowe
• Re: Thousands of tables versus on table?
  • From: Gregory Stark
• Re: Thousands of tables versus on table?
  • From: Scott Marlowe
• Re: Thousands of tables versus on table?
  • From: Thomas Andrews
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Hanu Kurubar
• Re: Thousands of tables versus on table?
  • From: Scott Marlowe
• Re: dbt2 NOTPM numbers
  • From: Greg Smith
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Douglas J Hunley
• Re: dbt2 NOTPM numbers
  • From: Markus Schiltknecht
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Douglas J Hunley
• Re: dbt2 NOTPM numbers
  • From: Heikki Linnakangas
• Re: dbt2 NOTPM numbers
  • From: Markus Schiltknecht
• Re: Performance Problem
  • From: Gregory Stark
• Re: Performance Problem
  • From: Steinar H. Gunderson
• Performance Problem
  • From: Gauri Kanekar
• Performance Problem
  • From: Gauri Kanekar
• Re: Question about SQL performance
  • From: Richard Huxton
• Re: Question about SQL performance
  • From: mark
• Re: Question about SQL performance
  • From: PFC
• Question about SQL performance
  • From: Jason Lustig
• postgresql running on a virtual cluster
  • From: Dave Cramer
• Re: PostgreSQL not fully utilizing system resources?
  • From: Greg Smith
• Re: PostgreSQL not fully utilizing system resources?
  • From: Bill Moran
• Re: Thousands of tables versus on table?
  • From: david
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Heikki Linnakangas
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Gregory Stark
• Re: dbt2 NOTPM numbers
  • From: Heikki Linnakangas
• Re: Thousands of tables versus on table?
  • From: Scott Marlowe
• Re: Thousands of tables versus on table?
  • From: Gregory Stark
• Re: Thousands of tables versus on table?
  • From: PFC
• Re: Thousands of tables versus on table?
  • From: Thomas Andrews
• Re: Thousands of tables versus on table?
  • From: Y Sidhu
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Douglas J Hunley
• Re: Thousands of tables versus on table?
  • From: Thomas Andrews
• Re: Thousands of tables versus on table?
  • From: Gregory Stark
• Re: Thousands of tables versus on table?
  • From: Thomas Andrews
• Re: dbt2 NOTPM numbers
  • From: Markus Schiltknecht
• Re: Thousands of tables versus on table?
  • From: Thomas Andrews
• Re: Thousands of tables versus on table?
  • From: Mark Lewis
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Alvaro Herrera
• Thousands of tables versus on table?
  • From: Thomas Andrews
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Douglas J Hunley
• Re: dbt2 NOTPM numbers
  • From: PFC
• Re: dbt2 NOTPM numbers
  • From: Markus Schiltknecht
• Re: dbt2 NOTPM numbers
  • From: Heikki Linnakangas
• dbt2 NOTPM numbers
  • From: Markus Schiltknecht
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Reid Thompson
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Luke Lonergan
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Heikki Linnakangas
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Douglas J Hunley
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Tom Lane
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Greg Smith
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Luke Lonergan
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Douglas J Hunley
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Douglas J Hunley
• Re: Append table
  • From: Hanu Kurubar
• Re: Postgres Benchmark Results
  • From: Josh Berkus
• Re: Append table
  • From: Gregory Stark
• Re: Append table
  • From: Arjen van der Meijden
• Re: Append table
  • From: Hanu Kurubar
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Kenneth Marshall
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Stefan Kaltenbrunner
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Tom Lane
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Michael Fuhr
• Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Rafael Martinez
• upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  • From: Douglas J Hunley
• Re: Autodetect of software RAID1+0 fails
  • From: Luke Lonergan
• Re: Autodetect of software RAID1+0 fails
  • From: mark
• Re: Autodetect of software RAID1+0 fails
  • From: Steinar H. Gunderson
• Re: Autodetect of software RAID1+0 fails
  • From: Luke Lonergan
• PostgreSQL not fully utilizing system resources?
  • From: Gregory Stewart
• Re: Autodetect of software RAID1+0 fails
  • From: Dimitri
• Autodetect of software RAID1+0 fails
  • From: Craig James
• Re: Seq Scan
  • From: Michael Glaesemann
• Re: Seq Scan
  • From: Dan Harris
• Seq Scan
  • From: Tyler Durden
• [no subject]
  • From: Unknown
• Re: Performance Woes
  • From: Jeff Davis
• Re: Performance Woes
  • From: Joshua D. Drake
• Re: Performance Woes
  • From: Ralph Mason
• Re: Performance Woes
  • From: Joshua D. Drake
• Re: Performance Woes
  • From: CAJ CAJ
• Performance Woes
  • From: Ralph Mason
• Vacuum Times - Verbose and maintenance_work_mem
  • From: Y Sidhu
• Re: Cannot make GIN intarray index be used by the planner
  • From: Tom Lane
• Re: Cannot make GIN intarray index be used by the planner
  • From: Valentine Gogichashvili
• Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2
  • From: david
• Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2
  • From: Jignesh Shah
• Re: Nested loops overpriced
  • From: Tom Lane
• Re: How to Find Cause of Long Vacuum Times - NOOB Question
  • From: Jim Nasby
• Re: Best OS for Postgres 8.2
  • From: Jim Nasby
• Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2
  • From: Alvaro Herrera
• ZFS and Postgresql - WASRe: Best OS for Postgres 8.2
  • From: Jignesh Shah
• Re: Nested loops overpriced
  • From: Peter Eisentraut
• Re: Apparently useless bitmap scans
  • From: Tom Lane
• Re: Apparently useless bitmap scans
  • From: Peter Eisentraut
• Re: Nested loops overpriced
  • From: Daniel Cristian Cruz
• Re: Apparently useless bitmap scans
  • From: Tom Lane
• Re: Nested loops overpriced
  • From: Gregory Stark
• Re: Poor performance with queries using clause: sth IN (...)
  • From: Gregory Stark
• Re: Apparently useless bitmap scans
  • From: Alvaro Herrera
• Re: Throttling PostgreSQL's CPU usage
  • From: Carlos Moreno
• Re: Nested loops overpriced
  • From: Tom Lane
• Re: Cannot make GIN intarray index be used by the planner
  • From: Oleg Bartunov
• Re: Throttling PostgreSQL's CPU usage
  • From: Daniel Griscom
• Re: Nested loops overpriced
  • From: Daniel Cristian Cruz
• Re: Cannot make GIN intarray index be used by the planner
  • From: Valentine Gogichashvili
• Re: Cannot make GIN intarray index be used by the planner
  • From: Oleg Bartunov
• Poor performance with queries using clause: sth IN (...)
  • From: Andrzej Zawadzki
• Cannot make GIN intarray index be used by the planner
  • From: Valentine Gogichashvili
• Apparently useless bitmap scans
  • From: Peter Eisentraut
• Re: Nested loops overpriced
  • From: Peter Eisentraut
• Re: FW:
  • From: Gregory Stark
• Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
  • From: Gregory Stark
• Re: Best OS for Postgres 8.2
  • From: david
• Re: Best OS for Postgres 8.2
  • From: Steinar H. Gunderson
• Re: estimating the need for VACUUM FULL and REINDEX
  • From: Guillaume Cottenceau
• Re: Best OS for Postgres 8.2
  • From: david
• Re: Throttling PostgreSQL's CPU usage
  • From: Magnus Hagander
• Re:
  • From: Robert Treat
• Re:
  • From: Greg Smith
• Re: Throttling PostgreSQL's CPU usage
  • From: Luke Lonergan
• Re: Best OS for Postgres 8.2
  • From: Greg Smith
• Re: Best OS for Postgres 8.2
  • From: Greg Smith
• Re: FW:
  • From: david
• FW:
  • From: Orhan Aglagul
• FW:
  • From: Orhan Aglagul
• FW:
  • From: Orhan Aglagul
• Re:
  • From: Orhan Aglagul
• Re:
  • From: Scott Marlowe
• Re:
  • From: Scott Marlowe
• Re:
  • From: Carlos Moreno
• Re:
  • From: Joshua D. Drake
• Re:
  • From: Dan Harris
• [no subject]
  • From: Orhan Aglagul
• Re: Throttling PostgreSQL's CPU usage
  • From: david
• Re: Throttling PostgreSQL's CPU usage
  • From: david
• Re: Throttling PostgreSQL's CPU usage
  • From: Carlos Moreno
• Re: Throttling PostgreSQL's CPU usage
  • From: Steinar H. Gunderson
• Re: Throttling PostgreSQL's CPU usage
  • From: Daniel Griscom
• Re: Throttling PostgreSQL's CPU usage
  • From: Carlos Moreno
• Re: Throttling PostgreSQL's CPU usage
  • From: Steinar H. Gunderson
• Re: Throttling PostgreSQL's CPU usage
  • From: Joshua D. Drake
• Re: Throttling PostgreSQL's CPU usage
  • From: Carlos Moreno
• Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
  • From: Alvaro Herrera
• Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
  • From: Steinar H. Gunderson
• Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
  • From: Alvaro Herrera
• Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
  • From: david
• What's The Difference Between VACUUM and VACUUM ANALYZE?
  • From: Y Sidhu
• Re: Throttling PostgreSQL's CPU usage
  • From: Mark Lewis
• Re: Throttling PostgreSQL's CPU usage
  • From: david
• Re: Throttling PostgreSQL's CPU usage
  • From: Bill Moran
• Re: Throttling PostgreSQL's CPU usage
  • From: Steinar H. Gunderson
• Re: Best OS for Postgres 8.2
  • From: Charles Sprickman
• Throttling PostgreSQL's CPU usage
  • From: Daniel Griscom
• Re: DISTINCT Question
  • From: Scott Marlowe