| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | kishore(dot)sainath(at)gmail(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: A tale of two similar databases |
| Date: | 2006-01-19 23:06:07 |
| Message-ID: | 20060119230607.GN78403@pervasive.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jan 17, 2006 at 09:17:41PM -0800, kishore(dot)sainath(at)gmail(dot)com wrote:
> Hi All,
>
> I haven't vacuum/analysed the D2 database or for that matter D1.
> In fact I have never used VACUUM before.
> Maybe that is the problem.
>
> What are the benefits of the VACUUM command in PostgreSQL?
VACUUM is as close as it comes to fast=true. If you don't do it your
database is almost guaranteed to become dog slow after a while.
http://www.pervasive-postgres.com/lp/newsletters/2005/Insights_opensource_Dec.asp#2
will probably be enlightening for you...
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-01-19 23:09:30 | Re: Upgrade Problem: 7.4.3 -> 8.1.2 |
| Previous Message | Rich Shepard | 2006-01-19 22:59:06 | Re: Upgrade Problem: 7.4.3 -> 8.1.2 |