I am guessing the analyze helped the pgadmin data-dictionary query
planning..The vacuum will help with space re-use. the size is not
smaller as I did not do a vacuum full.
On Mon, Oct 26, 2009 at 4:27 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Mon, Oct 26, 2009 at 3:29 PM, Anj Adu <fotographs@gmail.com> wrote:
>> We have several partitioned tables that get dropped every day ..We do
>> not do autovacuum as it is an IO hog (and most tables are dropped
>> anyways..and the large tables are never updated)..
>
> 1: autovac can be adjusted to use much less IO than regular vacuum.
> 2: You can tell it to ignore certain tables.
>
>> I however did a plain vacuum analyze and that fixed the problem with
>> tools(e.g pgadmin) that accessed the data dictionary and were very
>> slow before the vacuum.
>
> Huh. Is the pg_attribute size much smaller?
>