[postgis-devel] [SoC] Introduction and PostGIS-GSoC Project Information

[Imre Samu]

Hi Han,

Thank you for working on this topic!  :)

> Feel free to give me suggestions or ask me anything! I

my question:
- in the research paper ( "2018" - mentioned in your proposal ) -
"partitioning" mentioned multiple times ..
  Do you have any plan - for adding spatial partitioning to the test
cases?

comment:

As I know  - in the OpenStreetMap word - the current
clustering/"pre-sorting method":  is the GeoHash based sorting:
https://www.paulnorman.ca/blog/2016/06/improving-speed-with-reclustering/
https://www.paulnorman.ca/blog/2016/05/improve-your-st-geohash-sorting-with-these-three-simple-tricks/
Maybe you can borrow some ideas for your benchmark. :)

Thanks,
  Imre


Han Wang <hanwgeek at gmail.com> ezt írta (időpont: 2021. máj. 25., K, 4:19):

> Hi all,
>
> My name is Han WANG. I am a first year graduate student majoring in GIS at
> Peking University, and will get my Master's degree in 2023. And this is my
> github(https://github.com/HanwGeek) and my linkedin(
> https://www.linkedin.com/in/hanwgeek/). I am interested in all
> cool things. And it is very exciting to join the open source community! My
> research interest includes massive spatial temporal data management and
> analysis. Currently, I am working on a machine learning project based on
> big trajectory data, which is stored in PostgreSQL database and managed by
> PostGIS.
>
> My project title is to *implement a pre-sorting method for PostGIS data
> types before building GiST* *index. *Some previous research about
> building GiST indexes in PostGreSQL has been proved that data pre-sorting
> method will reduce the time of building an index. And the new feature will
> be added in PostGreSQL 14. So it is necessary to apply this new feature to
> some basic geometry data type. And my initial proposal is here(
> https://docs.google.com/document/d/1_mY_F2hPDk3vmXH5PPp2z9BuQWt-ZMORk6KxtdVQ3HY/edit?usp=sharing
> ).
>
> I am excited to make a contribution to the open source community. Feel
> free to give me suggestions or ask me anything! I am looking forward to
> hearing from you all!
>
> Best regards,
> Han
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20210525/c6e7c33c/attachment.html>