On 12/7/2016 4:54 PM, metaresolve wrote:
Choking: I get the "Waiting for the query execution to complete" circling around for a while. I tried shutting it down and trying again but it's still freezing on the execution. But if the TB are accurate, I wonder why it's slowing on this? Any thoughts?
note database write performance on a windows desktop system thats probably using one desktop hard drive is going to be a LOT slower than a proper dedicated database server.
inserting lots of rows into a table that has a multiple indexes is also quite time consuming. in fact, if you're starting with an empty table, don't create ANY indexes til AFTER you populate the table with data, and before doing the CREATE INDEX, make sure 'maintenance_work_mem' is like 1GB.
-- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
