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

From Yurgis Baykshtis
Subject Please consider removing "select count(*)..."
Date
Msg-id 56510AAEF435D240958D1CE8C6B1770A0138A581@mailc03.aurigin.com
Whole thread Raw
List pgadmin-hackers
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.

pgadmin-hackers by date:

Previous
From: Jochem van Dieten
Date:
Subject: Re: pgAdmin3 resources
Next
From: "Dave Page"
Date:
Subject: Re: Please consider removing "select count(*)..."