Re: after vacuum analyze, explain still wrong

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: after vacuum analyze, explain still wrong
Date: 2009-06-23 08:45:11
Message-ID: h1q4ml$2q3j$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Viktor Rosenfeld 2009-06-23 09:03:18 Re: Graphical representation of query plans
Previous Message Grzegorz Jaśkiewicz 2009-06-23 07:55:27 Re: Why my queryes doesnt not use indexes?