Postgres Pro
Downloads
Home   >   mailing lists

Re: Help, 400 million rows, query slow, I stopped after 5 days - Mailing list pgsql-novice

From Tom Lane
Subject Re: Help, 400 million rows, query slow, I stopped after 5 days
Date
Msg-id 8341.1138638524@sss.pgh.pa.us
Whole thread Raw
In response to Re: Help, 400 million rows, query slow, I stopped after 5 days  ("Christian Hofmann" <christian.hofmann@gmx.de>)
Responses Re: Help, 400 million rows, query slow, I stopped after 5 days  ("Christian Hofmann" <christian.hofmann@gmx.de>)
List pgsql-novice
Tree view 
"Christian Hofmann" <christian.hofmann@gmx.de> writes:
> work_mem = 650240            # min 64, size in KB

> But where can I find the sort_mem? In postgresql.conf is nothing with that
> keyword :-(

work_mem and sort_mem are the same ... so looks like you already pushed
it up.  Actually, maybe you pushed it up too far --- are you sure that
the machine has 650M RAM available to spare?  On Unix I'd suggest
watching free memory and swap activity to tell if it's too high, but
I dunno how to tell on Windows.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Luis Silva"
Date:
Subject: Re: quering NULL values
Next
From: Bruno Wolff III
Date:
Subject: Re: Restoring SQL Databse for use in PostgreSQL.