* Claudio Freire (klaussfreire@xxxxxxxxx) 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
Attachment:
signature.asc
Description: Digital signature
