Re: How to run this in reasonable time:

От: Matthew Wakeling
Тема: Re: How to run this in reasonable time:
Дата: ,
(см: обсуждение, исходный текст)
Ответ на: 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.


"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?