>> The best part is that you can skip the LIMIT/OFFSET entirely if you
>> put page numbers in your cache table while inserting into it, via a
>> temporary sequence or something. Retrieving the results will then be
>> very fast, but beware that SELECT * FROM table WHERE id =ANY( array )
>> won't use an index, so
>
> contrib/intarray provides index access to such queries.
Can you provide an example of such a query ? I've looked at the operators
for intarray without finding it.
Thanks.