Re: perf pb solved only after pg_dump and restore

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: Markus Schaber <schabi(at)logix-tt(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: perf pb solved only after pg_dump and restore
Date: 2006-08-28 13:47:42
Message-ID: 87ac5px98h.fsf@meuh.mnc.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Markus Schaber <schabi 'at' logix-tt.com> writes:

> > VACUUM ANALYZE is normally run overnight (each night). Is it not
> > regular enough? There can be hundreds of thousands of statements
> > a day.
>
> Which PostgreSQL version are you using? Maybe you should consider
> autovacuum (which is a contrib module at least since 7.4, and included
> in the server since 8.1). If you think that vacuum during working hours
> puts too much load on your server, there are options to tweak that, at
> least in 8.1.

Ok, thanks. Unfortunately production insists on sticking on 7.4.5
for the moment :/

--
Guillaume Cottenceau
Create your personal SMS or WAP Service - visit http://mobilefriends.ch/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ravindran G - TLS, Chennai. 2006-08-28 14:00:44 Re: Postgre SQL 7.1 cygwin performance issue.
Previous Message Markus Schaber 2006-08-28 13:43:48 Re: perf pb solved only after pg_dump and restore