Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql 8.0 RC1 not using indexes - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Postgresql 8.0 RC1 not using indexes
Date
Msg-id 2439.1103390555@sss.pgh.pa.us
Whole thread Raw
In response to Postgresql 8.0 RC1 not using indexes  (Tony Caduto <tony.caduto@amsoftwaredesign.com>)
Responses Re: Postgresql 8.0 RC1 not using indexes  (Tony Caduto <tony.caduto@amsoftwaredesign.com>)
List pgsql-bugs
Tree view 
Tony Caduto <tony.caduto@amsoftwaredesign.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: posgresql 8.0 RC1 missing schemas
Next
From: Simon Riggs
Date:
Subject: Re: Checkpoints occur too frequently