* Claudio Freire (klaussfre...@gmail.com) wrote: > I don't think you'd want that. Remember, work_mem is the amount of > memory *per sort*. > Queries can request several times that much memory, once per sort they > need to perform. > > You can set it really high, but not 60% of your RAM - that wouldn't be wise.
Oh, I dunno.. It's only used by the planner, so sometimes you have to
bump it up, especially when PG thinks the number of rows returned from
something will be a lot more than it really will be. :)
/me has certain queries where it's been set to 100GB... ;)
I agree that it shouldn't be the default, however. That's asking for
trouble. Do it for the specific queries that need it.
Thanks,
Stephen
signature.asc
Description: Digital signature
