Re: Optimizing a read-only database - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Optimizing a read-only database
Date
Msg-id A737B7A37273E048B164557ADEF4A58B366130E4@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: Optimizing a read-only database  (Sameer Thakur <samthakur74@gmail.com>)
Responses Re: Optimizing a read-only database  (Sameer Thakur <samthakur74@gmail.com>)
List pgsql-general
Sameer Thakur wrote:
> You could disable fsync as write reliability is not relevant

That is bad advice.
If there are no writes, fsync won't hurt anyway.
Never disable fsync for anything but test systems.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Memory Utilization Issue
Next
From: Sameer Thakur
Date:
Subject: Re: Optimizing a read-only database