Re: Improving the Performance of Full Table Updates

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Improving the Performance of Full Table Updates
Date: 2007-10-08 14:33:31
Message-ID: 18887.1191854011@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> writes:
> We mustn't write data pages before the WAL hits the disk, but we don't
> have any such limitation for WAL.

Um, you're right, I was remembering discussions about trying to mmap
data files. Still, googling "msync performance" leaves me full of
concern about whether this would be a portable improvement.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-10-08 15:19:11 Re: Improving the Performance of Full Table Updates
Previous Message Magnus Hagander 2007-10-08 14:25:53 Re: [COMMITTERS] pgsql: Added the Skytools extended transaction ID module to contrib as