> We thought to implement one partition for day.
That would be 365 partitions in a year.
In our experience INSERTS suffers the most in a partitioned table because triggers are the only way to route the row to
theproper child (inherited) table.
Question: How is your insert pattern? Do you insert always current date. In that case you can write the trigger code to
havecurrent date at the top so that the insert trigger finds the matching date as early as possible.
Selects, updates and deletes are reasonably better.