Bruce Momjian writes:
> I asked 3ware this at the Linuxworld Boston show and they said their
> controller keeps the information in cache until they are sure it is on
> the platters and not just in the disk cache, but that is far from a 100%
> reliable report.
Hm. Well, keeping it in cache is one
Anyone using power5 platform? something like an ibm eserver p5 520
running red hat linux.
(http://www-1.ibm.com/servers/eserver/pseries/hardware/entry/520.html)?
klint.
+---+-+
: Klint Gore: "Non rhyming:
: EMail
Greg Stark wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>
> > > I assume AMCC == 3ware now?
> > >
> > > Has anyone verified that fsync is safe on these controllers? Ie, that they
> > > aren't caching writes and "lying" about the write completing like IDE
> > > drives often do by default
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > I assume AMCC == 3ware now?
> >
> > Has anyone verified that fsync is safe on these controllers? Ie, that they
> > aren't caching writes and "lying" about the write completing like IDE
> > drives often do by default?
>
> The higher end AMCC/3ware
> I assume AMCC == 3ware now?
>
> Has anyone verified that fsync is safe on these controllers? Ie, that they
> aren't caching writes and "lying" about the write completing like IDE
> drives often do by default?
The higher end AMCC/3ware controllers actually warn you about using
write-cache. You
Greg Stark wrote:
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
Alex wrote:
Without starting too much controvesy I hope, I would seriously
recommend you evaluate the AMCC Escalade 9500S SATA controller.
.
At the risk of shaming myself with another 'me too' post, I'd like to
say t
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> Alex wrote:
> > Without starting too much controvesy I hope, I would seriously
> > recommend you evaluate the AMCC Escalade 9500S SATA controller.
...
> At the risk of shaming myself with another 'me too' post, I'd like to
> say that my experiences
Greg Stark wrote:
> Jan Dittmer <[EMAIL PROTECTED]> writes:
>
>
>>You could always do raid 1 over raid 0, with newer kernels (2.6ish)
>>there is even a dedicated raid10 driver.
>
>
> Aren't you much better off doing raid 0 over raid 1?
>
> With raid 1 over raid 0 you're mirroring two stripe s
Greg wrote:
> Josh Berkus writes:
>
> > Merlin,
> >
> > > I think the danger about SATA is that many SATA components are not
> > > server quality, so you have to be more careful about what you buy.
> For
> > > example, you can't just assume your SATA backplane has hot swap
lights
> > > (got bit b
Josh Berkus writes:
> Merlin,
>
> > I think the danger about SATA is that many SATA components are not
> > server quality, so you have to be more careful about what you buy. For
> > example, you can't just assume your SATA backplane has hot swap lights
> > (got bit by this one myself, heh).
>
Merlin,
> I think the danger about SATA is that many SATA components are not
> server quality, so you have to be more careful about what you buy. For
> example, you can't just assume your SATA backplane has hot swap lights
> (got bit by this one myself, heh).
Yeah, that's my big problem with any
Alex wrote:
> Without starting too much controvesy I hope, I would seriously
> recommend you evaluate the AMCC Escalade 9500S SATA controller. It
> has many of the features of a SCSI controler, but works with cheaper
> drives, and for half the price or many SCSI controlers (9500S-8MI goes
> for ab
Jan Dittmer <[EMAIL PROTECTED]> writes:
> You could always do raid 1 over raid 0, with newer kernels (2.6ish)
> there is even a dedicated raid10 driver.
Aren't you much better off doing raid 0 over raid 1?
With raid 1 over raid 0 you're mirroring two stripe sets. That means if any
drive from th
that people recommend? From what I've been
> reading RAID 10 and battery backed cache sound like things I need. :)
>
> Thanks,
>
> Benjamin Wragg
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Josh Berkus
> Sent
ECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Josh Berkus
Sent: Tuesday, 11 January 2005 5:35 PM
To: pgsql-performance@postgresql.org
Cc: Christopher Browne
Subject: Re: [PERFORM] which dual-CPU hardware/OS is fastest for PostgreSQL?
Chris,
> I don't know so much about FreeBSD's h
Joshua D. Drake wrote:
>>RAID controllers tend to use i960 or StrongARM CPUs that run at speeds
>>that _aren't_ all that impressive. With software RAID, you can take
>>advantage of the _enormous_ increases in the speed of the main CPU.
>>
>>I don't know so much about FreeBSD's handling of this, bu
No - I agree - Analysis cache hit rate as a single indicator is
dangerous. You can easily increase cache hit rate by de-optimizing a
good query so it uses more CPU cylces, and therefore has a higher
cache hit rate. All information has to be taken as a whole when
performing optimization on a syste
Alex Turner <[EMAIL PROTECTED]> writes:
> Infact the cache hit ratio that Oracle suggests is the minimum good
> value is 95%. Anything below that is bad news.
Well that seems very workload dependent. No amount of cache is going to be
able to achieve that for a DSS system chugging sequentially
Infact the cache hit ratio that Oracle suggests is the minimum good
value is 95%. Anything below that is bad news. The reason is pretty
obvious - RAM transfer speed is around 3.2G/sec these days, whilst
even the best array isn't going to give more than 400MB/sec, and
that's not even starting to t
Steinar H. Gunderson wrote:
On Mon, Jan 10, 2005 at 08:31:22PM -0800, Joshua D. Drake wrote:
Unless something has changed though, you can't run raid 10
with linux software raid
Hm, why not? What stops you from making two RAID-0 devices and mirroring
those? (Or the other way round, I can nev
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> heh, our apps do tend to be CPU bound. Generally, I think the extra CPU
> horsepower is worth the investment until you get to the really high end
> cpus.
I find that while most applications I work with shouldn't be cpu intensive
they do seem end up
while you weren't looking, Greg Stark wrote:
> Back in the day, we used to have problems with our 1U dual pentiums. We
> attributed it to heat accelerating failure. I would fear four opterons in 1U
> would be damned hard to cool effectively, no?
Opterons actually run pretty coolly, comparatively.
> $4000 is not going to get you much disk - If you buy components from
> the cheapest source I know (newegg.com) you end up around $5k with
> 14x36gig Raptor SATA drives and a 4U chasis with a 14xSATA built in
> back plane packing 2x9500S AMCC Escalade RAID cards, which are
> supported in Linux, 4G
to go nuts, they have
an 8U with 40xSATA backplane.
Alex Turner
NetEconomist
On Tue, 11 Jan 2005 08:33:09 -0500, Merlin Moncure
<[EMAIL PROTECTED]> wrote:
> > Subject: [PERFORM] which dual-CPU hardware/OS is fastest for
> PostgreSQL?
> >
> > I'm sorry if there
Rosser Schwarz <[EMAIL PROTECTED]> writes:
> Try also the Appro 1U 4-way Opteron server, at:
> http://www.appro.com/product/server_1142h.asp
Back in the day, we used to have problems with our 1U dual pentiums. We
attributed it to heat accelerating failure. I would fear four opterons in 1U
would b
while you weren't looking, Merlin Moncure wrote:
> 2 way or 4 way Opteron depending on needs (looking on a price for 4-way?
> Go here: http://www.swt.com/qo3.html).
Try also the Appro 1U 4-way Opteron server, at:
http://www.appro.com/product/server_1142h.asp
I specced a 4-way 842 (1.6 GHz: litt
> Subject: [PERFORM] which dual-CPU hardware/OS is fastest for
PostgreSQL?
>
> I'm sorry if there's a URL out there answering this, but I couldn't
find
> it.
>
> For those of us that need the best performance possible out of a
> dedicated dual-CPU Po
On 11 Jan 2005 04:25:04 GMT
Christopher Browne <[EMAIL PROTECTED]> wrote:
> Xeon sux pretty bad...
>
> > Linux or FreeBSD or _?_
>
> The killer question won't be of what OS is "faster," but rather of
> what OS better supports the fastest hardware you can get your hands
> on.
Well, if multiple
...and on Mon, Jan 10, 2005 at 08:31:22PM -0800, Joshua D. Drake used the
keyboard:
>
> >
> >RAID controllers tend to use i960 or StrongARM CPUs that run at speeds
> >that _aren't_ all that impressive. With software RAID, you can take
> >advantage of the _enormous_ increases in the speed of the
On Mon, Jan 10, 2005 at 08:31:22PM -0800, Joshua D. Drake wrote:
> Unless something has changed though, you can't run raid 10
> with linux software raid
Hm, why not? What stops you from making two RAID-0 devices and mirroring
those? (Or the other way round, I can never remember :-) )
/* Steinar *
Chris,
> I don't know so much about FreeBSD's handling of this, but on Linux,
> there's pretty strong indication that _SOFTWARE_ RAID is faster than
> hardware RAID.
Certainly better than an Adaptec. But not necessarily better than a
medium-end RAID card, like an LSI. It really depends on the
RAID controllers tend to use i960 or StrongARM CPUs that run at speeds
that _aren't_ all that impressive. With software RAID, you can take
advantage of the _enormous_ increases in the speed of the main CPU.
I don't know so much about FreeBSD's handling of this, but on Linux,
there's pretty strong
Xeon sux pretty bad...
> Linux or FreeBSD or _?_
The killer question won't be of what OS is "faster," but rather of
what OS better supports the fastest hardware you can get your hands
on.
We tried doing some FreeBSD benchmarking on a quad-Opteron box, only
to discover that the fibrechannel con
Quoth [EMAIL PROTECTED] (Miles Keaton):
> I'm sorry if there's a URL out there answering this, but I couldn't
> find it.
>
> For those of us that need the best performance possible out of a
> dedicated dual-CPU PostgreSQL server, what is recommended?
>
> AMD64/Opteron or i386/Xeon?
Xeon sux pretty
Miles Keaton wrote:
I'm sorry if there's a URL out there answering this, but I couldn't find it.
For those of us that need the best performance possible out of a
dedicated dual-CPU PostgreSQL server, what is recommended?
AMD64/Opteron or i386/Xeon?
AMD64/Opteron
Linux or FreeBSD or _?_
This i
I'm sorry if there's a URL out there answering this, but I couldn't find it.
For those of us that need the best performance possible out of a
dedicated dual-CPU PostgreSQL server, what is recommended?
AMD64/Opteron or i386/Xeon?
Linux or FreeBSD or _?_
I'm assuming hardware RAID 10 on 15k SCSI
36 matches
Mail list logo