Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
3d 75% 78 1,670 10,298 78 0 0 0
about_data 75% 185 1,595 10,660 185 75 0 0
advanced_geometry_construction 83% 57 1,286 7,936 57 10 0 0
backup 58% 210 5,011 31,509 210 8 0 0
clusterindex 75% 42 1,166 7,006 42 2 0 0
creating_db 72% 44 653 4,298 44 7 0 0
de9im 80% 45 855 5,120 45 0 0 0
equality 85% 12 397 2,475 12 0 0 0
geography 71% 149 2,987 21,545 148 1 1 0
geography_exercises 75% 42 470 3,188 42 8 0 0
geometries 83% 132 2,265 16,369 132 14 0 0
geometries_exercises 75% 106 804 6,482 106 22 0 0
geometry_returning 68% 71 1,759 12,660 71 4 3 0
geometry_returning_exercises 80% 28 346 2,370 28 23 1 0
history_tracking 83% 41 854 5,031 41 1 0 0
index CC-BY-3.0-US 80% 58 332 2,886 50 12 2 0
indexing 83% 62 1,318 9,331 62 37 0 0
installation CC-BY-3.0-US 92% 16 215 1,488 16 0 0 0
introduction 75% 239 4,007 27,949 239 59 8 1
joins 83% 35 868 5,703 35 0 1 0
joins_advanced 80% 40 763 4,781 40 0 0 0
joins_exercises 85% 29 266 1,937 29 18 0 0
knn 83% 15 429 2,591 15 0 0 0
license 75% 6 112 808 6 0 0 0
linear_referencing 66% 46 1,106 7,858 46 1 3 0
loading_data 56% 288 6,454 41,947 288 1 2 0
postgis-functions 85% 41 281 2,254 40 43 2 0
projection 85% 31 832 5,577 31 1 0 0
projection_exercises 83% 28 291 1,977 28 18 0 0
rasters CC-BY-3.0-US 66% 418 11,916 76,156 418 10 4 0
schemas 80% 36 698 4,263 36 0 1 0
security 80% 66 1,208 7,948 66 2 1 0
simple_sql 62% 101 1,795 11,990 101 2 2 0
simple_sql_exercises 75% 86 698 5,050 86 29 0 0
spatial_relationships 75% 83 1,730 12,735 83 9 0 0
spatial_relationships_exercises 83% 30 324 2,271 30 19 0 0
topology CC-BY-3.0-US 80% 61 1,634 10,453 61 4 2 0
topology_base_types 0 0 0 0 20 0 0
topology_topo_types 0 0 0 0 23 0 0
tuning 66% 92 2,196 14,212 92 20 3 0
upgrades 85% 34 594 3,714 34 2 0 0
validity 83% 34 797 5,076 34 1 0 0
welcome 78% 46 645 3,922 46 4 0 0
Glossary glossary 1 CC-BY-3.0-US 52% 205 2,645 21,657 205 0 31 0

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar yellow73 User avatar jef User avatar astrid_emde User avatar dmateos User avatar dkastl User avatar jsanz User avatar cvvergara User avatar andischi User avatar komzpa
Translation license CC-BY-3.0-US index installation rasters topology glossary 1
3 hours ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 14,379 262,859 1,743,543
Source 2,189 40,970 269,165
Translated 75% 10,911 74% 196,587 74% 1,300,062
Needs editing 1% 10 1% 78 1% 575
Read-only 15% 2,189 15% 40,970 15% 269,165
Failing checks 3% 510 1% 1,920 1% 19,454
Strings with suggestions 1% 67 1% 294 1% 2,263
Untranslated strings 24% 3,458 25% 66,194 25% 442,906
Last 12 months Previous

Activity in last 12 months

597 changes 5 changes 324 changes 65 changes 335 changes 3 changes 227 changes 0 changes 1,754 changes 42 changes 58 changes 697 changes 67 changes 106 changes 774 changes 12 changes 71 changes 6,205 changes 8 changes 50 changes 45 changes 2,258 changes 9 changes 1,170 changes
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep

Quick numbers

262 k
Hosted words
14,379
Hosted strings
75%
Translated
3
Contributors
and previous 30 days

Trends of last 30 days

+4%
Hosted words
+100%
+5%
Hosted strings
+100%
+11%
Translated
+64%
+66%
Contributors
+100%
User avatar None

Resource updated

  1. postgis-workshop
  2. spatial_relationships_exercises
  3. Spanish
The "postgis-intro/sources/locale/es/LC_MESSAGES/spatial_relationships_exercises.po" file was changed. 10 days ago
User avatar None

Repository rebased

  1. postgis-workshop
  2. index
Repository rebased

Original revision: 60356e8553121909fcd0bb33322177d7b62f4386
New revision: 1cb0b0861ab58b2bdec7454c1353c004c522a4b9 10 days ago
User avatar None

Repository notification received

  1. postgis-workshop
  2. index
GitHub: https://api.github.com/repos/postgis/postgis-workshops, master 10 days ago
User avatar robe

Changes pushed

  1. postgis-workshop
  2. index
Changes pushed 10 days ago
User avatar None

Changes pushed

  1. postgis-workshop
  2. index
Changes pushed 10 days ago
User avatar robe

Changes committed

  1. postgis-workshop
  2. tuning
  3. Spanish
Changes committed 10 days ago
User avatar robe

Translation changed

  1. postgis-workshop
  2. tuning
  3. Spanish
In addition to the memory PostgreSQL sets aside for ``shared_buffers`` the query planner also takes into account how many disk blocks the operating system may have cached as part of its virtual file system. For systems with large amount of memory, this can be quite large. The ``effective_cache_size`` is approximately the amount of memory on the machine, less the ``shared_buffers``, less the ``work_mem`` times the expected number of connections, less any memory required for any other processes running on the machine, less about 1GB for other random operating system needs. The database will not **use** the extra cache directly, but it will compute plans expecting that the operating system has cached filesystem data in about that much memory.
Además de la memoria que PostgreSQL reserva para ``shared_buffers``, el planificador de consultas también tiene en cuenta cuántos bloques de disco puede haber almacenado en caché el sistema operativo como parte de su sistema de archivos virtual. En sistemas con grandes cantidades de memoria, esto puede ser bastante elevado. El ``effective_cache_size`` es aproximadamente la cantidad de memoria de la máquina, menos ``shared_buffers``, menos ``work_mem`` multiplicado por el número esperado de conexiones, menos cualquier memoria requerida para otros procesos que se estén ejecutando en la máquina, menos alrededor de 1GB para otras necesidades aleatorias del sistema operativo. La base de datos no usará directamente esta memoria adicional como caché, pero calculará planes suponiendo que el sistema operativo ha almacenado en caché datos del sistema de archivos en aproximadamente esa cantidad de memoria.
10 days ago
User avatar robe

Changes pushed

  1. postgis-workshop
  2. index
Changes pushed 10 days ago
User avatar None

Changes pushed

  1. postgis-workshop
  2. index
Changes pushed 10 days ago
User avatar robe

Changes committed

  1. postgis-workshop
  2. simple_sql_exercises
  3. Ukrainian
Changes committed 10 days ago
Browse all project changes