More statistics? [was: SLOOOOOOOW]

From: "John D(dot) Burger" <john(at)mitre(dot)org>
To: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: More statistics? [was: SLOOOOOOOW]
Date: 2005-09-05 15:16:03
Message-ID: 9dc8673d7204c6ebc540cfa8e4c02037@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Have you set your stats appropriately?

I've been wondering about how high to set these - is there any
performance downside to pumping up the statistics count on a table? I
presume ANALYZE will take longer, and the planner might take a tiny bit
longer, but otherwise, it can't hurt, correct?

Thanks.

- John D. Burger
MITRE

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2005-09-05 15:54:54 Re: Embed PostgreSQL in application
Previous Message Zlatko Matić 2005-09-05 13:49:23 remote connection, web hosting, IP adress