public inbox for [email protected]
help / color / mirror / Atom feedQuick Question!
7+ messages / 6 participants
[nested] [flat]
* Quick Question!
@ 2001-07-10 09:14 Harry Yau <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Harry Yau @ 2001-07-10 09:14 UTC (permalink / raw)
To: [email protected]; PGH <[email protected]>; pgsql-general
Hi:
A really simple question: I wanna set up some WAL related config
parameter. I am wondering is it the same to add those parameter on
postgresql.conf as to add them on /etc/rc.d/init.d/postgres.init??
^ permalink raw reply [nested|flat] 7+ messages in thread
* Performance tuning for linux, 1GB RAM, dual CPU?
@ 2001-07-10 11:44 Adam Manock <[email protected]>
parent: Harry Yau <[email protected]>
0 siblings, 3 replies; 7+ messages in thread
From: Adam Manock @ 2001-07-10 11:44 UTC (permalink / raw)
To: pgsql-general
Hi,
I am about to put a 7.1.2 server into production on RedHat 7.1
The server will be dedicated to PostgreSQL, running a bare minimum of
additional services.
If anyone has already tuned the configurable parameters on a dual PIII w/
1GB RAM then I
will have a great place to start for my performance tuning!
When I'm done I'll be posting my results here for the next first timer that
comes along.
Thanks in advance,
Adam
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Performance tuning for linux, 1GB RAM, dual CPU?
@ 2001-07-10 13:21 Janning Vygen <[email protected]>
parent: Adam Manock <[email protected]>
2 siblings, 0 replies; 7+ messages in thread
From: Janning Vygen @ 2001-07-10 13:21 UTC (permalink / raw)
To: Adam Manock <[email protected]>; pgsql-general
Am Dienstag, 10. Juli 2001 13:44 schrieb Adam Manock:
> Hi,
>
> I am about to put a 7.1.2 server into production on RedHat 7.1
> The server will be dedicated to PostgreSQL, running a bare minimum of
> additional services.
> If anyone has already tuned the configurable parameters on a dual PIII w/
> 1GB RAM then I
> will have a great place to start for my performance tuning!
i am running the same hardware and postgresql 7.1.2
but i didnt tuned it because its fast enough for my purpose. But i am very
interested in your investigations. Could you please pm me, if you have
something of interest?
thanks
janning
> When I'm done I'll be posting my results here for the next first timer that
> comes along.
>
> Thanks in advance,
>
> Adam
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
--
Planwerk 6 /websolutions
Herzogstra�e 86
40215 D�sseldorf
fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Performance tuning for linux, 1GB RAM, dual CPU?
@ 2001-07-10 14:06 Philip Molter <[email protected]>
parent: Adam Manock <[email protected]>
2 siblings, 2 replies; 7+ messages in thread
From: Philip Molter @ 2001-07-10 14:06 UTC (permalink / raw)
To: Adam Manock <[email protected]>; +Cc: pgsql-general
On Tue, Jul 10, 2001 at 07:44:34AM -0400, Adam Manock wrote:
: Hi,
:
: I am about to put a 7.1.2 server into production on RedHat 7.1
: The server will be dedicated to PostgreSQL, running a bare minimum of
: additional services.
: If anyone has already tuned the configurable parameters on a dual PIII w/
: 1GB RAM then I
: will have a great place to start for my performance tuning!
: When I'm done I'll be posting my results here for the next first timer that
: comes along.
I have a similar system. It's a dual PII-450MHz Xeon with 512MB of RAM
running RH7.1 and 7.1.2. As far as performance tuning goes, here's the
relevant lines from the postgresql.conf file we're using:
max_connections = 64 # 1-1024
sort_mem = 8192
shared_buffers = 192
fsync = false
Obviously, depending on your needs, you can adjust those. If you've
got a 1GB of RAM, I'd set everything high and not worry about it.
* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
* [email protected]
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Performance tuning for linux, 1GB RAM, dual CPU?
@ 2001-07-10 20:12 Roderick A. Anderson <[email protected]>
parent: Adam Manock <[email protected]>
2 siblings, 0 replies; 7+ messages in thread
From: Roderick A. Anderson @ 2001-07-10 20:12 UTC (permalink / raw)
To: Adam Manock <[email protected]>; +Cc: pgsql-general
On Tue, 10 Jul 2001, Adam Manock wrote:
> Hi,
>
> I am about to put a 7.1.2 server into production on RedHat 7.1
> The server will be dedicated to PostgreSQL, running a bare minimum of
> additional services.
> If anyone has already tuned the configurable parameters on a dual PIII w/
> 1GB RAM then I
> will have a great place to start for my performance tuning!
> When I'm done I'll be posting my results here for the next first timer that
> comes along.
I've just did a quick read of Bruce's article in Linux Journal. My take
is this is more than a hardware issue. Table size, indexes (indices?)
verses sequential scans will come into play. I don't think you can even
really test without some relevant data, queries, etc.
Again this was a very quick read of the article.
Thanks Bruce. It looks enlightening.
Cheers,
Rod
--
Remove the word 'try' from your vocabulary ...
Don't try. Do it or don't do it ...
Steers try!
Don Aslett
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Performance tuning for linux, 1GB RAM, dual CPU?
@ 2001-07-11 03:32 Justin Clift <[email protected]>
parent: Philip Molter <[email protected]>
1 sibling, 0 replies; 7+ messages in thread
From: Justin Clift @ 2001-07-11 03:32 UTC (permalink / raw)
To: Philip Molter <[email protected]>; +Cc: Adam Manock <[email protected]>; pgsql-general
Hi all,
Just added these figures to a new document :
http://techdocs.postgresql.org/techdocs/perftuningfigures.php
As people provide/submit figures and details of the equipment they use,
I'll post them onto this page.
Hopefully it will become a good set of real world guidelines for people,
etc.
Standardised benchmarks would be nice to though.
:-)
Regards and best wishes,
Justin Clift
Philip Molter wrote:
>
> On Tue, Jul 10, 2001 at 07:44:34AM -0400, Adam Manock wrote:
> : Hi,
> :
> : I am about to put a 7.1.2 server into production on RedHat 7.1
> : The server will be dedicated to PostgreSQL, running a bare minimum of
> : additional services.
> : If anyone has already tuned the configurable parameters on a dual PIII w/
> : 1GB RAM then I
> : will have a great place to start for my performance tuning!
> : When I'm done I'll be posting my results here for the next first timer that
> : comes along.
>
> I have a similar system. It's a dual PII-450MHz Xeon with 512MB of RAM
> running RH7.1 and 7.1.2. As far as performance tuning goes, here's the
> relevant lines from the postgresql.conf file we're using:
>
> max_connections = 64 # 1-1024
> sort_mem = 8192
> shared_buffers = 192
> fsync = false
>
> Obviously, depending on your needs, you can adjust those. If you've
> got a 1GB of RAM, I'd set everything high and not worry about it.
>
> * Philip Molter
> * DataFoundry.net
> * http://www.datafoundry.net/
> * [email protected]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Performance tuning for linux, 1GB RAM, dual CPU?
@ 2001-07-13 00:32 Adam Manock <[email protected]>
parent: Philip Molter <[email protected]>
1 sibling, 0 replies; 7+ messages in thread
From: Adam Manock @ 2001-07-13 00:32 UTC (permalink / raw)
To: Justin Clift <[email protected]>; +Cc: pgsql-general
At 01:32 PM 7/11/01 +1000, Justin Clift wrote:
> Standardised benchmarks would be nice to though.
Sure would be nice....
Here's some preliminary results of my testing...
System: RedHat Linux 7.1, kernel 2.4.3smp (i686)
Dual PIII 733 / 133FSB 1024MB RAM
2 18Gb 10000rpm U160 SCSI drives, hardware RAID1
added to /etc/sysctl.conf:
kernel.shmmax = 268435456
kernel.shmall = 268435456
PG 7.1.2
postgresql-7.1.2-4PGDG binary rpm set
relevant entries from postgresql.conf:
max_connections = 32
sort_mem = 4096
shared_buffers = 32000
fsync = true
The only benchmark I have is almost useless but I'll put it here anyway...
time ./pg_regress --schedule=parallel_schedule
(using postmaster on Unix socket, default port)
...
...
======================
All 76 tests passed.
======================
real 0m40.784s
user 0m1.980s
sys 0m1.220s
Adam.
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2001-07-13 00:32 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-07-10 09:14 Quick Question! Harry Yau <[email protected]>
2001-07-10 11:44 ` Performance tuning for linux, 1GB RAM, dual CPU? Adam Manock <[email protected]>
2001-07-10 13:21 ` Re: Performance tuning for linux, 1GB RAM, dual CPU? Janning Vygen <[email protected]>
2001-07-10 14:06 ` Re: Performance tuning for linux, 1GB RAM, dual CPU? Philip Molter <[email protected]>
2001-07-11 03:32 ` Re: Performance tuning for linux, 1GB RAM, dual CPU? Justin Clift <[email protected]>
2001-07-13 00:32 ` Re: Performance tuning for linux, 1GB RAM, dual CPU? Adam Manock <[email protected]>
2001-07-10 20:12 ` Re: Performance tuning for linux, 1GB RAM, dual CPU? Roderick A. Anderson <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox