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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
