first postgrreSQL tunning

Поиск
Список
Период
Сортировка
От Vinicius Caldeira Carvalho
Тема first postgrreSQL tunning
Дата
Msg-id 41DD3AF7.6000202@squadra.com.br
обсуждение исходный текст
Ответы Re: first postgrreSQL tunning  (Frank Wiles <frank@wiles.org>)
Список 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 по дате отправления:

Предыдущее
От: Ben Bostow
Дата:
Сообщение: Re: Problems with high traffic
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Problems with high traffic