Highload website database architecture

From: "a" <a(at)tempinbox(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Highload website database architecture
Date: 2006-12-02 01:09:36
Message-ID: 1165021776.742309.167480@16g2000cwy.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am building a web app backed by database postgresql and currently the
site is under a humongous torrent of hits. I have a question regarding
the database backend config.

The database folder has a file called postgresql.cons where we can
specify no of active connections to the database -N which is currently
1024 and also specify the shared buffers. Is there any thumbrule in
deciding the -N and also the no of shared buffers for my config of 4
frontend servers and 1 database backend server. There is no global or
memcached mechanisms in use.

Any pointers would be greatly appreciated.

Thanx
a

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian Wipf 2006-12-02 01:30:45 Re: Unsuccessful SIGINT - More Info
Previous Message Brian Wipf 2006-12-02 00:54:56 Re: Unsuccessful SIGINT