Postgres Pro
Downloads
Home   >   mailing lists

Re: planner/optimizer question - Mailing list pgsql-performance

From Tom Lane
Subject Re: planner/optimizer question
Date
Msg-id 17175.1083275671@sss.pgh.pa.us
Whole thread Raw
In response to Re: planner/optimizer question  ("Gary Doades" <gpd@gpdnet.co.uk>)
Responses Re: planner/optimizer question  ("Gary Doades" <gpd@gpdnet.co.uk>)
List pgsql-performance
Tree view 
"Gary Doades" <gpd@gpdnet.co.uk> writes:
> In this example the statistics don't matter.

Don't they?

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

pgsql-performance by date:

Previous
From: "Gary Doades"
Date:
Subject: Re: planner/optimizer question
Next
From: Josh Berkus
Date:
Subject: Re: Simply join in PostrgeSQL takes too long