| 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
| 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 ) |