> I have no idea how good pg is with select queries over 365 partitions (1
> year).
no need to use a partition per day, I'm pretty sure he won't mind having
a few extra days or weeks. I'd go by month, and drop a whole month at
a time, that way there's only 12-13 partitions.
and doing this, there's no need for a date index if he's never searching
by date, just an index on the primary key. yes, the selects will have
to search all 12-13 tables, but SELECT ... WHERE pk=?; are very fast
searches, so doing this on 12 tables is pretty painless.