From: Vinicius Caldeira Carvalho <vinicius.carvalho@squadra.com.br>
To: pgsql-performance@postgresql.org
Subject: first postgrreSQL tunning
Date: Thu, 06 Jan 2005 11:19:51 -0200
Message-ID: <41DD3AF7.6000202@squadra.com.br> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: vinicius.carvalho@squadra.com.br
Subject: Re: first postgrreSQL tunning
In-Reply-To: <41DD3AF7.6000202@squadra.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox