Re: Query sometimes takes down server

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Query sometimes takes down server
Дата
Msg-id 1232132656.17048.19.camel@dell.linuxdev.us.dell.com
обсуждение исходный текст
Ответ на Re: Query sometimes takes down server  (Jason Long <mailing.list@supernovasoftware.com>)
Список pgsql-general
On Fri, 2009-01-16 at 12:35 -0600, Jason Long wrote:
> The schema is not auto generated.  It evolved as I created my
> inventory system.
> It is relatively easy for humans to understand.  Or at least for me
> since I wrote it.

On second look, there aren't that many tables. There are just a lot of
self joins. Those are going to be hard for PostgreSQL to optimize
effectively.

Looks like it's just the query that's hard to understand. You might do
better just writing it yourself from scratch.

Regards,
    Jeff Davis


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

Предыдущее
От: Jason Long
Дата:
Сообщение: Re: Query sometimes takes down server
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Query sometimes takes down server