Dave

icon indicating a website link https://www.davesrowe.co.uk

icon company Libraries Hacked icon location Bradford-on-Avon icon location Software and geospatial specialist. Ex-Local Government. Particularly interested in public library software and data.

Results 3 comments of Dave

Useful code for checking progress during indexing

Thank you! That's really useful. Those indexes on the json column I know are very slow to build. And probably not very efficient! The whole thing took about 2 days...

I am experiencing slow query performance in my PostgreSQL database

Hi Thanks for raising this issue! Apologies for the extremely late reply, I've been slowly working on a refinement to the loading process, and it's been exceptionally long in getting...

How to perform delta updates

Hi This is a good question, and sorry for late reply! To be honest, I think the most efficient way of doing updates for now would just be to regenerate...