On Tue, Mar 28, 2006 at 10:23:45AM -0800, Mark Liberman wrote:
> > Probably your biggest issue will be temporary files created by temporary
> > tables, sorts that spill to disk, etc.
>
> Is there any way to monitor this so I can estimate?
Keep an eye on $PGDATA/base/{database_oid}/pgsql_tmp.
> > What I'm confused by is the concern about disk space in the first place.
>
> We provide a device to customers that must run in an unattended fashion for
> as long as the hardward holds up. So, regardless of the disk size, they will
> run out at some time. Some of our solutions grow by 3.5 Gigs per day - and 6
> months of history is not an unreasonable expectation. We've just decided we
> want to keep as much history as possible given space limitations.
You might want to take a look at http://rrs.decibel.org, which is
something I created for a similar purpose.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
