Re: Pre-allocation of space: a business rationale - Mailing list pgsql-admin

From Tom Lane
Subject Re: Pre-allocation of space: a business rationale
Date
Msg-id 17603.1130989680@sss.pgh.pa.us
Whole thread Raw
In response to Pre-allocation of space: a business rationale  ("Bath, David" <dave.bath@unix.net>)
Responses Re: Pre-allocation of space: a business rationale
List pgsql-admin
"Bath, David" <dave.bath@unix.net> writes:
> C) I want to avoid the possibility of uncontrolled growth of luser data
>    blowing disk leading to stoppage of 24x7 data.

You put the luser data and the critical data into separate tablespaces
that are in separate partitions (filesystems).  End of problem ...

(And no, I don't believe in having Postgres reinvent filesystem-level
functionality.  If you didn't set up appropriate hard partitions,
consider a loopback filesystem for your tablespace.)

            regards, tom lane

pgsql-admin by date:

Previous
From: "Bath, David"
Date:
Subject: Pre-allocation of space: a business rationale
Next
From: Geoffrey
Date:
Subject: multiple postmasters on red hat cluster suite