Re: [SQL] OFFSET impact on Performance???
От
PFC
Тема
Re: [SQL] OFFSET impact on Performance???
Дата
Msg-id
opsk9zl5f5th1vuj@musicbox
Ответ на
Re: [SQL] OFFSET impact on Performance??? (Greg Stark)
Список
Дерево обсуждения
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 по дате отправления