Re: Improving performance of select query

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Muhammad Bilal Jamil <mbjamil92(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Improving performance of select query
Date: 2020-12-14 17:50:39
Message-ID: 4C1E13A7-63F6-473F-B249-E79F45E9D024@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Dec 14, 2020, at 10:37 AM, Muhammad Bilal Jamil <mbjamil92(at)gmail(dot)com> wrote:
>
> I think you can also increase the query performance by creating indexes?
>
>
>

OP said there was a key on the target (large) table. I’m not sure there’s much of a win in indexing 10K ids.
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andreas 'ads' Scherbaum 2020-12-14 18:15:42 PostgreSQL @ FOSDEM 2021 - Call for Papers
Previous Message Adam Scott 2020-12-14 17:50:26 Re: Improving performance of select query