Re: [SQL] OFFSET impact on Performance???

From: PFC <lists(at)boutiquenumerique(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: [SQL] OFFSET impact on Performance???
Date: 2005-01-27 19:11:55
Message-ID: opsk9zl5f5th1vuj@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2005-01-27 19:13:02 Re: [SQL] OFFSET impact on Performance???
Previous Message Greg Stark 2005-01-27 18:33:33 Re: [SQL] OFFSET impact on Performance???