EXPLAIN progress info - Mailing list pgsql-patches

From Gregory Stark
Subject EXPLAIN progress info
Date
Msg-id 87wsn82lda.fsf@oxford.xeocode.com
Whole thread Raw
Responses Re: EXPLAIN progress info
List pgsql-patches
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.


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 :(



--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's PostGIS support!

Attachment

pgsql-patches by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Partial match in GIN
Next
From: Alvaro Herrera
Date:
Subject: Re: Partial match in GIN