Re: Upgrade to dual processor machine?

"Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> writes:
> 3) Sort mem is a tricky affair. AFAIU, it is used only when you create index or
> sort results of a query. If do these things seldomly, you can set this very low
> or default. For individual session that creates index, you can set the sort
> memory accordingly.

What would the benefit of this be? sort_mem is just an upper limit on
memory consumption, and that memory is only allocated on demand. So
there shouldn't be a difference between setting sort_mem globally to
some reasonable value, and manually changing it for backends that need
to do any sorting.

Cheers,

Neil

--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC