Re: Performance degrade in Planning Time to find appropriate Partial Index

Il 01/03/2018 15:16, Michael Loftis ha scritto: On Thu, Mar 1, 2018 at 03:10 Meenatchi Sandanam wrote: I have created a table with 301 columns(ID, 150 BIGINT,

Re: Performance degrade in Planning Time to find appropriate Partial Index

On Thu, Mar 1, 2018 at 03:10 Meenatchi Sandanam wrote: > I have created a table with 301 columns(ID, 150 BIGINT, 150 TEXT). The > table contains multiple form data differentiated by ID range. Hence a > column contains more than one form data. To achieve Unique Constraint and > Indexing per form,

Re: Performance degrade in Planning Time to find appropriate Partial Index

Meenatchi Sandanam wrote: > I have created a table with 301 columns(ID, 150 BIGINT, 150 TEXT). The table > contains > multiple form data differentiated by ID range. Hence a column contains more > than one form data. > To achieve Unique Constraint and Indexing per form, I chose PostgreSQL > Parti

Performance degrade in Planning Time to find appropriate Partial Index

I have created a table with 301 columns(ID, 150 BIGINT, 150 TEXT). The table contains multiple form data differentiated by ID range. Hence a column contains more than one form data. To achieve Unique Constraint and Indexing per form, I chose PostgreSQL Partial Indexes which suits my requirement. I