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;
From: [EMAIL PROTECTED]
[mailto:pgsql-performance-
[EMAIL PROTECTED] 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
On Fri, Mar 24, 2006 at 08:46:54AM -0600, Dave Dutcher wrote:
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
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.
I get this message when I try to cancel the query:
server closed the connection unexpectedly
This probably