Re: slow count in window query
От
Pavel Stehule
Тема
Re: slow count in window query
Дата
Msg-id
162867790907160407u6bb86ac4n5e4bfacd674a8234@mail.gmail.com
Ответ на
Re: slow count in window query (Greg Stark)
Список
Дерево обсуждения
slow count in window query Pavel Stehule <pavel.stehule@gmail.com>
Re: slow count in window query Greg Stark <gsstark@mit.edu>
Re: slow count in window query Pavel Stehule <pavel.stehule@gmail.com>
Re: slow count in window query Hitoshi Harada <umi.tanuki@gmail.com>
Re: slow count in window query Pavel Stehule <pavel.stehule@gmail.com>
Re: slow count in window query "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: slow count in window query Pavel Stehule <pavel.stehule@gmail.com>
Re: slow count in window query "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: slow count in window query Hitoshi Harada <umi.tanuki@gmail.com>
Re: slow count in window query Hitoshi Harada <umi.tanuki@gmail.com>
Re: slow count in window query Hitoshi Harada <umi.tanuki@gmail.com>
Re: slow count in window query Pavel Stehule <pavel.stehule@gmail.com>
Re: slow count in window query Hitoshi Harada <umi.tanuki@gmail.com>
Re: slow count in window query Pavel Stehule <pavel.stehule@gmail.com>
> I'm also not sure how to handle this if the set has to be spooled to > disk. Quicksort and Quickselect do a lot of scans throught he data and > wouldn't perform well on disk. I thing, so problem is in aggregate func used as window func - or some missing optimalisation. when I replaced count(*) over () by subselect (SELECT count(*) FROM ...) then I got expected speed. Pavel > > -- > greg > http://mit.edu/~gsstark/resume.pdf >
В списке pgsql-hackers по дате отправления
