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: 4B68840B.3020402@uci.cu (view raw or flat)
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?

Regards


-- 
--------------------------------------------------------------------------------
"Para ser realmente grande, hay que estar con la gente, no por encima de ella."
                                                                   Montesquieu
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"
http://www.postgresql-es.org
http://www.postgresql.org
http://www.planetpostgresql.org

-- DWH + BI --
The Data WareHousing Institute
http://www.tdwi.org
http://www.tdwi.org/cbip
---------------------------------------------------------------------------------


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

In response to

Responses

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-2014 The PostgreSQL Global Development Group