Re: Optimizing a read-only database

From: hari(dot)fuchs(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimizing a read-only database
Date: 2015-05-19 08:12:42
Message-ID: 87vbfpj891.fsf@hf.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

François Battail <francois(dot)battail(at)sipibox(dot)fr> writes:

> My bad, got it. May be interesting but as I have a lot of indexes it
> will be hard to test and to choose the best candidate. No idea of how
> it can affect EWKB data indexed by a GiST (PostGIS) index, but it's
> something to try just to know.

You could also raise the statistics target and re-analyze. This will
take some time, but then your query plans might be better.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2015-05-19 09:39:20 Documentation bug?
Previous Message Geoff Montee 2015-05-18 18:24:04 Re: SQL Server access from PostgreSQL