Postgres Pro
Downloads
Home   >   mailing lists

More statistics? [was: SLOOOOOOOW] - Mailing list pgsql-general

From John D. Burger
Subject More statistics? [was: SLOOOOOOOW]
Date
Msg-id 9dc8673d7204c6ebc540cfa8e4c02037@mitre.org
Whole thread Raw
In response to Re: SLOOOOOOOW  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: ECPG in stored procedures?
Next
From: Zlatko Matić
Date:
Subject: remote connection, web hosting, IP adress