Re: User Quota Implementation

> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Yann Michel
> Sent: 11 June 2005 09:49
> To: Josh Berkus
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] User Quota Implementation
>
>
> 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?

> - 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.

Regards, Dave.