More statistics? [was: SLOOOOOOOW]

"John D. Burger" <john@xxxxxxxxx> · Mon, 5 Sep 2005 11:16:03 -0400

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq