Re: Queries within a function

Поиск
Список
Период
Сортировка
От Віталій Тимчишин
Тема Re: Queries within a function
Дата
Msg-id 331e40661002030810p445dd862i3eb9f3c025943d1d@mail.gmail.com
обсуждение исходный текст
Ответ на Queries within a function  (Mridula Mahadevan <mmahadevan@stratify.com>)
Ответы Re: Queries within a function  (Mridula Mahadevan <mmahadevan@stratify.com>)
Список pgsql-performance
Дерево обсуждения


2010/2/2 Mridula Mahadevan <mmahadevan@stratify.com>

Hi,

 I am running a bunch of queries within a function, creating some temp tables and populating them. When the data exceeds say, 100k the queries start getting really slow and timeout (30 min). when these are run outside of a transaction(in auto commit mode), they run in a few seconds. Any ideas on what may be going on and any postgresql.conf parameters etc that might help?

Thanks

Have you tried to analyze temp tables after you've populated them? Because AFAIK it won't do it automatically for tables created, filled and then used  in same transaction.

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

Предыдущее
От: Nikolas Everett
Дата:
Сообщение: Re: queries with subquery constraints on partitioned tables not optimized?
Следующее
От: Reid Thompson
Дата:
Сообщение: Re: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes