Re: Add database to PGXACT / per database vacuuming - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Add database to PGXACT / per database vacuuming
Date
Msg-id CA+TgmoYGC4yHEto22Erv1BhOHzYVvrV08zjcbCp5iz9JzsD55w@mail.gmail.com
Whole thread Raw
In response to Re: Add database to PGXACT / per database vacuuming  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On Fri, Aug 30, 2013 at 2:29 PM, Andres Freund <andres@2ndquadrant.com> wrote:
>> I don't know how big an impact adding the database oid would have, on the
>> case that the PGPROC/PGXACT split was done in the first place. In the worst
>> case it will make taking a snapshot 1/3 slower under contention. That needs
>> to be tested.
>
> Yes, definitely. I am basically wondering whether somebody has/sees
> fundamental probles with it making it pointless to investigate.

I expect there will be a measurable performance degradation, though
I'm willing to be proven wrong.  I think the question is whether we
get enough bang for the buck out of it to eat that.  It seems quite
likely that users with many databases will come out ahead, as such
systems seem likely to be shared hosting environments where the
machine is lightly loaded most of the time anyway, but where
cross-database interactions cause headaches.  But many users have One
Big Database, and AFAICS this is just overhead for them.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: logical changeset generation v5
Next
From: Andres Freund
Date:
Subject: Re: logical changeset generation v5