On 12/24/14, 12:27 AM, Jim Nasby wrote:
> There were several select-only runs on both to warm shared_buffers (set to 512MB for this test, and fsync is off).
BTW, presumably this ~380M database isn't big enough to show any problems with hash collisions, and I'm guessing you'd
needway more memory than what I have on this laptop. Might be worth looking into that on a machine with a serious
amountof memory.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com