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 f
> 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 bi
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;
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
