Re: User Quota Implementation

Поиск
Список
Период
Сортировка
От Jonah H. Harris
Тема Re: User Quota Implementation
Дата
Msg-id 40EEC659.8070307@tvi.edu
обсуждение исходный текст
Ответ на Re: User Quota Implementation  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Ответы Re: User Quota Implementation
Список pgsql-hackers
Quota is currently enforced on commit.  I've considered checking during 
insert/update/copy and throwing an abort but within a transaction they 
may be deleting data as well.

However, even as a delete may take place before a massive insert/update, 
a vacuum cannot be run within a transaction block and therefore the 
commit would fail at the same point as an insert/update within the 
transaction itself.

So, essentially, there is no difference at which point to check other 
than to reduce the calculation overhead by placing the check at the 
commit point.

What's the consensus on when to check?

Alvaro Herrera wrote:
> On Thu, Jul 08, 2004 at 03:27:34PM -0600, Jonah H. Harris wrote:
> 
> 
>>Out of necessity, I've implemented user quotas in 7.4.3.  What would the 
>>process be for having this reviewed and combined?  I have a patch for 
>>7.4.3 ready, but wanted to know if you suggest that I patch the latest 
>>cvs instead.  Below if some information on the implementation.
> 
> 
> At exactly what time is the quota enforced?  Does the enforcement
> somehow serialize that operation?
> 

-- 
Jonah H. Harris, UNIX Administrator  | phone: 505.224.4814
Albuquerque TVI                      | fax:   505.224.3014
525 Buena Vista SE                   | jharris@tvi.edu
Albuquerque, New Mexico 87106        | http://w3.tvi.edu/~jharris/

"All great truths begin as blasphemies."                --  George Bernard Shaw



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Nested Transactions, Abort All
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: User Quota Implementation