| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | vinita bansal <sagivini(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: generating statistics |
| Date: | 2005-03-16 19:04:07 |
| Message-ID: | 20050316190406.GA36496@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Mar 16, 2005 at 06:27:43PM +0000, vinita bansal wrote:
> > Did you uncomment the settings in addition to setting them to true?
> > Did you restart the database after making the configuration changes?
>
> Yes, I did.
> FYI- I am using Postgres 8
Have you used SHOW to verify that the variables are indeed set? As
Tom Lane suggested, if you're on a *nix system, did you use "ps"
to see if the stats buffer process and stats collector process are
running? (I'm not sure how to check that if you're on Windows.)
Have you looked for errors in the postmaster logs?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heather Johnson | 2005-03-16 19:34:48 | help with plpgsql function called by trigger |
| Previous Message | Michael Fuhr | 2005-03-16 18:13:21 | Re: plpython function problem workaround |