News for hackers. Stuff that matters.
Re:Using the linear distance operator in Postgres 12 to find... by miles-po on Thursday November 07, 2019 @01:30PM (#21475869)
While the unindexed time is impressive for the lack of index, the GIST and SP-GIST times are not 0.939 sec and 0.358 sec. All times are in milliseconds. GIST returns in slightly less than 1ms, not 1s. SP-GIST returns in slightly more than 1/3 of a millisecond.

Performance for GIST and SP-GIST are in fact three orders of magnitude better than what the author summarized!

There are no comments on this comment yet.