Re: index not being used when variable is sent

From: Jim Nasby <jim(at)nasby(dot)net>
To: Eyal Wilde <eyal(at)impactsoft(dot)co(dot)il>
Cc: 25601(dot)1313502058(at)sss(dot)pgh(dot)pa(dot)us, pgsql-performance(at)postgresql(dot)org, erans(at)impactsoft(dot)co(dot)il, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: index not being used when variable is sent
Date: 2011-08-17 20:49:59
Message-ID: 8FF48EE6-93A0-42CE-B73C-8FDB8692EC70@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Aug 17, 2011, at 1:49 AM, Eyal Wilde wrote:
> 1. is there any more elegant solution?

Very possibly, but I'm having a heck of a time trying to figure out what your current code is actually doing.

What's the actual problem you're trying to solve here?
--
Jim C. Nasby, Database Architect jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message ktm@rice.edu 2011-08-17 20:56:40 Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++
Previous Message Aidan Van Dyk 2011-08-17 20:41:48 Re: DBT-5 & Postgres 9.0.3