Re: Very low performance on table with only 298 rows

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Andreas Joseph Krogh" <andreak(at)officenet(dot)no>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Very low performance on table with only 298 rows
Date: 2005-04-14 17:08:53
Message-ID: op.so8e83t2th1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


> 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2005-04-14 17:10:12 Re: row-attribute in EXPLAIN-output doesn't match count(*)
Previous Message Andreas Joseph Krogh 2005-04-14 16:38:14 row-attribute in EXPLAIN-output doesn't match count(*)