Re: Problem with a rule on upgrade to v7.1.1
| От | Tom Lane |
|---|---|
| Тема | Re: Problem with a rule on upgrade to v7.1.1 |
| Дата | |
| Msg-id | 3934.989534679@sss.pgh.pa.us обсуждение |
| Ответ на | Re: Problem with a rule on upgrade to v7.1.1 (Jon Lapham <lapham@extracta.com.br>) |
| Ответы |
Re: Problem with a rule on upgrade to v7.1.1
Re: Problem with a rule on upgrade to v7.1.1 |
| Список | pgsql-hackers |
Jon Lapham <lapham@extracta.com.br> writes:
>> Uh, have you VACUUM ANALYZEd yet? Those EXPLAIN numbers look
>> suspiciously like default statistics ...
> Nope, forgot to on the little demonstration tables I made. I tacked the
> post-VACUUM ANALYZE explain results (they look much better) at the end of
> this email.
Ah. The plans for the little demo tables are uninteresting anyway,
but the plans for the real tables are interesting.
Next question: do you still have your 7.0.* DB up? Can you get an
EXPLAIN that shows how it did it (on the real tables)?
regards, tom lane
В списке pgsql-hackers по дате отправления: