pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgresql on SAN
4+ messages / 4 participants
[nested] [flat]

* Postgresql on SAN
@ 2004-02-19 16:28 Anjan Dave <adave@vantage.com>
  2004-02-19 17:36 ` Re: Postgresql on SAN Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Anjan Dave @ 2004-02-19 16:28 UTC (permalink / raw)
  To: pgsql-performance

Hello,
 
Has anyone designed/implemented postgresql server on storage networks?
 
Are there any design considerations?
 
Are there any benchmarks for storage products (HBAs, Switches, Storage
Arrays)?
 
Any recommendation on the design, resources, references, keeping PG in
mind?
 
 
Thanks,
Anjan
 
************************************************************************
** 

This e-mail and any files transmitted with it are intended for the use
of the addressee(s) only and may be confidential and covered by the
attorney/client and other privileges. If you received this e-mail in
error, please notify the sender; do not disclose, copy, distribute, or
take any action in reliance on the contents of this information; and
delete it from your system. Any other use of this e-mail is prohibited.

 

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Postgresql on SAN
  2004-02-19 16:28 Postgresql on SAN Anjan Dave <adave@vantage.com>
@ 2004-02-19 17:36 ` Josh Berkus <josh@agliodbs.com>
  2004-02-19 18:06   ` Re: Postgresql on SAN Nick Barr <nicky@chuckie.co.uk>
  2004-03-11 00:43   ` Re: Postgresql on SAN Joseph Shraibman <jks@selectacast.net>
  0 siblings, 2 replies; 4+ messages in thread

From: Josh Berkus @ 2004-02-19 17:36 UTC (permalink / raw)
  To: Anjan Dave <adave@vantage.com>; 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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Postgresql on SAN
  2004-02-19 16:28 Postgresql on SAN Anjan Dave <adave@vantage.com>
  2004-02-19 17:36 ` Re: Postgresql on SAN Josh Berkus <josh@agliodbs.com>
@ 2004-02-19 18:06   ` Nick Barr <nicky@chuckie.co.uk>
  1 sibling, 0 replies; 4+ messages in thread

From: Nick Barr @ 2004-02-19 18:06 UTC (permalink / raw)
  To: josh@agliodbs.com; +Cc: Anjan Dave <adave@vantage.com>; pgsql-performance

Josh Berkus wrote:

>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.
>
>  
>
We run PG on a SAN array. We currently have it setup so a single PG 
instance runs off of a single LUN, this includes the WAL logs. Apart 
from that we have made no other special considerations; we just treat it 
as a fast RAID array. We haven't got to the stage where the speed of the 
SAN is a problem as load hasn't increased as expected. This will change, 
when it does I am sure the performance list will be hearing from us ;-). 
Out current limitations, as I see it, are amount of memory and then 
processing power. The only problem we have had was a dodgy set of kernel 
modules (drivers) for the fibre cards, this was because they were beta 
drivers and obviously still had a few bugs. This was solved by reverting 
to an older version. Everything has run smoothly since then (uptime is 
153 days :-)).


Nick






^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Postgresql on SAN
  2004-02-19 16:28 Postgresql on SAN Anjan Dave <adave@vantage.com>
  2004-02-19 17:36 ` Re: Postgresql on SAN Josh Berkus <josh@agliodbs.com>
@ 2004-03-11 00:43   ` Joseph Shraibman <jks@selectacast.net>
  1 sibling, 0 replies; 4+ messages in thread

From: Joseph Shraibman @ 2004-03-11 00:43 UTC (permalink / raw)
  To: pgsql-performance

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

Really?  What happened?



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-03-11 00:43 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-19 16:28 Postgresql on SAN Anjan Dave <adave@vantage.com>
2004-02-19 17:36 ` Josh Berkus <josh@agliodbs.com>
2004-02-19 18:06   ` Nick Barr <nicky@chuckie.co.uk>
2004-03-11 00:43   ` Joseph Shraibman <jks@selectacast.net>

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