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: (view raw, whole thread or download thread mbox)
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.


"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-2017 The PostgreSQL Global Development Group