Thread: createdb problem

createdb problem

From

Sterpu Victor

Date:

25 September 2005, 00:47:08

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.

Re: createdb problem

From

Tom Lane

Date:

25 September 2005, 04:03:11

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

Re: createdb problem

From

"Jim C. Nasby"

Date:

25 September 2005, 04:05:35

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?
>
>               http://www.postgresql.org/docs/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