On Wed, Sep 9, 2015 at 2:31 PM, Fabien COELHO <coe...@cri.ensmp.fr> wrote: > > > Hello Amit, > >>> I think that we may conclude, on these run: >>> >>> (1) sorting seems not to harm performance, and may help a lot. >> >> >> I agree with first part, but about helping a lot, I am not sure > > > I'm focussing on the "sort" dimension alone, that is I'm comparing the average tps performance with sorting with the same test without sorting, : There are 4 cases from your tests, if I'm not mistaken: > > - T1 flush=off 27480 -> 27482 : +0.0% > - T1 flush=on 25214 -> 26819 : +6.3% > - T2 flush=off 5050 -> 6194 : +22.6% > - T2 flush=on 2771 -> 6110 : +120.4% >
There is a clear win only in cases when sort is used with flush, apart from that using sort alone doesn't have any clear advantage. With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
