From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, pgsql-advocacy(at)postgresql(dot)org |
Subject: | Re: Devx Database Comparison [Updated] |
Date: | 2005-11-29 20:37:43 |
Message-ID: | 438CBC17.2020108@Yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
On 11/15/2005 5:13 PM, Joshua D. Drake wrote:
> Jim C. Nasby wrote:
>> Well, I guess the question is: is InnoDB considered external? I would
>> argue it is, since afaik you have to get it yourself unless you buy the
>> pro version.
>>
> As far as I know, Innodb ships with MySQL. Recall that Innodb is GPL.
It ships with it, but it is still an add-on, implementation wise. And
AFAIK this is the reason why they don't have deferrable foreign keys.
Jan
>
>
>> BTW, this also applies to MVCC too. Probably some other stuff.
>>
>> On Tue, Nov 15, 2005 at 01:11:57PM -0800, Joshua D. Drake wrote:
>>
>>> Jim C. Nasby wrote:
>>>
>>>> Shouldn't RI be listed as external for MySQL?
>>>>
>>>>
>>> If you mean Referential Integrity, Innodb supports Foreign Keys as far
>>> as I know.
>>>
>>> Sincerely,
>>>
>>> Joshua D. Drake
>>>
>>>
>>>> On Tue, Nov 15, 2005 at 12:03:15PM -0800, Joshua D. Drake wrote:
>>>>
>>>>
>>>>> Hello,
>>>>>
>>>>> This matrix should be more accurate. Let me know if there are any
>>>>> problems you see.
>>>>>
>>>>> http://www.devx.com/dbzone/Article/29480
>>>>>
>>>>> Sincerely,
>>>>>
>>>>> Joshua D. Drake
>>>>>
>>>>>
>>>>> ---------------------------(end of broadcast)---------------------------
>>>>> TIP 5: don't forget to increase your free space map settings
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>>> choose an index scan if your joining column's datatypes do not
>>> match
>>>
>>>
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2005-11-29 21:07:50 | Re: Devx Database Comparison [Updated] |
Previous Message | Josh Berkus | 2005-11-29 19:31:57 | Re: Thoughts on MySQL and InnoDB |