Re: Btree indizes, FILLFACTOR, vacuum_freeze_min_age and CLUSTER - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Btree indizes, FILLFACTOR, vacuum_freeze_min_age and CLUSTER
Date
Msg-id 20090513175245.GE5986@alvh.no-ip.org
Whole thread Raw
In response to Btree indizes, FILLFACTOR, vacuum_freeze_min_age and CLUSTER  (Philipp Marek <philipp.marek@emerion.com>)
Responses Re: Btree indizes, FILLFACTOR, vacuum_freeze_min_age and CLUSTER
List pgsql-general
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Failure during initdb - creating dictionaries ... FATAL: could not access file "$libdir/libdict_snowball": No such file or directory
Next
From: Juan Camilo Marín
Date:
Subject: Re: lack in psql console