pgadmin3 and partitionned tables

From: Marc Cousin <mcousin(at)sigma(dot)fr>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgadmin3 and partitionned tables
Date: 2006-04-10 07:49:49
Message-ID: 200604100949.49138.mcousin@sigma.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2006-04-10 07:54:20 Re: pgadmin3 and partitionned tables
Previous Message Dave Page 2006-04-09 14:11:28 Re: sql window issues