On Mon, Jun 6, 2011 at 6:10 PM, Mike Broers <mbro...@gmail.com> wrote: > Thanks for the suggestion, maintenance_work_mem is set to the default of > 16MB on the host that was taking over an hour as well as on the host that > was taking less than 10 minutes. I tried setting it to 1GB on the faster > test server and it reduced the time from around 6-7 minutes to about 3:30. > this is a good start, if there are any other suggestions please let me know > - is there any query to check estimated time remaining on long running > transactions?
Sadly, no. I suspect that coming up with a good algorithm for that is a suitable topic for a PhD thesis. :-( -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
