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

Поиск
Список
Период
Сортировка
Искать
От
PFC
Тема
Re: [SQL] OFFSET impact on Performance???
Дата
Msg-id
opsk9zl5f5th1vuj@musicbox
Ответ на
Список
Дерево обсуждения
Re: [SQL] OFFSET impact on Performance??? "Merlin Moncure" <merlin.moncure@rcsonline.com>
Re: [SQL] OFFSET impact on Performance??? Greg Stark <gsstark@mit.edu>
Re: [SQL] OFFSET impact on Performance??? PFC <lists@boutiquenumerique.com>
Re: [SQL] OFFSET impact on Performance??? Kevin Brown <kevin@sysexperts.com>
Re: [SQL] OFFSET impact on Performance??? Alex Turner <armtuk@gmail.com>
Re: [SQL] OFFSET impact on Performance??? Greg Stark <gsstark@mit.edu>
Re: [SQL] OFFSET impact on Performance??? PFC <lists@boutiquenumerique.com>
Re: [SQL] OFFSET impact on Performance??? Alex Turner <armtuk@gmail.com>
Re: [SQL] OFFSET impact on Performance??? PFC <lists@boutiquenumerique.com>
Re: [SQL] OFFSET impact on Performance??? Oleg Bartunov <oleg@sai.msu.su>
Re: [SQL] OFFSET impact on Performance??? PFC <lists@boutiquenumerique.com>
Re: [SQL] OFFSET impact on Performance??? Oleg Bartunov <oleg@sai.msu.su>
Re: [SQL] OFFSET impact on Performance??? Greg Stark <gsstark@mit.edu>
Re: [SQL] OFFSET impact on Performance??? PFC <lists@boutiquenumerique.com>
Re: [SQL] OFFSET impact on Performance??? Oleg Bartunov <oleg@sai.msu.su>
Re: [SQL] OFFSET impact on Performance??? PFC <lists@boutiquenumerique.com>
Re: [SQL] OFFSET impact on Performance??? Greg Stark <gsstark@mit.edu>
Re: [SQL] OFFSET impact on Performance??? PFC <lists@boutiquenumerique.com>
> 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 по дате отправления
От: Greg Stark
Дата:
От: Merlin Moncure
Дата:
FAQ