Re: complicated queries in pl/pgsql

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: complicated queries in pl/pgsql
Дата
Msg-id 200301141236.15915.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: complicated queries in pl/pgsql  (Tomasz Myrta <jasiek@klaster.net>)
Список pgsql-performance
Tomasz,

> Thanks a lot.
> I'm asking, because I use some queries which are easy to change into
> views. Most of their execution time takes planning, they use 5-10
> explicit table joins with not too many rows in these tables and returns
> few values.

You might want to investigate the new "prepared query" functionality in 7.3.1.

I haven't used it yet, so I can't help much.


--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: 7.3.1 New install, large queries are slow
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: 7.3.1 New install, large queries are slow