Re: shared_buffers Question

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Joe Lester <joe_lester(at)sweetwater(dot)com>
Cc: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Re: shared_buffers Question
Date: 2004-08-11 03:50:55
Message-ID: BD3EF3BF.4D8BA%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Your shared buffers are almost certainly not the problem here. 2000
> shared buffers is only 16 Megs of ram, max. More than likely, the
> database filled up the data directory / partition because it wasn't
> being vacuumed.

Yes.

Also check to make sure that some rogue process somewhere isn't filling your
hard disk with some huge log file. I don't remember the UNIX commands
offhand, but you should sudo a search starting in / for all large files, say
> 1GB for instance.

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 665-7007 voice

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2004-08-11 04:03:33 Re: shared_buffers Question
Previous Message Rajesh Kumar Mallah 2004-08-11 03:48:18 Re: error moving table to tablespace (8.0 beta win32 )