In summary, it seems one of these is true:
1. Drive manufacturers don't design server drives to be more
reliable than consumer drive
2. Drive manufacturers _do_ design server drives to be more
reliable than consumer drive, but the design doesn't yield significantly
better relia
Ron wrote:
I read them as soon as they were available. Then I shrugged and noted
YMMV to myself.
1= Those studies are valid for =those= users under =those= users'
circumstances in =those= users' environments.
How well do those circumstances and environments mimic anyone else's?
Exactly,
* Charles Sprickman <[EMAIL PROTECTED]> [070407 00:49]:
> On Fri, 6 Apr 2007, [EMAIL PROTECTED] wrote:
>
> >On Fri, 6 Apr 2007, Scott Marlowe wrote:
> >
> >>Based on experience I think that on average server drives are more
> >>reliable than consumer grade drives, and can take more punishment.
> >
On Fri, 6 Apr 2007, Charles Sprickman wrote:
On Fri, 6 Apr 2007, [EMAIL PROTECTED] wrote:
On Fri, 6 Apr 2007, Scott Marlowe wrote:
> Based on experience I think that on average server drives are more
> reliable than consumer grade drives, and can take more punishment.
this I am not sure
On Fri, 6 Apr 2007, [EMAIL PROTECTED] wrote:
On Fri, 6 Apr 2007, Scott Marlowe wrote:
Based on experience I think that on average server drives are more
reliable than consumer grade drives, and can take more punishment.
this I am not sure about
I think they should survey Tivo owners next t
On Fri, 6 Apr 2007, Scott Marlowe wrote:
Based on experience I think that on average server drives are more
reliable than consumer grade drives, and can take more punishment.
this I am not sure about
But,
the variables of manufacturer, model, and the batch often make even more
difference tha
On 4/6/07, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Fri, Apr 06, 2007 at 04:38:33PM -0400, Alex Deucher wrote:
> One more anomaly between 7.4 and 8.2. DB dumped from 7.4 and loaded
> onto 8.2, both have locale set to C. 8.2 seems to prefer Seq Scans
> for the first query while the ordering in
On Fri, Apr 06, 2007 at 04:38:33PM -0400, Alex Deucher wrote:
> One more anomaly between 7.4 and 8.2. DB dumped from 7.4 and loaded
> onto 8.2, both have locale set to C. 8.2 seems to prefer Seq Scans
> for the first query while the ordering in the second query seems to
> perform worse on 8.2. I
On Fri, Apr 06, 2007 at 03:37:08PM -0400, Ron wrote:
studies. I respect that. Unfortunately the RW is too fast moving
and too messy to wait for a laboratory style study to be completed
before we are called on to make professional decisions on most
issues we face within our work
IME I have to
On Fri, 6 Apr 2007, Scott Marlowe wrote:
Most server drives are rated for 55-60C environmental temperature
operation, which means the drive would be even hotter.
I chuckled when I dug into the details for the drives in my cheap PC; the
consumer drives from Seagate:
http://www.seagate.com/doc
One more anomaly between 7.4 and 8.2. DB dumped from 7.4 and loaded
onto 8.2, both have locale set to C. 8.2 seems to prefer Seq Scans
for the first query while the ordering in the second query seems to
perform worse on 8.2. I ran analyze. I've tried with the encoding
set to UTF-8 and SQL_ASCI
On 4/6/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> The problem seems to be that clan_members_v contains a call to an
> expensive function:
I'll bet that the function is marked VOLATILE. 8.2 is more conservative
about optimizing away volatile functions than previous releases. If
it has no side ef
At 02:19 PM 4/6/2007, Michael Stone wrote:
On Fri, Apr 06, 2007 at 12:41:25PM -0400, Ron wrote:
3.based on personal observation, case study reports, or random
investigations rather than systematic scientific evaluation:
anecdotal evidence.
Here you even quote the appropriate definition before
"Jonathan Ellis" <[EMAIL PROTECTED]> writes:
> It was in my original post unless it got clipped:
Sorry, I had forgotten.
> The problem seems to be that clan_members_v contains a call to an
> expensive function:
I'll bet that the function is marked VOLATILE. 8.2 is more conservative
about optimi
On Fri, Apr 06, 2007 at 12:41:25PM -0400, Ron wrote:
3.based on personal observation, case study
reports, or random investigations rather than
systematic scientific evaluation: anecdotal evidence.
Here you even quote the appropriate definition before ignoring it.
In short, professional advic
On 4/6/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Jonathan Ellis" <[EMAIL PROTECTED]> writes:
> I can do that... you don't think the fact I mentioned, that
> redefining the view to leave out the expensive function fixes the
> problem, is relevant?
Hm, I'd not have thought that an expensive functi
"Jonathan Ellis" <[EMAIL PROTECTED]> writes:
> I can do that... you don't think the fact I mentioned, that
> redefining the view to leave out the expensive function fixes the
> problem, is relevant?
Hm, I'd not have thought that an expensive function would get evaluated
partway up the join tree,
On 4/6/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Jonathan Ellis" <[EMAIL PROTECTED]> writes:
> On 4/6/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>> Yeah, it sure is the same plan, and 8.2 seems to be a tad faster right
>> up to the hash join on user_id. Is user_id a textual datatype?
> user_id is a
"Jonathan Ellis" <[EMAIL PROTECTED]> writes:
> On 4/6/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>> Yeah, it sure is the same plan, and 8.2 seems to be a tad faster right
>> up to the hash join on user_id. Is user_id a textual datatype?
> user_id is an int; they are both C locale.
Really!? So much
Stefan Kaltenbrunner wrote:
Geoffrey wrote:
We are trying to attack this problem from multiple avenues, thus I'm
starting a separate thread. This is with regard to the problem posted
via thread:
http://archives.postgresql.org/pgsql-performance/2007-04/msg00120.php
One thing we are seeing with
At 09:23 AM 4/6/2007, Michael Stone wrote:
On Fri, Apr 06, 2007 at 08:49:08AM -0400, Ron wrote:
Not quite. Each of our professional
experiences is +also+ statistical
evidence. Even if it is a personally skewed sample.
I'm not sure that word means what you think it
means. I think the one yo
Geoffrey wrote:
> We are trying to attack this problem from multiple avenues, thus I'm
> starting a separate thread. This is with regard to the problem posted
> via thread:
>
> http://archives.postgresql.org/pgsql-performance/2007-04/msg00120.php
>
> One thing we are seeing with this move to the
We are trying to attack this problem from multiple avenues, thus I'm
starting a separate thread. This is with regard to the problem posted
via thread:
http://archives.postgresql.org/pgsql-performance/2007-04/msg00120.php
One thing we are seeing with this move to the new hardware (and rhas 4)
On Thu, 2007-04-05 at 23:37, Greg Smith wrote:
> On Thu, 5 Apr 2007, Scott Marlowe wrote:
>
> > On Thu, 2007-04-05 at 14:30, James Mansion wrote:
> >> Can you cite any statistical evidence for this?
> > Logic?
>
> OK, everyone who hasn't already needs to read the Google and CMU papers.
> I'll ev
Hey Guys thanks for the input. I do have some more questions. I am looking a
doing some additional tuning on the system. The first think I am looking at
is the OS tuning. What kernel parameters would I look at setting on a RHEL 4
box? I have set the SHMMAX and SHMALL to 1GB. What other tuning optio
On 4/6/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Jonathan Ellis" <[EMAIL PROTECTED]> writes:
> On 4/5/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>>> Is this a regression, or a "feature" of 8.2?
>>
>> Hard to say without EXPLAIN ANALYZE output to compare.
> To my eye they are identical other than the
On Fri, Apr 06, 2007 at 08:49:08AM -0400, Ron wrote:
Not quite. Each of our professional experiences is +also+
statistical evidence. Even if it is a personally skewed sample.
I'm not sure that word means what you think it means. I think the one
you're looking for is "anecdotal".
My experie
Michael Stone wrote:
On Fri, Apr 06, 2007 at 02:00:15AM -0400, Tom Lane wrote:
It seems hard to believe that the vendors themselves wouldn't burn in
the drives for half a day, if that's all it takes to eliminate a large
fraction of infant mortality. The savings in return processing and
customer
At 07:38 AM 4/6/2007, Michael Stone wrote:
On Thu, Apr 05, 2007 at 11:19:04PM -0400, Ron wrote:
Both statements are the literal truth.
Repeating something over and over again doesn't make it truth. The
OP asked for statistical evidence (presumably real-world field
evidence) to support that a
Tom Lane wrote:
Greg Smith <[EMAIL PROTECTED]> writes:
On Fri, 6 Apr 2007, Tom Lane wrote:
It seems hard to believe that the vendors themselves wouldn't burn in
the drives for half a day, if that's all it takes to eliminate a large
fraction of infant mortality.
I've read that much of the dama
I read them as soon as they were available. Then I shrugged and
noted YMMV to myself.
1= Those studies are valid for =those= users under =those= users'
circumstances in =those= users' environments.
How well do those circumstances and environments mimic anyone else's?
I don't know since the
On Fri, Apr 06, 2007 at 02:00:15AM -0400, Tom Lane wrote:
It seems hard to believe that the vendors themselves wouldn't burn in
the drives for half a day, if that's all it takes to eliminate a large
fraction of infant mortality. The savings in return processing and
customer goodwill would surely
On Thu, Apr 05, 2007 at 11:19:04PM -0400, Ron wrote:
Both statements are the literal truth.
Repeating something over and over again doesn't make it truth. The OP
asked for statistical evidence (presumably real-world field evidence) to
support that assertion. Thus far, all the publicly availab
33 matches
Mail list logo
