Re: avoid select expens_expr(col) like unneccessary calculations

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: avoid select expens_expr(col) like unneccessary calculations
Date: 2003-07-07 22:55:53
Message-ID: Pine.LNX.4.33.0307071655260.5244-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 8 Jul 2003, Markus Bertheau wrote:

> Hi,
>
> when you have
> select expensive_expression(column), * from table offset 20 limit 40
>
> can you somehow save the cost for the first 20 calculations of
> expensive_expression?

Might a functional or partial index work here?

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2003-07-08 08:44:50 Re: columnar format
Previous Message Stephan Szabo 2003-07-07 22:47:06 Re: avoid select expens_expr(col) like unneccessary calculations