Re: Performance issue questions - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Performance issue questions
Date
Msg-id YgRWjERTtTNAFarL@momjian.us
Whole thread Raw
In response to Performance issue questions  (Rama Krishnan <raghuldrag@gmail.com>)
List pgsql-general
On Thu, Feb 10, 2022 at 05:11:07AM +0530, Rama Krishnan wrote:
> Hi all, 
> 
> It was a famous interview question
> 
> If the table contains multiple indexes what kind of performance issue or impact
> will be there.

Sure:

    https://momjian.us/main/blogs/pgblog/2012.html#July_9_2012
    https://momjian.us/main/presentations/performance.html#optimizer

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Undetected Deadlock
Next
From: Thomas Munro
Date:
Subject: Re: Compile 14.1 in EL5.8