I'm likely going to make this the default for PostgreSQL on FreeBSD
starting with 7.4 (just posted something to -hackers about this)f. If
you'd like to do this in your testing, just apply the following patch.
Right now PostgreSQL defaults to 8K blocks, but FreeBSD uses 16K
blocks which
Hey all.
I said I was going to do it, and I finally did it.
As with all performance tests/benchmarks, there are probably dozens or
more reasons why these results aren't as accurate or wonderful as they
should be. Take them for what they are and hopefully everyone can
learn a few things from
the integrity of your tests.
Thanks for all the work.
Balazs
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Moran
Sent: Tuesday, August 26, 2003 6:48 PM
To: [EMAIL PROTECTED]
Subject: [PERFORM] The results of my PostgreSQL/filesystem performance
tests
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Balazs Wellisch)
wrote:
Very interesting results. I'd like to command you on your honesty.
Having started out with the intentions of proving that FreeBSD is faster
than Linux only to find that the opposite is true must not have
Couple of questions:
What was the postgresql.conf configuration used? Default?
How many threads of the script ran? Looks like a single user only.
I assume there was nothing else running at the time (cron, sendmail,
etc. were all off?)
Do you know whether the machines were disk or I/O bound?
http://www.potentialtech.com/wmoran/postgresql.php
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
Adding my voice to the many, thanks for sharing your results Bill. Very
instructive.
--
Best,
Al Hulaton| Sr. Account Engineer | Command Prompt, Inc.
503.222.2783 |
What it still leaves quite open is just what happens when the OS has
more than one disk drive or CPU to play with. It's not clear what
happens in such cases, whether FreeBSD would catch up, or be left
further in the dust. The traditional propaganda has been that
there are all sorts of
I need to step in and do 2 things:
Thanks for posting that. Let me know if you have any questions while
doing your testing. I've found that using 16K blocks on FreeBSD
results in about an 8% speedup in writes to the database, fwiw.
I'm likely going to make this the default for PostgreSQL on
SC == Sean Chittenden [EMAIL PROTECTED] writes:
I need to step in and do 2 things:
SC Thanks for posting that. Let me know if you have any questions while
SC doing your testing. I've found that using 16K blocks on FreeBSD
SC results in about an 8% speedup in writes to the database, fwiw.
SC == Sean Chittenden [EMAIL PROTECTED] writes:
I need to step in and do 2 things:
SC Thanks for posting that. Let me know if you have any questions while
SC doing your testing. I've found that using 16K blocks on FreeBSD
SC results in about an 8% speedup in writes to the database, fwiw.
I need to step in and do 2 things:
SC Thanks for posting that. Let me know if you have any questions while
SC doing your testing. I've found that using 16K blocks on FreeBSD
SC results in about an 8% speedup in writes to the database, fwiw.
ok.. ignore my prior request about how to set
11 matches
Mail list logo
