Re: Btree indizes, FILLFACTOR, vacuum_freeze_min_age and CLUSTER

Philipp Marek wrote:
> Hello everybody,
>
> we're using postgresql 8.3 for some logging framework.
>
> There are several tables for each day (which are inherited from a common
> base), which
> - are filled during the day,
> - after midnight the indizes are changed to FILLFACTOR=100, and
> - the tables get CLUSTERed by the most important index.
> - Some time much later the tables that aren't needed anymore are DROPped.
>
> So far, so fine.

Do say, do you have any long-running transactions, or "idle"
transactions?  Maybe someone opened a terminal somewhere and left it
open for days?  Have a look at pg_stat_activity.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.