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
- [PERFORM] Queries within a function Mridula Mahadevan
- Re: [PERFORM] Queries within a functi... Pavel Stehule
- Re: [PERFORM] Queries within a functi... Tom Lane
- Re: [PERFORM] Queries within a fu... Mridula Mahadevan
- Re: [PERFORM] Queries within ... ramasubramanian
- Re: [PERFORM] Queries within a functi... Ing. Marcos Ortiz Valmaseda
- Re: [PERFORM] Queries within a fu... Mridula Mahadevan
- Re: [PERFORM] Queries within a functi... Віталій Тимчишин
- Re: [PERFORM] Queries within a fu... Mridula Mahadevan