Re: Performance problems testing with Spamassassin 3.1.0

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Matthew Schumacher" <matt(dot)s(at)aptalaska(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problems testing with Spamassassin 3.1.0
Date: 2005-08-04 08:45:40
Message-ID: op.suy6mejzth1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> What I really want to do is have the token array available as a record
> so that I can query against it, but not have it take up the resources of
> a real table. If I could copy from an array into a record then I can
> even get rid of the loop. Anyone have any thoughts on how to do this?

You could make a set-returning-function (about 3 lines) which RETURNs
NEXT every element in the array ; then you can use this SRF just like a
table and SELECT from it, join it with your other tables, etc.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Laszlo Hornyak 2005-08-04 08:52:09 Re: Indexed views.
Previous Message Christopher Kings-Lynne 2005-08-04 08:37:14 Re: Indexed views.