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

Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

Header And Logo

PostgreSQL

|

The world's most advanced open source database.

Site Navigation

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

Last updated: Wed Jan 18 04:16:46 2012
477 messages

Main Index
[Prev Page]
[Next Page]

Non-blocking vacuum full Peter Schuller (Fri 28 18:12)

Re: Non-blocking vacuum full Heikki Linnakangas (Fri 28 19:32)

Re: Non-blocking vacuum full Ron Mayer (Sat 29 02:52)

Re: Non-blocking vacuum full Heikki Linnakangas (Sat 29 08:06)

OOM Errors as a result of table inheritance and a bad plan(?) Arctic Toucan (Fri 28 17:53)

Re: OOM Errors as a result of table inheritance and a bad plan(?) Tom Lane (Fri 28 20:56)

Postgres 7.4.2 hanging when vacuum full is run Radhika S (Fri 28 14:28)

Re: Postgres 7.4.2 hanging when vacuum full is run Vivek Khera (Fri 28 14:53)
Re: Postgres 7.4.2 hanging when vacuum full is run Scott Marlowe (Fri 28 15:28)

sequence query performance issues Peter Koczan (Thu 27 22:04)

Re: sequence query performance issues Richard Huxton (Fri 28 08:06)

Re: sequence query performance issues Tom Lane (Fri 28 14:16)

Re: sequence query performance issues Richard Huxton (Fri 28 14:43)
Re: sequence query performance issues Peter Koczan (Fri 28 17:33)

Tuning for warm standby Kevin Kempter (Thu 27 17:44)

Re: Tuning for warm standby Merlin Moncure (Fri 28 13:18)

Difference in query plan when using = or > in where clause Radhika S (Wed 26 18:00)

Re: Difference in query plan when using = or > in where clause Heikki Linnakangas (Thu 27 12:40)

Incorrect row estimates in plan? pgdba (Wed 26 14:22)

Re: Incorrect row estimates in plan? Tom Lane (Wed 26 14:45)

Re: Incorrect row estimates in plan? pgdba (Wed 26 15:24)

Re: Incorrect row estimates in plan? Tom Lane (Wed 26 16:38)

Re: Incorrect row estimates in plan? pgdba (Wed 26 16:56)

Re: Effects of cascading references in foreign keys Bruce Momjian (Wed 26 08:22)
Attempting to disable count triggers on cleanup Dave Cramer (Tue 25 11:08)

Re: Attempting to disable count triggers on cleanup hubert depesz lubaczewski (Tue 25 11:21)

Re: Attempting to disable count triggers on cleanup Dave Cramer (Tue 25 11:39)

Acceptable level of over-estimation? Carlo Stonebanks (Mon 24 19:51)

Re: Acceptable level of over-estimation? Gregory Stark (Mon 24 20:18)

TEXT or LONGTEXT? Fabiola Fernández (Mon 24 15:21)

Re: TEXT or LONGTEXT? Alexander Staubo (Mon 24 15:29)
Re: TEXT or LONGTEXT? Niklas Johansson (Mon 24 16:01)

select count(*) performance (vacuum did not help) Gábor Farkas (Mon 24 14:14)

Re: select count(*) performance (vacuum did not help) Pavan Deolasee (Mon 24 14:23)
Re: select count(*) performance (vacuum did not help) Heikki Linnakangas (Mon 24 14:31)

Re: select count(*) performance (vacuum did not help) Gábor Farkas (Mon 24 15:04)

Re: select count(*) performance (vacuum did not help) Heikki Linnakangas (Mon 24 15:09)

Re: select count(*) performance (vacuum did not help) Gábor Farkas (Mon 24 15:14)

Re: select count(*) performance (vacuum did not help) Bill Moran (Mon 24 15:29)
Re: select count(*) performance (vacuum did not help) Csaba Nagy (Mon 24 15:33)
Re: select count(*) performance (vacuum did not help) Dave Dutcher (Mon 24 15:38)

zero value in statistics collector's result Yinan Li (Sun 23 17:00)
Possible explanations for catastrophic performace deterioration? Carlos Moreno (Sun 23 16:45)

Re: Possible explanations for catastrophic performace deterioration? Jonah H. Harris (Sun 23 16:56)

Re: Possible explanations for catastrophic performace deterioration? Tom Lane (Sun 23 17:27)
Re: Possible explanations for catastrophic performace deterioration? Carlos Moreno (Sun 23 18:15)

Re: Possible explanations for catastrophic performace deterioration? Alvaro Herrera (Sun 23 18:24)

Re: Possible explanations for catastrophic performace deterioration? Carlos Moreno (Sun 23 19:12)

Re: Possible explanations for catastrophic performace deterioration? Jonah H. Harris (Sun 23 19:24)
Re: Possible explanations for catastrophic performance deterioration? Carlos Moreno (Sun 23 20:33)
Re: Possible explanations for catastrophic performance deterioration? Alvaro Herrera (Sun 23 20:58)
Re: Possible explanations for catastrophic performance deterioration? Carlos Moreno (Sun 23 21:55)
Re: Possible explanations for catastrophic performance deterioration? Jonah H. Harris (Sun 23 22:29)
Re: Possible explanations for catastrophic performance deterioration? Gregory Stark (Sun 23 23:05)

Query planner unaware of possibly best plan Denes Daniel (Fri 21 15:38)

Re: Query planner unaware of possibly best plan Simon Riggs (Fri 21 17:51)

Re: Query planner unaware of possibly best plan Denes Daniel (Fri 21 19:30)

Re: Query planner unaware of possibly best plan Alvaro Herrera (Fri 21 19:56)

Re: Query planner unaware of possibly best plan Denes Daniel (Fri 21 20:05)

<Possible follow-ups>
Re: Query planner unaware of possibly best plan Denes Daniel (Sat 22 00:08)

Re: Query planner unaware of possibly best plan Tom Lane (Sat 22 06:07)

Re: Query planner unaware of possibly best plan Denes Daniel (Sat 22 12:33)

Searching for the cause of a bad plan Csaba Nagy (Fri 21 10:03)

Re: Searching for the cause of a bad plan Simon Riggs (Fri 21 11:01)

Re: Searching for the cause of a bad plan Csaba Nagy (Fri 21 11:29)

Re: Searching for the cause of a bad plan Simon Riggs (Fri 21 11:36)

Re: Searching for the cause of a bad plan Csaba Nagy (Fri 21 12:11)

Re: Searching for the cause of a bad plan Simon Riggs (Fri 21 13:37)
Re: Searching for the cause of a bad plan Csaba Nagy (Fri 21 14:26)
Re: Searching for the cause of a bad plan Csaba Nagy (Fri 21 15:47)
Re: Searching for the cause of a bad plan Simon Riggs (Fri 21 17:20)

Re: Searching for the cause of a bad plan Tom Lane (Fri 21 16:08)

Re: Searching for the cause of a bad plan Simon Riggs (Fri 21 17:40)

Re: Searching for the cause of a bad plan Tom Lane (Fri 21 17:53)

Re: Searching for the cause of a bad plan Simon Riggs (Fri 21 18:39)

Re: Searching for the cause of a bad plan Tom Lane (Fri 21 23:30)
Re: Searching for the cause of a bad plan Simon Riggs (Mon 24 13:28)
Re: Searching for the cause of a bad plan Csaba Nagy (Mon 24 14:04)
Re: Searching for the cause of a bad plan Simon Riggs (Mon 24 17:56)
Re: Searching for the cause of a bad plan Csaba Nagy (Wed 26 14:52)
Re: Searching for the cause of a bad plan Tom Lane (Wed 26 15:22)
Re: Searching for the cause of a bad plan Csaba Nagy (Thu 27 11:54)
Re: Searching for the cause of a bad plan Tom Lane (Thu 27 14:40)
Re: Searching for the cause of a bad plan Csaba Nagy (Thu 27 15:16)
Re: Searching for the cause of a bad plan Ron Mayer (Thu 27 18:22)
Re: Searching for the cause of a bad plan Csaba Nagy (Fri 28 08:12)
Message not available
Re: Searching for the cause of a bad plan Csaba Nagy (Fri 28 12:33)
Re: Searching for the cause of a bad plan Simon Riggs (Thu 27 15:26)

Linux mis-reporting memory Decibel! (Thu 20 23:04)

Re: Linux mis-reporting memory Tom Lane (Thu 20 23:12)

Re: Linux mis-reporting memory Gregory Stark (Fri 21 08:03)

Re: Linux mis-reporting memory Csaba Nagy (Fri 21 08:29)

Re: Linux mis-reporting memory Gregory Stark (Fri 21 10:00)

Re: Linux mis-reporting memory Csaba Nagy (Fri 21 10:08)
Re: Linux mis-reporting memory Heikki Linnakangas (Fri 21 10:35)
Re: Linux mis-reporting memory Csaba Nagy (Fri 21 11:33)
Re: Linux mis-reporting memory Simon Riggs (Fri 21 11:03)

Re: Linux mis-reporting memory Adam Tauno Williams (Fri 21 00:22)
Re: Linux mis-reporting memory Dimitri Fontaine (Fri 21 09:49)
Re: Linux mis-reporting memory Greg Smith (Fri 21 19:24)

query io stats and finding a slow query Kamen Stanev (Thu 20 21:37)

Re: query io stats and finding a slow query Kevin Grittner (Fri 21 16:35)

Re: query io stats and finding a slow query Kamen Stanev (Tue 25 19:41)

Re: query io stats and finding a slow query Bryan Murphy (Tue 25 19:59)

Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211 (Thu 20 19:10)

Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Carlos Moreno (Thu 20 19:34)

Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211 (Thu 20 20:32)

Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Scott Marlowe (Thu 20 21:25)

Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Scott Marlowe (Thu 20 21:26)
Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211 (Thu 20 23:25)

Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Scott Marlowe (Fri 21 00:52)
Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211 (Fri 21 03:25)

Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! db (Fri 21 05:58)

Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211 (Fri 21 13:14)

Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Bill Moran (Fri 21 13:26)
Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Dave Dutcher (Fri 21 14:08)

<Possible follow-ups>
Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Jeff Harris (Fri 21 13:44)

REPOST: Nested loops row estimates always too high Carlo Stonebanks (Thu 20 15:20)

Re: REPOST: Nested loops row estimates always too high Ow Mun Heng (Mon 24 06:46)

Re: REPOST: Nested loops row estimates always too high Carlo Stonebanks (Mon 24 18:21)

Re: REPOST: Nested loops row estimates always too high Ow Mun Heng (Tue 25 00:50)

Re: REPOST: Nested loops row estimates always too high Carlo Stonebanks (Tue 25 04:53)

Re: REPOST: Nested loops row estimates always too high Ow Mun Heng (Tue 25 05:16)
Re: REPOST: Nested loops row estimates always too high Steinar H. Gunderson (Tue 25 09:31)
Re: REPOST: Nested loops row estimates always too high Ow Mun Heng (Wed 26 03:50)
Re: REPOST: Nested loops row estimates always too high Tom Lane (Wed 26 04:03)
Re: REPOST: Nested loops row estimates always too high Ow Mun Heng (Thu 27 06:59)

REPOST: Performance improves only after repeated VACUUM/ANALYZE Carlo Stonebanks (Thu 20 15:20)
Low CPU Usage brauagustin-susc (Wed 19 17:45)

Re: Low CPU Usage Heikki Linnakangas (Wed 19 17:53)
Re: Low CPU Usage Mark Lewis (Wed 19 18:03)
<Possible follow-ups>
Re: Low CPU Usage brauagustin-susc (Wed 19 19:13)

Re: Low CPU Usage Scott Marlowe (Wed 19 19:41)

Re: Low CPU Usage brauagustin-susc (Wed 19 19:52)

Re: Low CPU Usage Scott Marlowe (Wed 19 20:15)

Re: Low CPU Usage brauagustin-susc (Thu 20 11:31)

Re: Low CPU Usage Jean-David Beyer (Thu 20 12:32)

Re: Low CPU Usage brauagustin-susc (Thu 20 17:28)

Re: Low CPU Usage Greg Smith (Sat 22 06:29)

Re: Low CPU Usage brauagustin-susc (Fri 21 17:30)

Re: Low CPU Usage Kevin Grittner (Fri 21 17:52)

Re: Low CPU Usage brauagustin-susc (Fri 21 17:52)
Re: Low CPU Usage brauagustin-susc (Fri 21 18:20)

Re: Low CPU Usage Bill Moran (Fri 21 18:34)

Re: Low CPU Usage brauagustin-susc (Fri 21 19:01)

Re: Low CPU Usage Bill Moran (Fri 21 19:11)

Re: Low CPU Usage brauagustin-susc (Fri 21 19:34)

Re: Low CPU Usage Luiz K. Matsumura (Fri 21 20:41)

Re: Low CPU Usage Kevin Grittner (Fri 21 20:57)
Re: Low CPU Usage Craig James (Fri 21 21:13)

Re: Low CPU Usage Dave Dutcher (Fri 21 20:55)

Re: Low CPU Usage brauagustin-susc (Fri 21 21:45)
Re: Low CPU Usage brauagustin-susc (Mon 24 13:59)
Re: Low CPU Usage brauagustin-susc (Mon 24 14:16)

Tablespaces and NFS Carlos Moreno (Wed 19 16:16)

Re: Tablespaces and NFS Craig James (Wed 19 20:48)
Re: Tablespaces and NFS Peter Koczan (Wed 19 21:54)

Re: Tablespaces and NFS Carlos Moreno (Thu 20 13:20)

Re: Tablespaces and NFS Peter Koczan (Thu 20 18:50)

Re: Tablespaces and NFS Carlos Moreno (Thu 20 19:24)

Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks (Mon 17 20:22)

Re: Query works when kludged, but would prefer "best practice" solution Merlin Moncure (Tue 18 00:03)

Re: Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks (Tue 18 00:13)

Re: Query works when kludged, but would prefer "best practice" solution Merlin Moncure (Tue 18 00:17)

Re: Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks (Tue 18 00:38)

Re: Query works when kludged, but would prefer "best practice" solution Tom Lane (Tue 18 03:29)

Re: Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks (Tue 18 06:28)

Re: Query works when kludged, but would prefer "best practice" solution Tom Lane (Tue 18 14:08)
Re: Query works when kludged, but would prefer "best practice" solution Dave Dutcher (Tue 18 15:11)

Performance improves only after repeated VACUUM/ANALYZE Carlo Stonebanks (Tue 18 19:59)
Nested loops row estimates always too high Carlo Stonebanks (Tue 18 20:07)

DELETE queries slow down Galantucci Giovanni (Mon 17 08:10)

Re: DELETE queries slow down Heikki Linnakangas (Mon 17 09:20)

Re: DELETE queries slow down Gregory Stark (Mon 17 10:21)

R: DELETE queries slow down Galantucci Giovanni (Tue 18 07:17)

Re: R: DELETE queries slow down Bill Moran (Tue 18 16:22)

R: R: DELETE queries slow down Galantucci Giovanni (Wed 19 09:47)
Re: R: R: DELETE queries slow down Bill Moran (Wed 19 11:14)
Re: R: R: DELETE queries slow down Gregory Williamson (Wed 19 11:27)

Regarding COPY command from Postgres 8.2.0 soni de (Fri 14 10:21)

Main Index
[Prev Page]
[Next Page]

Mail converted by MHonArc

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group