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

Re: Replacing Cursors with Temporary Tables

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Eliot Gable <egable+pgsql-performance(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Replacing Cursors with Temporary Tables
Date: 2010-04-22 12:17:00
Message-ID: x2kb42b73151004220517q6e6435bbrdb89dd84627ccc31@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Apr 22, 2010 at 8:14 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> This will use an index on bar.bar_id if it exists.  Obviously, any
> indexes on foo are not used after creating the array but doesn't
> matter much as long as the right side is indexed.  Your cursor method
> does do any better in this regard.  You can create an index on a temp

er, meant to say: 'doesn't do any better'.

merlin

In response to

pgsql-performance by date

Next:From: Greg SmithDate: 2010-04-22 12:37:32
Subject: Re: Optimization idea
Previous:From: Merlin MoncureDate: 2010-04-22 12:14:42
Subject: Re: Replacing Cursors with Temporary Tables

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