| From: | Ray Ontko <rayo(at)ontko(dot)com> |
|---|---|
| To: | Ray Ontko <rayo(at)ontko(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Are statistics gathered on function indexes? |
| Date: | 2002-06-28 15:44:02 |
| Message-ID: | 200206281544.KAA04567@shire.ontko.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Tom, et al,
> It appears that "vacuum analyze verbose actor" causes the problem.
> It appears that I have to say "vacuum analyze actor" in order to
> clear out the ill effects of having said "vacuum analyze verbose actor".
> Typing "vacuum verbose analyze actor" doesn't clear things out,
> but it doesn't produce the problem.
Here's two more data points:
1) "analyze verbose actor" causes the problem too. "analyze actor"
usually clears the problem out.
2) In cases where "analyze actor" doesn't clear out the problem,
exiting psql and trying again does clear the problem out.
Ray
----------------------------------------------------------------------
Ray Ontko rayo(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexaki Sofia | 2002-06-28 16:17:23 | Compile problem in PostgreSQL v7.2.1 |
| Previous Message | Nick Fankhauser | 2002-06-28 15:15:38 | Re: Postmaster environment variables |