Re: Devx Database Comparison [Updated] - Mailing list pgsql-advocacy

From Jim C. Nasby
Subject Re: Devx Database Comparison [Updated]
Date
Msg-id 20051115214446.GV44860@pervasive.com
Whole thread Raw
In response to Re: Devx Database Comparison [Updated]  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Devx Database Comparison [Updated]  (Michael Paesold <mpaesold@gmx.at>)
Re: Devx Database Comparison [Updated]  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-advocacy
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.

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
>

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-advocacy by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Devx Database Comparison [Updated]
Next
From: Robert Treat
Date:
Subject: Re: Devx Database Comparison [Updated]