Zen

Translation

Tag: para
<link xlink:href="http://www.pledgebank.com/postgistopology"><emphasis role="bold">postgistopology</emphasis></link> - 10 plus sponsors each contributed $250 USD to build toTopoGeometry function and beef up topology support in 2.0.0. It happened.
277/2460 · 246

Sign in to save the translation.

English Polish Actions
Palantir Technologies
 
Paragon Corporation
 
R3 GIS
 
Refractions Research
 
Regione Toscana - SITA
 
Safe Software
 
Sirius Corporation plc
 
Stadt Uster
 
UC Davis Center for Vectorborne Diseases
 
Université Laval
 
U.S. Department of State (HIU)
 
Zonar Systems
 
Crowd Funding Campaigns
Kampanie corwdfundingowe
Crowd funding campaigns are campaigns we run to get badly wanted features funded that can service a large number of people. Each campaign is specifically focused on a particular feature or set of features. Each sponsor chips in a small fraction of the needed funding and with enough people/organizations contributing, we have the funds to pay for the work that will help many. If you have an idea for a feature you think many others would be willing to co-fund, please post to the <link xlink:href="https://lists.osgeo.org/mailman/listinfo/postgis-users">PostGIS newsgroup</link> your thoughts and together we can make it happen.
 
PostGIS 2.0.0 was the first release we tried this strategy. We used <link xlink:href="http://www.pledgebank.com">PledgeBank</link> and we got two successful campaigns out of it.
PostGIS 2.0.0 był pierwszym wydaniem, w którym wypróbowaliśmy taką strategię. Skorzystaliśmy z <link xlink:href="http://www.pledgebank.com">PledgeBank</link> i przeprowadzilśmy dwie udane kampanie.
<link xlink:href="http://www.pledgebank.com/postgistopology"><emphasis role="bold">postgistopology</emphasis></link> - 10 plus sponsors each contributed $250 USD to build toTopoGeometry function and beef up topology support in 2.0.0. It happened.
<link xlink:href="http://www.pledgebank.com/postgistopology"><emphasis role="bold">postgistopology</emphasis></link> - ponad 10 sponsorów wpłaciło po 250$ w celu stworzenia funkcji toTopoGeometry oraz rozbudowy wsparcia dla topologii w wersji 2.0.0. To naprawdę się wydarzyło.
<link xlink:href="http://www.pledgebank.com/postgis64windows"><emphasis role="bold">postgis64windows</emphasis></link> - 20 someodd sponsors each contributed $100 USD to pay for the work needed to work out PostGIS 64-bit issues on windows. It happened.
<link xlink:href="http://www.pledgebank.com/postgistopology"><emphasis role="bold">postgistopology</emphasis></link> - ponad 10 sponsorów wpłaciło po 250$ w celu stworzenia funkcji toTopoGeometry oraz rozbudowy wsparcia dla topologii w wersji 2.0.0. To naprawdę się wydarzyło.
Important Support Libraries
Istotne biblioteki wspierające
The <link xlink:href="https://libgeos.org">GEOS</link> geometry operations library
 
The <link xlink:href="https://gdal.org">GDAL</link> Geospatial Data Abstraction Library used to power much of the raster functionality introduced in PostGIS 2. In kind, improvements needed in GDAL to support PostGIS are contributed back to the GDAL project.
 
The <link xlink:href="https://www.proj4.org">PROJ</link> cartographic projection library
 
Last but not least, <link xlink:href="http://www.postgresql.org">PostgreSQL</link>, the giant that PostGIS stands on. Much of the speed and flexibility of PostGIS would not be possible without the extensibility, great query planner, GIST index, and plethora of SQL features provided by PostgreSQL.
 
Performance Tips
 
Small tables of large geometries
 
Problem description
 
Current PostgreSQL versions (including 9.6) suffer from a query optimizer weakness regarding TOAST tables. TOAST tables are a kind of "extension room" used to store large (in the sense of data size) values that do not fit into normal data pages (like long texts, images or complex geometries with lots of vertices), see <link xlink:href="http://www.postgresql.org/docs/current/static/storage-toast.html">the PostgreSQL Documentation for TOAST</link> for more information).
 
The problem appears if you happen to have a table with rather large geometries, but not too many rows of them (like a table containing the boundaries of all European countries in high resolution). Then the table itself is small, but it uses lots of TOAST space. In our example case, the table itself had about 80 rows and used only 3 data pages, but the TOAST table used 8225 pages.
 
Now issue a query where you use the geometry operator &amp;&amp; to search for a bounding box that matches only very few of those rows. Now the query optimizer sees that the table has only 3 pages and 80 rows. It estimates that a sequential scan on such a small table is much faster than using an index. And so it decides to ignore the GIST index. Usually, this estimation is correct. But in our case, the &amp;&amp; operator has to fetch every geometry from disk to compare the bounding boxes, thus reading all TOAST pages, too.
 
To see whether your suffer from this issue, use the "EXPLAIN ANALYZE" postgresql command. For more information and the technical details, you can read the thread on the PostgreSQL performance mailing list: <link xlink:href="http://archives.postgresql.org/pgsql-performance/2005-02/msg00030.php">http://archives.postgresql.org/pgsql-performance/2005-02/msg00030.php</link>
 
and newer thread on PostGIS <link xlink:href="https://lists.osgeo.org/pipermail/postgis-devel/2017-June/026209.html">https://lists.osgeo.org/pipermail/postgis-devel/2017-June/026209.html</link>
 
Workarounds
 

Loading…

User avatar None

String updated in the repository

  1. postgis
  2. PostGIS Manual
  3. Polish
<link xlink:href="http://www.pledgebank.com/postgistopology"><emphasis role="bold">postgistopology</emphasis></link> - 10 plus sponsors each contributed $250 USD to build toTopoGeometry function and beef up topology support in 2.0.0. It happened.
<link xlink:href="http://www.pledgebank.com/postgistopology"><emphasis role="bold">postgistopology</emphasis></link> - ponad 10 sponsorów wpłaciło po 250$ w celu stworzenia funkcji toTopoGeometry oraz rozbudowy wsparcia dla topologii w wersji 2.0.0. To naprawdę się wydarzyło.
a year ago
Browse all string changes

Things to check

Double space

Translation contains double space

Fix string

Reset

Glossary

English Polish
No related strings found in the glossary.

String information

Source string description
Tag: para
Flags
no-c-format
String age
a year ago
Last updated
a year ago
Source string age
a year ago
Translation file
doc/po/pl/postgis-manual.po, string 1272