Frank Dekervel <[EMAIL PROTECTED]> 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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
