Re: Extent Locks

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Extent Locks
Date: 2013-05-28 16:44:51
Message-ID: 20130528164451.GH8597@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Jaime Casanova (jaime(at)2ndquadrant(dot)com) wrote:
> On Tue, May 28, 2013 at 10:53 AM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
> > But I agree. This needs to work without much manual intervention. I
> > think we just need to make autovacuum truncate only if it finds more
> > free space than whatever amount we might have added at that relation
> > size plus some slop.
>
> And how do you decide the amount of that "slop"?

How about % of table size?

Thanks,

Stephen

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Clark C. Evans 2013-05-28 17:00:51 GRANT role_name TO role_name ON database_name
Previous Message Jaime Casanova 2013-05-28 16:42:55 Re: Extent Locks