Postgres Pro
Downloads
Home   >   mailing lists

Re: after vacuum analyze, explain still wrong - Mailing list pgsql-general

From Sim Zacks
Subject Re: after vacuum analyze, explain still wrong
Date
Msg-id h1q4ml$2q3j$1@news.hub.org
Whole thread Raw
In response to after vacuum analyze, explain still wrong  (Sim Zacks <sim@compulab.co.il>)
Responses Re: after vacuum analyze, explain still wrong
List pgsql-general
Tree view 
> increase default_statistics_target to 100 for instance, and retry.

I changed the setting, reloaded the configuration (without restarting
the server) ran vacuum analyze and the results were the exact same.

Any other thoughts?

Sim

pgsql-general by date:

Previous
From: Viktor Rosenfeld
Date:
Subject: Re: Graphical representation of query plans
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: after vacuum analyze, explain still wrong