Re: How to read query plan - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: How to read query plan
Date
Msg-id 4235533E.8040100@familyhealth.com.au
Whole thread Raw
In response to Re: How to read query plan  (Miroslav Šulc <miroslav.sulc@startnet.cz>)
Responses Re: How to read query plan  (Miroslav Šulc <miroslav.sulc@startnet.cz>)
List pgsql-performance
> 1) in PostgreSQL I use 'varchar(1)' for a lot of fields and in MySQL I
> use 'enum'
> 2) in PostgreSQL in some cases I use connection fields that are not of
> the same type (smallint <-> integer (SERIAL)), in MySQL I use the same
> types

Well both those things will make PostgreSQL slower...

Chris

pgsql-performance by date:

Previous
From: Miroslav Šulc
Date:
Subject: Re: How to read query plan
Next
From: PFC
Date:
Subject: Re: How to read query plan