createdb problem
I use postgresql 7.4.8.
I need te delete and recreate a database very ofent, because I do some
tests in it.
After a few months the command createdb becamed very slow.
How can I make it go fast again?
Thank you.
Sterpu Victor <victor@ambra.ro> writes:
I use postgresql 7.4.8.
I need te delete and recreate a database very ofent, because I do some
tests in it.
After a few months the command createdb becamed very slow.
How can I make it go fast again?
The only explanation that comes to mind is that you haven't ever
vacuumed pg_database ... at this point you probably need a VACUUM
FULL, and maybe REINDEX too, to get it back down to a reasonable
size.
regards, tom lane
My guess is you need to vacuum. Try a vacuumdb -a.
On Sun, Sep 25, 2005 at 03:46:38AM +0300, Sterpu Victor wrote:
I use postgresql 7.4.8.
I need te delete and recreate a database very ofent, because I do some
tests in it.
After a few months the command createdb becamed very slow.How can I make it go fast again?
Thank you.---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
--
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