Re: WAL Rate Limiting - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: WAL Rate Limiting
Date
Msg-id 52D94D72.1070308@vmware.com
Whole thread Raw
In response to Re: WAL Rate Limiting  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: WAL Rate Limiting  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On 01/17/2014 05:20 PM, Simon Riggs wrote:
> +    if (RelationNeedsWAL(indexrel))
> +        CHECK_FOR_WAL_BUDGET();

I don't think we need the RelationNeedsWAL tests. If the relation is not 
WAL-logged, you won't write much WAL, so you should easily stay under 
the limit. And CHECK_FOR_WAL_BUDGET() better be cheap when you're below 
the limit.

- Heikki



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: WAL Rate Limiting
Next
From: Mel Gorman
Date:
Subject: Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance