Hi, Marc,
Marc Morin wrote:
>> I wonder whether there is a way to use table partitioning to
>> make the insert pattern more localized? We'd need to know a
>> lot more about your insertion patterns to guess how, though.
>
> We're doing partitioning as well.....
And is constraint exclusion set up properly, and have you verified that
it works?
HTH,
Markus
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
