[ckan-changes] [ckan/ckan] aa8744: Timing tests show that asking when analyze was don...

Fri Nov 9 12:59:26 UTC 2018

  Branch: refs/heads/datastore-estimate-total
  Home:   https://github.com/ckan/ckan
  Commit: aa87446740de947933327943822dde802c05bbeb
      https://github.com/ckan/ckan/commit/aa87446740de947933327943822dde802c05bbeb
  Author: David Read <david.read at hackneyworkshop.com>
  Date:   2018-11-09 (Fri, 09 Nov 2018)

  Changed paths:
    M ckanext/datastore/backend/postgres.py

  Log Message:
  -----------
  Timing tests show that asking when analyze was done is v slow - 12ms - compared to asking for the estimated row count - <1ms - so dont bother with the former. Additionally, in the case that row stats arent calculated for some reason, running ANALYZE to get this estimate is v slow - 17s for the 311 data, compared to 1.7s for SELECT COUNT(*) so lets not run ANALYZE in this case.


      **NOTE:** This service has been marked for deprecation: https://developer.github.com/changes/2018-04-25-github-services-deprecation/

      Functionality will be removed from GitHub.com on January 31st, 2019.