Eric Cholet <cholet@logilune.com> writes:
> Consequently would I gain performance if I changed the
> schema so that 'date' is an integer
No, you wouldn't, at least not enough to notice. (But if you only need
a date and not a time of day, consider changing the column type to
"date".)
I suspect the issue is selectivity of the queries, but with no actual
query examples or EXPLAIN ANALYZE results to look at, that's just idle
speculation.
regards, tom lane