Re: MERGE: performance advices

Richard Broersma wrote:
> On Tue, Sep 2, 2008 at 9:47 AM, Steve Clark <sclark@netwolves.com> wrote:
>
>>srm2=# explain
>>srm2-# INSERT INTO Myevents
>>srm2-#      SELECT *
>
>
>>ERROR:  INSERT has more expressions than target columns
>
>
>>srm2=# explain
>>srm2-# INSERT INTO Myevents
>>srm2-#      SELECT *
>>ERROR:  INSERT has more expressions than target columns
>
>
> Oops, replace SELECT * with SELECT A.*.
>
Richard,

This is AWESOME! This now only takes seconds where before it was taking longer than
I wanted to wait, I had let it run all night before aborting it.

Thanks so much Richard,

Regards,
Steve