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:deep...@yahoo.com] Sent: Thursday, May 9, 2019 9:44 AM To: Tom Lane ; Bruce Momjian ; Naik, Sameer Cc: pgsql-performance@lists.postgresql.org 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:t...@sss.pgh.pa.us] Sent: Monday, April 29, 2019 8:06 PM To: Bruce Momjian Cc: Naik, Sameer ; pgsql-performance@lists.postgr