From: "Ing. Marcos Ortiz Valmaseda" <mlortiz@uci.cu>
To: Mridula Mahadevan <mmahadevan@stratify.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Queries within a function
Date: Tue, 02 Feb 2010 14:59:07 -0500
Message-ID: <4B68840B.3020402@uci.cu> (raw)
In-Reply-To: <0A59BA5B590B7E4A8D441196A9F17E904C68825D26@corpmail11.calpurnia.com>
References: <0A59BA5B590B7E4A8D441196A9F17E904C68825D26@corpmail11.calpurnia.com>
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.orghttp://www.postgresql.orghttp://www.planetpostgresql.org
-- DWH + BI --
The Data WareHousing Institute
http://www.tdwi.orghttp://www.tdwi.org/cbip
---------------------------------------------------------------------------------
Attachments:mlortiz.vcf (text/x-vcard, 637B) download
begin:vcard
fn;quoted-printable:Marcos Lu=C3=ADs Ort=C3=ADz Valmaseda
n;quoted-printable;quoted-printable:Ort=C3=ADz Valmaseda;Marcos Lu=C3=ADs
org:CENTALAD;PostgreSQL DB Architect and Sys Admin
adr;quoted-printable:;;Universidad de las Ciencias Inform=C3=A1ticas;La Habana;CH;10400;Cuba
email;internet:marcosluis2186@gmail.com
title;quoted-printable:Centro de Tecnolog=C3=ADas de Almacenamiento y An=C3=A1lisis de Datos
tel;quoted-printable;work:Centro de Tecnolog=C3=ADas de Almacenamiento y An=C3=A1lisis de Datos
tel;home:Edificio # 18. Apto 9 .5to Piso. Rpto: A.Mestre
x-mozilla-html:TRUE
url:http://www.uci.cu
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mlortiz@uci.cu, mmahadevan@stratify.com
Subject: Re: Queries within a function
In-Reply-To: <4B68840B.3020402@uci.cu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox