On Tue, Jan 17, 2006 at 09:17:41PM -0800, kishore.sainath@gmail.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@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461