Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group