Re: "append" takes a lot of time in a query

Frank Dekervel <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 pu****ng the inheritance feature far
beyond what it's designed to do.

			regards, tom lane

-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance