>on 06/08/11 11:14 PM, Andrea Peri wrote:
>Hi,
>
>
>Is possible the limit the size of an user (quota user) as space allocated in a tablespace ? >I don't find this option in the 9.0 version of PG,
>so I think it is not available.
>
>Perhaps it should be possible to simulate it using triggers.
>
>
>However before start to work on it , I like to have a confirm and if there is some documentation or information on this >problem available.
>what exactly would this limit?
>
>
>The total size of tables created by that user regardless of what role inserted data into said tables? There's really no way to >track the data written by a user into tables that multiple users have insert/update privs to. and does it include older tuple >versions that aren't yet vacuumed? calculating pg_total_relation_size is fairly expensive, too, it requires scanning the table >and ancilliary items (indexes, toast storage) to sum up the number of blocks allocated. >
I guess the quota limit should be applied to the owner of the table is also the owner of the indexes, sequences, and so on..
regardless of which has inserted on it.
And also regardless of vacuumed space.
>calculating pg_total_relation_size is fairly expensive, too, it requires scanning the table >and ancilliary items (indexes, toast
>storage) to sum up the number of blocks allocated.
yes I think this is a fairly expensive task,
But is for me necessary.
--
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------