Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Frank Wiles
Sent: Wednesday, June 22, 2005 10:52 AM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] Performance Tuning Article
Hi Everyone,
I've put together a short article and posted it online regarding
There have been problems with Xeon processors.
Can you elaborate on that please ?
Thanks,
--
Radu-Adrian Popescu
CSA, DBA, Developer
Aldrapay MD
Aldratech Ltd.
+40213212243
smime.p7s
Description: S/MIME Cryptographic Signature
My understanding is that it isn't particularly XEON processors that
is the problem
Any dual processor will exhibit the problem, XEON's with
hyperthreading exacerbate the problem though
and the good news is that it has been fixed in 8.1
Dave
On 23-Jun-05, at 8:16 AM, Keith Worthington
On Wed, 22 Jun 2005 22:31:29 -0400
Keith Worthington [EMAIL PROTECTED] wrote:
Frank,
A couple of things I wish I had been told when I started asking how to
configure a new machine.
Use RAID 10 (striping across mirrored disks)
or RAID 0+1 (mirror a striped array) for your data.
Use
Dave Cramer wrote:
My understanding is that it isn't particularly XEON processors that is
the problem
Any dual processor will exhibit the problem, XEON's with hyperthreading
exacerbate the problem though
and the good news is that it has been fixed in 8.1
Where's that ? The only
On Wed, Jun 22, 2005 at 10:31:29PM -0400, Keith Worthington wrote:
Use RAID 10 (striping across mirrored disks)
or RAID 0+1 (mirror a striped array) for your data.
yikes! never tell an unsuspecting person to use mirred stripes--that
configuration has lower reliability and performance than
Dave Cramer [EMAIL PROTECTED] writes:
AFAIK, the problem was the buffer manager
The buffer manager was the place that seemed to be hit hardest by Xeon's
problems with spinlock contention. I think we've partially fixed that
issue in 8.1, but as we continue to improve the system's performance,
Hi Everyone,
I've put together a short article and posted it online regarding
performance tuning PostgreSQL in general. I believe it helps to bring
together the info in a easy to digest manner. I would appreciate any
feedback, comments, and especially any technical corrections.
Frank,
I've put together a short article and posted it online regarding
performance tuning PostgreSQL in general. I believe it helps to bring
together the info in a easy to digest manner. I would appreciate any
feedback, comments, and especially any technical corrections.
Looks
On Wed, 22 Jun 2005 10:16:03 -0700
Josh Berkus josh@agliodbs.com wrote:
Frank,
I've put together a short article and posted it online regarding
performance tuning PostgreSQL in general. I believe it helps to
bring together the info in a easy to digest manner. I would
On Wed, 2005-06-22 at 09:52 -0500, Frank Wiles wrote:
I've put together a short article and posted it online regarding
performance tuning PostgreSQL in general.
Nice work! Some minor issues I saw:
* section Understanding the process, para 5:
Now that PostgreSQL has a plan of what it
[Frank Wiles - Wed at 09:52:27AM -0500]
I've put together a short article and posted it online regarding
performance tuning PostgreSQL in general. I believe it helps to bring
together the info in a easy to digest manner. I would appreciate any
feedback, comments, and especially any
I've put together a short article and posted it online regarding
performance tuning PostgreSQL in general. I believe it helps to
bring together the info in a easy to digest manner. I would
appreciate any feedback, comments, and especially any technical
corrections.
Looks nice. You
13 matches
Mail list logo
