Postgres Pro
Downloads
Home   >   mailing lists

Re: Cost of AtEOXact_Buffers in --enable-cassert - Mailing list pgsql-hackers

From Greg Smith
Subject Re: Cost of AtEOXact_Buffers in --enable-cassert
Date
Msg-id 4C622C58.6@2ndquadrant.com
Whole thread Raw
In response to Cost of AtEOXact_Buffers in --enable-cassert  (Andres Freund <andres@anarazel.de>)
Responses Re: Cost of AtEOXact_Buffers in --enable-cassert
List pgsql-hackers
Tree view 
Andres Freund wrote:
> The most prohibitively expensive part is the AtEOXact_Buffers check of running 
> through all buffers and checking their pin count. And it makes $app's 
> regression tests take thrice their time...
>   

Have you tried reducing shared_buffers from the default the system found 
by probing to make this overhead smaller?

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Regression tests versus the buildfarm environment
Next
From: Fujii Masao
Date:
Subject: Re: RecordTransactionCommit() and SharedInvalidationMessages