first postgrreSQL tunning - Mailing list pgsql-performance

From Vinicius Caldeira Carvalho
Subject first postgrreSQL tunning
Date
Msg-id 41DD3AF7.6000202@squadra.com.br
Whole thread Raw
Responses Re: first postgrreSQL tunning
List pgsql-performance
Hi there! I'm doing my first tunning on my postgreSQL, my server is for
a small app, largest table shall never exceed 10k rows, and less than 1k
transactions/day. So I don't think I should run out of resources. The
machine is a Fedora Core 3.0 with 1gb ran and kernel 2.6. I'm thinking
in having 50 connections limit, so besides semaphores should I do
anything special on kernel parameters. The app is so small that during
late night time almost no one will access so, I'm thinking in full
vacuuming it every day at 1:00AM.

Any tips are very very welcome :D

Thanks all

pgsql-performance by date:

Previous
From: Ben Bostow
Date:
Subject: Re: Problems with high traffic
Next
From: Dave Cramer
Date:
Subject: Re: Problems with high traffic