pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql on SAN
4+ messages / 4 participants
[nested] [flat]
* Postgresql on SAN
@ 2004-02-19 16:28 Anjan Dave <adave@vantage.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 17:36 Josh Berkus <josh@agliodbs.com>
parent: Anjan Dave <adave@vantage.com>
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 18:06 Nick Barr <nicky@chuckie.co.uk>
parent: Josh Berkus <josh@agliodbs.com>
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-03-11 00:43 Joseph Shraibman <jks@selectacast.net>
parent: Josh Berkus <josh@agliodbs.com>
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