> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings