Re: Understanding PostgreSQL Storage Engines

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Understanding PostgreSQL Storage Engines
Date: 2010-10-08 23:54:29
Message-ID: 4CAFAF35.9090405@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/08/2010 03:39 PM, Adrian Klaver wrote:
> On Friday 08 October 2010 2:30:40 pm Carlos Mennens 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.
>>
>> Thanks for any help...
>>
>> -Carlos
>
> Postgres only has one storage engine. Sort of simplifies things.
>
My guess is the OP wants to know that Postgres uses tactically in its
engine: B(+)trees (or whatever it does actually use) versus Indexed
Sequential Access Method (judging by the name). No?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-10-09 03:32:55 Re: Understanding PostgreSQL Storage Engines
Previous Message Miroslav Šulc 2010-10-08 23:41:04 Another PostgreSQL Diff Tool 2.2.2 released