From: Dave Dutcher <dave@tridecap.com>
To: 'Jim C. Nasby' <jnasby@pervasive.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Problem with query, server totally unresponsive
Date: Fri, 24 Mar 2006 08:46:54 -0600
Message-ID: <000c01c64f51$cb71b590$8300a8c0@tridecap.com> (raw)
In-Reply-To: <20060324102520.GS90527@pervasive.com>
> From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-
> owner@postgresql.org] On Behalf Of Jim C. Nasby
> Subject: Re: [PERFORM] Problem with query, server totally unresponsive
>
> 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.
Maybe I'm confused by the marketing, but I think those CPUs do exist.
According to New Egg the Pentium D 830 and the Pentium D 930 both are
dual core Pentiums that run at 3Ghz. It also specifically says these
processors don't support hyper threading, so I believe they really have
two cores. Maybe you are thinking he was talking about a 3Ghz Core
Duo.
http://www.newegg.com/Product/ProductList.asp?Category=34&N=2000340000+5
0001157+1302820275+1051007392&Submit=ENE
Dave
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: dave@tridecap.com, jnasby@pervasive.com
Subject: Re: Problem with query, server totally unresponsive
In-Reply-To: <000c01c64f51$cb71b590$8300a8c0@tridecap.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