View Single Post

   
  #3 (permalink)  
Old 04-11-2008, 03:07 AM
Tom Lane
 
Posts: n/a
Default Re: Query crashes/hangs server

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I recieved this report of a failing set of queries:


Fixed. ShutdownPostgres needs to be sure we've released buffer pins
before it tries to drop newly-created files. This has actually been
wrong all along, but it is masked pre-8.0 because DropRelFileNodeBuffers
was willing to arbitrarily throw away a pin on a victim buffer.
I thought that was a bad idea and took it out, expecting that we'd find
any bad consequences a bit quicker than this ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply With Quote