Skip site navigation (1) Skip section navigation (2)

Re: Problem with query, server totally unresponsive

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Bendik Rognlien Johansen <bendik(dot)johansen(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Problem with query, server totally unresponsive
Date: 2006-03-24 10:25:20
Message-ID: 20060324102520.GS90527@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

Responses

pgsql-performance by date

Next:From: Alvaro HerreraDate: 2006-03-24 12:39:02
Subject: Re: WAL logging of SELECT ... INTO command
Previous:From: Jim C. NasbyDate: 2006-03-24 10:21:38
Subject: Re: Indexes with descending date columns

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group