pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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?



view thread (4+ messages)  latest in thread

Message-ID: <41DD413D.6000009@squadra.com.br>
Permalink:  ../41DD413D.6000009@squadra.com.br/
Also on:    postgresql.org/message-id/41DD413D.6000009@squadra.com.br

 · 

reply

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