Postgres Pro
Downloads
Home   >   mailing lists

Re: Inefficient query plan - Mailing list pgsql-performance

From Grzegorz Jaśkiewicz
Subject Re: Inefficient query plan
Date
Msg-id AANLkTimwRj9CWa594f1wd+RKuarcNe6ui=wJ4vCD1Nkz@mail.gmail.com
Whole thread Raw
In response to Re: Inefficient query plan  (Jann Röder <roederja@ethz.ch>)
Responses Re: Inefficient query plan  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
Tree view 
joining on varchars is always going to be very expensive. Longer the
value is, more expensive it will be. Consider going for surrogate
keys.

pgsql-performance by date:

Previous
From: Jann Röder
Date:
Subject: Re: Inefficient query plan
Next
From: "Kevin Grittner"
Date:
Subject: Re: Inefficient query plan