Re: "append" takes a lot of time in a query - Mailing list pgsql-performance

From Tom Lane
Subject Re: "append" takes a lot of time in a query
Date
Msg-id 13354.1210342366@sss.pgh.pa.us
Whole thread Raw
In response to "append" takes a lot of time in a query  (Frank Dekervel <frank.dekervel@smartlounge.be>)
List pgsql-performance
Frank Dekervel <frank.dekervel@smartlounge.be> 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

pgsql-performance by date:

Previous
From: Frank Dekervel
Date:
Subject: "append" takes a lot of time in a query
Next
From: "Merlin Moncure"
Date:
Subject: Re: plan difference between set-returning function with ROWS within IN() and a plain join