Postgres Pro
Downloads
Home   >   mailing lists

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

From PFC
Subject Re: Very low performance on table with only 298 rows
Date
Msg-id op.so8e83t2th1vuj@localhost
Whole thread Raw
In response to Very low performance on table with only 298 rows  (Andreas Joseph Krogh <andreak@officenet.no>)
List pgsql-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(*)