first postgrreSQL tunning

From: Vinicius Caldeira Carvalho <vinicius(dot)carvalho(at)squadra(dot)com(dot)br>
To: pgsql-performance(at)postgresql(dot)org
Subject: first postgrreSQL tunning
Date: 2005-01-06 13:19:51
Message-ID: 41DD3AF7.6000202@squadra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Cramer 2005-01-06 13:32:41 Re: Problems with high traffic
Previous Message Ben Bostow 2005-01-06 13:18:43 Re: Problems with high traffic