• Text Size: Normal / Large
• Donate
• Contact

Section Navigation

• Community
• Mailing Lists
  • Subscribe
  • User lists
    • pgsql-admin
    • pgsql-advocacy
    • pgsql-announce
    • pgsql-bugs
    • pgsql-docs
    • pgsql-cygwin
    • pgsql-general
    • pgsql-interfaces
    • pgsql-jdbc
    • pgsql-jobs
    • pgsql-novice
    • pgsql-odbc
    • pgsql -performance
    • pgsql-php
    • pgsql-ports
    • pgsql-sql
  • Developer lists
  • Regional lists
  • Project lists
  • User groups
  • Inactive lists
• IRC
• In The Real World
• International Sites
• Propaganda
• Resources
• Weekly News

pgsql-performance 2007-09 Chronological Index (1/3)

• Thread Index
• [Prev Page]
• [Next Page]

• 29 September 2007
  • Re: Non-blocking vacuum full Heikki Linnakangas
  • Re: Non-blocking vacuum full Ron Mayer
• 28 September 2007
  • Re: OOM Errors as a result of table inheritance and a bad plan(?) Tom Lane
  • Re: Non-blocking vacuum full Heikki Linnakangas
  • Non-blocking vacuum full Peter Schuller
  • OOM Errors as a result of table inheritance and a bad plan(?) Arctic Toucan
  • Re: sequence query performance issues Peter Koczan
  • Re: Postgres 7.4.2 hanging when vacuum full is run Scott Marlowe
  • Re: Postgres 7.4.2 hanging when vacuum full is run Vivek Khera
  • Re: sequence query performance issues Richard Huxton
  • Postgres 7.4.2 hanging when vacuum full is run Radhika S
  • Re: sequence query performance issues Tom Lane
  • Re: Tuning for warm standby Merlin Moncure
  • Re: Searching for the cause of a bad plan Csaba Nagy
  • Re: Searching for the cause of a bad plan Csaba Nagy
  • Re: sequence query performance issues Richard Huxton
• 27 September 2007
  • sequence query performance issues Peter Koczan
  • Re: Searching for the cause of a bad plan Ron Mayer
  • Tuning for warm standby Kevin Kempter
  • Re: Searching for the cause of a bad plan Simon Riggs
  • Re: Searching for the cause of a bad plan Csaba Nagy
  • Re: Searching for the cause of a bad plan Tom Lane
  • Re: Difference in query plan when using = or > in where clause Heikki Linnakangas
  • Re: Searching for the cause of a bad plan Csaba Nagy
  • Re: REPOST: Nested loops row estimates always too high Ow Mun Heng
• 26 September 2007
  • Difference in query plan when using = or > in where clause Radhika S
  • Re: Incorrect row estimates in plan? pgdba
  • Re: Incorrect row estimates in plan? Tom Lane
  • Re: Incorrect row estimates in plan? pgdba
  • Re: Searching for the cause of a bad plan Tom Lane
  • Re: Searching for the cause of a bad plan Csaba Nagy
  • Re: Incorrect row estimates in plan? Tom Lane
  • Incorrect row estimates in plan? pgdba
  • Re: Effects of cascading references in foreign keys Bruce Momjian
  • Re: REPOST: Nested loops row estimates always too high Tom Lane
  • Re: REPOST: Nested loops row estimates always too high Ow Mun Heng
• 25 September 2007
  • Re: query io stats and finding a slow query Bryan Murphy
  • Re: query io stats and finding a slow query Kamen Stanev
  • Re: Attempting to disable count triggers on cleanup Dave Cramer
  • Re: Attempting to disable count triggers on cleanup hubert depesz lubaczewski
  • Attempting to disable count triggers on cleanup Dave Cramer
  • Re: REPOST: Nested loops row estimates always too high Steinar H. Gunderson
  • Re: REPOST: Nested loops row estimates always too high Ow Mun Heng
  • Re: REPOST: Nested loops row estimates always too high Carlo Stonebanks
  • Re: REPOST: Nested loops row estimates always too high Ow Mun Heng
• 24 September 2007
  • Re: Acceptable level of over-estimation? Gregory Stark
  • Acceptable level of over-estimation? Carlo Stonebanks
  • Re: REPOST: Nested loops row estimates always too high Carlo Stonebanks
  • Re: Searching for the cause of a bad plan Simon Riggs
  • Re: TEXT or LONGTEXT? Niklas Johansson
  • Re: select count(*) performance (vacuum did not help) Dave Dutcher
  • Re: select count(*) performance (vacuum did not help) Csaba Nagy
  • Re: TEXT or LONGTEXT? Alexander Staubo
  • Re: select count(*) performance (vacuum did not help) Bill Moran
  • TEXT or LONGTEXT? Fabiola Fernández
  • Re: select count(*) performance (vacuum did not help) Gábor Farkas
  • Re: select count(*) performance (vacuum did not help) Heikki Linnakangas
  • Re: select count(*) performance (vacuum did not help) Gábor Farkas
  • Re: select count(*) performance (vacuum did not help) Heikki Linnakangas
  • Re: select count(*) performance (vacuum did not help) Pavan Deolasee
  • Re: Low CPU Usage brauagustin-susc
  • select count(*) performance (vacuum did not help) Gábor Farkas
  • Re: Searching for the cause of a bad plan Csaba Nagy
  • Re: Low CPU Usage brauagustin-susc
  • Re: Searching for the cause of a bad plan Simon Riggs
  • [OT] Re: [Again] Postgres performance problem Ow Mun Heng
  • Re: REPOST: Nested loops row estimates always too high Ow Mun Heng
• 23 September 2007
  • Re: Possible explanations for catastrophic performance deterioration? Gregory Stark
  • Re: Possible explanations for catastrophic performance deterioration? Jonah H. Harris
  • Re: Possible explanations for catastrophic performance deterioration? Carlos Moreno
  • Re: Possible explanations for catastrophic performance deterioration? Alvaro Herrera
  • Re: Possible explanations for catastrophic performance deterioration? Carlos Moreno
  • Re: Possible explanations for catastrophic performace deterioration? Jonah H. Harris
  • Re: Possible explanations for catastrophic performace deterioration? Carlos Moreno
  • Re: Possible explanations for catastrophic performace deterioration? Alvaro Herrera
  • Re: Possible explanations for catastrophic performace deterioration? Carlos Moreno
  • Re: Possible explanations for catastrophic performace deterioration? Tom Lane
  • zero value in statistics collector's result Yinan Li
  • Re: Possible explanations for catastrophic performace deterioration? Jonah H. Harris
  • Possible explanations for catastrophic performace deterioration? Carlos Moreno
• 22 September 2007
  • Re: Query planner unaware of possibly best plan Denes Daniel
  • Re: Low CPU Usage Greg Smith
  • Re: Query planner unaware of possibly best plan Tom Lane
  • Re: Query planner unaware of possibly best plan Denes Daniel
• 21 September 2007
  • Re: Searching for the cause of a bad plan Tom Lane
  • Re: Low CPU Usage brauagustin-susc
  • Re: Low CPU Usage Craig James
  • Re: Low CPU Usage Kevin Grittner
  • Re: Low CPU Usage Dave Dutcher
  • Re: Low CPU Usage Luiz K. Matsumura
  • Re: Query planner unaware of possibly best plan Denes Daniel
  • Re: Query planner unaware of possibly best plan Alvaro Herrera
  • Re: Low CPU Usage brauagustin-susc
  • Re: Query planner unaware of possibly best plan Denes Daniel
  • Re: Linux mis-reporting memory Greg Smith
  • Re: Low CPU Usage Bill Moran
  • Re: Low CPU Usage brauagustin-susc
  • Re: Searching for the cause of a bad plan Simon Riggs
  • Re: Low CPU Usage Bill Moran
  • Re: Low CPU Usage brauagustin-susc
  • Re: Searching for the cause of a bad plan Tom Lane
  • Re: Low CPU Usage Kevin Grittner
  • Re: Low CPU Usage brauagustin-susc
  • Re: Query planner unaware of possibly best plan Simon Riggs
  • Re: Searching for the cause of a bad plan Simon Riggs
  • Re: Low CPU Usage brauagustin-susc
  • Re: Searching for the cause of a bad plan Simon Riggs
  • Re: query io stats and finding a slow query Kevin Grittner
  • Re: Searching for the cause of a bad plan Tom Lane
  • Re: Searching for the cause of a bad plan Csaba Nagy
  • Query planner unaware of possibly best plan Denes Daniel
  • Re: Searching for the cause of a bad plan Csaba Nagy
  • Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Dave Dutcher
  • Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Jeff Harris
  • Re: Searching for the cause of a bad plan Simon Riggs
  • Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Bill Moran
  • Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211
  • Re: Searching for the cause of a bad plan Csaba Nagy
  • Re: Searching for the cause of a bad plan Simon Riggs
  • Re: Linux mis-reporting memory Csaba Nagy
  • Re: Searching for the cause of a bad plan Csaba Nagy
  • Re: Linux mis-reporting memory Simon Riggs
  • Re: Searching for the cause of a bad plan Simon Riggs
  • Re: Linux mis-reporting memory Heikki Linnakangas
  • Re: Linux mis-reporting memory Csaba Nagy
  • Searching for the cause of a bad plan Csaba Nagy
  • Re: Linux mis-reporting memory Gregory Stark
  • Re: Linux mis-reporting memory Dimitri Fontaine
  • Re: Linux mis-reporting memory Csaba Nagy
  • Re: Linux mis-reporting memory Gregory Stark
  • Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! db
  • Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211
  • Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Scott Marlowe
  • Re: Linux mis-reporting memory Adam Tauno Williams
• 20 September 2007
  • Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211
  • Re: Linux mis-reporting memory Tom Lane
  • Linux mis-reporting memory Decibel!
  • query io stats and finding a slow query Kamen Stanev
  • Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Scott Marlowe
  • Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Scott Marlowe
  • Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211
  • Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Carlos Moreno
  • Re: Tablespaces and NFS Carlos Moreno
  • Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211
  • Re: Tablespaces and NFS Peter Koczan
  • Re: Low CPU Usage brauagustin-susc
  • REPOST: Nested loops row estimates always too high Carlo Stonebanks
  • REPOST: Performance improves only after repeated VACUUM/ANALYZE Carlo Stonebanks
  • Re: Tablespaces and NFS Carlos Moreno
  • Re: Low CPU Usage Jean-David Beyer
  • Re: Low CPU Usage brauagustin-susc
• 19 September 2007
  • Re: Tablespaces and NFS Peter Koczan
  • Re: Tablespaces and NFS Craig James
  • Re: Low CPU Usage Scott Marlowe
  • Re: Low CPU Usage brauagustin-susc
  • Re: Low CPU Usage Scott Marlowe
  • Re: Low CPU Usage brauagustin-susc
  • Re: Low CPU Usage Mark Lewis
  • Re: Low CPU Usage Heikki Linnakangas
  • Low CPU Usage brauagustin-susc
  • Tablespaces and NFS Carlos Moreno
  • Re: R: R: DELETE queries slow down Gregory Williamson
  • Re: R: R: DELETE queries slow down Bill Moran
  • R: R: DELETE queries slow down Galantucci Giovanni
• 18 September 2007
  • Nested loops row estimates always too high Carlo Stonebanks
  • Performance improves only after repeated VACUUM/ANALYZE Carlo Stonebanks
  • Re: R: DELETE queries slow down Bill Moran
  • Re: Query works when kludged, but would prefer "best practice" solution Dave Dutcher
  • Re: Regarding COPY command from Postgres 8.2.0 Scott Marlowe
  • Re: Regarding COPY command from Postgres 8.2.0 Evan Carroll
  • Re: Query works when kludged, but would prefer "best practice" solution Tom Lane
  • Re: Index usage when bitwise operator is used valgog
  • R: DELETE queries slow down Galantucci Giovanni
  • Re: Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks
  • Re: Regarding COPY command from Postgres 8.2.0 soni de
  • Re: Query works when kludged, but would prefer "best practice" solution Tom Lane
  • Re: Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks
  • Re: Query works when kludged, but would prefer "best practice" solution Merlin Moncure
  • Re: Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks
  • Re: Query works when kludged, but would prefer "best practice" solution Merlin Moncure

• Thread Index
• [Prev Page]
• [Next Page]