Re: Postgresql 8.0 RC1 not using indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tony Caduto <tony(dot)caduto(at)amsoftwaredesign(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postgresql 8.0 RC1 not using indexes
Date: 2004-12-18 17:22:35
Message-ID: 2439.1103390555@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tony Caduto <tony(dot)caduto(at)amsoftwaredesign(dot)com> writes:
> I just installed 8.0 RC1 and then restored my database which was working
> perfectly on 7.4.5.
> I have a function that imports rows from a comma seperated file and on
> 7.4.5 using this same function I could get around 1000 rows every 2.5
> seconds, now with 8.0 RC1 this has gone way up and it seems to be
> because it is not using the indexes defined on the table.

Have you done an ANALYZE or VACUUM ANALYZE since loading the data?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Simon Riggs 2004-12-18 20:02:13 Re: Checkpoints occur too frequently
Previous Message Tom Lane 2004-12-18 17:10:52 Re: posgresql 8.0 RC1 missing schemas