"Greg Sabino Mullane" wrote:
> ANALYZE;
>
> SELECT n.nspname, relname, reltuples
> FROM pg_class c, pg_namespace n
> WHERE c.relnamespace=n.oid
> AND relkind='r'
> AND NOT n.nspname ~ '^pg_'
> ORDER BY 1,2;
Maybe this gem should be passed onto the pgadmin folks. When you
click on a table name in the interface it does what I can only
presume is a count(*) from relation, which takes forever on enormous
relations. It then claims this to be a row estimate anyway, so
they could probably drop the analyze.
Ian
--
Ian Freislich
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
