[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Irreversible performance drop after increasing shared mem
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2004-02-29 3:30:12
Message-ID: 12291.1078025412 () sss ! pgh ! pa ! us
[Download RAW message or body]

Martijn van Oosterhout <kleptog@svana.org> writes:
> After you changed the conf file, did you restart the postmaster? Not
> just reload, since that won't affect existing sessions I beleive.

SIGHUP will cause existing sessions to adopt a new value of sort_mem
from the config file (unless it's been locally overridden, eg with SET).

However, shared_buffers can only be set at postmaster start, so changing
it in the config file will affect nothing unless you stop and restart
the postmaster.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]