Skip site navigation (1) Skip section navigation (2)

Re: How to run this in reasonable time:

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to run this in reasonable time:
Date: 2009-08-13 14:36:15
Message-ID: alpine.DEB.2.00.0908131527390.19472@aragorn.flymine.org (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, 13 Aug 2009, Greg Stark wrote:
> On Thu, Aug 13, 2009 at 3:16 PM, Matthew Wakeling<matthew(at)flymine(dot)org> 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

In response to

pgsql-performance by date

Next:From: David KerrDate: 2009-08-13 16:07:48
Subject: Under the hood of views
Previous:From: Kevin GrittnerDate: 2009-08-13 14:32:40
Subject: Re: Why is vacuum_freeze_min_age 100m?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group