pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed64bit Opteron multi drive raid. Help with best config settings
2+ messages / 2 participants
[nested] [flat]
* 64bit Opteron multi drive raid. Help with best config settings
@ 2005-03-09 03:07 David B <davidb999@gmail.com>
2005-03-09 03:53 ` Re: 64bit Opteron multi drive raid. Help with best config Karim Nassar <Karim.Nassar@acm.org>
0 siblings, 1 reply; 2+ messages in thread
From: David B @ 2005-03-09 03:07 UTC (permalink / raw)
To: pgsql-performance
Hi folks,
I'm about to start testing PGv8 on an Opteron 64bit box with 12GB Ram
running RedHat.
A bunch of raided drives in the backend.
Expecting 50GB of data per month (100GB+ initial load).
I do not see any example config settings. Have some MySql experience
and and for it there are config settings for small or large server
operations.
Does PG have similar examples (if so they are well hidden…at least
from Google search<g>).
If not can any of you send me a typical config for such an environment.
I basically want to get a good setting so I can good insert
performance…low vol selects.
DB data consists of customer info and their call history.
Lots of customers…lots of call history. Not that wide of rows.
Want to be able to insert at rate of 1000's per sec. Should think thats poss.
Any help you folks can provide to optimize this in a shootout between
it and MSql (we hope to be move from Oracle)
Tx,
David
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 64bit Opteron multi drive raid. Help with best config
2005-03-09 03:07 64bit Opteron multi drive raid. Help with best config settings David B <davidb999@gmail.com>
@ 2005-03-09 03:53 ` Karim Nassar <Karim.Nassar@acm.org>
0 siblings, 0 replies; 2+ messages in thread
From: Karim Nassar @ 2005-03-09 03:53 UTC (permalink / raw)
To: David B <davidb999@gmail.com>; +Cc: pgsql-performance
On Tue, 2005-03-08 at 19:07 -0800, David B wrote:
> I do not see any example config settings. Have some MySql experience
> and and for it there are config settings for small or large server
> operations.
For starters, this might be helpful:
http://www.powerpostgresql.com/PerfList
Then this:
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
http://www.powerpostgresql.com/Downloads/annotated_conf_80.pdf
Someone else might have an example config for you.
HTH,
--
Karim Nassar
Department of Computer Science
Box 15600, College of Engineering and Natural Sciences
Northern Arizona University, Flagstaff, Arizona 86011
Office: (928) 523-5868 -=- Mobile: (928) 699-9221
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-03-09 03:53 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-09 03:07 64bit Opteron multi drive raid. Help with best config settings David B <davidb999@gmail.com>
2005-03-09 03:53 ` Re: 64bit Opteron multi drive raid. Help with best config Karim Nassar <Karim.Nassar@acm.org>
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