Re: [HACKERS] [Proposal] Progress bar for pg_dump/pg_restore

2015-06-24 Thread Taiki Kondo
in Moncure [mailto:mmonc...@gmail.com] Sent: Friday, June 12, 2015 10:42 PM To: Taiki Kondo Cc: pgsql-hackers@postgresql.org; Akio Iwaasa Subject: Re: [HACKERS] [Proposal] Progress bar for pg_dump/pg_restore On Fri, Jun 12, 2015 at 7:45 AM, Taiki Kondo wrote: > Hi, all. > > I am n

Re: [HACKERS] [Proposal] Progress bar for pg_dump/pg_restore

2015-06-22 Thread Jim Nasby
On 6/21/15 9:45 PM, Craig Ringer wrote: And, I also understood your concern about "CREATE INDEX", but we have no way to get progress information of "CREATE INDEX". >At present, I think it may be good to refer to the same time as estimated time to execute "COPY TO". You could probably get a han

Re: [HACKERS] [Proposal] Progress bar for pg_dump/pg_restore

2015-06-21 Thread Craig Ringer
On 19 June 2015 at 16:45, Taiki Kondo wrote: > Hi, andres > > Thank you for your comment, and sorry for late response. > >> The question is how to actually get useful estimates. As there's no >> progress report for indvidiual COPY and CREATE INDEX commands you'll, in >> many cases, have very irreg

Re: [HACKERS] [Proposal] Progress bar for pg_dump/pg_restore

2015-06-19 Thread Taiki Kondo
10:48 PM To: Taiki Kondo Cc: pgsql-hackers@postgresql.org; Akio Iwaasa Subject: Re: [HACKERS] [Proposal] Progress bar for pg_dump/pg_restore Hi, On 2015-06-12 12:45:50 +, Taiki Kondo wrote: > Design & API > > When pg_dump / pg_restore is running, progress bar and estimat

Re: [HACKERS] [Proposal] Progress bar for pg_dump/pg_restore

2015-06-12 Thread Andres Freund
Hi, On 2015-06-12 12:45:50 +, Taiki Kondo wrote: > Design & API > > When pg_dump / pg_restore is running, progress bar and estimated time to > finish is shown on screen like following. > > > => (50%) 15:50 > > The bar ("=>" in above) and percentage value ("

Re: [HACKERS] [Proposal] Progress bar for pg_dump/pg_restore

2015-06-12 Thread Merlin Moncure
On Fri, Jun 12, 2015 at 7:45 AM, Taiki Kondo wrote: > Hi, all. > > I am newbie in hackers. > I have an idea from my point of view as one user, I would like to propose the > following. > > > Progress bar for pg_dump / pg_restore > = > > Motivation > -- >

[HACKERS] [Proposal] Progress bar for pg_dump/pg_restore

2015-06-12 Thread Taiki Kondo
Hi, all. I am newbie in hackers. I have an idea from my point of view as one user, I would like to propose the following. Progress bar for pg_dump / pg_restore = Motivation -- "pg_dump" and "pg_restore" show nothing if users don't specify verbose (-v