Re: [PERFORM] Deleting bytea, autovacuum, and 8.2/8.4 differences

2010-03-13 Thread Dave Crooke
Hi there I'm not an expert on PG's "toast" system, but a couple of thoughts inline below. Cheers Dave On Sat, Mar 13, 2010 at 3:17 PM, fka...@googlemail.com < fka...@googlemail.com> wrote: > Hi all, > > my posting on 2010-01-14 about the performance when writing > bytea to disk caused a longer

[PERFORM] Deleting bytea, autovacuum, and 8.2/8.4 differences

2010-03-13 Thread fka...@googlemail.com
Hi all, my posting on 2010-01-14 about the performance when writing bytea to disk caused a longer discussion. While the fact still holds that the overall postgresql write performance is roughly 25% of the serial I/O disk performance this was compensated for my special use case here by doing some o

Re: [PERFORM] Is DBLINK transactional

2010-03-13 Thread Craig Ringer
On 13/03/2010 5:54 AM, Jeff Davis wrote: On Fri, 2010-03-12 at 12:07 -0500, Merlin Moncure wrote: of course. You can always explicitly open a transaction on the remote side over dblink, do work, and commit it at the last possible moment. Your transactions aren't perfectly synchronized...if you