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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group