Re: Please consider removing "select count(*)..." - Mailing list pgadmin-hackers

From Dave Page
Subject Re: Please consider removing "select count(*)..."
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B825A20B@mail.vale-housing.co.uk
Whole thread Raw
In response to Please consider removing "select count(*)..."  ("Yurgis Baykshtis" <ybaykshtis@aurigin.com>)
List pgadmin-hackers

> -----Original Message-----
> From: Yurgis Baykshtis [mailto:ybaykshtis@aurigin.com]
> Sent: 23 May 2003 19:46
> To: pgadmin-hackers@postgresql.org
> Subject: [pgadmin-hackers] Please consider removing "select
> count(*)..."
>
>
> In both pgAdmin 2 and 3, whenever I click on a table node in
> the object tree, for a table with relatively big number of
> rows, it's taking a very long time to update the property
> panel (up to a few minutes with very high CPU load by the
> postgres process) making practically impossible usage of the
> tool. The reason is in the "select count(*)" query pgAdmin
> use to get table row count.
> I am not sure whether there is another way to count table
> rows in Postgres, but I see it does not like 'select
> count(*)' much for large tables.
>
> I just commented out this query for myself forcing row count
> field to be always zero and it works just fine for me.

Hi,

In pgAdmin II, go to Tools -> Options -> PostgreSQL and switch off Auto
Row Count.

In pgAdmin III I notice the option is not there yet. I'll see if I can
add it shortly.

Regards, Dave.

pgadmin-hackers by date:

Previous
From: "Yurgis Baykshtis"
Date:
Subject: Please consider removing "select count(*)..."
Next
From: Anthony DeRobertis
Date:
Subject: Re: [ANNOUNCE] pgAdmin Licencing Changes