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 Riggs||Date: 2004-12-18 20:02:13|
|Subject: Re: Checkpoints occur too frequently|
|Previous:||From: Tom Lane||Date: 2004-12-18 17:10:52|
|Subject: Re: posgresql 8.0 RC1 missing schemas |