Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar jef User avatar cvvergara User avatar dkastl User avatar robe User avatar strk User avatar jsanz User avatar astrid_emde User avatar komzpa User avatar dmateos User avatar andischi User avatar darkblueb User avatar yellow73
Translation license CC-BY-3.0-US installation glossary 1 index

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 482 8,277 55,839
Translated 1% 8 1% 85 1% 514
Needs editing 0% 0 0% 0 0% 0
Read-only 1% 1 1% 1 1% 10
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 1% 2 1% 2 1% 6
Untranslated strings 98% 474 98% 8,192 99% 55,325
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 9 changes 0 changes 0 changes 0 changes 55 changes 0 changes 0 changes 0 changes 2 changes 0 changes 14 changes
May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr

Quick numbers

8,277
Hosted words
482
Hosted strings
1%
Translated
1
Contributors
and previous 30 days

Trends of last 30 days

+1%
Hosted words
—
—
Hosted strings
—
—
Translated
—
—
Contributors
—
User avatar None

New strings to translate

postgis-workshop / clusterindex — Italian

10 new strings to translate appeared to the translation. a month ago
User avatar None

Resource update

postgis-workshop / clusterindex — Italian

The "postgis-intro/sources/locale/it/LC_MESSAGES/clusterindex.po" file was changed. a month ago
User avatar None

String updated in the repository

postgis-workshop / clusterindex — Italian

`CLUSTER <https://www.postgresql.org/docs/current/sql-cluster.html>`_: Re-orders the data in a table to match the ordering in the index.
 
a month ago
User avatar None

String updated in the repository

postgis-workshop / clusterindex — Italian

The difference between "no index" and "index" is generally huge and highly measurable. The difference between "mediocre index" and "great index" usually takes quite careful measurement to discern, and can be very sensitive to the workload being tested.
 
a month ago
User avatar None

String updated in the repository

postgis-workshop / clusterindex — Italian

In theory, yes. In practice, no really. As long as the index is a "pretty good" spatial decomposition of the data, the main determinant of performance will be the order of the actual table tuples.
 
a month ago
User avatar None

String updated in the repository

postgis-workshop / clusterindex — Italian

Does Index Structure Matter?
 
a month ago
User avatar None

String updated in the repository

postgis-workshop / clusterindex — Italian

System RAM is not the fastest memory on a modern computer. There are several levels of cache between system RAM and the actual CPU, and the underlying operating system and processor will move data up and down the cache heirarchy in blocks. If the block getting moved up happens to include the piece of data the system will need next... that's a big win. Correlating the memory structure with the spatial structure is a way in increase the odds of that win happening.
 
a month ago
User avatar None

String updated in the repository

postgis-workshop / clusterindex — Italian

Surprisingly, yes. Keeping records that are "near each other" in space "near each other" in memory increases the odds that related records will move up the servers "memory cache heirarchy" together, and thus make memory accesses faster.
 
a month ago
User avatar None

String updated in the repository

postgis-workshop / clusterindex — Italian

Is clustering still necessary?
 
a month ago
User avatar None

String updated in the repository

postgis-workshop / clusterindex — Italian

Most modern databases are run using SSD storage, which is much faster at random access than old spinning magnetic media. Also, most modern databases are running on top of data which is small enough to fit into the RAM of the database server, and ends up there as the operating system "virtual filesystem" caches it.
 
a month ago
Browse all language changes