On 1/18/2015 11:13 PM, James Sewell wrote:
>
> Each index is about 2.5GB, I suspect I am trying to read a these into
> memory in entirety.
an 11GB table with a (presumably integer) primary key requires an 2.5GB
index ? 100 of these would need 250GB of shared_buffers to stay
resident, not likely.
--
john r pierce 37N 122W
somewhere on the middle of the left coast