Thread: Performance issue questions

Performance issue questions

From
Rama Krishnan
Date:
Hi all, 

It was a famous interview question

If the table contains multiple indexes what kind of performance issue or impact will be there.

Re: Performance issue questions

From
Bruce Momjian
Date:
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.