Re: [PERFORM] Partition table query performance

2008-11-27 Thread Greg Jaman
Thanks Gregory, I was on IRC yesterday and a few people indicated the same thing... Searching for the last reading is a very important function for our database. I wrote the below function searches all child tables for the max. It is not optimization because it doesn't omit tables by look at t

Re: [PERFORM] Partition table query performance

2008-11-26 Thread Gregory Stark
"Greg Jaman" <[EMAIL PROTECTED]> writes: > I have a problem with partitioning and I'm wondering if anyone can provide > some insight. I'm trying to find the max value of a column across multiple > partitions. The query against the partition set is quite slow while queries > against child partit

[PERFORM] Partition table query performance

2008-11-25 Thread Greg Jaman
I have a problem with partitioning and I'm wondering if anyone can provide some insight. I'm trying to find the max value of a column across multiple partitions. The query against the partition set is quite slow while queries against child partitions is very fast! I setup a basic Range Partiti