Hi Chris,
A couple comments on the NetApp SAN.
We use NetApp, primarily with Fiber connectivity and FC drives. All of the
Postgres files are located on the SAN and this configuration works well.
We have tried iSCSI, but performance his horrible. Same with SATA drives.
The SAN will definitely be
Hi list,
My employer will be donated a NetApp FAS 3040 SAN [1] and we want to run
our warehouse DB on it. The pg9.0 DB currently comprises ~1.5TB of
tables, 200GB of indexes, and grows ~5%/month. The DB is not update
critical, but undergoes larger read and insert operations frequently.
My
chris wrote:
My employer is a university with little funds and we have to find a
cheap way to scale for the next 3 years, so the SAN seems a good chance
to us.
A SAN is rarely ever the cheapest way to scale anything; you're paying
extra for reliability instead.
I was thinking to put the
1 x Intel Xeon X5670, 6C, 2.93GHz, 12M Cache
16 GB (4x4GB) Low Volt DDR3 1066Mhz
PERC H700 SAS RAID controller
4 x 300 GB 10k SAS 6Gbps 2.5 in RAID 10
Apart from Gregs excellent recommendations. I would strongly suggest
more memory. 16GB in 2011 is really on the low side.
PG is using
On 7/15/2011 2:10 AM, Greg Smith wrote:
chris wrote:
My employer is a university with little funds and we have to find a
cheap way to scale for the next 3 years, so the SAN seems a good chance
to us.
A SAN is rarely ever the cheapest way to scale anything; you're paying
extra for reliability
On Fri, Jul 15, 2011 at 12:34 AM, chris chri...@gmx.net wrote:
I was thinking to put the WAL and the indexes on the local disks, and
the rest on the SAN. If funds allow, we might downgrade the disks to
SATA and add a 50 GB SATA SSD for the WAL (SAS/SATA mixup not possible).
Just to add to the
On Fri, Jul 15, 2011 at 10:39 AM, Robert Schnabel
schnab...@missouri.edu wrote:
I'm curious what people think of these:
http://www.pc-pitstop.com/sas_cables_enclosures/scsase166g.asp
I currently have my database on two of these and for my purpose they seem to
be fine and are quite a bit less
Just to add to the conversation, there's no real advantage to putting
WAL on SSD. Indexes can benefit from them, but WAL is mosty
seqwuential throughput and for that a pair of SATA 1TB drives at
7200RPM work just fine for most folks.
Actually, there's a strong disadvantage to putting WAL
Hi list,
Thanks a lot for your very helpful feedback!
I've tested MD1000, MD1200, and MD1220 arrays before, and always gotten
seriously good performance relative to the dollars spent
Great hint, but I'm afraid that's too expensive for us. But it's a great
way to scale over the years, I'll keep
On Fri, Jul 15, 2011 at 11:49 AM, chris r. chri...@gmx.net wrote:
Hi list,
Thanks a lot for your very helpful feedback!
I've tested MD1000, MD1200, and MD1220 arrays before, and always gotten
seriously good performance relative to the dollars spent
Great hint, but I'm afraid that's too
On 7/14/11 11:34 PM, chris wrote:
Any comments on the configuration? Any experiences with iSCSI vs. Fibre
Channel for SANs and PostgreSQL? If the SAN setup sucks, do you see a
cheap alternative how to connect as many as 16 x 2TB disks as DAS?
Here's the problem with iSCSI: on gigabit ethernet,
11 matches
Mail list logo