Re: Vacuum problem - Mailing list pgsql-general

From S H
Subject Re: Vacuum problem
Date
Msg-id BAY155-W40A7B02A7180456D53D529FDA10@phx.gbl
Whole thread Raw
In response to Re: Vacuum problem  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Vacuum problem
List pgsql-general
I am doing regular insertion/deletion on the same tables .. and running vacuum in an hour... 

I suspect there is bloating  in my tables.. but how does bloating in pgcatalog is happening is not clear...
> Normally vacuum full is NOT required on a regular basis. However, if
> you did something like creation 100M tables and then dropped them, or
> did it one at a time real fast, you could outrun your autovacuum
> daemons and get bloat in the pg catalog tables.
>
> Just offering a possibility for why a connection might be taking a
> long time. There's plenty of other possibilities I'm sure.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Running out of memory on vacuum
Next
From: Scott Marlowe
Date:
Subject: Re: Vacuum problem