Re: Left joining against two empty tables makes a query SLOW
| От | Gnanavel S |
|---|---|
| Тема | Re: Left joining against two empty tables makes a query SLOW |
| Дата | |
| Msg-id | eec3b03c050728210512f3fed5@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Left joining against two empty tables makes a query (Chris Travers <chris@travelamericas.com>) |
| Ответы |
Re: Left joining against two empty tables makes a query
Re: Left joining against two empty tables makes a query |
| Список | pgsql-performance |
On 7/28/05, Chris Travers <chris@travelamericas.com> wrote:
reindex the tables separately.
pg_statistics
Gnanavel S wrote:
>
>
> vacuum & reindex the department and project table as the planner
> expects there are 1060 rows but actually returning nothing.
I guess I should have mentioned that I have been vacuuming and
reindexing at least once a week, and I did so just before running this test.
Normally I do:
vacuum analyze;
reindex database ....;
reindex the tables separately.
Secondly, the project table has *never* had anything in it. So where
are these numbers coming from?
pg_statistics
Best Wishes,
Chris Travers
Metatron Technology Consulting
--
with regards,
S.Gnanavel
Satyam Computer Services Ltd.
В списке pgsql-performance по дате отправления: