"Gary Doades" <gpd(at)gpdnet(dot)co(dot)uk> writes:
> In this example the statistics don't matter.
A prior poster mentioned that he thought MSSQL tries to keep all its
indexes in memory. I wonder whether you are giving Postgres a fair
chance to do the same. What postgresql.conf settings are you using?
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2004-04-29 22:10:08|
|Subject: Re: Simply join in PostrgeSQL takes too long|
|Previous:||From: Gary Doades||Date: 2004-04-29 21:15:12|
|Subject: Re: planner/optimizer question|