Re: complicated queries in pl/pgsql

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tomasz Myrta <jasiek(at)klaster(dot)net>
Cc: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: complicated queries in pl/pgsql
Date: 2003-01-14 20:36:15
Message-ID: 200301141236.15915.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Tomasz,

> Thanks a lot.
> I'm asking, because I use some queries which are easy to change into
> views. Most of their execution time takes planning, they use 5-10
> explicit table joins with not too many rows in these tables and returns
> few values.

You might want to investigate the new "prepared query" functionality in 7.3.1.

I haven't used it yet, so I can't help much.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Noah Silverman 2003-01-14 20:51:16 Multiple databases
Previous Message Vernon Wu 2003-01-14 19:42:07 How good I can get