Translation status

21 Strings 4%
Browse Translate
583 Words 1%
3,503 Characters 1%

Strings status

Strings Words Characters
21 583 3,503
All strings Browse Translate Zen
1 2 13
Translated strings Browse Translate Zen
20 581 3,490
Unfinished strings Browse Translate Zen
20 581 3,490
Untranslated strings Browse Translate Zen
20 581 3,490
Unfinished strings without suggestions Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
spatial_relationships_exercises 0 0 0 0 1 2 0
geography_exercises 71% 6 136 793 6 4 0 0
joins_exercises 0 0 0 0 0 0 0
projection_exercises 0 0 0 0 8 0 0
advanced_geometry_construction 0% 58 1,288 7,944 58 1 1 0
simple_sql_exercises 0 0 0 0 9 3 0
3d 23% 30 742 4,695 30 0 0 0
license 0% 3 56 404 3 0 0 0
installation CC-BY-3.0-US 0 0 0 0 0 0 0
equality 0% 12 397 2,475 12 0 0 0
Browse all components

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar komzpa User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar cvvergara User avatar astrid_emde User avatar jef User avatar yellow73
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
Source code repository https://github.com/postgis/postgis-workshops.git
Repository branch master
Last remote commit Merge pull request #136 from latot/topo_intro 3b31e91
Regina Obe authored 17 hours ago
Last commit in Weblate Translated using Weblate (Japanese) d028968
Teramoto Ikuhiro authored 4 months ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/clusterindex.po
Translation file Download postgis-intro/sources/locale/zh_Hans/LC_MESSAGES/clusterindex.po
Last change Jan. 8, 2023, 2:50 a.m.
Last author None
2 weeks ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 21 583 3,503
Translated 4% 1 1% 2 1% 13
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 95% 20 99% 581 99% 3,490
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 1 change 0 changes 1 change 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 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct

Quick numbers

583
Hosted words
21
Hosted strings
4%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
—
Translated
+4%
—
Contributors
—
User avatar None

Resource updated

  1. postgis-workshop
  2. clusterindex
  3. Chinese (Simplified)
The "postgis-intro/sources/locale/zh_Hans/LC_MESSAGES/clusterindex.po" file was changed. a year ago
User avatar None

Resource updated

  1. postgis-workshop
  2. clusterindex
  3. Chinese (Simplified)
The "postgis-intro/sources/locale/zh_Hans/LC_MESSAGES/clusterindex.po" file was changed. a year ago
User avatar None

Resource updated

  1. postgis-workshop
  2. clusterindex
  3. Chinese (Simplified)
The "postgis-intro/sources/locale/zh_Hans/LC_MESSAGES/clusterindex.po" file was changed. 2 years ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. clusterindex
  3. Chinese (Simplified)
`CLUSTER <https://www.postgresql.org/docs/current/sql-cluster.html>`_: Re-orders the data in a table to match the ordering in the index.
 
2 years ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. clusterindex
  3. Chinese (Simplified)
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.
 
2 years ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. clusterindex
  3. Chinese (Simplified)
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.
 
2 years ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. clusterindex
  3. Chinese (Simplified)
Does Index Structure Matter?
 
2 years ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. clusterindex
  3. Chinese (Simplified)
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.
 
2 years ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. clusterindex
  3. Chinese (Simplified)
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.
 
2 years ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. clusterindex
  3. Chinese (Simplified)
Is clustering still necessary?
 
2 years ago
Browse all translation changes