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

Re: snowflaking

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Joe Conway <mail(at)joeconway(dot)com>,pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: snowflaking
Date: 2004-04-05 12:02:56
Message-ID: 40714AF0.3040605@e-trolley.de (view raw or flat)
Thread:
Lists: pgsql-novice
Joe Conway wrote:
> 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).

Hm, unfortunately my queries (at least the expensive ones) are only executed once per session.
If only it could be made persistent, then it would help :(

Any other ideas?
What if I create views for such queries?
Would these be faster (i.e. prepared automatically/persistent)?

TFYH
-- 
  e-Trolley Sayegh & John, Nabil Sayegh
  Tel.: 0700 etrolley /// 0700 38765539
  Fax.: +49 69 8299381-8
  PGP : http://www.e-trolley.de

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2004-04-06 04:25:26
Subject: Re: Help for MSSQL "Compute" equivalent in Postgres
Previous:From: Joe ConwayDate: 2004-04-05 05:27:09
Subject: Re: snowflaking

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