Re: Re: Hot Standby query cancellation and Streaming Replication integration
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Stark <stark@mit.edu>
Cc: Josh Berkus <josh@agliodbs.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Greg Smith <greg@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>
Date: 2010-03-02T01:04:11Z
Lists: pgsql-hackers
Greg Stark <stark@mit.edu> writes: > josh, nobody is talking about it because it doesn't make sense. you could > only retry if it was the first query in the transaction and only if you > could prove there were no side-effects outside the database and then you > would have no reason to think the retry would be any more likely to work. But it's hot standby, so there are no data-modifying transactions. Volatile functions could be a problem, though. A bigger problem is we might have already shipped partial query results to the client. I agree it ain't easy, but it might not be completely out of the question. Definitely won't be happening for 9.0 though. regards, tom lane