Queries within a function

Поиск
Список
Период
Сортировка
От Mridula Mahadevan
Тема Queries within a function
Дата
Msg-id 0A59BA5B590B7E4A8D441196A9F17E904C68825D26@corpmail11.calpurnia.com
обсуждение исходный текст
Ответы Re: Queries within a function
Re: Queries within a function
Re: Queries within a function
Re: Queries within a function
Список pgsql-performance

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

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)