pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedSystem tuning
4+ messages / 3 participants
[nested] [flat]
* System tuning
@ 2004-02-22 21:11 Gyorgy Molnar <yuri@powercom.com.sg>
0 siblings, 1 reply; 4+ messages in thread
From: Gyorgy Molnar @ 2004-02-22 21:11 UTC (permalink / raw)
To: pgsql-general@postgresql.org
Greetings,
I have a Linux RedHat 9.0 computer. It has 1G memory. Is there anybody who
could help me to fine tune the Kernel for PgSql, and also the with the
proper settings for the PgSql server. I have two additional java program
running on that computer, otherwise I used a custom installation with the
minimal neccessary packages (No X-Server is initalled).
I read the docuentation, and also the PostgreSQL Hardware Performance Tuning
by Bruce Momjian.
Both of them was very usefull, I could manage to come up with the
configuration. Everything works fine, but I'm not sure I have chosen the
best settings.
Thank you in advance.
Kind regards,
Yuri
ps. I almost forgot; I need 64 connections at the same times, and the max
record length is aroung 1024 bytes.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: System tuning
@ 2004-02-23 07:58 Richard Huxton <dev@archonet.com>
parent: Gyorgy Molnar <yuri@powercom.com.sg>
0 siblings, 1 reply; 4+ messages in thread
From: Richard Huxton @ 2004-02-23 07:58 UTC (permalink / raw)
To: Gyorgy Molnar <yuri@powercom.com.sg>; pgsql-general@postgresql.org
On Sunday 22 February 2004 21:11, Gyorgy Molnar wrote:
> Greetings,
>
> I have a Linux RedHat 9.0 computer. It has 1G memory. Is there anybody who
> could help me to fine tune the Kernel for PgSql, and also the with the
> proper settings for the PgSql server. I have two additional java program
> running on that computer, otherwise I used a custom installation with the
> minimal neccessary packages (No X-Server is initalled).
Well, you should probably read the tuning and configuration docs at:
http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php
Then, post your main config settings to the -performance list along with
details of any problems you are seeing.
Bear in mind that "best" performance depends on what queries you are
executing, so optimising for one group of queries may involve trade-offs with
others.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: System tuning
@ 2004-02-25 02:36 Jeff Holle <jeff.holle@verizon.net>
parent: Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 4+ messages in thread
From: Jeff Holle @ 2004-02-25 02:36 UTC (permalink / raw)
To: pgsql-general@postgresql.org
Will somebody on this list, hopefully the list manager, tell me how to
unsubscribe to this list?
In attempting to sent a request for this to
"majordomo-owner@postgresql.org" , I got this response:
>>>>>>>> unregister jeff.holle@verizon.net
>>>>
>>>>
---- The unregister command did not succeed.
----
---- The request
---- "unregister jeff.holle@verizon.net"
---- must be confirmed. Confirmation instructions have been mailed to
---- jeff.holle@verizon.net in a separate message.
----
1 valid command processed; it is pending.
Regretably, I didn't get the promised seperate message, hense I'm still receiving messages.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: System tuning
@ 2004-02-25 08:25 Richard Huxton <dev@archonet.com>
parent: Jeff Holle <jeff.holle@verizon.net>
0 siblings, 0 replies; 4+ messages in thread
From: Richard Huxton @ 2004-02-25 08:25 UTC (permalink / raw)
To: Jeff Holle <jeff.holle@verizon.net>; pgsql-general@postgresql.org
On Wednesday 25 February 2004 02:36, Jeff Holle wrote:
> Will somebody on this list, hopefully the list manager, tell me how to
> unsubscribe to this list?
>
> In attempting to sent a request for this to
>
> "majordomo-owner@postgresql.org" , I got this response:
> >>>>>>>> unregister jeff.holle@verizon.net
I think "unsubscribe" is what you needed here, however, I use the webmail
interface for my admin tasks:
http://webmail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-02-25 08:25 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-22 21:11 System tuning Gyorgy Molnar <yuri@powercom.com.sg>
2004-02-23 07:58 ` Richard Huxton <dev@archonet.com>
2004-02-25 02:36 ` Jeff Holle <jeff.holle@verizon.net>
2004-02-25 08:25 ` Richard Huxton <dev@archonet.com>
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