On Wed, Mar 19, 2008 at 11:38 PM, Aftab Alam <[EMAIL PROTECTED]> wrote:
>
> Dear All,
>
> I am using postgres 7.0 with linux with 15 GB of database & 3 gb
> of RAM.
>
> Can anyone suggest what is the best setting for postgres. I am using
> postgres as web db.
If you really are running
> I am using postgres 7.0 with linux with 15 GB of database &
> 3 gb of RAM. Can anyone suggest what is the best setting
> for postgres. I am using postgres as web db.
You mentioned elsewhere that you are getting 2,000 hits/day. I don't
know the nature of your web app but typical web apps involv
Aftab Alam wrote:
Dear All,
I am using postgres 7.0 with linux with 15 GB of database
& 3 gb of RAM.
Can anyone suggest what is the best setting for postgres. I am using
postgres as web db.
I'm going to assume/hope that you mean 8.0. Even then, you would be well
advised t
Dear All,
I am using postgres 7.0 with linux with 15 GB of database & 3 gb of
RAM.
Can anyone suggest what is the best setting for postgres. I am using postgres
as web db.
Regards
aftab
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION in
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vishal
AroraSent: Thursday, March 20, 2008 4:34 PMTo: Aftab Alam; [EMAIL PROTECTED]:
[EMAIL PROTECTED]: Re: [ADMIN] Postgres Performance
> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> CC:
> [email protected]&
: [ADMIN] Postgres Performance
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> CC: [email protected]
> Subject: Re: [ADMIN] Postgres Performance
> Date: Thu, 20 Mar 2008 16:02:48 +0530
>
> Dear Hubert,
>
> I have mistaken
> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> CC:
> [email protected]> Subject: Re: [ADMIN] Postgres Performance> Date:
> Thu, 20 Mar 2008 16:02:48 +0530> > Dear Hubert,> > I have mistaken written
> 7.0 instead of 7.3, I am getting more
On Thu, Mar 20, 2008 at 04:02:48PM +0530, Aftab Alam wrote:
> I have mistaken written 7.0 instead of 7.3, I am getting more than 2000 hits
> daily, can u suggest the best configuration. Mean while I am trying to
> migrate it to 8.3.1
7.3 is also pretty old.
as for 2000 hits daily - it's not much.
, March 20, 2008 3:27 PM
To: Aftab Alam
Cc: [email protected]
Subject: Re: [ADMIN] Postgres Performance
On Thu, Mar 20, 2008 at 03:12:43PM +0530, Aftab Alam wrote:
> I am using postgres 7.0 with linux with 15 GB of database & 3
gb of RAM.
> Can anyone suggest what i
On Thu, Mar 20, 2008 at 03:12:43PM +0530, Aftab Alam wrote:
> I am using postgres 7.0 with linux with 15 GB of database & 3 gb
> of RAM.
> Can anyone suggest what is the best setting for postgres. I am using postgres
> as web db.
the best setting would be to upgrade.
7.0 was released
Dear All,
I am using postgres 7.0 with linux with 15 GB of database & 3 gb of
RAM.
Can anyone suggest what is the best setting for postgres. I am using postgres
as web db.
Regards
aftab
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION in
hi all,
I have 1 gb ram on the server
i am doing some performance tuning for postgres server.
some of the configuration changes i have made are
max_connections = 128
shared_buffers = 1048576
sort_mem = 4096
random_page_cost = 2
echo "1073741824" >/proc/sys/kernel/shmall
echo "1073741824" >/pro
Hi,
I'm sure this should be a FAQ, but I'm struggling with tuning my Postgres. I
wonder if someone can give me some advice or some pointers, or even a
suggested starting point for tuning.
Some details
I've got Postgres 7.2.1 running on Debian with kernel 2.4.18. The database
is running on a
We are planning to install a postgres database along with an
apache webserver for a small internal Help-desk site.
I have no intention of starting a OS war, but I have heard a great
deal about FreeBSD being a superior network server relative to
Linux, and I would like to know if there is some com
Hello!
We are planning to install a postgres database along with an apache webserver
for a small e-business site. We assume that we will have about
5.000 customers (in a year) that access the database through JDBC.
Now my question:
We want to use a Pentium II-350Mhz machine with about 256 MB RA
15 matches
Mail list logo
