Re: how to improve perf of 131MM row table?

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: AJ Weber <aweber(at)comcast(dot)net>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: how to improve perf of 131MM row table?
Date: 2014-06-26 16:19:06
Message-ID: CAGTBQpZWsKF=Qjf_nrhoxGDhSda-G0HnRgRvwAZp12ENcEK-5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Jun 26, 2014 at 12:48 PM, AJ Weber <aweber(at)comcast(dot)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 (...)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shaun Thomas 2014-06-26 16:23:54 Re: how to improve perf of 131MM row table?
Previous Message AJ Weber 2014-06-26 15:48:27 Re: how to improve perf of 131MM row table?