[CLUE-Talk] Postgres RULES!!!!!! Linux is more good than cheap!!!!

[Grant Johnson]

Well, I play one on TV.....

<smartalecquip>
Actually, I do both.  Much as I am sure that you can both walk and chew 
gum, although likely not simultaneously.
</smartalecquip>
BTW, I already answered the sound question.


Dave Anselmi wrote:

>Grant Johnson wrote:
>
>>update test_copy
>>set stat=(select t2.val from test2 t2 where t2.prikey=test_copy.ctr::int)
>>where stat='N';
>>
>>This little querry may not look like much, but on an Oracle on Solaris
>>machine, it takes over 5 minutes to update 20,000 out of 35,000 rows.
>> The machine it is running is a dual CPU Ultra Sparc with a gig of RAM
>>(not sure of CPU speed).  However, updating 250,000 of 500,000 on
>>Postgres on Linux on a Celeron 300a with 256M of memory, it takes a
>>minute and 5 seconds.  Both were run on nearly unloaded machines.  The
>>Linux machine was additionally acting as a mail and file server at the time.
>>
>
>Hey, that's cool.  But what does this have to do with my sound card?  Aren't you
>an audio engineer???  What's going on here????
>
><BG>
>Dave
>
>
>_______________________________________________
>CLUE-Talk mailing list
>CLUE-Talk at clue.denver.co.us
>http://clue.denver.co.us/mailman/listinfo/clue-talk
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cluedenver.org/pipermail/clue-talk/attachments/20020215/c7001286/attachment.html