| From: | "Bryan White" <bryan(at)arcamax(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: VACUUM, 24/7 availability and 7.2 |
| Date: | 2001-10-11 14:34:21 |
| Message-ID: | 009d01c15261$d1398e40$2ed260d1@bryan |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> The runtime seems to be dependent on what hind of activity you do. If you
> frequently rollback inserts, vacuum seems to take longer. Say, a database
> with 1m records which endures 5m inserts + rollback is going to take a
> while to vacuum.
As another data point, daily vacuums on our database take 25 to 30 minutes.
This is on a dual PIII 933Mhz with 2GB RAM and the database is on a 4 Drive
RAID 10 array (stripe + mirror) of 15K RPM SCSI drives. Our database is
9GB. I don't really have a good estimate as to the number of insertions and
updates that occur daily. I have some mass updates that I hold until the
weekend. PostgreSQL is 7.03. I see vacuum downtime as the number 1 drawback
to PostgreSQL.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mwilliams | 2001-10-11 15:49:28 | Joining Between Databases |
| Previous Message | David Link | 2001-10-11 14:18:43 | Re: Performance problem with 50,000,000 rows |