Re: SELECT DISTINCT Performance Issue

From: George Essig <george(dot)essig(at)gmail(dot)com>
To: K C Lau <kclau60(at)netvigator(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SELECT DISTINCT Performance Issue
Date: 2005-06-08 14:51:11
Message-ID: 6744b385050608075132eeb8a6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 6/8/05, K C Lau <kclau60(at)netvigator(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Allan Wang 2005-06-08 15:04:04 Performance problems, bad estimates and plan
Previous Message K C Lau 2005-06-08 14:25:16 Re: SELECT DISTINCT Performance Issue