On Mon, Jun 30, 2008 at 7:09 PM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> wrote: > Rafael Domiciano escribió: >> The Postgres version is 8.3.3 and I am using Fedora Core 8. >> I have in the actual server around 70 connections the same time. I am >> assigning for this 100. > > 100 MB? That's not very much either. You can probably get a hefty > performance boost by upping it a lot more (depending on whether the > machine is doing something else, or Postgres is the only service running > on it.) I think he was talking about max connections. As for shared buffers, I'd start out at about 25% main memory for 8.3.3 and test that. Also, he should be looking at his setting for work_mem
