On Thu, Jan 17, 2008 at 11:14:22AM -0800, Glyn Astill wrote: > > begin; > > set transaction isolation level serializable; > > > > --- begin dumping stuff; > > > > Wouldn't that just lock everything so nothing could be updated? Or > just the table it is outputting?
PostgreSQL uses MVCC, which means the whole thing is lock free. It just requires more diskspace. To keep the older versions around. Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Those who make peaceful revolution impossible will make violent revolution > inevitable. > -- John F Kennedy
signature.asc
Description: Digital signature
