Re: SOC & user quotas - Mailing list pgsql-hackers

From Sergey E. Koposov
Subject Re: SOC & user quotas
Date
Msg-id Pine.LNX.4.64.0703010151250.14175@lnfm1.sai.msu.ru
Whole thread Raw
In response to Re: SOC & user quotas  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
On Wed, 28 Feb 2007, Joshua D. Drake wrote:

> The bad point is not that we would rollback the transaction. The bad
> point is what happens when you need to rollback a transaction and in
> your scenario it is quite plausible that a large rollback could occur,
> more than once, causing the requirement of something like a vacuum full
> to clean things up.

Yes, I understand, but I think, the scenario of working and always 
hitting a quota is not normal. I think you shouldn't expect perfect, 
stable performance etc. in that case. It's similar to if you'll try to 
work with PG with very little memory and/or shared memory. You can work, 
but you can easily hit these limits, and than something will not work...

regards,    Sergey

*******************************************************************
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: math@sai.msu.ru


pgsql-hackers by date:

Previous
From: Joachim Wieland
Date:
Subject: Re: SOC & user quotas
Next
From: "Sergey E. Koposov"
Date:
Subject: Re: SOC & user quotas