Re: PostgreSQL+ZFS

2011-01-01 Thread Boyd Stephen Smith Jr.
On Saturday 01 January 2011 20:30:31 Stan Hoeppner wrote: > Boyd Stephen Smith Jr. put forth on 1/1/2011 2:16 PM: > > Is your problem with RAID5 or the SSDs? > > RAID 5 > > > Sudden disk failure can occur with SSDs, just like with magnetic media. > > If > > This is not true. This is true. Whi

Re: PostgreSQL+ZFS

2011-01-01 Thread Stan Hoeppner
Atif CEYLAN put forth on 1/1/2011 3:58 PM: > On 01/01/2011 06:24 PM, Stan Hoeppner wrote: >> How much data? Total GB? > ~300 GB >> Are you currently short of space? > no, don't need more space. Perfect. :) >> Are you currently short of IOPS capacity? > yes Got it. >> How many concurrent t

Re: PostgreSQL+ZFS

2011-01-01 Thread Stan Hoeppner
Boyd Stephen Smith Jr. put forth on 1/1/2011 2:16 PM: > Is your problem with RAID5 or the SSDs? RAID 5 > Sudden disk failure can occur with SSDs, just like with magnetic media. If This is not true. The failure modes and rates for SSDs are the same as other solid state components, such as syst

Re: PostgreSQL+ZFS

2011-01-01 Thread Atif CEYLAN
On 01/01/2011 06:24 PM, Stan Hoeppner wrote: Atif CEYLAN put forth on 12/31/2010 4:58 PM: Hi all, I have a large postgresql database system and I want to migrate to a new and fast storage system (10 Gbp/s FC network). But 150x3 ssd disk on my db server and I want to use ext4 file system (rai

Re: PostgreSQL+ZFS

2011-01-01 Thread Boyd Stephen Smith Jr.
In <4d1f5543.3010...@hardwarefreak.com>, Stan Hoeppner wrote: >Atif CEYLAN put forth on 12/31/2010 4:58 PM: >> I have a large postgresql database system and I want to migrate to a new >> and fast storage system (10 Gbp/s FC network). But 150x3 ssd disk on my >> db server and I want to use ext4 file

Re: PostgreSQL+ZFS

2011-01-01 Thread Stan Hoeppner
Atif CEYLAN put forth on 12/31/2010 4:58 PM: > Hi all, > I have a large postgresql database system and I want to migrate to a new > and fast storage system (10 Gbp/s FC network). But 150x3 ssd disk on my > db server and I want to use ext4 file system (raid5) at the ssd disks as > xlog storage or us

PostgreSQL+ZFS

2010-12-31 Thread Atif CEYLAN
Hi all, I have a large postgresql database system and I want to migrate to a new and fast storage system (10 Gbp/s FC network). But 150x3 ssd disk on my db server and I want to use ext4 file system (raid5) at the ssd disks as xlog storage or use zfs (raidz) as disk buffer cache. What is your i