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

From: Aaron Weber <aweber(at)comcast(dot)net>
To: Shaun Thomas <sthomas(at)optionshouse(dot)com>,Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: how to improve perf of 131MM row table?
Date: 2014-06-26 20:43:47
Message-ID: 793dbf54-9aee-41c7-8fdb-613b800ba80d@email.android.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>I'm curious to see if Aaron can test his structure on 9.3 with the
>original data and WHERE clause and see if the planner still goes for
>the
>terrible plan. If it does, that would seem like an obvious planner
>tweak
>to me.

I will try to spin up a test 9.3 db and run the same queries to see if this is the case. Least I can do in return for the help.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2014-06-26 23:49:36 60 core performance with 9.3
Previous Message Aaron Weber 2014-06-26 20:40:51 Re: how to improve perf of 131MM row table?