Re: [PERFORM] Queries within a function

: Віталій Тимчишин [mailto:tiv...@gmail.com] Sent: Wednesday, February 03, 2010 8:11 AM To: Mridula Mahadevan Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Queries within a function 2010/2/2 Mridula Mahadevan mailto:mmahade...@stratify.com>> Hi, I am running a bunch of q

Re: [PERFORM] Queries within a function

Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Tuesday, February 02, 2010 11:28 AM To: Mridula Mahadevan Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Queries within a function Mridula Mahadevan writes: > I am running a bunch of queries within a function, creating s

Re: [PERFORM] Queries within a function

clauses -Original Message- From: "Ing. Marcos Ortiz Valmaseda" [mailto:mlor...@uci.cu] Sent: Tuesday, February 02, 2010 11:59 AM To: Mridula Mahadevan Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Queries within a function Mridula Mahadevan wrote: > > Hi, &g

[PERFORM] 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 idea