From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
---|---|
To: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> |
Cc: | "Patches" <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: A little COPY speedup |
Date: | 2007-03-02 10:25:18 |
Message-ID: | 1172831119.3760.1367.camel@silverbirch.site |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
On Fri, 2007-03-02 at 10:09 +0000, Heikki Linnakangas wrote:
> Well, there's one big change: your patch to suppress WAL logging on
> tables created in the same transaction.
OK, just checking thats what you meant.
> All the page locking related functions account for ~10% in total,
> including the LWLockAcquire/Release, Pin/UnBuffer, hash_any and so on.
> And then there's all the memcpying...
I think its a great spot that PageAddItem() was so bad. I realise I
didn't actually look at what it was doing, just looked at ways to avoid
doing it on each individual call to the block for each row.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2007-03-02 12:02:16 | Re: Numeric patch to add special-case representations for < 8 bytes |
Previous Message | Heikki Linnakangas | 2007-03-02 10:09:21 | Re: A little COPY speedup |