>>> On Sat, Jan 26, 2008 at 7:39 AM, in message
<[EMAIL PROTECTED]>, "Scott Marlowe"
<[EMAIL PROTECTED]> wrote:
> On Jan 26, 2008 5:42 AM, growse <[EMAIL PROTECTED]> wrote:
>> Scott Marlowe-2 wrote:
>> > Can you import to another table then
>> >
>> > begin;
>> > alter table realtable rename to ga
Thanks, Tom. Looks like that was the issue.
I changed the function to use groupid = 57925 instead of groupid = $1
(I can do the same change in the JDBC prepare statement), and the
performance is much better.
It is still more than twice that of the simple query: 401.111 ms vs.
155.544 ms,
2008/1/30, Tom Lane <[EMAIL PROTECTED]>:
> "Dmitry Potapov" <[EMAIL PROTECTED]> writes:
> > 2008/1/25, Tom Lane <[EMAIL PROTECTED]>:
> >> It's hard to tell whether the planner is just being overoptimistic
> >> about the results of ANDing the three join conditions, or if one or
> >> more of the basi
