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
---------------------------------------------------------------------------------
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@xxxxxxxxx
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
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
