YMMV but I had a snort server logging to postgres on OpenBSD running on an AMD duron 900Mhz that *idled* at 100,000 inserts an hour.
On Wed, Aug 6, 2008 at 9:28 PM, bofh <[EMAIL PROTECTED]> wrote: > Hi all, > I'm looking at a project that I'm trying to run on openbsd. All that > box will have is postgresql. At this time, it's just 2 programmers > and 1 sysadmin type person that's involved, no DBAs, so apologies if > the questions are... too simplistic. > > And I realize if I want to maximize performance, I need to examine > OSes as well. But at this point, I want to explore what is the > biggest postgresql server I can run under openbsd. If at all > possible, I want to run everything in memory. > > What I'm looking for is what is the biggest database I can run on a 4 > socket (4 core per socket) AMD motherboard with 64GB or 128GB of Ram > using a standard kernel? > > For example, what should shmmax be set to? > http://developer.postgresql.org/pgdocs/postgres/kernel-resources.html > recommends several hundred megabytes. > > I understand I may need to recompile the kernel. Any recommendations > for something that can run on 64/128GB ram, 16 cpus, running only > postgresql? > > Thanks in advance. I'm exploring what is possible at this point. I > realize I haven't given out more information, but I don't have that in > hand yet. But I'm interested in finding out what my top end is. > Thanks! > > > -- > http://www.glumbert.com/media/shift > http://www.youtube.com/watch?v=tGvHNNOLnCk > "This officer's men seem to follow him merely out of idle curiosity." > -- Sandhurst officer cadet evaluation. > "Securing an environment of Windows platforms from abuse - external or > internal - is akin to trying to install sprinklers in a fireworks > factory where smoking on the job is permitted." -- Gene Spafford > learn french: http://www.youtube.com/watch?v=j1G-3laJJP0&feature=related
