On Wed, Apr 26, 2006 at 04:33:04PM -0400, Chris Hoover wrote: > Each of the partition tables needs it's own set of indexes. Build them, and > see if the does not fix your performance issues. Also, be sure you turned > on the constraint_exclusion parameter, and each table (other than the > "master") has an constraint on it that is unique.
I don't believe constraint_exclusion is smart enough to deal with ORDER BY / LIMIT yet... :/ -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
