From: Віталій Тимчишин <tivv00@gmail.com>
To: Mridula Mahadevan <mmahadevan@stratify.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Queries within a function
Date: Wed, 3 Feb 2010 18:10:46 +0200
Message-ID: <331e40661002030810p445dd862i3eb9f3c025943d1d@mail.gmail.com> (raw)
In-Reply-To: <0A59BA5B590B7E4A8D441196A9F17E904C68825D26@corpmail11.calpurnia.com>
References: <0A59BA5B590B7E4A8D441196A9F17E904C68825D26@corpmail11.calpurnia.com>
2010/2/2 Mridula Mahadevan <mmahadevan@stratify.com>
> 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
>
Have you tried to analyze temp tables after you've populated them? Because
AFAIK it won't do it automatically for tables created, filled and then used
in same transaction.
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: tivv00@gmail.com, mmahadevan@stratify.com
Subject: Re: Queries within a function
In-Reply-To: <331e40661002030810p445dd862i3eb9f3c025943d1d@mail.gmail.com>
* 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