> Excellent, it sounds like you should be fine then.  One thing to
> note:  if you want to get an "idea" of how many rows you have in your
> partitions, you can run a SUM aggregate on reltuples in pg_class for
> all of your partitions.  The more recent the last ANALYZE for each
> table, the more accurate those values will be.

cool, thanks.

regards

thomas


---------------------------(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

Reply via email to