Re: Partitioning attempts

On Mon, 2005-10-31 at 21:02 +0100, Mikael Carneholm wrote:
> So far so good. Now, the part where it fails to be useful (performance wise) is when you want to make sure a select
queryonly scans the relevant partition(s), as it's not possible to create a conditional SELECT rule using an INSTEAD
select... from ONLY ..., i.e: 

There is no need to do this.

Try doing a select against mastertab and you will see that it only
selects from the correct partitions. Look at constraint_exclusion
parameter, which needs to be set on for this to work.

> Also, we would need UPDATE and DELETE rules, but these are tricky as an update may involve both inserting and
deletingrows (if the row belongs to another child table after the update). 

Not implemented in 8.1

Best Regards, Simon Riggs