Benjamin Minshall <minshall(at)intellicon(dot)biz> writes:
> What are the advantages or disadvantages of using arrays in this
> situation? The = ANY array method makes plpgsql development cleaner,
> but seems to really lack performance in certain cases.
In existing releases, the form with IN (list-of-scalar-constants)
can be optimized into indexscan(s), but = ANY (array) isn't.
8.2 will treat them equivalently (in fact, it converts IN (...) to
= ANY (ARRAY[...]) !). So depending on your time horizon, you might
wish to stick with whichever is cleaner for your calling code.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Luke Lonergan||Date: 2006-09-16 23:46:04|
|Subject: Re: RAID 0 not as fast as expected|
|Previous:||From: Benjamin Minshall||Date: 2006-09-15 19:12:07|
|Subject: Performance of IN (...) vs. = ANY array[...]|