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

Re: snowflaking

From: Joe Conway <mail(at)joeconway(dot)com>
To: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: snowflaking
Date: 2004-04-05 05:27:09
Message-ID: 4070EE2D.2090909@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-novice
Nabil Sayegh wrote:
[...big snowflake query and explain analyze results...]
> Is there anything I can do to speed it a bit up?
> We can assume, that
> a) inserts are done very rarely and
> b) the number of actual results are very low

One simple idea is to use PREPARE and EXECUTE. This is only useful if 
you can PREPARE once and then EXECUTE multiple times (i.e. as long as 
you don't need to reconnect prior to every execution of the query).

HTH,

Joe

In response to

Responses

pgsql-novice by date

Next:From: Nabil SayeghDate: 2004-04-05 12:02:56
Subject: Re: snowflaking
Previous:From: stm23Date: 2004-04-05 03:31:05
Subject: ecpg preprocessor

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