Re: partitioning for speed, but query planner ignores

From: bricklen <bricklen(at)gmail(dot)com>
To: David Rysdam <drysdam(at)ll(dot)mit(dot)edu>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: partitioning for speed, but query planner ignores
Date: 2013-10-02 19:03:08
Message-ID: CAGrpgQ9fZek9iF35rHQLcwX53MW5cRMTtBFERomCfV9SS7mehQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 2, 2013 at 9:01 AM, David Rysdam <drysdam(at)ll(dot)mit(dot)edu> wrote:

> I had some vague notion of tables "doing work" but really if it can load
> one
> partition into RAM and get most of my hits from there, it'd be a big
> win.

The same concept applies to the frequently-used indexes on that partition.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2013-10-02 20:31:45 Re: Timestamp with and without timezone conversion confusion.
Previous Message Merlin Moncure 2013-10-02 19:00:38 Re: Doubt with physical storage being used by postgres when storing LOBs