Re: Sanity check requested - Mailing list pgsql-performance

From Nick Fankhauser
Subject Re: Sanity check requested
Date
Msg-id NEBBLAAHGLEEPCGOBHDGOEFEHMAA.nickf@ontko.com
Whole thread Raw
In response to Re: Sanity check requested  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Sanity check requested
List pgsql-performance
> Wrong, actually.   Sort memory is allocated *per sort*, not per
connnection or
> per query.   So a single complex query could easily use 4xsort_mem if it
has
> several merge joins ...

Thanks for the correction- it sounds like this is one where usage can't be
precisely controlled in a dynamic user environment & I just need to get a
feel for what works under a load that approximates my production system.

-Nick


pgsql-performance by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: Hardware performance
Next
From: Richard Huxton
Date:
Subject: Re: Relation of indices to ANALYZE