pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedpostmaster confiugration and hardware configuration
3+ messages / 3 participants
[nested] [flat]
* postmaster confiugration and hardware configuration
@ 1999-02-06 09:00 KoPra Workshop <kopraworkshop@telkom.net>
2001-03-05 09:26 ` Re: postmaster confiugration and hardware configuration Gavin Sherry <swm@linuxworld.com.au>
2001-03-05 13:47 ` Re: postmaster confiugration and hardware configuration Anthony E . Greene <agreene@pobox.com>
0 siblings, 2 replies; 3+ messages in thread
From: KoPra Workshop @ 1999-02-06 09:00 UTC (permalink / raw)
To: pgsql-general@postgresql.org
Hi...
I'm newbie, and confuse on configuration....
I already installed postgresql 7.0.3 on Compaq Proliant ML 350 - Intel
Pentium III 600 - RAM 128 MB.
Operating system is linux on distribution SuSE 6.4
This server only running database itself. Directory '/data' is independent
partition and size is 3GB
This database is used for application with intensive querries and around 30
connection at a time.
Postmaster configuration is default.
Problem comes up with decrease performace of query result when connection
reached around 30, long wait situatioon is like you can make a cup of coffee
on the kitchen...around 12 second. The bad news is...broken pipe() and all
connection to postgresql is gone...
The application using 'begin...commit' method.
Any suggestion to increase performance of my postgresql....at least great
configuration for postmaster and hardware...?
Pleasse.... :-)
Regards,
Eko Pranoto
Database Administrator of Health Care Information System Project
Rumah Sakit Pertamina Jaya
Indonesia
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postmaster confiugration and hardware configuration
1999-02-06 09:00 postmaster confiugration and hardware configuration KoPra Workshop <kopraworkshop@telkom.net>
@ 2001-03-05 09:26 ` Gavin Sherry <swm@linuxworld.com.au>
1 sibling, 0 replies; 3+ messages in thread
From: Gavin Sherry @ 2001-03-05 09:26 UTC (permalink / raw)
To: KoPra Workshop <kopraworkshop@telkom.net>; +Cc: pgsql-general@postgresql.org
Eko,
On Sat, 6 Feb 1999, KoPra Workshop wrote:
> Any suggestion to increase performance of my postgresql....at least great
> configuration for postmaster and hardware...?
> Pleasse.... :-)
It is hard to tell with the information you are giving, but perhaps you
are hitting the default limit for the number of simultaneous backends
(32). You can increase this by passing -N <number> to postmaster at
startup from the command line (naturally, this should be greater than 32,
perhaps 64). Increasing the number of backends necessitates the increasing
of the number of buffers.
More info in the postgres documentation.
>
> Regards,
> Eko Pranoto
> Database Administrator of Health Care Information System Project
> Rumah Sakit Pertamina Jaya
> Indonesia
Gavin Sherry
Alcove Systems Engineering.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postmaster confiugration and hardware configuration
1999-02-06 09:00 postmaster confiugration and hardware configuration KoPra Workshop <kopraworkshop@telkom.net>
@ 2001-03-05 13:47 ` Anthony E . Greene <agreene@pobox.com>
1 sibling, 0 replies; 3+ messages in thread
From: Anthony E . Greene @ 2001-03-05 13:47 UTC (permalink / raw)
To: pgsql-general@postgresql.org
On Sat, 06 Feb 1999 04:00:26 KoPra Workshop wrote:
>I'm newbie, and confuse on configuration....
Your system clock is not correct.
--
Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/;
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D
Chat: AOL/Yahoo: TonyG05 ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/;
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-03-05 13:47 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-06 09:00 postmaster confiugration and hardware configuration KoPra Workshop <kopraworkshop@telkom.net>
2001-03-05 09:26 ` Gavin Sherry <swm@linuxworld.com.au>
2001-03-05 13:47 ` Anthony E . Greene <agreene@pobox.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