Skip site navigation (1) Skip section navigation (2)

Re: Queries within a function

From: "Ing(dot) Marcos Orti­z Valmaseda" <mlortiz(at)uci(dot)cu>
To: Mridula Mahadevan <mmahadevan(at)stratify(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Queries within a function
Date: 2010-02-02 19:59:07
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
Mridula Mahadevan wrote:
> 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
Do you put here the result of the explain command of the query?
Do you put here the postgresql.conf parameters that you have in your box?


"Para ser realmente grande, hay que estar con la gente, no por encima de ella."
Ing. Marcos Luís Ortíz Valmaseda
PostgreSQL System DBA && DWH -- BI Apprentice

Centro de Tecnologías de Almacenamiento y Análisis de Datos (CENTALAD)
Universidad de las Ciencias Informáticas

Linux User # 418229

-- PostgreSQL --
"TIP 4: No hagas 'kill -9' a postmaster"

-- DWH + BI --
The Data WareHousing Institute

Attachment: mlortiz.vcf
Description: text/x-vcard (639 bytes)

In response to


pgsql-performance by date

Next:From: Andy ColsonDate: 2010-02-02 20:11:34
Subject: Re: Slow-ish Query Needs Some Love
Previous:From: Tom LaneDate: 2010-02-02 19:58:40
Subject: Re: Re: 回复:Re: [PERFORM] the jokes for pg concurrency write performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group