Summary

Project website postgis.net/workshops/postgis-intro
Project maintainers9 User avatar cvvergaraUser avatar dkastlUser avatar komzpaUser avatar astrid_emdeUser avatar dmateosUser avatar jsanzUser avatar andischiUser avatar jefUser avatar yellow73
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 Update sql cheat sheet with makevalid example 5f99414
Paul Ramsey authored 10/30/2025
Last commit in Weblate Translated using Weblate (Spanish) 61fed39
juan sebastian jimenez aldana authored 10/24/2025
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/tuning.po
Translation file Download postgis-intro/sources/locale/sv/LC_MESSAGES/tuning.po
Last change June 6, 2025, 6:30 a.m.
Last change made by None
Language Swedish
Language code sv
Text direction Left to right
Case sensitivity Case-sensitive
Number of speakers 13,338,376
Number of plurals 2
Plural type One/other
Plurals Singular 1
Plural 0, 2, 3, 4, 5, 6, 7, 8, 9, 10, …
Plural formula n != 1
02/26/2026

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 46 1,098 7,106
Translated 100% 46 100% 1,098 100% 7,106
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 10% 5 1% 5 1% 72
Strings with suggestions 2% 1 1% 1 1% 14
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 102 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 0 changes
MarAprMayJunJulAugSepOctNovDecJanFeb

Quick numbers

1,098
Hosted words
46
Hosted strings
100%
Translated
1
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed
Changes committed 06/06/2025
User avatar yeager

Translation changed
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.
Förutom det minne som PostgreSQL avsätter för `` delade shared_buffertar s`` tar frågeplaneraren också hänsyn till hur många diskblock operativsystemet kan ha cachat som en del av dess virtuella filsystem. För system med stor mängd minne kan detta vara ganska stort. Den "``effektiva ctive_cachestorleken"_size`` är ungefär lika stor som maskinens minne, minus de "delade buffertarna", minus "arbetsminnet"``shared_buffers``, minus ``work_mem`` gånger det förväntade antalet anslutningar, minus det minne som krävs för andra processer som körs på maskinen, minus ca 1 GB för andra slumpmässiga behov hos operativsystemet. Databasen kommer inte att **använda** den extra cachen direkt, men den kommer att beräkna planer som förväntar sig att operativsystemet har cachat filsystemdata i ungefär lika mycket minne.
06/06/2025
User avatar None

Changes committed
Changes committed 06/06/2025
User avatar yeager

Translation changed
random_page_cost
slumpmässig_sidkostnadrandom_page_cost
06/06/2025
User avatar yeager

Translation changed
Basic PostgreSQL Tuning
Grundläggande PostgreSQL-tunjustering
06/06/2025
User avatar None

Changes committed
Changes committed 06/04/2025
User avatar yeager

Translation uploaded
Back in pgAdmin, click the server again select *Disconnect*.
Tillbaka i pgAdmin klickar du på servern igen och väljer *Disconnect*.
06/04/2025
User avatar yeager

Translation uploaded
In Windows Services (``services.msc``) right-click **PostgreSQL** and select *Restart*.
I Windows Services (``services.msc``) högerklickar du på **PostgreSQL** och väljer *Restart*.
06/04/2025
User avatar yeager

Translation uploaded
In pgAdmin, right-click the server **PostGIS (localhost:5432)** and select *Disconnect*.
I pgAdmin högerklickar du på servern **PostGIS (localhost:5432)** och väljer *Disconnect*.
06/04/2025
User avatar yeager

Translation uploaded
After these changes are made, save changes and reload the configuration. The easiest way to do this is to restart the PostgreSQL service.
När dessa ändringar har gjorts sparar du ändringarna och laddar om konfigurationen. Det enklaste sättet att göra detta är att starta om PostgreSQL-tjänsten.
06/04/2025
Browse all translation changes