Re: SELECT DISTINCT Performance Issue - Mailing list pgsql-performance

From George Essig
Subject Re: SELECT DISTINCT Performance Issue
Date
Msg-id 6744b385050608075132eeb8a6@mail.gmail.com
Whole thread Raw
In response to Re: SELECT DISTINCT Performance Issue  (K C Lau <kclau60@netvigator.com>)
List pgsql-performance
On 6/8/05, K C Lau <kclau60@netvigator.com> wrote:
> Both keys are text fields. Does it make any difference if PlayerID were
> integer?
>

It can make a difference in speed and integrity.  If the column is an
integer, the storage on disk could be smaller for the column and the
related indexes.  If the the column is an integer, it would not be
possible to have a value like 'arbitrary value that looks nothing like
an integer'.

George Essig

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: full outer performance problem
Next
From: Allan Wang
Date:
Subject: Performance problems, bad estimates and plan