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-20 Thread Lars Bergeson
I/O Timings: read=2706123.209 Settings: effective_cache_size = '21553496kB', maintenance_io_concurrency = '1', max_parallel_workers_per_gather = '0', search_path = 'public, public, "$user"' Planning Time: 0.068 ms Execution Time: 26452.691 ms It seems to be the actual pres

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

2021-12-20 Thread Lars Bergeson
First of all, here is the version of PostgreSQL I'm using: PostgreSQL 13.3 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit I'm new to PostgreSQL, and I'm deciding if I should make columns in my database nullable or not. I have no need to distinguish between blank/z