Leo Hsu

Boston, Massachusetts

Areas of Expertise:

  • PostgreSQL
  • PostGIS
  • ASP.NET
  • SQL Server
  • Economics
  • Database
  • consulting
  • speaking
  • programming
  • training
Leo Hsu is a co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 15 years of professional experience developing and thinking about databases for organizations large and small. Leo holds an MS degree in engineering of economic systems from Stanford University and BS degrees in mechanical engineering and economics from the Massachusetts Institute of Technology. He co-authored PostGIS in Action and PostgreSQL: Up and Running.

PostgreSQL: Up and Running PostgreSQL: Up and Running
by Regina Obe , Leo Hsu
July 2012
Print: $19.99
Ebook: $14.99

Leo blogs at:

CMake support for PostGIS planned

June 17 2013

I've been having issues with PostgreSQL error handling mostly on windows 64-bit using binaries I build with mingw64 and using under VC++ built PostgreSQL. Most of which I don't understand. As many have pointed out these issues MIGHT go away or be easier to debug if PostGIS was built with… read more

KNN GIST with a Lateral twist: Coming soon to a database near you

May 22 2013

One of the things that really frustrated me about the KNN GIST distance box box centroid operators that came in PostgreSQL 9.1 and PostGIS 2.0 was the fact that one of the elements needed to be constant to take advantage of the index. In PostGIS speak, this meant you couldn't… read more

PostgreSQL 9.3 extension treats for windows users: plV8

May 13 2013

Now that PostgreSQL 9.3 beta1 has been released we've started to jump start our experimentation by compiling our favorite extensions. First on the list is PL/V8 js. This was compiled against 9.3beta1 for 64-bit and 32-bit and plv8 version 1.4.0. We briefly tried with the EDB windows builds which we… read more