Does iscachable work?

From: root <ffabrizio(at)mmrd(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Does iscachable work?
Date: 2002-02-22 15:25:33
Message-ID: 3C7662ED.1070002@mmrd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

I'm running PostgreSQL 7.1.3, and I have a query that uses one of my
functions:

select findregion(entityid) from msg200;

The findregion function is set to be 'with (iscachable)'. However, the
query takes upwards of 40 seconds to run, the first time and every time
thereafter, consistently. It doesn't seem like the caching is working.

The only other time I tried to use function results caching, it actually
consistently increased my execution time. Anything I need to be doing
differently?

Thanks,
Fran

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tony 2002-02-22 15:27:33 Re: Protection of intellectual property (Schema & SQL
Previous Message Holger Marzen 2002-02-22 15:25:16 Re: How does Index Scan get used