Re: pgadmin3 and partitionned tables

[Andreas Pflug <pgadmin(at)pse-consulting(dot)de>]

Marc Cousin wrote:
> Hi,
>
> I've got a partitionned table with PG 8.1, and I'm using pgadmin3 1.4.1.
> I'm having problems using pgadmin because it tries to count the elements of 
> the partitionned table...
>
> The main table contains 0 record (so the stats say 0), so pgadmin decides it 
> can count all the elements from the table... but the count() on this table is 
> avout 40 000 000 record including all the partitions. The consequence is that 
> everytime I click on  the main table, pgadmin scans all the partitions 
> (taking about 3 minutes and slowing down the server...)
>
> Is this a known problem ?

Yes. You clearly ignored the Guru's hint to vacuum.

Regards,
Andreas