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

Re: Row counts for large tables cause temporary hang

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Mark Kirkwood" <markir(at)paradise(dot)net(dot)nz>,<pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Row counts for large tables cause temporary hang
Date: 2004-04-28 07:13:16
Message-ID: 03AF4E498C591348A42FC93DEA9661B889FB7A@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers
 
Hi Mark,

> -----Original Message-----
> From: Mark Kirkwood [mailto:markir(at)paradise(dot)net(dot)nz] 
> Sent: 28 April 2004 08:00
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] Row counts for large tables cause 
> temporary hang
> 
> Dear list,
> 
> Just recently downloaded Pgadmin III 1.0.2 for win32, and am 
> using it against (native) win32 Pg 7.5dev (to get a nicer 
> client interface) - I am very impressed with Pgadmin, it rocks!

Thanks :-)

> The only gripe I have is the seemingly automatic count on 
> tables as they are clicked on - this hangs Pgadmin for 
> minutes on one of the big tables (10 million rows).

Please look under File -> Options, and on the Query tab you can set the
threshold value for the 'estimated' rows above which 'real' rows are not
counted. You need to analyse your database periodically to ensure the
estimated value stays fairly accurate (this is recommended anyway).

Regards, Dave.

Responses

pgadmin-hackers by date

Next:From: Mark KirkwoodDate: 2004-04-28 08:21:39
Subject: Re: Row counts for large tables cause temporary hang
Previous:From: Mark KirkwoodDate: 2004-04-28 07:00:21
Subject: Row counts for large tables cause temporary hang

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