From: | Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
---|---|
To: | Petr Jelinek <petr(at)2ndquadrant(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Relation extension scalability |
Date: | 2016-03-10 08:57:43 |
Message-ID: | CAFiTN-vd-Yr-1TJei24qG2pa61TuRQj5MGaBUOjTnU=jMzKW_g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Mar 10, 2016 at 7:55 AM, Petr Jelinek <petr(at)2ndquadrant(dot)com> wrote:
Thanks for the comments..
> Hmm, why did you remove the comment above the call to
> UnlockRelationForExtension?
While re factoring I lose this comment.. Fixed it
> It still seems relevant, maybe with some minor modification?
>
> Also there is a bit of whitespace mess inside the conditional lock block.
Fixed
I got the result of 10 mins run so posting it..
Note: Base code results are copied from up thread...
Results For 10 Mins run of COPY 10000 records of size 4 bytes script and
configuration are same as used in up thread
--------------------------------------------------------------------------------------------
Client Base Patch
1 105 111
2 217 246
4 210 428
8 166 653
16 145 808
32 124 988
64 --- 974
Results For 10 Mins run of INSERT 1000 records of size 1024 bytes(data
don't fits in shared buffer)
--------------------------------------------------------------------------------------------------
Client Base Patch
1 117 120
2 111 126
4 51 130
8 43 147
16 40 209
32 --- 254
64 --- 205
--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com
Attachment | Content-Type | Size |
---|---|---|
multi_extend_v7.patch | text/x-patch | 9.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Vladimir Borodin | 2016-03-10 09:00:29 | Re: Improving replay of XLOG_BTREE_VACUUM records |
Previous Message | Simon Riggs | 2016-03-10 08:50:42 | Re: Improving replay of XLOG_BTREE_VACUUM records |