Web pgadmin.org
 Home 
 ·  ·  ·  ·  ·  ·  · 
pgadmin3 and partitionned tables

pgadmin3 and partitionned tables



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 ?

Regards



Home | Main Index | Thread Index

top