Re: Optimizing a read-only database - Mailing list 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