On Fri, Oct 8, 2010 at 5:30 PM, Carlos Mennens <carlos.mennens@xxxxxxxxx> wrote: > I know that MySQL uses MyISAM storage engine by default and was just > trying to look on Google to try and see if I could understand what > storage engine does PostgreSQL use by default when I generate a > database / table. Is there some way someone (me) who knows nothing > about how a ORDBMS works understand the difference between all storage > engine options and which does PostgreSQL use by default. You could make a pretty strong case that temp tables are a different 'storage engine', since they interact differently with the storage system. for example, they are not wal logged and this is one of the things that makes them faster than regular tables. This illustrates a wider philosophy of the databases in terms of features. Postgresql went a different route than mysql. We do expose various knobs that allow you to control specific mechanics of how data is store in a table. For example, using table storage parameters, you can enable/disable compression for large datums. Many of the other things you would like do do with storage engines, like not sync, or custom data organization, are correspondingly exposed via the mvcc engine or the type system. It's much cleaner conceptually (IMNSHO) to deal with these things on the SQL level vs storage engines with their arcane tradeoffs. There are of course some cool things we can't do that mysql can, but the postgresql database behaves in much more regular fashion. Imagine debugging data corruption on a third party engine -- this is a problem we don't want. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
