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

From Greg Stark
Subject Re: How to read query plan
Date
Msg-id 877jkauslc.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: How to read query plan  (Miroslav Šulc <miroslav.sulc@startnet.cz>)
List pgsql-performance
Miroslav ©ulc <miroslav.sulc@startnet.cz> writes:

> I think so. I'll change the varchar(1) fields to char(1) where possible

char isn't faster than varchar on postgres. If anything it may be slightly
slower because every comparison first needs to pad both sides with spaces.

--
greg

pgsql-performance by date:

Previous
From: John Arbash Meinel
Date:
Subject: Re: How to read query plan
Next
From: Tom Lane
Date:
Subject: Re: How to read query plan