| From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance problems |
| Date: | 2003-04-26 18:27:40 |
| Message-ID: | 1051381659.22845.2.camel@zeutrh9 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2003-04-25 at 11:46, Shridhar Daithankar wrote:
> Why don't you take a look at pgavd? It will periodically connect to database
> and check if it needs vacuum. just that it won't issue vacuum full because it
> locks table and IMO only administrator should do it.
>
> http://gborg.postgresql.org/project/pgavd/projdisplay.php
Or, pg_autovacuum which is now included in 7.4 contrib. It should
compile against 7.3.2 without any trouble. I would be curious to see
how it goes (always looking for real world feedback). If you need any
help let me know.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2003-04-27 00:18:20 | Re: Backing up 16TB of data (was Re: > 16TB worth of |
| Previous Message | Lincoln Yeoh | 2003-04-26 17:20:31 | Re: Backing up 16TB of data (was Re: > 16TB worth of |