On Fri, 2007-11-09 at 13:12 -0600, Scott Marlowe wrote: > Note that my best time was at around 16 Meg work_mem. This data set > is MUCH bigger than 16 Meg, it's around 300-400 Meg. But work_mem > optimized out at 16 Meg. Btw, I tried it going as high as 768 Meg, > and it was still slower than 16M. Remember that what you have shown is that for *this* dataset 16Mb is the optimum value. It is not a recommended value for all cases. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
