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 import
Hello Alvaro,
On Montag, 11. Mai 2009, Alvaro Herrera wrote:
> Philipp Marek wrote:
> > A few days before we found the machine much slower, because of the
> > autovacuum processes that were started automatically ["autovacuum: VACUUM
> > ... (to prevent wraparound)"]
On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote:
> > 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=1
On Donnerstag, 14. Mai 2009, Alvaro Herrera wrote:
> Philipp Marek wrote:
> > On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote:
> > > Do say, do you have any long-running transactions, or "idle"
> > > transactions? Maybe someone opened a terminal somewhere and
On Donnerstag, 14. Mai 2009, Philipp Marek wrote:
> On Donnerstag, 14. Mai 2009, Alvaro Herrera wrote:
> > Philipp Marek wrote:
> > > On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote:
> > > > Do say, do you have any long-running transactions, or "idle"
>
