Re: Query plan - now what?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query plan - now what?
Дата
Msg-id 19869.1071243210@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Query plan - now what?  (David Shadovitz <david@shadovitz.com>)
Список pgsql-performance
David Shadovitz <david@shadovitz.com> writes:
> Well, now that I have the plan for my slow-running query, what do I
> do?

This is not very informative when you didn't show us the query nor
the table schemas (column datatypes and the existence of indexes
are the important parts).  I have a feeling that you might be well
advised to fold the multiple tables into one "animals" table, but
there's not enough info here to make that recommendation for sure.

BTW, what did you do with this, print and OCR it?  It's full of the
most bizarre typos ... mostly "l" for "1", but others too ...

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Rhaoni Chiu Pereira
Дата:
Сообщение: ODBC Driver generates a too big "windows swap file" and it's too slow
Следующее
От: David Shadovitz
Дата:
Сообщение: Re: Query plan - now what?