Re: [SQL] OFFSET impact on Performance??? - Mailing list pgsql-performance

From PFC
Subject Re: [SQL] OFFSET impact on Performance???
Date
Msg-id opsk9zl5f5th1vuj@musicbox
Whole thread Raw
In response to Re: [SQL] OFFSET impact on Performance???  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
> What you want is called UNNEST. It didn't get done in time for 8.0. But
> if
> what you have is an array of integers the int_array_enum() function I
> quoted
> in the other post is basically that.

    Yes, I used it, thanks. That's what I wanted. The query plans are good.

> You don't really need the int_array_aggregate function any more. You can
> write
> your own aggregate using the new array operators:
> Of course it's about 50x slower than the C implementation though:

    Heh. I'll keep using int_array_aggregate ;)

    Have a nice day.

pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: [SQL] OFFSET impact on Performance???
Next
From: "Merlin Moncure"
Date:
Subject: Re: [SQL] OFFSET impact on Performance???