Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Queries within a function
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
Responses
- Re: Queries within a function at 2010-02-02 19:07:10 from Pavel Stehule
- Re: Queries within a function at 2010-02-02 19:27:59 from Tom Lane
- Re: Queries within a function at 2010-02-02 19:59:07 from Ing. Marcos Ortiz Valmaseda
- Re: Queries within a function at 2010-02-03 16:10:46 from Віталій Тимчишин
pgsql-performance by date
Next: From: Andres Freund Date: 2010-02-02 18:34:07 Subject: Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Previous: From: Robert Haas Date: 2010-02-02 18:14:40 Subject: Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)