From: Jim C. Nasby <jnasby@pervasive.com>
To: Bendik Rognlien Johansen <bendik.johansen@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Problem with query, server totally unresponsive
Date: Fri, 24 Mar 2006 04:25:20 -0600
Message-ID: <20060324102520.GS90527@pervasive.com> (raw)
In-Reply-To: <0B8E0D23-F08D-457D-B26F-1D475F8064F4@gmail.com>
References: <0B8E0D23-F08D-457D-B26F-1D475F8064F4@gmail.com>
On Thu, Mar 23, 2006 at 01:12:08PM +0100, Bendik Rognlien Johansen wrote:
> Hello, I have a big problem with one of my databases. When i run my
> query, after a few minutes, the postmaster shows 99% mem i top, and
> the server becomes totally unresponsive.
You've got a bunch of sorts going on; could you be pushing the machine
into swapping?
> I get this message when I try to cancel the query:
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
Did you send a kill of some kind to the backend?
> The machine has 2x Intel dual core processors (3GHz) and 2 Gigs of ram.
Unless I missed some big news recently, no such CPU exists.
Hyperthreading is absolutely not the same as dual core, and many people
have found that it's best to disable hyperthreading on database servers.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
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: jnasby@pervasive.com, bendik.johansen@gmail.com
Subject: Re: Problem with query, server totally unresponsive
In-Reply-To: <20060324102520.GS90527@pervasive.com>
* 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