Home > mailing lists

Re: Improving performance of select query - Mailing list pgsql-general

From	Rob Sargent
Subject	Re: Improving performance of select query
Date	December 14, 2020 20:50:39
Msg-id	4C1E13A7-63F6-473F-B249-E79F45E9D024@gmail.com Whole thread Raw
In response to	Re: Improving performance of select query (Muhammad Bilal Jamil <mbjamil92@gmail.com>)
List	pgsql-general

Tree view

On Dec 14, 2020, at 10:37 AM, Muhammad Bilal Jamil <mbjamil92@gmail.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.

pgsql-general by date:

From: Muhammad Bilal Jamil
Date: 14 December 2020, 20:37:01
Subject: Re: Improving performance of select query

From: Andreas 'ads' Scherbaum
Date: 14 December 2020, 21:15:42
Subject: PostgreSQL @ FOSDEM 2021 - Call for Papers

Re: Improving performance of select query - Mailing list pgsql-general

Previous

Next