Re: splitting data into multiple tables - Mailing list pgsql-performance

From Greg Smith
Subject Re: splitting data into multiple tables
Date
Msg-id 4B5F5162.8010607@2ndquadrant.com
Whole thread Raw
In response to Re: splitting data into multiple tables  (Viji V Nair <viji@fedoraproject.org>)
List pgsql-performance
Viji V Nair wrote:
> There are catches in the SAN controllers also. SAN vendors wont give
> that much information regarding their internal controller design. They
> will say they have 4 external 4G ports, you should also check how many
> internal ports they have and the how the controllers are operating,
> in Active-Active or Active- Standby mode.

Right, the SAN cache serves the same purpose as the controller cache on
direct-attached storage.  I've never seen a Fiber Channel card that had
its own local cache too; doubt that's even possible.  So I think of them
as basically being the same type of cache, with the primary difference
being that the transfers between the host and the cache has some latency
on it with FC compared to direct storage.

You're right that people should question the internal design too of
course.  Some days I wonder if I'm in the wrong business--the people who
do SAN tuning seem to have no idea what they're doing and yet are still
expensive to hire.  But this is off-topic for the question being asked here.

--
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com


pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Poor query plan across OR operator
Next
From: Tom Lane
Date:
Subject: Re: Poor query plan across OR operator