Re: cross table indexes or something?

Neil,

> > 1) to keep it working, you will probably need to run ANALZYE more
> >    often than you have been;
>
> I'm not sure why this would be the case -- can you elaborate?

For the more granular stats to be useful, they have to be accurate; otherwise
you'll go back to a nestloop as soon as the query planner encounters a value
that it doens't think is in the table at all.

>
> > 4) Currently, pg_dump does *not* back up statistics settings.
>
> Yes, it does.

Oh, good.   Was this a 7.4 improvement?   I missed that in the changelogs ....

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco