On Fri, 2004-07-09 at 09:29, Stephen Frost wrote: > * Christopher Kings-Lynne ([EMAIL PROTECTED]) wrote: > > >Personally, I would love to see this in PostgreSQL. It'd be great if it > > >could get into 7.5. An issue I see with that is that (similar to > > >Oracle...) I think people would want to be able to specify > > >per-tablespace quotas. Perhaps that wouldn't be too hard to add? > > > > 7.5 is already closed for new features I believe... > > Quotas is part of a sane tablespace implementation, right? O;)
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. Or do we expect a PostgreSQL implementation to do more than that, to only count active data by ignoring data pending a vacuum? ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
