On Tue, Aug 15, 2006 at 12:47:54PM -0600, Carl Youngblood wrote: > I tried setting it to 2GB and postgres wouldn't start. Didn't > investigate in much greater detail as to why it wouldn't start, but > after switching it back to 1GB it started fine. Most likely because you didn't set the kernel's shared memory settings high enough. To answer you other question: http://archives.postgresql.org/pgsql-performance/2006-08/msg00095.php > On 8/15/06, Jim C. Nasby <jnasby@xxxxxxxxxxxxx> wrote: > >See the recent thread about how old rules of thumb for shared_buffers > >are now completely bunk. With 4G of memory, setting shared_buffers to 2G > >could easily be reasonable. The OP really needs to test several > >different values with their actual workload and see what works best. > > ---------------------------(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 > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
