Re: checkpointer continuous flushing - Mailing list pgsql-hackers

From Cédric Villemain
Subject Re: checkpointer continuous flushing
Date
Msg-id 55754802.1050401@2ndQuadrant.com
Whole thread Raw
In response to Re: checkpointer continuous flushing  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: checkpointer continuous flushing  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
Le 07/06/2015 16:53, Fabien COELHO a écrit :
> +» » /*·Others:·say·that·data·should·not·be·kept·in·memory...
> +» » ·*·This·is·not·exactly·what·we·want·to·say,·because·we·want·to·write
> +» » ·*·the·data·for·durability·but·we·may·need·it·later·nevertheless.
> +» » ·*·It·seems·that·Linux·would·free·the·memory·*if*·the·data·has
> +» » ·*·already·been·written·do·disk,·else·it·is·ignored.
> +» » ·*·For·FreeBSD·this·may·have·the·desired·effect·of·moving·the
> +» » ·*·data·to·the·io·layer.
> +» » ·*/
> +» » rc·=·posix_fadvise(context->fd,·context->offset,·context->nbytes,
> +» » » » » » ···POSIX_FADV_DONTNEED);
> +

It looks a bit hazardous, do you have a benchmark for freeBSD ?

Sources says:case POSIX_FADV_DONTNEED:    /*     * Flush any open FS buffers and then remove pages     * from the
backingVM object.  Using vinvalbuf() here     * is a bit heavy-handed as it flushes all buffers for     * the given
vnode,not just the buffers covering the     * requested range.
 

-- 
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: PATCH: use foreign keys to improve join estimates v1
Next
From: Fabien COELHO
Date:
Subject: Re: checkpointer continuous flushing