pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar@frodo.hserus.net>
To: Paul Serby <paul.serby@clockltd.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: The black art of postgresql.conf  tweaking
Date: Mon, 9 Aug 2004 20:16:47 +0530
Message-ID: <200408092016.47304.shridhar@frodo.hserus.net> (raw)
In-Reply-To: <411789F1.6020305@clockltd.com>
References: <4110DA83.7020505@clockltd.com>
	<411789F1.6020305@clockltd.com>

On Monday 09 Aug 2004 7:58 pm, Paul Serby wrote:
> I've not maxed out the connections since making the changes, but I'm
> still not convinced everything is running as well as it could be. I've
> got some big result sets that need sorting and I'm sure I could spare a
> bit more sort memory.

You could set the sort mem for that connection before issuing the query.

i.e.

# set sort_mem=20000;
# select * ....;

And reset it back. Setting it globally is not that good. If you do it 
selectively, that would tune it as per your needs..

> Where does everyone get there information about the settings? I still
> can't find anything that helps explain each of the settings and how you
> determine there optimal settings.

http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

HTH

 Shridhar



view thread (14+ messages)

Message-ID: <200408092016.47304.shridhar@frodo.hserus.net>
Permalink:  ../200408092016.47304.shridhar@frodo.hserus.net/
Also on:    postgresql.org/message-id/200408092016.47304.shridhar@frodo.hserus.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: shridhar@frodo.hserus.net, paul.serby@clockltd.com
  Subject: Re: The black art of postgresql.conf  tweaking
  In-Reply-To: <200408092016.47304.shridhar@frodo.hserus.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox