No strings found!

Translation status

61 Strings 100%
Browse Translate
1,288 Words 100%
9,117 Characters 100%

Strings status

Strings Words Characters
61 1,288 9,117
All strings Browse Translate Zen
61 1,288 9,117
Translated strings Browse Translate Zen
16 32 986
Translated strings with dismissed checks Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
spatial_relationships_exercises 0 0 0 0 8 2 0
joins_exercises 0 0 0 0 7 2 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
spatial_relationships 9% 38 799 5,897 38 0 0 0
joins 0 0 0 0 0 2 0
license 0% 3 56 404 3 0 0 0
installation CC-BY-3.0-US 0 0 0 0 0 0 0
Browse all components

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar komzpa User avatar dmateos User avatar yellow73 User avatar cvvergara User avatar dkastl User avatar astrid_emde User avatar jsanz User avatar andischi User avatar 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 #122 from osgeoweblate/weblate-postgis-workshop-index 9424034
Regina Obe authored 2 weeks ago
Last commit in Weblate Translated using Weblate (Chinese (Simplified)) c0fdeaa
Wangdapeng authored a week ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/indexing.po
Translation file Download postgis-intro/sources/locale/zh_Hans/LC_MESSAGES/indexing.po
Last change May 6, 2024, 9 p.m.
Last author None
2 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 61 1,288 9,117
Translated 100% 61 100% 1,288 100% 9,117
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

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

Quick numbers

1,288
Hosted words
61
Hosted strings
100%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed

  1. postgis-workshop
  2. indexing
  3. Chinese (Simplified)
Changes committed a week ago
User avatar xinbo

Translation completed

  1. postgis-workshop
  2. indexing
  3. Chinese (Simplified)
Translation completed 8 days ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. indexing
  3. Chinese (Simplified)
Vacuuming and analyzing the database can be performed separately as needed. Issuing ``VACUUM`` command will not update the database statistics; likewise issuing an ``ANALYZE`` command will not recover unused table rows. Both commands can be run against the entire database, a single table, or a single column.
可以根据需要单独执行数据库的清理和分析。发出 ``VACUUM`` 命令不会更新数据库统计信息；同样，发出``ANALYZE``命令将不会恢复未使用的表行。这两个命令都可以针对整个数据库、单个表或单个列运行。
8 days ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. indexing
  3. Chinese (Simplified)
Autovacuum both vacuums (recovers space) and analyzes (updates statistics) on your tables at sensible intervals determined by the level of activity. While this is essential for highly transactional databases, it is not advisable to wait for an autovacuum run after adding indices or bulk-loading data. Whenever a large batch update is performed, you should manually run ``VACUUM``.
Autovacuum 根据活动级别确定的合理时间间隔对表进行真空处理（恢复空间）和分析（更新统计信息）。虽然这对于高度事务性数据库至关重要，但不建议在添加索引或批量加载数据后等待 autovacuum 运行。每当执行大批量更新时，您应该手动运行``VACUUM`` 。
8 days ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. indexing
  3. Chinese (Simplified)
Vacuuming is so critical for the efficient running of the database that PostgreSQL provides an "autovacuum" facility by default.
清理对于数据库的高效运行至关重要，因此 PostgreSQL 默认提供“自动清理”功能。
8 days ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. indexing
  3. Chinese (Simplified)
It's worth stressing that just creating an index is not enough to allow PostgreSQL to use it effectively. VACUUMing must be performed whenever a large number of UPDATEs, INSERTs or DELETEs are issued against a table. The ``VACUUM`` command asks PostgreSQL to reclaim any unused space in the table pages left by updates or deletes to records.
值得强调的是，仅仅创建索引并不足以让 PostgreSQL 有效地使用它。每当对表发出大量 UPDATE、INSERT 或 DELETE 时，都必须执行 VACUUMing。该 ``VACUUM``命令要求 PostgreSQL 回收因更新或删除记录而留下的表页中任何未使用的空间。
8 days ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. indexing
  3. Chinese (Simplified)
The ``ANALYZE`` command asks PostgreSQL to traverse the table and update its internal statistics used for query plan estimation (query plan analysis will be discussed later).
``ANALYZE`` 命令要求 PostgreSQL 遍历该表并更新其用于查询计划估计的内部统计信息（稍后将讨论查询计划分析）。
8 days ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. indexing
  3. Chinese (Simplified)
To ensure the statistics match your table contents, it is wise the to run the ``ANALYZE`` command after bulk data loads and deletes in your tables. This force the statistics system to gather data for all your indexed columns.
为了确保统计信息与您的表内容匹配，明智的做法是在表中加载和删除批量数据后运行 ``ANALYZE`` 命令。这迫使统计系统收集所有索引列的数据。
8 days ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. indexing
  3. Chinese (Simplified)
In order to figure out what situation it is dealing with (reading a small part of the table versus reading a large portion of the table), PostgreSQL keeps statistics about the distribution of data in each indexed table column. By default, PostgreSQL gathers statistics on a regular basis. However, if you dramatically change the contents of your table within a short period of time, the statistics will not be up-to-date.
为了弄清楚它正在处理什么情况（读取表的一小部分与读取表的大部分），PostgreSQL 保留有关每个索引表列中数据分布的统计信息。默认情况下，PostgreSQL 会定期收集统计信息。但是，如果您在短时间内大幅更改表的内容，则统计信息将不是最新的。
8 days ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. indexing
  3. Chinese (Simplified)
Knowing the size of the query rectangle is not enough to pin down whether a query will return a large number or small number of records. Below, the red square is small, but will return many more records than the blue square.
了解查询矩形的大小不足以确定查询是否会返回大量记录或少量记录。下面，红色方块很小，但会返回比蓝色方块更多的记录。
8 days ago
Browse all translation changes