Re: Performance on Bulk Insert to Partitioned Table

It's a pity. Why does not it listed in "Compatibility" section of create
trigger documentation? I think, this makes "for each statement" triggers
not compatible with SQL99.

2012/12/28 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>

> Hello
>
> >
> > Also, for bulk insert, have you tried "for each statement" triggers
> instead
> > of "for each row"?
> > This would look like a lot of inserts and would not be fast in
> > single-row-insert case, but can give you benefit for huge inserts.
> > It should look like
> > insert into quotes_2012_09_10 select * from new where
> cast(new.received_time
> > as date) = '2012-09-10' ;
> > insert into quotes_2012_09_11 select * from new where
> cast(new.received_time
> > as date) = '2012-09-11' ;
> > ...
>
> It has only one problem - PostgreSQL has not relations NEW and OLD for
> statements triggers.
>
> Regards
>
> Pavel
>

--
Best regards,
Vitalii Tymchyshyn