Not to be opened before May 1st! I know I should still be looking at code from the March Commitfest but I was annoyed by this *very* FAQ:
http://archives.postgresql.org/pgsql-general/2008-04/msg00402.php This also came up at the UKUUG-Pg conference so it was already on my mind. I couldn't resist playing with it and trying to solve this problem.
explain-progress.diff.gz
Description: Binary data
I'm not sure what the right way to get the data back to psql would be. Probably it should be something other than what it's doing now, an INFO message. It might even be a special message type? Also need some thought about what progress info could be reported in other situations aside from the executor. VACUUM, for example, could report its progress pretty easily. To use it run a long query in psql and hit C-\ in (unless you're on a system with SIGINFO support such as BSD where the default will probably be C-t). But no reviewing it until we finish with the March patches! Do as I say, not as I do :(
explain-progress.diff.gz
Description: Binary data
-- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support!
-- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches