| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Jack Coates <jack(at)lyris(dot)com> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: tuning questions |
| Date: | 2003-12-04 17:26:38 |
| Message-ID: | Pine.LNX.4.33.0312041024380.1592-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On Thu, 4 Dec 2003, Jack Coates wrote:
> Another problem is that performance of the 6 million row job is decent
> if I stop the job and run a vacuumdb --analyze before letting it
> continue; is this something that 7.4 will help with? vacuumb --analyze
> doesn't seem to have much effect on the 18 million row job.
Just to add to what the others have said here, you probably want to run
the pg_autovacuum daemon in the background. It comes with 7.4 but will
work fine with 7.3.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2003-12-04 17:55:51 | How to get started hacking on pgsql |
| Previous Message | Rob Fielding | 2003-12-04 17:13:19 | Re: tuning questions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dror Matalon | 2003-12-04 17:57:38 | Re: tuning questions |
| Previous Message | Rob Fielding | 2003-12-04 17:13:19 | Re: tuning questions |