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	1	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	komzpa dmateos dkastl jsanz andischi yellow73 cvvergara 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 #143 from osgeoweblate/weblate-postgis-workshop-index `4a5082b` Regina Obe authored 12 days ago
Last commit in Weblate	Translated using Weblate (Japanese) `3edef1a` Teramoto Ikuhiro authored a year ago
Weblate repository	`https://weblate.osgeo.org/git/postgis-workshop/index/`
File mask	`postgis-intro/sources/locale/*/LC_MESSAGES/tuning.po`

a week 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%	6	1%	14	1%	108
Untranslated strings	59%	136	59%	3,288	59%	21,278

Last 12 months Previous

Activity in last 12 months


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

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:>=2025-05-02 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:>=2025-05-02 AND state:<=needs-editing`	Add
Translated strings in a certain language	`is:translated AND language:en`	Add

mt:weblate Suggestion added postgis-workshop tuning German	English shared_buffers German 14 characters edited shared_buffers 5 months ago
None Alert triggered postgis-workshop tuning	Component seems unused. 7 months ago
None Changes committed postgis-workshop tuning Japanese	Changes committed a year 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 を選択します。 a year 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 を右クリックして「再起動」を選択します。 a year 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 を選択します。 a year 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 サービスを再起動するのが最も簡単です。 a year 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`` との間の差は、クエリプランナの選択に大きな影響を与えます。この値はセッションごとに設定することもできます。 a year 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`` コマンドでセッションごとに設定できます。このコマンドは、クエリプランにどれぐらい影響を与えるかを試すのに使えます。 a year 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 のランダムアクセスコストは、それより低く設定するべきです。 a year ago

Browse all component changes