Re: User Quota Implementation - Mailing list pgsql-hackers

From Yann Michel
Subject Re: User Quota Implementation
Date
Msg-id 20050611170852.GA21180@grrr.spline.inf.fu-berlin.de
Whole thread Raw
In response to Re: User Quota Implementation  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-hackers
Hi,

On Sat, Jun 11, 2005 at 05:36:34PM +0100, Dave Page wrote:
> > 
> > What do we need:
> > 
> > - Extension of the "CREATE TABLESPACE" command:
> >   CREATE TABLESPACE tablespacename 
> >         [ OWNER username ] 
> >         [ SIZE <integer><K | M | G | T> ] 
> >         LOCATION 'directory'
> > 
> > - Extension of the "ALTER TABLESPACE" command:
> >   ALTER TABLESPACE name 
> >         {RENAME TO newname |
> >         SIZE <integer><K | M | G | T> }
> 
> Wouldn't MAXSIZE be more appropriate?

Yes, of cause. 

> > - Storage of this information in the system "tablespace" relation
> >   
> > - Determine the actual size of a tables space
> >   --> Already exists in contrib/dbsize/dbsize.c
> 
> A patch was recently submitted by Andreas Pflug to move those functions
> into the backend permanently.

I think that's why I found it there ;-)

Regards,
Yann


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: The Contrib Roundup (long)
Next
From: Heikki Linnakangas
Date:
Subject: Re: Two-phase commit issues