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
|
| Список | pgsql-performance |
2010/2/2 Mridula Mahadevan <mmahadevan@stratify.com>
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.
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 по дате отправления: