Re: MultiXacts & WAL - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: MultiXacts & WAL
Date
Msg-id 200606171222.41942.josh@agliodbs.com
Whole thread Raw
In response to Re: MultiXacts & WAL  (paolo romano <paolo.romano@yahoo.it>)
Responses Re: MultiXacts & WAL
List pgsql-hackers
Tom, Paolo,

> Yeah, it's difficult to believe that multixact stuff could form a
> noticeable fraction of the total WAL load, except perhaps under really
> pathological circumstances, because the code just isn't supposed to be
> exercised often.  So I don't think this is worth pursuing.  Paolo's free
> to try to prove the opposite of course ... but I'd want to see numbers
> not speculation.

I would like to see some checking of this, though.  Currently I'm doing
testing of PostgreSQL under very large numbers of connections (2000+) and am
finding that there's a huge volume of xlog output ... far more than
comparable RDBMSes.   So I think we are logging stuff we don't really have
to.

--
Josh Berkus
PostgreSQL @ Sun
San Francisco


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: MultiXacts & WAL
Next
From: Tom Lane
Date:
Subject: Re: MultiXacts & WAL