Frank Dekervel <frank.dekervel@xxxxxxxxxxxxxx> writes: > this turns this query in an append of a whole lot of seq scan/ index scan's. > These scans are predictably quick, but the "append" takes 5 seconds (and the > numbers of the scans do not add up to the append actual time) It says 5 milliseconds, not 5 seconds. > Does someone have an explanation / possible solution for this performance ? Rethink your schema --- this is pushing the inheritance feature far beyond what it's designed to do. regards, tom lane
