Postgres Pro
Downloads
Home   >   mailing lists

Re: Very low performance on table with only 298 rows - Mailing list pgsql-sql

FromPFC
SubjectRe: Very low performance on table with only 298 rows
Date
Msg-idop.so8e83t2th1vuj@localhost
Whole thread Raw
In response toVery low performance on table with only 298 rows  (Andreas Joseph Krogh <[email protected]>)
Listpgsql-sql
Tree view
> nbeweb=> EXPLAIN ANALYZE select count(*) from onp_web_index;
>  Total runtime: 179748.993 ms
WOW.It's possible your table is bloated.What version of PG are you using ?
VACUUM FULL ANALYZE VERBOSE onp_web_index
if it solves your problem, good, else post the results from that command.

pgsql-sql by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: row-attribute in EXPLAIN-output doesn't match count(*)
Next
From: Andrew Sullivan
Date:
Subject: Re: row-attribute in EXPLAIN-output doesn't match count(*)