Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group