Re: how to improve perf of 131MM row table? - Mailing list pgsql-performance

From Claudio Freire
Subject Re: how to improve perf of 131MM row table?
Date
Msg-id CAGTBQpZWsKF=Qjf_nrhoxGDhSda-G0HnRgRvwAZp12ENcEK-5g@mail.gmail.com
Whole thread Raw
In response to Re: how to improve perf of 131MM row table?  (AJ Weber <aweber@comcast.net>)
Responses Re: how to improve perf of 131MM row table?  (Shaun Thomas <sthomas@optionshouse.com>)
List pgsql-performance
On Thu, Jun 26, 2014 at 12:48 PM, AJ Weber <aweber@comcast.net> wrote:
> FWIW: I tested removing the quotes around each value, and it did not change
> the plan (I am a little surprised too, but I guess PG is "smarter than
> that").
>
> Thanks for the idea.


Ok, second round.

Try changing node_id in (...) into node.id in (...)


pgsql-performance by date:

Previous
From: AJ Weber
Date:
Subject: Re: how to improve perf of 131MM row table?
Next
From: Shaun Thomas
Date:
Subject: Re: how to improve perf of 131MM row table?