Re: Querying a time range across multiple partitions

Number of child tables: 1581

that's an insane number of children.    We try and limit it to 50 or so child tables, for instance, 6 months retention by week, of data will millions of rows/day.

-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast