Re: Creating Index - Mailing list pgsql-sql

From Tom Lane
Subject Re: Creating Index
Date
Msg-id 19818.1065194783@sss.pgh.pa.us
Whole thread Raw
In response to Re: Creating Index  ("CN" <cnliou9@fastmail.fm>)
List pgsql-sql
"CN" <cnliou9@fastmail.fm> writes:
> I thought I have got no more question in this thread, and I was wrong :-(
> Is the extra 300ms in UNION essential?

Dividing, it looks like the Append node is taking about 3 microseconds
per tuple, which seems kind of a lot considering it isn't really doing
anything.  I suspect though that most of this overhead is due to the
EXPLAIN ANALYZE instrumentation, and would in fact go away when you
are just running the query.
        regards, tom lane


pgsql-sql by date:

Previous
From: achill@matrix.gatewaynet.com
Date:
Subject: Re: HeapTuple->t_tableOid==0 after SPI_exec
Next
From: Jeff Boes
Date:
Subject: Re: Data type conversion