Re: [GENERAL] "Quota"

2007-06-27 Thread Hannes Dorbath
On 27.06.2007 15:18, Albe Laurenz wrote: Hannes Dorbath wrote: What would be a solution to prevent a single user/schema to fill the disk using PostgreSQL? Is it a good idea to use separate table spaces? Table spaces are the only solution I can think of. If you create a table space on a differe

Re: [GENERAL] "Quota"

2007-06-27 Thread Hannes Dorbath
On 27.06.2007 16:58, Dawid Kuroczko wrote: On 6/27/07, Hannes Dorbath <[EMAIL PROTECTED]> wrote: What would be a solution to prevent a single user/schema to fill the disk using PostgreSQL? Is it a good idea to use separate table spaces? I am contemplating using XFS filesystem's quota to achiev

Re: [GENERAL] "Quota"

2007-06-27 Thread Dawid Kuroczko
On 6/27/07, Hannes Dorbath <[EMAIL PROTECTED]> wrote: What would be a solution to prevent a single user/schema to fill the disk using PostgreSQL? Is it a good idea to use separate table spaces? I am afraid currently you are stuck with tablespaces as a quoting tool. Of course having a filesyste

Re: [GENERAL] "Quota"

2007-06-27 Thread Albe Laurenz
Hannes Dorbath wrote: > > What would be a solution to prevent a single user/schema to fill the > disk using PostgreSQL? Is it a good idea to use separate table spaces? Table spaces are the only solution I can think of. If you create a table space on a different file system, then a table in that

[GENERAL] "Quota"

2007-06-27 Thread Hannes Dorbath
What would be a solution to prevent a single user/schema to fill the disk using PostgreSQL? Is it a good idea to use separate table spaces? -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore y