On 12-8-2010 2:53 gnuo...@rcn.com wrote:
- The value of SSD in the database world is not as A Faster HDD(tm).
Never was, despite the naive' who assert otherwise. The value of SSD
is to enable BCNF datastores. Period. If you're not going to do
that, don't bother. Silicon storage will never
Hi Joe,
the general rule on Solaris SPARC is:
- if you need to address a big size of memory (over 4G): compile in 64bit
- otherwise: compile in 32bit ;-)
It's true that 32bit code will run faster comparing to 64bit ont the
64bit SPARC - you'll operate with 2 times shorter addresses, and in
As others said, RAID6 is RAID5 + a hot spare.
No. RAID6 is NOT RAID5 plus a hot spare.
The original phrase was that RAID 6 was like RAID 5 with a hot spare
ALREADY BUILT IN.
Built-in, or not - it is neither. It is more than that, actually. RAID
6 is like RAID 5 in that it uses parity for
On 10-08-12 03:22 AM, Arjen van der Meijden wrote:
On 12-8-2010 2:53 gnuo...@rcn.com wrote:
- The value of SSD in the database world is not as A Faster HDD(tm).
Never was, despite the naive' who assert otherwise. The value of SSD
is to enable BCNF datastores. Period. If you're not going to
Tom Lane t...@sss.pgh.pa.us wrote in message
news:25116.1277047...@sss.pgh.pa.us...
Davor J. dav...@live.com writes:
Suppose 2 functions: factor(int,int) and offset(int, int).
Suppose a third function: convert(float,int,int) which simply returns
$1*factor($2,$3)+offset($2,$3)
All three
Ref these two queries against a view:
-- QUERY 1, executes 0.5 secs
SELECT *
FROM mdx_core.vw_provider AS p
WHERE provider_id IN (13083101)
-- QUERY 2, executes 13.5 secs
SELECT *
FROM mdx_core.vw_provider AS p
WHERE provider_id IN (SELECT 13083101)
I am using the simple IN (SELECT n) in
On Aug 11, 2010, at 9:30 PM, Greg Smith wrote:
Scott Carey wrote:
What is the likelihood that your RAID card fails, or that the battery that
reported 'good health' only lasts 5 minutes and you lose data before power
is restored? What is the likelihood of human error?
These are all
On 13-8-2010 1:40 Scott Carey wrote:
Agreed. There is a HUGE gap between ooh ssd's are fast, look! and
engineering a solution that uses them properly with all their
strengths and faults. And as 'gnuoytr' points out, there is a big
difference between an Intel SSD and say, this thing: