Re: 8.4 open item: copy performance regression? - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: 8.4 open item: copy performance regression?
Date
Msg-id 4A3FB487.30409@dunslane.net
Whole thread Raw
In response to Re: 8.4 open item: copy performance regression?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>   
>> Tom Lane wrote:
>>     
>>> I thought he was asking for a solution to the problem of WALInsertLock
>>> contention.  In any case, we have "WAL bypass on a table by table basis"
>>> now, don't we?
>>>       
>
>   
>> If we do I'm ignorant of it ;-) How do we say "Never WAL this table"?
>>     
>
> Make it a temporary table.
>
>
>   

That doesn't help if you need the data visible in multiple sessions. But 
we're digressing from the original topic. Sorry.

cheers

andrew


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: security checks for largeobjects?
Next
From: Markus Wanner
Date:
Subject: Re: Synch Rep: communication between backends and walsender