Re: User Quota Implementation

From: Yann Michel <yann-postgresql(at)spline(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: Yann Michel <yann-postgresql(at)spline(dot)de>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: User Quota Implementation
Date: 2005-06-11 17:08:52
Message-ID: 20050611170852.GA21180@grrr.spline.inf.fu-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2005-06-11 17:53:22 Re: Two-phase commit issues
Previous Message Tom Lane 2005-06-11 17:01:26 Re: The Contrib Roundup (long)