--Original 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 o
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,
AFAIK, the problem was the buffer manager
Dave
On 23-Jun-05, at 9:46 AM, Radu-Adrian Popescu wrote:
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
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 stri
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 informat
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 dat
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 wrote
Radu-Adrian Popescu wrote:
There have been problems with Xeon processors.
Can you elaborate on that please ?
Thanks,
Not really as I do not understand the issue.
Here is one post from the archives.
http://archives.postgresql.org/pgsql-performance/2005-05/msg00441.php
If you search the ar
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
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 shoul
[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
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 b
On Wed, 22 Jun 2005 10:16:03 -0700
Josh Berkus 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
> > appreciate any fe
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 n
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.
T
15 matches
Mail list logo
