Re: Inefficient query plan

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Jann Röder <roederja(at)ethz(dot)ch>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Inefficient query plan
Date: 2010-08-23 13:28:51
Message-ID: AANLkTimwRj9CWa594f1wd+RKuarcNe6ui=wJ4vCD1Nkz@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

joining on varchars is always going to be very expensive. Longer the
value is, more expensive it will be. Consider going for surrogate
keys.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2010-08-23 13:33:22 Re: Inefficient query plan
Previous Message Jann Röder 2010-08-23 13:19:20 Re: Inefficient query plan