Re: User Quota Implementation - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: User Quota Implementation
Date
Msg-id 20040709150650.GE21419@ns.snowman.net
Whole thread Raw
In response to Re: User Quota Implementation  (Rod Taylor <pg@rbt.ca>)
Responses Re: User Quota Implementation  (Rod Taylor <pg@rbt.ca>)
List pgsql-hackers
* Rod Taylor (pg@rbt.ca) wrote:
> I would think having would allow us to take advantage of all of the
> various kernel level filesystem features without needing to implement
> them directly within PostgreSQL (crypto, quotas, data mirror, etc.).
>
> Simply setup a tablespace for a given user with permissions to allow
> only that user to create new objects within it and make it the default
> location) -- tie their schema to their tablespace? -- then set a kernel
> level quota on their tablespace.

Since the user accessing/writing to the tablespaces would be the
postgres user I don't really think this 'solution' works in reality.

> Or do we expect a PostgreSQL implementation to do more than that, to
> only count active data by ignoring data pending a vacuum?

Certainly, it should.
Stephen

pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: User Quota Implementation
Next
From: Bruce Momjian
Date:
Subject: Re: pg_dump 7.4 bug