On Thu, Dec 6, 2018 at 10:03 AM Pavel Stehule <pavel.steh...@gmail.com> wrote: > > čt 6. 12. 2018 v 5:02 odesílatel Mithun Cy <mithun...@enterprisedb.com> > napsal: >> >> COPY command seems to have improved very slightly with zheap in both with >> size of wal and execution time. I also did some tests with insert statement >> where I could see some regression in zheap when compared to heap with >> respect to execution time. With further more investigation I will reply here. >> > > 20% of size reduction looks like effect of fill factor. >
I think it is because of smaller zheap tuple sizes. Mithun can tell more about setup whether he has used different fillfactor or anything else which could lead to such a big difference. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
