Skip site navigation (1) Skip section navigation (2)

Re: High load

From: A_Schnabel(at)t-online(dot)de (Andre Schnabel)
To: "Alexey Rodriguez Yakushev" <alexey(at)serinbol(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: High load
Date: 2001-07-20 18:13:48
Message-ID: 001401c11147$b94bfe40$ (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

your first idea should work fine.
PostgreSQL 7.1.2 handles 32 clients per default. You can increase this
number in postgresql.conf .
For more details of options in this file look at:

I think, i'ts a good idea to lok at the techdocs too


----- Original Message -----
From: Alexey Rodriguez Yakushev
To: pgsql-admin(at)postgresql(dot)org
Sent: Friday, July 20, 2001 2:45 AM
Subject: [ADMIN] High load

  Oops, i sent this message to pgsql-general. Well, now it goes to the right

  Hi guys, i am managing the database server for several sites for my
with postgresql 7.0.3 . These days traffic has been increasing and scripts
start to fail because too many clients are already connected.
  I'd like to know how many clients can handle 7.0.3 and if i can change
limit. To solve the problem i will try following aproches:

 - Upgrade to 7.1.2 and increase the max number of clients, i think my
hardware can handle the requirements.

  - Use more than one database server.

  Do you think the first approach will work? If it is possible i'd love some
pointers to database administration manuals that could help me with this
issue. How do the guys at sourceforge handle such loads with postgres?
  BTW i am not subscribed to the list, could you send me a copy?
  Thanks a lot.



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

  • High load at 2001-07-20 00:45:05 from Alexey Rodriguez Yakushev

pgsql-admin by date

Next:From: Aaron LevensailorDate: 2001-07-20 18:56:11
Subject: Datatype Conversion
Previous:From: Fareed M. ZaffarDate: 2001-07-20 18:07:48

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group