Re: How to run this in reasonable time:

От: Matthew Wakeling
Тема: Re: How to run this in reasonable time:
Дата: ,
Msg-id: alpine.DEB.2.00.0908131527390.19472@aragorn.flymine.org
(см: обсуждение, исходный текст)
Ответ на: Re: How to run this in reasonable time:  (Greg Stark)
Список: pgsql-performance

On Thu, 13 Aug 2009, Greg Stark wrote:
> On Thu, Aug 13, 2009 at 3:16 PM, Matthew Wakeling<> wrote:
>> Now, I'd like to get this done this side of Christmas, so I was wondering if
>> there's a neat trick I can use to get it to only consider the rows from s to
>> e, instead of having to iterate through them all. I tried this, but got an
>> error message:
>>
>> SELECT id, objectid, bin
>> FROM locationbintemp, generate_series(s, e) AS bin;
>
> select id, objectid, generate_series(s,e) as bin
>  from locationbintemp

Thanks. That looks like it shouldn't work, but it does.

Matthew

--
"Beware the lightning that lurketh in an undischarged capacitor, lest it
 cause thee to be bounced upon thy buttocks in a most ungentlemanly manner."
                                -- The Ten Commandments of Electronics


В списке pgsql-performance по дате сообщения:

От: Alvaro Herrera
Дата:
Сообщение: Re: Memory usage of writer process
От: Josh Berkus
Дата:
Сообщение: Re: Why is vacuum_freeze_min_age 100m?