|From:||Peter Eisentraut <peter_e(at)gmx(dot)net>|
|Subject:||Progress indication prototype|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
Here is a small prototype for a query progress indicator.
Past discussions seemed to indicate that the best place to report this
would be in pg_stat_activity. So that's what this does. You can try it
out with any of the following (on a sufficiently large table): VACUUM
(lazy) (also autovacuum), COPY out from table, COPY in from file,
table-rewriting ALTER TABLE (e.g., add column with default), or a very
simple query. Run the command, and stare at pg_stat_activity (perhaps
via "watch") in a separate session.
More can be added, and the exact placement of the counters is debatable,
but those might be details to be worked out later. Note, my emphasis
here is on maintenance commands; I don't plan to do a progress
estimation of complex queries at this time.
- Are the interfaces OK?
- Is this going to be too slow to be useful?
- Should there be a separate switch to turn it on (currently
- How to handle commands that process multiple tables? For example,
lazy VACUUM on a single table is pretty easy to track (count the block
numbers), but what about a database-wide lazy VACUUM?
|Next Message||Jaime Casanova||2010-08-17 06:16:14||Re: Per-column collation, proof of concept|
|Previous Message||KaiGai Kohei||2010-08-17 05:14:25||Re: security label support, part.2|