Translation status

21 Strings
100%
Browse Translate
583 Words
100%
3,503 Characters
100%

Strings status

Strings Words Characters
21 583 3,503
All strings Browse Translate Zen
21 583 3,503
Translated strings Browse Translate Zen

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) cb600c1
Weblate authored 09/04/2025
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/clusterindex.po
Translation file Download postgis-intro/sources/locale/sv/LC_MESSAGES/clusterindex.po
Last change June 4, 2025, 5:47 p.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/04/2026

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 21 583 3,503
Translated 100% 21 100% 583 100% 3,503
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 46 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

583
Hosted words
21
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/04/2025
User avatar yeager

Translation uploaded
`CLUSTER <https://www.postgresql.org/docs/current/sql-cluster.html>`_: Re-orders the data in a table to match the ordering in the index.
`CLUSTER <https://www.postgresql.org/docs/current/sql-cluster.html>`_: Ordnar om data i en tabell så att de stämmer överens med ordningen i indexet.
06/04/2025
User avatar yeager

Translation uploaded
Function List
Funktionslista
06/04/2025
User avatar yeager

Translation uploaded
The difference between "no index" and "index" is generally huge and highly measurable. The difference between "mediocre index" and "great index" usually takes quite careful measurement to discern, and can be very sensitive to the workload being tested.
Skillnaden mellan "inget index" och "index" är i allmänhet enorm och mycket mätbar. Skillnaden mellan "mediokert index" och "bra index" kräver vanligtvis ganska noggranna mätningar för att urskiljas och kan vara mycket känslig för den arbetsbelastning som testas.
06/04/2025
User avatar yeager

Translation uploaded
In theory, yes. In practice, no really. As long as the index is a "pretty good" spatial decomposition of the data, the main determinant of performance will be the order of the actual table tuples.
I teorin, ja. I praktiken inte riktigt. Så länge indexet är en "ganska bra" spatial nedbrytning av data kommer den viktigaste faktorn för prestanda att vara ordningen på de faktiska tabelltuplerna.
06/04/2025
User avatar yeager

Translation uploaded
Does Index Structure Matter?
Har indexstrukturen någon betydelse?
06/04/2025
User avatar yeager

Translation uploaded
System RAM is not the fastest memory on a modern computer. There are several levels of cache between system RAM and the actual CPU, and the underlying operating system and processor will move data up and down the cache heirarchy in blocks. If the block getting moved up happens to include the piece of data the system will need next... that's a big win. Correlating the memory structure with the spatial structure is a way in increase the odds of that win happening.
System-RAM är inte det snabbaste minnet i en modern dator. Det finns flera nivåer av cache mellan systemets RAM-minne och den faktiska processorn, och det underliggande operativsystemet och processorn flyttar data upp och ner i cache-hierarkin i block. Om det block som flyttas upp råkar innehålla den del av data som systemet behöver härnäst är det en stor vinst. Att korrelera minnesstrukturen med den spatiala strukturen är ett sätt att öka oddsen för att den vinsten ska inträffa.
06/04/2025
User avatar yeager

Translation uploaded
Surprisingly, yes. Keeping records that are "near each other" in space "near each other" in memory increases the odds that related records will move up the servers "memory cache heirarchy" together, and thus make memory accesses faster.
Förvånansvärt nog, ja. Att hålla poster som är "nära varandra" i rymden "nära varandra" i minnet ökar oddsen för att relaterade poster kommer att flytta upp i servrarnas "minnescache-hirarki" tillsammans, och därmed göra minnesåtkomster snabbare.
06/04/2025
User avatar yeager

Translation uploaded
Is clustering still necessary?
Är klustring fortfarande nödvändigt?
06/04/2025
User avatar yeager

Translation uploaded
Most modern databases are run using SSD storage, which is much faster at random access than old spinning magnetic media. Also, most modern databases are running on top of data which is small enough to fit into the RAM of the database server, and ends up there as the operating system "virtual filesystem" caches it.
De flesta moderna databaser körs med SSD-lagring, som är mycket snabbare vid slumpmässig åtkomst än gamla roterande magnetiska medier. Dessutom körs de flesta moderna databaser på data som är tillräckligt små för att rymmas i databasserverns RAM-minne och som hamnar där när operativsystemets "virtuella filsystem" lagrar dem i cacheminnet.
06/04/2025
Browse all translation changes