Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group