Performance issue questions

Started by Rama Krishnanabout 4 years ago2 messagesgeneral
Jump to latest
#1Rama Krishnan
raghuldrag@gmail.com

Hi all,

It was a famous interview question

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Rama Krishnan (#1)
Re: Performance issue questions

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.