Re: performance tuning: shared_buffers, sort_mem; swap

From: Thomas O'Connell <tfo(at)monsterlabs(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: performance tuning: shared_buffers, sort_mem; swap
Date: 2002-08-14 16:28:32
Message-ID: tfo-945CE5.11283214082002@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

In article <1806(dot)1029277058(at)sss(dot)pgh(dot)pa(dot)us>,
tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:

> So, what are you seeing to start the avalanche?

Indeed, here it is:

DEBUG: incomplete startup packet
DEBUG: pq_recvbuf: unexpected EOF on client connection
DEBUG: server process (pid 6867) was terminated by signal 9

That's very good to know.

This has been a partial mystery to me for some time. I've been trying to
tweak our numbers, stress the system, and I've been coming at it from
the wrong end.

Thanks again, Tom!

-tfo

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-08-14 19:48:12 Re: Leftover processes on shutdown - Debian+JDBC
Previous Message Tom Lane 2002-08-14 13:41:01 Re: performance tuning: shared_buffers, sort_mem; swap