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

Re: Help, 400 million rows, query slow, I stopped after 5 days

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christian Hofmann" <christian(dot)hofmann(at)gmx(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Help, 400 million rows, query slow, I stopped after 5 days
Date: 2006-01-30 16:28:44
Message-ID: 8341.1138638524@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"Christian Hofmann" <christian(dot)hofmann(at)gmx(dot)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

In response to

Responses

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2006-01-30 17:36:02
Subject: Re: Restoring SQL Databse for use in PostgreSQL.
Previous:From: Luis SilvaDate: 2006-01-30 15:55:55
Subject: Re: quering NULL values

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