Re: Optimizing a read-only database

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'Sameer Thakur *EXTERN*'" <samthakur74(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Optimizing a read-only database
Date: 2015-05-20 08:25:34
Message-ID: A737B7A37273E048B164557ADEF4A58B366130E4@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sameer Thakur 2015-05-20 08:52:50 Re: Optimizing a read-only database
Previous Message Albe Laurenz 2015-05-20 08:11:56 Re: Memory Utilization Issue