Re: Inefficient query plan - Mailing list pgsql-performance

From Grzegorz Jaśkiewicz
Subject Re: Inefficient query plan
Date
Msg-id AANLkTim1GOMuN+EzEj9CcePUHQ=71uLhF=Dn3p1n3tpE@mail.gmail.com
Whole thread Raw
In response to Re: Inefficient query plan  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Inefficient query plan  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
I am not a fan of 'do this - this is best' response to queries like that.
Rather: this is what you should try, and choose whichever one suits you better.
So, rather than 'natural keys ftw', I am giving him another option to
choose from.

You see, in my world, I was able to improve some large dbs performance
10+ times fold, by going for surrogate keys. But in them cases, joins
were performed on 2+ varchar PK fields, and the whole thing was
crawwwling.

So, don't narrow down to one solution because it worked for you. Keep
an open book.

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Inefficient query plan
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Inefficient query plan