Re: [GENERAL] Recommendations for SSDs in production?

[Thomas Mieslinger]

Am 03.11.2011 18:59, schrieb Robert Treat:

On Wed, Nov 2, 2011 at 11:02 PM, Benjamin Smith
  wrote:

On Wednesday, November 02, 2011 11:39:25 AM Thomas Strunz wrote:

I guess go Intel
route or some other crazy expensive enterprise stuff.


It's advice about some of the "crazy expensive enterprise" stuff that I'm
seeking...? I don't mind spending some money if I get to keep up this level of


Stec (http://stec-inc.com/) or texas memory systems 
(http://www.ramsan.com/) do the kind of ssds you want for enterprise 
application. Reading the specs for intel 320, 710 you can calculate how 
long ssds will live when loaded with maximum random io workload.


intel 320  80GB   10TB written 1 4k IOPS
 about 3 days to the of end design lifetime

intel 710 100GB  500TB written  2700 4k IOPS
 about 575 days to the of end design lifetime

If you are using Linux you can use the values in /proc/iostats to get a 
rough idea what your system is doing and how many tb get written per day.


stec offers a wear resistant ssd which is composed from 8GB RAM, a big 
capacitor, 8GB Flash and some logic to write the ram contents into flash 
when the power has gone.


see
http://www.intel.com/content/dam/doc/product-brief/ssd-320-brief.pdf

http://www.intel.com/content/dam/doc/product-specification/ssd-710-series-specification.pdf

http://embeddedcomputingsystems.com/wp-content/uploads/2011/05/STEC_AVNET_SSD_Spring2011.pdf


performance, but also am not looking to make somebody's private plane payment,
either.


There's a pretty varied mix of speed, durability, and price with any
SSD based architecture, but the two that have proven best in our
testing and production use (for ourselves and our clients) seem to be
Intel (mostly 320 series iirc), and Fusion-IO. I'd start with looking
at those.

Robert Treat
conjecture: xzilla.net
consulting: omniti.com




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Anyone using the solaris 11 precompiled binaries on opensolaris snv_134

[Thomas Mieslinger]

Hi,

I'm trying to run the precomplied binaries form postgresql.org for 
solaris 11 intel. The Readme says it has been compiled on opensolaris 
2010.11 which is (to the best of my knowledge snv_134). My machine is 
also snv_134.


When I do ldd /usr/postgres/9.1-pgdg/bin/postgres it tells me that:

libsocket.so.1 (SUNW_1.7) =>  (version not found)

$ pvs /lib/libsocket.so.1
libnsl.so.1 (SUNW_1.7, SUNWprivate_1.1);
libc.so.1 (SUNW_1.23, SUNWprivate_1.1);
libsocket.so.1;
SUNW_1.6;
SUNW_1.5;
SUNW_1.4;
SUNW_1.3;
SUNW_1.2;
SUNW_1.1;
SUNW_0.7;
SUNWprivate_1.3;
SUNWprivate_1.2;
SUNWprivate_1.1;

So my libc has only the interfaces up to SUNW_1.6. How can this happen 
that two snv_134 machines have different libsockets?


Thanks for your insight

Thomas

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general