Tom, Do you mean it would be impossible to change the code so that existing selects continue to use the pre-truncated table until they commit? Or just require a more extensive change?
The update/insert rule change appears to be more more doable? No? > -----Original Message----- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 01, 2006 12:50 AM > To: Marc Morin > Cc: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] partitioning and locking problems > > "Marc Morin" <[EMAIL PROTECTED]> writes: > > Would like to understand the implications of changing postgres' > > code/locking for rule changes and truncate to not require > locking out > > select statements? > > It won't work... > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
