Postgres Pro
Downloads
Home   >   mailing lists

Re: partitioning for speed, but query planner ignores - Mailing list pgsql-general

From bricklen
Subject Re: partitioning for speed, but query planner ignores
Date
Msg-id CAGrpgQ9fZek9iF35rHQLcwX53MW5cRMTtBFERomCfV9SS7mehQ@mail.gmail.com
Whole thread Raw
In response to Re: partitioning for speed, but query planner ignores  (David Rysdam <drysdam@ll.mit.edu>)
List pgsql-general
Tree view

On Wed, Oct 2, 2013 at 9:01 AM, David Rysdam <drysdam@ll.mit.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.


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Doubt with physical storage being used by postgres when storing LOBs
Next
From: Karsten Hilbert
Date:
Subject: Re: Timestamp with and without timezone conversion confusion.