Re: Partitioning

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