Re: storage engine , mysql syntax CREATE TABLE t (i INT)

Gaetano Mendola wrote:
> We have only one engine: the full transactional one. If the OP need
> to have for example the MEMORY one the he can easily create a RAM
> disk and with the tablespaces support he can create tables or index
> or whatever objects in memory.

Well, it certainly could make sense to have different storage engines
for different access patterns. (Not for different degrees of
implementation correctness, mind you.) So let's just say we don't have
them.

Postgres was, however, one of the systems that in fact pioneered
pluggable storage managers. So we could say we're already one
generation ahead of everyone else: we had switchable storage managers,
realized we didn't need them, and got rid of them.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/