Re: Sanity check requested

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>, "Pgsql-Performance(at)Postgresql(dot) Org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Sanity check requested
Date: 2003-07-17 16:11:41
Message-ID: NEBBLAAHGLEEPCGOBHDGOEFEHMAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jean-Luc Lachance 2003-07-17 16:13:27 Re: Hardware performance
Previous Message Josh Berkus 2003-07-17 15:57:08 Re: Sanity check requested