Re: select query does not pick up the right index

2019-01-04 Thread Justin Pryzby
On Fri, Jan 04, 2019 at 08:58:57AM +, Abadie Lana wrote: > SELECT (SELECT sum(x) FROM unnest(most_common_freqs) x) frac_MCV, tablename, > attname, null_frac, n_distinct, array_length(most_common_vals,1) n_mcv, > array_length(histogram_bounds,1) n_hist FROM pg_stats WHERE attname='...' AND >

RE: select query does not pick up the right index

2019-01-04 Thread Abadie Lana
-Original Message- From: [email protected] On Behalf Of Abadie Lana Sent: 04 January 2019 09:18 To: Justin Pryzby Cc: David Rowley ; [email protected] Subject: [Possible Spoof] RE: select query does not pick up the right ind

RE: select query does not pick up the right index

2019-01-04 Thread Abadie Lana
-Original Message- From: Justin Pryzby Sent: 04 January 2019 00:48 To: Abadie Lana Cc: David Rowley ; [email protected] Subject: Re: select query does not pick up the right index On Thu, Jan 03, 2019 at 12:57:27PM +, Abadie Lana wrote: > Main parameters : eff

RE: select query does not pick up the right index

2019-01-04 Thread Abadie Lana
-Original Message- From: David Rowley Sent: 03 January 2019 22:42 To: Abadie Lana Cc: [email protected] Subject: Re: select query does not pick up the right index On Fri, 4 Jan 2019 at 02:20, Abadie Lana wrote: > > From: David Rowley > > Sent: 03 January 2019 14: