From: Svenne Krap <svenne@krap.dk>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Perfomance of views
Date: Thu, 27 Oct 2005 17:10:29 +0200
Message-ID: <4360EDE5.9050400@krap.dk> (raw)
In-Reply-To: <18899.1130423882@sss.pgh.pa.us>
References: <435FA002.4060509@krap.dk>
<43609EF4.8060907@archonet.com>
<4360B375.8000303@krap.dk>
<18899.1130423882@sss.pgh.pa.us>
Tom Lane wrote:
>There's been some discussion of inline-expanding SQL functions that
>return sets when they are called in FROM, which would make a SQL
>function that contains just a SELECT effectively equivalent to a view
>as far as the planner's powers of optimization go. No one's tried to
>make it happen yet though.
>
>
This is exactly what would be brilliant in my case. Use the functions as
a kind of strict, parameterized views, that in the planner (or wherever)
gets replaced down to a simple (?!?!) sql-statement.
This would imho be highly valuable for almost any kind of complex
time-travel application (and surely dozens of other applications).
And before anyone suggests it, I don't code C well enough (*cough*
rusty) to try to do it myself. I would apriciate if it went on the todo
for 8.2 though. (I might even be willing to sponsor some money (a single
or perhpas two thousands of US dollars) for getting it done and release
it immediately under postgresql standard license (BSD)).
I by the way also support the idea of a way to force a table into a
PgSQL managed cache like discussed a while ago. Sometimes overall speed
for the system is less important than speed of a single query.
I must also say, that I am very impressed with the performance
enhancements of 8.1 beta, the bitmap index scans are amazing ! Good job,
guys - PgSQL has come a far way from 7.0 (where I started) and the
future looks bright ;)
Svenne
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: svenne@krap.dk, tgl@sss.pgh.pa.us
Subject: Re: Perfomance of views
In-Reply-To: <4360EDE5.9050400@krap.dk>
* 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