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

From hari.fuchs@gmail.com
Subject Re: Optimizing a read-only database
Date
Msg-id 87vbfpj891.fsf@hf.protecting.net
Whole thread Raw
In response to Optimizing a read-only database  (François Battail <francois.battail@sipibox.fr>)
List pgsql-general
François Battail <francois.battail@sipibox.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.

pgsql-general by date:

Previous
From: Geoff Montee
Date:
Subject: Re: SQL Server access from PostgreSQL
Next
From: Thomas Kellerer
Date:
Subject: Documentation bug?