Skip site navigation (1) Skip section navigation (2)

Re: Postgresql on SAN

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Anjan Dave" <adave(at)vantage(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Postgresql on SAN
Date: 2004-02-19 17:36:47
Message-ID: 200402190936.47208.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Anjan,

> Has anyone designed/implemented postgresql server on storage networks?

Yes, Zapatec.com runs their stuff this way.  Probably others as well.

> Are there any design considerations?

I don't know.   Probably.

> Are there any benchmarks for storage products (HBAs, Switches, Storage
> Arrays)?

Not specific to PostgreSQL.    I'm sure there are generic benchmarks.   Keep 
in mind that PostgreSQL needs lots of 2-way I/O, batch writes, and random 
reads.

> Any recommendation on the design, resources, references, keeping PG in
> mind?

See above.   Also keep in mind that PostgreSQL's use of I/O should improve 
100% in version 7.5.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


In response to

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2004-02-19 17:39:12
Subject: Re: Forcing filter/join order?
Previous:From: Anjan DaveDate: 2004-02-19 16:28:56
Subject: Postgresql on SAN

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group