postgis-workshop

tuning

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

	German	0%	46	1,098	7,106	46	0	0	0

	Italian	0%	46	1,098	7,106	46	0	1	0

	Japanese		0	0	0	0	0	0	0

	Spanish	4%	44	1,092	7,066	44	0	4	0

Please sign in to see the alerts.

Overview

Project website	postgis.net/workshops/postgis-intro
Project maintainers	jsanz komzpa dmateos yellow73 dkastl cvvergara andischi astrid_emde jef
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 #120 from osgeoweblate/weblate-postgis-workshop-index `75182f2` Regina Obe authored 3 weeks ago
Last commit in Weblate	Translated using Weblate (Japanese) `3edef1a` Teramoto Ikuhiro authored 5 months ago
Weblate repository	`https://weblate.osgeo.org/git/postgis-workshop/index/`
File mask	`postgis-intro/sources/locale/*/LC_MESSAGES/tuning.po`

3 weeks ago

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		230		5,490		35,530
Source		46		1,098		7,106
Translated	40%	94	40%	2,202	40%	14,252
Needs editing	0%	0	0%	0	0%	0
Read-only	20%	46	20%	1,098	20%	7,106
Failing checks	0%	0	0%	0	0%	0
Strings with suggestions	2%	5	1%	13	1%	94
Untranslated strings	59%	136	59%	3,288	59%	21,278

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

5,490

Hosted words

230

Hosted strings

40%

Translated

and previous 30 days

Trends of last 30 days

—

Hosted words

+100%

—

Hosted strings

+100%

—

Translated

+40%

—

Contributors

—

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>=2024-03-19 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:>=2024-03-19 AND state:<=needs-editing`	Add
Translated strings in a certain language	`is:translated AND language:en`	Add

None Changes committed postgis-workshop tuning Japanese	Changes committed 5 months ago
yellow73 Suggestion accepted postgis-workshop tuning Japanese	English Back in pgAdmin, click the server again select Disconnect. Japanese 52 characters edited Current translation Translated その後 pgAdmin に戻って、サーバをクリックして Connect Server を選択します。 5 months ago
yellow73 Suggestion accepted postgis-workshop tuning Japanese	English In Windows Services (``services.msc``) right-click PostgreSQL and select Restart. Japanese 70 characters edited Current translation Translated Windows サービス (``services.msc``) では PostgreSQL を右クリックして「再起動」を選択します。 5 months ago
yellow73 Suggestion accepted postgis-workshop tuning Japanese	English In pgAdmin, right-click the server PostGIS (localhost:5432) and select Disconnect. Japanese 87 characters edited Current translation Translated まず pgAdmin で、サーバ PostGIS (localhost:5432) を右クリックして Disconnect from server を選択します。 5 months ago
yellow73 Suggestion accepted postgis-workshop tuning Japanese	English After these changes are made, save changes and reload the configuration. The easiest way to do this is to restart the PostgreSQL service. Japanese 72 characters edited Current translation Translated これらの変更を行った後に、変更を保存して、コンフィギュレーションを再読込して下さい。PostgreSQL サービスを再起動するのが最も簡単です。 5 months ago
yellow73 Suggestion accepted postgis-workshop tuning Japanese	English This is the parameter that controls the cost of a sequential page access. This value does not generally require adjustment but the difference between this value and ``random_page_cost`` greatly affects the choices made by the query planner. This value can also be set on a per-session basis. Japanese 132 characters edited Current translation Translated これは、順次ページアクセスのコストを制御するパラメータです。この値は一般的には調整する必要はありませんが、この値と ``random_page_cost`` との間の差は、クエリプランナの選択に大きな影響を与えます。この値はセッションごとに設定することもできます。 5 months ago
yellow73 Suggestion accepted postgis-workshop tuning Japanese	English This value can be set on a per-session basis using the ``SET random_page_cost TO 2.0`` command, which can be useful for testing how it effects query plans. Japanese 94 characters edited Current translation Translated この値は ``SET random_page_cost TO 2.0`` コマンドでセッションごとに設定できます。このコマンドは、クエリプランにどれぐらい影響を与えるかを試すのに使えます。 5 months ago
yellow73 Translation changed postgis-workshop tuning Japanese	English This is a unit-less value that represents the cost of a random page access from disk. This value is relative to a number of other cost parameters including sequential page access, and CPU operation costs. While there is no magic bullet for this value, the default is generally conservative and for databases running on spinning media. The random access cost for SSD should be set even lower. Japanese 2 characters edited Current translation Translated ディスクからのランダムページアクセスのコストを表現する、単位の無い値です。この値は、シーケンシャルページアクセスや CPU 処理コストなどといった他のコストパラメータとの相対値です。この値には魔法の弾丸はなく、デフォルトは一般的に保守的で、ハードディスクなどの回転するメディア上でのデータベース実行用です。SSD のランダムアクセスコストは、それより低く設定するべきです。 5 months ago
yellow73 Suggestion accepted postgis-workshop tuning Japanese	English This is a unit-less value that represents the cost of a random page access from disk. This value is relative to a number of other cost parameters including sequential page access, and CPU operation costs. While there is no magic bullet for this value, the default is generally conservative and for databases running on spinning media. The random access cost for SSD should be set even lower. Japanese 184 characters edited Translated ディスクからのランダムページアクセスのコストを表現する、単位の無い値です。この値は、シーケンシャルページアクセスや CPU 処理コストなどといった他のコストパラメータとの相対値でこの値には魔法の弾丸はなく、デフォルトは一般的に保守的で、ハードディスクなどの回転するメディア上でのデータベース実行用です。SSD のランダムアクセスコストは、それより低く設定するべきです。 5 months ago
yellow73 Suggestion accepted postgis-workshop tuning Japanese	English Because the checkpoint process requires the flushing of all dirty data pages to disk, it creates a significant I/O load. The same argument from above applies; geospatial data is large enough to unbalance non-geospatial optimizations. Increasing this value will prevent excessive checkpoints, though it may cause the server to restart more slowly in the event of a crash. Japanese 168 characters edited Current translation Translated チェックポイント処理は全てのダーティなデータページをディスクにフラッシュする必要があるため、かなりの I/O 負荷が発生します。前の議論と同じで、空間データは非空間データの最適化のバランスを崩すのに十分大きなものです。この値を大きくすると、過剰なチェックポイントを防ぐことができますが、クラッシュした際の再起動が遅くなるかも知れません。 5 months ago

Browse all component changes