From: Vinicius Caldeira Carvalho <vinicius.carvalho@squadra.com.br>
To: pgsql-performance@postgresql.org
Subject: Re: first postgrreSQL tunning
Date: Thu, 06 Jan 2005 11:46:37 -0200
Message-ID: <41DD413D.6000009@squadra.com.br> (raw)
In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3412A7595@Herge.rcsinc.local>
References: <6EE64EF3AB31D5448D0007DD34EEB3412A7595@Herge.rcsinc.local>
Merlin Moncure wrote:
>>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.
>>
>>
>
>The biggest danger with small databases is it's easy to become
>overconfident...writing poor queries and such and not properly indexing.
>50 users can hit your system pretty hard if they all decide to do
>something at once. Aside from that, just remember to bump up work_mem a
>bit for fast joining.
>
>Your application may be small, but if it is written well and works, it
>well inevitably become larger and more complex, so plan for the future
>:)
>
>Merlin
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
>
>
Thanks Merlin, besides what I said of tunning anything else I should
care looking at?
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: <41DD413D.6000009@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