postgis-workshop

clusterindex

	Language	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
	English		0	0	0	0	1	0	0

	Chinese (Simplified)	4%	20	581	3,490	20	0	0	0

	German	0%	21	583	3,503	21	0	0	0

	Italian	0%	21	583	3,503	21	0	0	0

	Japanese		0	0	0	0	0	0	0

	Spanish	0%	21	583	3,503	21	0	0	0

Please sign in to see the alerts.

Overview

Project website	postgis.net/workshops/postgis-intro
Project maintainers	komzpa dkastl dmateos jef andischi yellow73 cvvergara jsanz astrid_emde
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 #81 from osgeoweblate/weblate-postgis-workshop-index `8d62b97` Regina Obe authored 6 days ago
Last commit in Weblate	Translated using Weblate (Japanese) `bf7bfdc` Teramoto Ikuhiro authored a month ago
Weblate repository	`https://weblate.osgeo.org/git/postgis-workshop/index/`
File mask	`postgis-intro/sources/locale/*/LC_MESSAGES/clusterindex.po`

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		126		3,498		21,018
Source		21		583		3,503
Translated	34%	43	33%	1,168	33%	7,019
Needs editing	0%	0	0%	0	0%	0
Read-only	16%	21	16%	583	16%	3,503
Failing checks	1%	1	2%	83	2%	466
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	65%	83	66%	2,330	66%	13,999

Last 12 months Previous

Activity in last 12 months


May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr

Quick numbers

3,498

Hosted words

126

Hosted strings

34%

Translated

0

Contributors

and previous 30 days

Trends of last 30 days

—

Hosted words

—

—

Hosted strings

—

—

Translated

+15%

—

Contributors

—

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>=2023-04-30 AND NOT changed_by:anonymous`	Add
Translated strings	`state:>=translated`	Add
Strings with comments	`has:comment`	Add
Strings with any failing checks	`has:check`	Add
Strings with suggestions from others	`has:suggestion AND NOT suggestion_author:anonymous`	Add
Approved strings with suggestions	`state:approved AND has:suggestion`	Add
All untranslated strings added the past month	`added:>=2023-04-30 AND state:<=needs-editing`	Add
Translated strings in a certain language	`is:translated AND language:en`	Add

yellow73 Suggestion accepted postgis-workshop / clusterindex — Japanese	English `CLUSTER <https://www.postgresql.org/docs/current/sql-cluster.html>`_: Re-orders the data in a table to match the ordering in the index. Japanese 115 characters edited Current translation Translated `CLUSTER <https://www.postgresql.jp/document/current/html/sql-cluster.html>`_: テーブル内のデータの並びをインデックスの並びと合致するよう並べ替えます。 a month ago
yellow73 Suggestion accepted postgis-workshop / clusterindex — Japanese	English 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. Japanese 136 characters edited Current translation Translated 「インデックスなし」と「インデックスあり」との間の違いは、一般的には大きく、計測は問題なく可能です。「平凡なインデックス」と「素晴らしいインデックス」との差では、見定めるのには非常に慎重な測定が必要で、この差は、テストしている仕事量に対して非常に敏感になることがあります。 a month ago
yellow73 Translation changed postgis-workshop / clusterindex — Japanese	English 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. Japanese 2 characters edited Current translation Translated 理論的には、そうです。実地で際には、そうではありません。インデックスが「かなり良い」空間分解であるなら、パフォーマンスを決める主な要因はテーブルのタプルの順序になります。 a month ago
yellow73 Suggestion accepted postgis-workshop / clusterindex — Japanese	English 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. Japanese 83 characters edited Translated 理論的には、そうです。実地では、そうではありません。インデックスが「かなり良い」空間分解であるなら、パフォーマンスを決める主な要因はテーブルのタプルの順序になります。 a month ago
yellow73 Suggestion accepted postgis-workshop / clusterindex — Japanese	English Does Index Structure Matter? Japanese 15 characters edited Current translation Translated インデックス構造は重要ですか? a month ago
yellow73 Suggestion accepted postgis-workshop / clusterindex — Japanese	English 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. Japanese 212 characters edited Current translation Translated システム RAM は、最新のコンピュータでは早いメモリではありません。数レベルの階層を持つキャッシュがシステム RAM と実際の CPU との間にあり、オペレーティングシステムとプロセッサはデータをブロック単位で上層下層に異動させます。ブロックが上層に挙がると、システムが次に求めるとみられるデータの一部を含んでいるなら…それは大勝利となります。メモリ構造と空間構造とを相関させることは、この勝利を得る確率を高める方法です。 a month ago
yellow73 Suggestion accepted postgis-workshop / clusterindex — Japanese	English 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. Japanese 104 characters edited Current translation Translated 驚くべきことに、そうなのです。空間で「互いに近い」ものをメモリ上で「互いに近い」レコードとして保持すると、関連するレコード同士がサーバの「メモリキャッシュ階層」を一緒に移動し、メモリアクセスが高速になります。 a month ago
yellow73 Translation changed postgis-workshop / clusterindex — Japanese	English Is clustering still necessary? Japanese 4 characters edited Current translation Translated クラスタリングはなお重要なのでしょうか? a month ago
yellow73 Suggestion accepted postgis-workshop / clusterindex — Japanese	English Is clustering still necessary? Japanese 16 characters edited Translated クラスタリングはなお重要なのか? a month ago
yellow73 Suggestion accepted postgis-workshop / clusterindex — Japanese	English 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. Japanese 168 characters edited Current translation Translated 最近のデータベースの多くは SSD ストレージを使っています。ランダムアクセスにおいては、古い回転磁性体よりもずっと早いです。最近のデータベースの多くは、データベースサーバの RAM に収まるぐらい十分に小さいデータ上で実行されていて、オペレーティングシステムの仮想ファイルシステムがデータをキャッシュするにつれて、そこに落ち着きます。 a month ago

Browse all component changes