On Sun, Jan 16, 2011 at 5:47 PM, Tim Uckun <timuc...@gmail.com> wrote:
>> Hmm, autovacuum *should* have been keeping track of things for you,
>> but it might still be worth doing a manual ANALYZE against that table
>> to see if the estimated rowcount changes. If not, you'll need to raise
>> the statistics target for that column (and again ANALYZE).
>
>
> The analyze finished. I re-ran the explain it was still taking a very
> long time. I stopped it eventually.
Hmm. What do you get for:
SELECT relname, pg_relation_size(oid), reltuples, relpages FROM
pg_class WHERE relname IN ('consolidated_urls',
'consolidated_urls_pkey');
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
