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 [EMAIL PROTECTED] 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?
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]