postgis/performance_tips.xml — Japanese @ OSGeo Weblate

Translation status

28	Strings		100%	Browse Translate
935	Words		100%	Browse Translate

Strings status

28	All strings — 935 words	Browse Translate Zen
28	Translated strings — 935 words	Browse Translate Zen
28	Strings waiting for review — 935 words	Browse Translate Zen
4	Translated strings with dismissed checks — 176 words	Browse Translate Zen

Other components

Component	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
reference_coverage CC-BY-3.0	69%	10	317	2,128	10	0	0	0

reference_srs.xml	72%	31	573	5,253	31	0	0	0

release_notes.xml	99%	2	61	399	2	0	0	0

reference_transformation.xml		0	0	0	0	0	0	0

faq.xml		0	0	0	0	0	0	0

reference_management.xml		0	0	0	0	0	0	0

database_tuning.xml		0	0	0	0	0	0	0

faq_raster.xml		0	0	0	0	0	0	0

extras.xml		0	0	0	0	0	0	0

Glossary Glossary		0	0	0	0	0	0	0

Browse all components

Overview

Project website	postgis.net
Project maintainers	komzpa cvvergara strk robe
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://git.osgeo.org/gitea/postgis/postgis.git`
Repository branch	master
Last remote commit	Never rely on tolerance-based point equality for topology code `4c776d418` Sandro Santilli authored yesterday
Last commit in Weblate	Translated using Weblate (Japanese) `994b97db9` Teramoto Ikuhiro authored 2 weeks ago
Weblate repository	`https://weblate.osgeo.org/git/postgis/postgis/`
File mask	`doc/po/*/performance_tips.xml.po`
Translation file	Download `doc/po/ja/performance_tips.xml.po`
Last change	May 16, 2023, 2:14 a.m.
Last author	Teramoto Ikuhiro

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		28		935		6,108
Approved	0%	0	0%	0	0%	0
Waiting for review	100%	28	100%	935	100%	6,108
Translated	100%	28	100%	935	100%	6,108
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	0%	0	0%	0	0%	0

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

935

Hosted words

Hosted strings

100%

Translated

Contributors

and previous 30 days

Trends of last 30 days

—

Hosted words

—

Hosted strings

—

Translated

—

+100%

Contributors

—

yellow73 Translation changed postgis / performance_tips.xml — Japanese	English lwgeom=# CLUSTER my_geom_index ON my_table; ERROR: cannot cluster when index access method does not handle null values HINT: You may be able to work around this by marking column "geom" NOT NULL. Japanese 1 character edited Current translation Translated lwgeom=# CLUSTER my_geom_index ON my_table; ERROR: cannot cluster when index access method does not handle null values (エラー: インデックスアクセスメソッドがNULL値を扱わない場合クラスタ化できません) HINT: You may be able to work around this by marking column "geom" NOT NULL. (ヒント: 列"the_geom"をNOT NULLとすることで、これを回避できるかもしれません) 2 weeks ago
yellow73 Translation changed postgis / performance_tips.xml — Japanese	English However, currently PostgreSQL does not allow clustering on PostGIS GIST indices because GIST indices simply ignores NULL values, you get an error message like: Japanese 2 characters edited Current translation Translated しかし、GiSTインデックスは単純にNULL値を無視するため現在のところPostGISのGiSTインデックスのクラスタリングはできず、次のようなエラーメッセージを得ます。 2 weeks ago
yellow73 Translation changed postgis / performance_tips.xml — Japanese	English For tables that are mostly read-only, and where a single index is used for the majority of queries, PostgreSQL offers the CLUSTER command. This command physically reorders all the data rows in the same order as the index criteria, yielding two performance advantages: First, for index range scans, the number of seeks on the data table is drastically reduced. Second, if your working set concentrates to some small intervals on the indices, you have a more efficient caching because the data rows are spread along fewer data pages. (Feel invited to read the CLUSTER command documentation from the PostgreSQL manual at this point.) Japanese 2 characters edited Current translation Translated 読み込むことがほとんどで、かつほとんどのクエリでひとつのインデックスを使うようなテーブルのために、PostgreSQLはCLUSTERコマンドを提供しています。このコマンドは、全てのデータ行を、インデックス基準にあわせて物理的に再整理するので、二つの性能の利点を生みます。一つは、インデックスの範囲走査のために、データテーブルのシーク回数が劇的に減少することです。もう一つは、いくつかの小さなインデックス間隔に集中する場合には、データ行が分布するデータページがより少なくなることで、より効率的なキャッシュを持つことです (この点は、PostgreSQLマニュアルのCLUSTERコマンドのドキュメントを読むように仕向けられていると感じて下さい)。 2 weeks ago
yellow73 Translation changed postgis / performance_tips.xml — Japanese	English CLUSTERing on geometry indices Japanese 1 character edited Current translation Translated ジオメトリインデックスでCLUSTERを実行する 2 weeks ago
yellow73 Translation changed postgis / performance_tips.xml — Japanese	English The first workaround is to force the query planner to use the index. Send "SET enable_seqscan TO off;" to the server before issuing the query. This basically forces the query planner to avoid sequential scans whenever possible. So it uses the GIST index as usual. But this flag has to be set on every connection, and it causes the query planner to make misestimations in other cases, so you should "SET enable_seqscan TO on;" after the query. Japanese 2 characters edited Current translation Translated 一つは、クエリプランナにインデックスの使用を強制することです。クエリを発行する前に"SET enable_seqscan TO off;"をサーバに送信します。これは基本的にクエリプランナに対して可能な限り順に走査することを避けるよう強制します。そのためGiSTインデックスを通常使うようになります。しかし、このフラグは接続するたびに設定しなければならず、他のケースにおいてはクエリプランナに誤った見積もりをさせることになるので、 "SET enable_seqscan TO on;"をクエリの後に送信すべきです。 2 weeks ago
yellow73 Translation changed postgis / performance_tips.xml — Japanese	English Now issue a query where you use the geometry operator && to search for a bounding box that matches only very few of those rows. Now the query optimizer sees that the table has only 3 pages and 80 rows. It estimates that a sequential scan on such a small table is much faster than using an index. And so it decides to ignore the GIST index. Usually, this estimation is correct. But in our case, the && operator has to fetch every geometry from disk to compare the bounding boxes, thus reading all TOAST pages, too. Japanese 2 characters edited Current translation Translated ここで、ジオメトリ演算子の&&を使って、ほとんどマッチしないようなバウンダリボックスを検索するクエリを出してみます。クエリオプティマイザにはテーブルは3ページ80行しかないように見えます。オプティマイザは、小さなテーブルを順に走査する方がインデックスを使うよりも早いと見積もります。そして、GiSTインデックスは無視すると決めます。通常なら、この見積もりは正しいです。しかし、この場合は&&演算子が全てのジオメトリをディスクから呼び出してバウンディングボックスと比較しなければならなくなり、ゆえに、全てのTOASTページもまた呼び出す必要があります。 2 weeks ago
yellow73 Translation changed postgis / performance_tips.xml — Japanese	English In case of large tables, it may be wise to divide this UPDATE into smaller portions by constraining the UPDATE to a part of the table via a WHERE clause and your primary key or another feasible criteria, and running a simple "VACUUM;" between your UPDATEs. This drastically reduces the need for temporary disk space. Additionally, if you have mixed dimension geometries, restricting the UPDATE by "WHERE dimension(geom)>2" skips re-writing of geometries that already are in 2D. Japanese 0 characters edited Current translation Translated 大きなテーブルの場合、WHERE節、およびプライマリキー若しくは他の適切な基準によってテーブルの一部へのUPDATEを制限させて、UPDATEの実行の間に単に"VACUUM;"と実行することで、UPDATEをより小さい塊に分割するのが賢いやり方かもしれません。これにより、テンポラリディスクスペースが劇的に減少します。さらに、次元混合のジオメトリを持つ場合、"WHERE dimension(the_geom)>2"によってUPDATEを制限することで、2次元で書かれているジオメトリの再書き込みをスキップさせることができます。 11 months ago
yellow73 Translation changed postgis / performance_tips.xml — Japanese	English UPDATE mytable SET geom = ST_Force2D(geom); VACUUM FULL ANALYZE mytable; Japanese 8 characters edited Current translation Translated UPDATE mytable SET ~~the_~~geom = ST_Force2D(~~the_~~geom); VACUUM FULL ANALYZE mytable; 11 months ago
yellow73 Translation changed postgis / performance_tips.xml — Japanese	English lwgeom=# ALTER TABLE my_table ALTER COLUMN geom SET not null; ALTER TABLE Japanese 0 characters edited Current translation Translated lwgeom=# ALTER TABLE my_table ALTER COLUMN geom SET not null; ALTER TABLE 11 months ago
yellow73 Marked for edit postgis / performance_tips.xml — Japanese	English lwgeom=# ALTER TABLE my_table ALTER COLUMN geom SET not null; ALTER TABLE Japanese 4 characters edited Current translation Needs editing lwgeom=# ALTER TABLE my_table ALTER COLUMN ~~the_~~geom SET not null; ALTER TABLE 11 months ago

Browse all translation changes

Quick downloads

28	File in original format as translated in the repository	gettext PO file
28	All strings, converted files enriched with comments; suitable for offline translation	CSV	gettext MO	gettext PO	TBX	TMX	XLIFF 1.1 with gettext extensions	XLIFF 1.1	XLSX

Customize download

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>=2023-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:>=2023-05-02 AND state:<=needs-editing`	Add