Re: SOC & user quotas
От | Martijn van Oosterhout |
---|---|
Тема | Re: SOC & user quotas |
Дата | |
Msg-id | 20070228183936.GC3157@svana.org обсуждение исходный текст |
Ответ на | Re: SOC & user quotas ("Joshua D. Drake" <jd@commandprompt.com>) |
Ответы |
Re: SOC & user quotas
|
Список | pgsql-hackers |
On Wed, Feb 28, 2007 at 09:58:52AM -0800, Joshua D. Drake wrote: > E.g; if user foo then pg_database_size may not be > than X? > > I guess the big question would be when do we check though? At each > transaction seems like it would add significant overhead, especially if > we had to rollback the transaction because it was going to go over their > quota. Generally, rolling back a transaction doesn't reduce the amount of disk used. Only VACUUM FULL actually shrinks relations. Seem to me if the RelationOpen stores a pointer to a counter that gets incremented on mdextend, it should work reasonably well. Extending doesn't happen that often relative to other database activity. Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
В списке pgsql-hackers по дате отправления: