RE: Postgres not using index on views

2020-04-17 Thread Rick Vincent
Hi David, Oh, okay…I missed that implied part. Will try it and post back. Thanks, Rick From: David G. Johnston Sent: Friday, April 17, 2020 4:55 PM To: Rick Vincent Cc: Tom Lane ; Justin Pryzby ; pgsql-performa...@postgresql.org; Manoj Kumar ; Herve Aubert Subject: Postgres not using index

Postgres not using index on views

2020-04-17 Thread David G. Johnston
On Friday, April 17, 2020, Rick Vincent wrote: > Hi, > > I was wondering if anyone can explain the below problem. Should a bug be > logged for this? > > Kind regards, > Rick > > _ > *From:* Rick Vincent > *Sent:* Tuesday, April 7, 2020 11:08 AM > *To:*

RE: Postgres not using index on views

2020-04-17 Thread Rick Vincent
Hi, I was wondering if anyone can explain the below problem. Should a bug be logged for this? Kind regards, Rick _ From: Rick Vincent Sent: Tuesday, April 7, 2020 11:08 AM To: 'Tom Lane' ; Justin Pryzby Cc: pgsql-performa...@postgresql.org; Manoj Ku