pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql 9.0.6 Raid 5 or not please help.
13+ messages / 5 participants
[nested] [flat]
* Postgresql 9.0.6 Raid 5 or not please help.
@ 2011-12-23 03:36 tuanhoanganh <hatuan05@gmail.com>
2011-12-23 03:55 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: tuanhoanganh @ 2011-12-23 03:36 UTC (permalink / raw)
To: pgsql-performance
I have IBM x3560 with 2G RAM - RAID 5 3 disk - PostgreSQL 9.0.6 64bit on
Windows 2003 64bit
I had read some tuning guide, it recomment not use RAID 5. So Raid 5 is
bestter than 3 disk independent or not.
Here is my pgbench -h %HOST% -p 5433 -U postgres -c 10 -T 1800 -s 10
pgbench
pgbench -h 127.0.0.1 -p 5433 -U postgres -c 10 -T 1800 -s 10 pgbench
Scale option ignored, using pgbench_branches table count = 10
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 10
query mode: simple
number of clients: 10
number of threads: 1
duration: 1800 s
number of transactions actually processed: 775366
tps = 430.736191 (including connections establishing)
tps = 430.780400 (excluding connections establishing)
Sorry for my English.
Tuan Hoang Anh
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:36 Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
@ 2011-12-23 03:55 ` Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 04:00 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Scott Marlowe @ 2011-12-23 03:55 UTC (permalink / raw)
To: tuanhoanganh <hatuan05@gmail.com>; +Cc: pgsql-performance
On Thu, Dec 22, 2011 at 8:36 PM, tuanhoanganh <hatuan05@gmail.com> wrote:
> I have IBM x3560 with 2G RAM - RAID 5 3 disk - PostgreSQL 9.0.6 64bit on
> Windows 2003 64bit
> I had read some tuning guide, it recomment not use RAID 5. So Raid 5 is
> bestter than 3 disk independent or not.
>
> Here is my pgbench -h %HOST% -p 5433 -U postgres -c 10 -T 1800 -s 10
> pgbench
>
> pgbench -h 127.0.0.1 -p 5433 -U postgres -c 10 -T 1800 -s 10 pgbench
> Scale option ignored, using pgbench_branches table count = 10
> starting vacuum...end.
> transaction type: TPC-B (sort of)
> scaling factor: 10
> query mode: simple
> number of clients: 10
> number of threads: 1
> duration: 1800 s
> number of transactions actually processed: 775366
> tps = 430.736191 (including connections establishing)
> tps = 430.780400 (excluding connections establishing)
RAID 5 is aweful. Look up RAID 1E for 3 disks:
http://en.wikipedia.org/wiki/Non-standard_RAID_levels#RAID_1E
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:36 Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 03:55 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
@ 2011-12-23 04:00 ` Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 06:18 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Scott Marlowe @ 2011-12-23 04:00 UTC (permalink / raw)
To: tuanhoanganh <hatuan05@gmail.com>; +Cc: pgsql-performance
On Thu, Dec 22, 2011 at 8:55 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Thu, Dec 22, 2011 at 8:36 PM, tuanhoanganh <hatuan05@gmail.com> wrote:
>> I have IBM x3560 with 2G RAM - RAID 5 3 disk - PostgreSQL 9.0.6 64bit on
>> Windows 2003 64bit
>> I had read some tuning guide, it recomment not use RAID 5. So Raid 5 is
>> bestter than 3 disk independent or not.
>>
>> Here is my pgbench -h %HOST% -p 5433 -U postgres -c 10 -T 1800 -s 10
>> pgbench
>>
>> pgbench -h 127.0.0.1 -p 5433 -U postgres -c 10 -T 1800 -s 10 pgbench
>> Scale option ignored, using pgbench_branches table count = 10
>> starting vacuum...end.
>> transaction type: TPC-B (sort of)
>> scaling factor: 10
>> query mode: simple
>> number of clients: 10
>> number of threads: 1
>> duration: 1800 s
>> number of transactions actually processed: 775366
>> tps = 430.736191 (including connections establishing)
>> tps = 430.780400 (excluding connections establishing)
>
> RAID 5 is aweful. Look up RAID 1E for 3 disks:
> http://en.wikipedia.org/wiki/Non-standard_RAID_levels#RAID_1E
If Windows doesn't support RAID 1E then setup a mirror set and use the
third drive as a hot spare. Still faster than RAID-5.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:36 Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 03:55 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 04:00 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
@ 2011-12-23 06:18 ` tuanhoanganh <hatuan05@gmail.com>
2011-12-23 07:05 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: tuanhoanganh @ 2011-12-23 06:18 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: pgsql-performance
Thanks for your answer. But how performance between raid5 and one disk.
Please help me.
Thanks in advance
Tuan Hoang Anh
On Fri, Dec 23, 2011 at 11:00 AM, Scott Marlowe <scott.marlowe@gmail.com>wrote:
> On Thu, Dec 22, 2011 at 8:55 PM, Scott Marlowe <scott.marlowe@gmail.com>
> wrote:
> > On Thu, Dec 22, 2011 at 8:36 PM, tuanhoanganh <hatuan05@gmail.com>
> wrote:
> >> I have IBM x3560 with 2G RAM - RAID 5 3 disk - PostgreSQL 9.0.6 64bit on
> >> Windows 2003 64bit
> >> I had read some tuning guide, it recomment not use RAID 5. So Raid 5 is
> >> bestter than 3 disk independent or not.
> >>
> >> Here is my pgbench -h %HOST% -p 5433 -U postgres -c 10 -T 1800 -s 10
> >> pgbench
> >>
> >> pgbench -h 127.0.0.1 -p 5433 -U postgres -c 10 -T 1800 -s 10 pgbench
> >> Scale option ignored, using pgbench_branches table count = 10
> >> starting vacuum...end.
> >> transaction type: TPC-B (sort of)
> >> scaling factor: 10
> >> query mode: simple
> >> number of clients: 10
> >> number of threads: 1
> >> duration: 1800 s
> >> number of transactions actually processed: 775366
> >> tps = 430.736191 (including connections establishing)
> >> tps = 430.780400 (excluding connections establishing)
> >
> > RAID 5 is aweful. Look up RAID 1E for 3 disks:
> > http://en.wikipedia.org/wiki/Non-standard_RAID_levels#RAID_1E
>
> If Windows doesn't support RAID 1E then setup a mirror set and use the
> third drive as a hot spare. Still faster than RAID-5.
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:36 Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 03:55 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 04:00 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 06:18 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
@ 2011-12-23 07:05 ` Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 07:58 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Satoshi Nagayasu <satoshi.nagayasu@gmail.com>
2011-12-23 09:20 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Mario Weilguni <roadrunner6@gmx.at>
0 siblings, 2 replies; 13+ messages in thread
From: Scott Marlowe @ 2011-12-23 07:05 UTC (permalink / raw)
To: tuanhoanganh <hatuan05@gmail.com>; +Cc: pgsql-performance
On Thu, Dec 22, 2011 at 11:18 PM, tuanhoanganh <hatuan05@gmail.com> wrote:
> Thanks for your answer. But how performance between raid5 and one disk.
One disk will usually win, 2 disks (in a mirror) will definitely win.
RAID-5 has the highest overhead and the poorest performance,
especially if it's degraded (1 drive out) that simple mirroring
methods don't suffer from. But even in an undegraded state it is
usually the slowest method. RAID-10 is generally the fastest with
redundancy, and of course pure RAID-0 is fastest of all but has no
redundancy.
You should do some simple benchmarks with something like pgbench and
various configs to see for yourself. For extra bonus points, break a
mirror (2 disk -> 1 disk) and compare it to RAID-5 (3 disk -> 2 disk
degraded) for performance. The change in performance for a RAID-1 to
single disk degraded situation is usually reads are half as fast and
writes are just as fast. For RAID-5 expect to see it drop by a lot.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:36 Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 03:55 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 04:00 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 06:18 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 07:05 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
@ 2011-12-23 07:58 ` Satoshi Nagayasu <satoshi.nagayasu@gmail.com>
1 sibling, 0 replies; 13+ messages in thread
From: Satoshi Nagayasu @ 2011-12-23 07:58 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; pgsql-performance-owner@postgresql.org, "tuanhoanganh" <hatuan05@gmail.com>; +Cc: pgsql-performance
Hi,
In addition, when you have multiple hard drive, it needs to be considered to put a database cluster and wal files separately on different spindles (hard drives), because of different I/O charasteristics, in particular update intensive workload.
Generally speaking, having 4 disks, one RAID-1 pair for a database cluster and another RAID-1 pair for WAL files, would be fine.
--
NAGAYASU Satoshi <satoshi.nagayasu@gmail.com>
-----Original Message-----
From: Scott Marlowe <scott.marlowe@gmail.com>
Sender: pgsql-performance-owner@postgresql.orgDate: Fri, 23 Dec 2011 00:05:31
To: tuanhoanganh<hatuan05@gmail.com>
Cc: <pgsql-performance@postgresql.org>
Subject: Re: [PERFORM] Postgresql 9.0.6 Raid 5 or not please help.
On Thu, Dec 22, 2011 at 11:18 PM, tuanhoanganh <hatuan05@gmail.com> wrote:
> Thanks for your answer. But how performance between raid5 and one disk.
One disk will usually win, 2 disks (in a mirror) will definitely win.
RAID-5 has the highest overhead and the poorest performance,
especially if it's degraded (1 drive out) that simple mirroring
methods don't suffer from. But even in an undegraded state it is
usually the slowest method. RAID-10 is generally the fastest with
redundancy, and of course pure RAID-0 is fastest of all but has no
redundancy.
You should do some simple benchmarks with something like pgbench and
various configs to see for yourself. For extra bonus points, break a
mirror (2 disk -> 1 disk) and compare it to RAID-5 (3 disk -> 2 disk
degraded) for performance. The change in performance for a RAID-1 to
single disk degraded situation is usually reads are half as fast and
writes are just as fast. For RAID-5 expect to see it drop by a lot.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:36 Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 03:55 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 04:00 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 06:18 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 07:05 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
@ 2011-12-23 09:20 ` Mario Weilguni <roadrunner6@gmx.at>
2011-12-23 12:15 ` Re: Postgresql 9.0.6 Raid 5 or not please help. alexandre - aldeia digital <adaldeia@gmail.com>
1 sibling, 1 reply; 13+ messages in thread
From: Mario Weilguni @ 2011-12-23 09:20 UTC (permalink / raw)
To: pgsql-performance
Am 23.12.2011 08:05, schrieb Scott Marlowe:
> On Thu, Dec 22, 2011 at 11:18 PM, tuanhoanganh<hatuan05@gmail.com> wrote:
>> Thanks for your answer. But how performance between raid5 and one disk.
> One disk will usually win, 2 disks (in a mirror) will definitely win.
> RAID-5 has the highest overhead and the poorest performance,
> especially if it's degraded (1 drive out) that simple mirroring
> methods don't suffer from. But even in an undegraded state it is
> usually the slowest method. RAID-10 is generally the fastest with
> redundancy, and of course pure RAID-0 is fastest of all but has no
> redundancy.
>
> You should do some simple benchmarks with something like pgbench and
> various configs to see for yourself. For extra bonus points, break a
> mirror (2 disk -> 1 disk) and compare it to RAID-5 (3 disk -> 2 disk
> degraded) for performance. The change in performance for a RAID-1 to
> single disk degraded situation is usually reads are half as fast and
> writes are just as fast. For RAID-5 expect to see it drop by a lot.
>
I'm not so confident that a RAID-1 will win over a single disk. When it
comes to writes, the latency should be ~50 higher (if both disk must
sync), since the spindles are not running synchronously. This applies to
softraid, not something like a battery-backend raid controller of course.
Or am I wrong here?
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:36 Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 03:55 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 04:00 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 06:18 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 07:05 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 09:20 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Mario Weilguni <roadrunner6@gmx.at>
@ 2011-12-23 12:15 ` alexandre - aldeia digital <adaldeia@gmail.com>
2011-12-23 15:25 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: alexandre - aldeia digital @ 2011-12-23 12:15 UTC (permalink / raw)
To: pgsql-performance
> I'm not so confident that a RAID-1 will win over a single disk. When it
> comes to writes, the latency should be ~50 higher (if both disk must
> sync), since the spindles are not running synchronously. This applies to
> softraid, not something like a battery-backend raid controller of course.
>
> Or am I wrong here?
>
Software RAID-1 in Linux, can read data in all disks and generally
increase a lot the data rate in reads. In writes, for sure, the overhead
is great compared with a single disk, but not too much.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:36 Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 03:55 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 04:00 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 06:18 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 07:05 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 09:20 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Mario Weilguni <roadrunner6@gmx.at>
2011-12-23 12:15 ` Re: Postgresql 9.0.6 Raid 5 or not please help. alexandre - aldeia digital <adaldeia@gmail.com>
@ 2011-12-23 15:25 ` Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 15:32 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Scott Marlowe @ 2011-12-23 15:25 UTC (permalink / raw)
To: alexandre - aldeia digital <adaldeia@gmail.com>; +Cc: pgsql-performance
On Fri, Dec 23, 2011 at 5:15 AM, alexandre - aldeia digital
<adaldeia@gmail.com> wrote:
>> I'm not so confident that a RAID-1 will win over a single disk. When it
>> comes to writes, the latency should be ~50 higher (if both disk must
>> sync), since the spindles are not running synchronously. This applies to
>> softraid, not something like a battery-backend raid controller of course.
>>
>> Or am I wrong here?
>>
>
> Software RAID-1 in Linux, can read data in all disks and generally increase
> a lot the data rate in reads. In writes, for sure, the overhead is great
> compared with a single disk, but not too much.
Exactly. Unless you spend a great deal of time writing data out to
the disks, the faster reads will more than make up for a tiny increase
in latency for the writes to the drives.
As regards the other recommendation in this thread to use two mirror
sets one for xlog and one for everything else, unless you're doing a
lot of writing, it's often still a winner to just run one big 4 disk
RAID-10.
Of course the real winner is to put a hardware RAID controller with
battery backed cache between your OS and the hard drives, then the
performance of even just a pair of drives in RAID-1 will be quite
fast.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:36 Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 03:55 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 04:00 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 06:18 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 07:05 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 09:20 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Mario Weilguni <roadrunner6@gmx.at>
2011-12-23 12:15 ` Re: Postgresql 9.0.6 Raid 5 or not please help. alexandre - aldeia digital <adaldeia@gmail.com>
2011-12-23 15:25 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
@ 2011-12-23 15:32 ` tuanhoanganh <hatuan05@gmail.com>
2011-12-23 18:06 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: tuanhoanganh @ 2011-12-23 15:32 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: alexandre - aldeia digital <adaldeia@gmail.com>; pgsql-performance
Thanks for all. I change to RAID 1 and here is new pg_bench result:
pgbench -h 127.0.0.1 -p 5433 -U postgres -c 10 -T 1800 -s 10 pgbench
Scale option ignored, using pgbench_branches table count = 10
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 10
query mode: simple
number of clients: 10
number of threads: 1
duration: 1800 s
number of transactions actually processed: 4373177
tps = 2429.396876 (including connections establishing)
tps = 2429.675016 (excluding connections establishing)
Press any key to continue . . .
Tuan Hoang ANh
On Fri, Dec 23, 2011 at 10:25 PM, Scott Marlowe <scott.marlowe@gmail.com>wrote:
> On Fri, Dec 23, 2011 at 5:15 AM, alexandre - aldeia digital
> <adaldeia@gmail.com> wrote:
> >> I'm not so confident that a RAID-1 will win over a single disk. When it
> >> comes to writes, the latency should be ~50 higher (if both disk must
> >> sync), since the spindles are not running synchronously. This applies to
> >> softraid, not something like a battery-backend raid controller of
> course.
> >>
> >> Or am I wrong here?
> >>
> >
> > Software RAID-1 in Linux, can read data in all disks and generally
> increase
> > a lot the data rate in reads. In writes, for sure, the overhead is great
> > compared with a single disk, but not too much.
>
> Exactly. Unless you spend a great deal of time writing data out to
> the disks, the faster reads will more than make up for a tiny increase
> in latency for the writes to the drives.
>
> As regards the other recommendation in this thread to use two mirror
> sets one for xlog and one for everything else, unless you're doing a
> lot of writing, it's often still a winner to just run one big 4 disk
> RAID-10.
>
> Of course the real winner is to put a hardware RAID controller with
> battery backed cache between your OS and the hard drives, then the
> performance of even just a pair of drives in RAID-1 will be quite
> fast.
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:36 Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 03:55 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 04:00 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 06:18 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 07:05 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 09:20 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Mario Weilguni <roadrunner6@gmx.at>
2011-12-23 12:15 ` Re: Postgresql 9.0.6 Raid 5 or not please help. alexandre - aldeia digital <adaldeia@gmail.com>
2011-12-23 15:25 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 15:32 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
@ 2011-12-23 18:06 ` Scott Marlowe <scott.marlowe@gmail.com>
2011-12-25 03:13 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Scott Marlowe @ 2011-12-23 18:06 UTC (permalink / raw)
To: tuanhoanganh <hatuan05@gmail.com>; +Cc: alexandre - aldeia digital <adaldeia@gmail.com>; pgsql-performance
On Fri, Dec 23, 2011 at 8:32 AM, tuanhoanganh <hatuan05@gmail.com> wrote:
> Thanks for all. I change to RAID 1 and here is new pg_bench result:
>
> pgbench -h 127.0.0.1 -p 5433 -U postgres -c 10 -T 1800 -s 10 pgbench
> Scale option ignored, using pgbench_branches table count = 10
> starting vacuum...end.
> transaction type: TPC-B (sort of)
> scaling factor: 10
> query mode: simple
> number of clients: 10
> number of threads: 1
> duration: 1800 s
> number of transactions actually processed: 4373177
> tps = 2429.396876 (including connections establishing)
> tps = 2429.675016 (excluding connections establishing)
> Press any key to continue . . .
Note that those numbers are really only possible if your drives are
lying about fsync or you have fsync turned off or you have a battery
backed caching RAID controller. I.e. your database is likely not
crash-proof.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:36 Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 03:55 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 04:00 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 06:18 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 07:05 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 09:20 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Mario Weilguni <roadrunner6@gmx.at>
2011-12-23 12:15 ` Re: Postgresql 9.0.6 Raid 5 or not please help. alexandre - aldeia digital <adaldeia@gmail.com>
2011-12-23 15:25 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 15:32 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 18:06 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
@ 2011-12-25 03:13 ` tuanhoanganh <hatuan05@gmail.com>
2011-12-25 07:15 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: tuanhoanganh @ 2011-12-25 03:13 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: alexandre - aldeia digital <adaldeia@gmail.com>; pgsql-performance
Thank for your information.
My postgresql config fsync default
#fsync = on # turns forced synchronization on or off
My RAID is ServeRAID M5015 SAS/SATA controller, in MegaRaid Store Manager
it show BBU Present = YES.
Does it have battery backed caching RAID controller?
Please help me, I am newbie of RAID card manager.
Tuan Hoang Anh.
On Sat, Dec 24, 2011 at 1:06 AM, Scott Marlowe <scott.marlowe@gmail.com>wrote:
> On Fri, Dec 23, 2011 at 8:32 AM, tuanhoanganh <hatuan05@gmail.com> wrote:
> > Thanks for all. I change to RAID 1 and here is new pg_bench result:
> >
> > pgbench -h 127.0.0.1 -p 5433 -U postgres -c 10 -T 1800 -s 10 pgbench
> > Scale option ignored, using pgbench_branches table count = 10
> > starting vacuum...end.
> > transaction type: TPC-B (sort of)
> > scaling factor: 10
> > query mode: simple
> > number of clients: 10
> > number of threads: 1
> > duration: 1800 s
> > number of transactions actually processed: 4373177
> > tps = 2429.396876 (including connections establishing)
> > tps = 2429.675016 (excluding connections establishing)
> > Press any key to continue . . .
>
> Note that those numbers are really only possible if your drives are
> lying about fsync or you have fsync turned off or you have a battery
> backed caching RAID controller. I.e. your database is likely not
> crash-proof.
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:36 Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 03:55 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 04:00 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 06:18 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 07:05 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 09:20 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Mario Weilguni <roadrunner6@gmx.at>
2011-12-23 12:15 ` Re: Postgresql 9.0.6 Raid 5 or not please help. alexandre - aldeia digital <adaldeia@gmail.com>
2011-12-23 15:25 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 15:32 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 18:06 ` Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe <scott.marlowe@gmail.com>
2011-12-25 03:13 ` Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
@ 2011-12-25 07:15 ` Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 13+ messages in thread
From: Scott Marlowe @ 2011-12-25 07:15 UTC (permalink / raw)
To: tuanhoanganh <hatuan05@gmail.com>; +Cc: alexandre - aldeia digital <adaldeia@gmail.com>; pgsql-performance
On Sat, Dec 24, 2011 at 8:13 PM, tuanhoanganh <hatuan05@gmail.com> wrote:
> Thank for your information.
> My postgresql config fsync default
> #fsync = on # turns forced synchronization on or off
> My RAID is ServeRAID M5015 SAS/SATA controller, in MegaRaid Store Manager it
> show BBU Present = YES.
> Does it have battery backed caching RAID controller?
> Please help me, I am newbie of RAID card manager.
Yep you've got battery backed caching RAID. So regular pgbench tells
you how much faster RAID-1 is than RAID-5 at a read/write mixed load.
You can run it with a -s switch for a read only benchmark to get an
idea how much, if any, of a difference there is between the two.
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2011-12-25 07:15 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-12-23 03:36 Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh <hatuan05@gmail.com>
2011-12-23 03:55 ` Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 04:00 ` Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 06:18 ` tuanhoanganh <hatuan05@gmail.com>
2011-12-23 07:05 ` Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 07:58 ` Satoshi Nagayasu <satoshi.nagayasu@gmail.com>
2011-12-23 09:20 ` Mario Weilguni <roadrunner6@gmx.at>
2011-12-23 12:15 ` alexandre - aldeia digital <adaldeia@gmail.com>
2011-12-23 15:25 ` Scott Marlowe <scott.marlowe@gmail.com>
2011-12-23 15:32 ` tuanhoanganh <hatuan05@gmail.com>
2011-12-23 18:06 ` Scott Marlowe <scott.marlowe@gmail.com>
2011-12-25 03:13 ` tuanhoanganh <hatuan05@gmail.com>
2011-12-25 07:15 ` Scott Marlowe <scott.marlowe@gmail.com>
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