RE: Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans

2019-05-23 Thread Naik, Sameer
'OI-289fbe99682948ae86eb8e1fbf7e2350'::text)' '-> Bitmap Index Scan on i776_0_179_t776 (cost=0.00..4.43 rows=1 width=0) (actual time=0.009..0.009 rows=1 loops=1)' ' Index Cond: ((c179)::text = 'OI-1e8ac9e7b19245059

RE: Re: Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans

2019-05-17 Thread Naik, Sameer
to some expert advice here when dealing with citext data type. -Thanks and Regards, Sameer Naik From: Deepak Somaiya [mailto:[email protected]] Sent: Thursday, May 9, 2019 9:44 AM To: Tom Lane ; Bruce Momjian ; Naik, Sameer Cc: [email protected] Subject: [EXTERNAL] Re: Re

RE: Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans

2019-04-30 Thread Naik, Sameer
ords the value of c400127400 the value is same and is ' 'DATASET2M' . -Thanks and Regards, Sameer Naik -Original Message- From: Tom Lane [mailto:[email protected]] Sent: Monday, April 29, 2019 8:06 PM To: Bruce Momjian Cc: Naik, Sameer ; [email protected]