Re: Optimizing a read-only database

From: François Battail <francois(dot)battail(at)sipibox(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimizing a read-only database
Date: 2015-05-18 14:38:18
Message-ID: 5559F95A.2040405@sipibox.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le 18/05/2015 16:20, Andreas Kretschmer a écrit :

Thank you Andreas,

> you can set fillfactor to 100

Yes, but it's already the default value according to documentation.

> And you can disable VACUUM.

Already done ;-)

I was more dreaming of something like "disable read write locks or
mutexes" when accessing the database in read-only mode, but sadly this
case seems unhandled.

Best regards

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William Dunn 2015-05-18 14:38:21 Re: Optimizing a read-only database
Previous Message Koray Eyidoğan 2015-05-18 14:34:21 Re: pg_xlog Concern