Re: How to read query plan

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Miroslav Šulc <miroslav(dot)sulc(at)startnet(dot)cz>
Cc: John Arbash Meinel <john(at)arbash-meinel(dot)com>, PGSQL mailing list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How to read query plan
Date: 2005-03-14 09:02:54
Message-ID: 4235533E.8040100@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message PFC 2005-03-14 09:08:48 Re: How to read query plan
Previous Message Miroslav Šulc 2005-03-14 08:58:49 Re: How to read query plan

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2005-03-14 09:08:48 Re: How to read query plan
Previous Message Miroslav Šulc 2005-03-14 08:58:49 Re: How to read query plan