Re: User Quota Implementation

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Yann Michel
> Sent: 11 June 2005 09:49
> To: Josh Berkus
> Cc: pgsql-hackers(at)postgresql(dot)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.