Re: Query is slower with a large proportion of NULLs in several columns

2021-12-21 Thread David G. Johnston
On Tue, Dec 21, 2021 at 4:07 PM Tom Lane wrote: > Lars Bergeson writes: > > I'm running PostgreSQL under AWS Aurora, and I didn't set it up or > install > > it, so I'm not sure about the OS version. > > Oh! Aurora is not Postgres. My admittedly-not-well-informed > understanding is that they st

Re: Query is slower with a large proportion of NULLs in several columns

2021-12-21 Thread Tom Lane
Lars Bergeson writes: > I'm running PostgreSQL under AWS Aurora, and I didn't set it up or install > it, so I'm not sure about the OS version. Oh! Aurora is not Postgres. My admittedly-not-well-informed understanding is that they stuck a Postgres front end on their existing storage engine, so i

Re: Query is slower with a large proportion of NULLs in several columns

2021-12-21 Thread Lars Bergeson
Justin, Thanks for your continued interest. I'm running PostgreSQL under AWS Aurora, and I didn't set it up or install it, so I'm not sure about the OS version. I can't run the grep command since I don't know how to get down to the command line on the actual box running Aurora. I just connect to

Re: Query is slower with a large proportion of NULLs in several columns

2021-12-21 Thread Justin Pryzby
On Tue, Dec 21, 2021 at 12:33:06AM -0500, Tom Lane wrote: > So now we have a real mystery about what is happening on Lars' > system. Those numbers can't be right. I realized Lars said it was x86_64/Linux, but I'm hoping to hear back with more details: What OS version? Is it a VM of some type ? H