Many thanks to you Giuseppe for suggesting the idea and taking on the job of
being a GSOC mentor. Wouldn’t have been possible without your initiative.
For those who are interested in the underlying details, Han gave a presentation
of his work at FOSS4G 2021.
You can view it here:
htt
That's really a fantastic news! Thanks Han again for your work on this, and
thanks to all the people that helped with this!
Giuseppe.
On Sun, 28 Nov 2021, 20:26 Regina Obe, wrote:
> I think Han and Kontur have some benchmarks.
>
> https://git.osgeo.org/gitea/postgis/postgis-performance
>
> In m
Hi Regina,
Thanks for that clear information.
Seeing a 3-4x speed up of GiST index build time, is definitely
significant and comforting, and thanks to all involved for realizing the
new functionality. This will be a welcome enhancement for many PostGIS
and OpenStreetMap data users once they h
I think Han and Kontur have some benchmarks.
https://git.osgeo.org/gitea/postgis/postgis-performance
In my pgTap benchmarks the index build timing is approximately 3-4 times
faster with osm data of Belarus and China. Han said the query performance
slowed a little, but I didn't see that in my pg
Okay I didn't completely read the error:
> > > SELECT postgis_extensions_upgrade();
> > > NOTICE: Updating extension postgis from 3.0.2 to 3.1.0alpha1
> > > ERROR: extension "postgis" has no update path from version "3.0.2"
> > > to
> > version "3.1.0alpha1"
> > > CONTEXT: SQL statement "ALTER
All the upgrade scripts are the same. We just delete the pre-release scripts to
reduce disk space.
To upgrade yours do the following
-- this changes all your installed versions to 3.1.0 so you have an upgrade path
UPDATE pg_catalog.pg_extension SET extversion = '3.1.0' WHERE extname
IN('postgis'
This is actually in response to Regina Obe's email which I didn't
receive but only saw on the list archives. Maybe there is another way of
replying to her message but I don't know it.
I have definitely upgraded my debian/unstable installation.
> $ dpkg-query -W postgis
> postgis 3.1.4+dfsg-3+b
