Re: Performance problems with large telemetric datasets on 7.4.2 - Mailing list pgsql-performance

From Sven Clement
Subject Re: Performance problems with large telemetric datasets on 7.4.2
Date
Msg-id 881035ea0708060010u1bbb4b58r57bdf6f51b12f7d9@mail.gmail.com
Whole thread Raw
In response to Re: Performance problems with large telemetric datasets on 7.4.2  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: Performance problems with large telemetric datasets on 7.4.2
Re: Performance problems with large telemetric datasets on 7.4.2
List pgsql-performance


2007/8/5, Heikki Linnakangas <heikki@enterprisedb.com>:

I don't remember a bug like that. Where did you read that from?

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

Partially I found that one in the PostgreSQL Documentation for the 7.x.x versions under the command REINDEX where they claim that you should run a reindex under certain circumstances and for my comprehension this says that with some access pattern (as ours (major writes / one big delete per day)) the index may be corrupted or otherwise not really useful.

Sven Clement

pgsql-performance by date:

Previous
From: Decibel!
Date:
Subject: Re: TRUNCATE TABLE
Next
From: Henrik Zagerholm
Date:
Subject: Extreme slow select query 8.2.4