Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/indexing/changes/?format=api
{ "count": 713, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/changes/?format=api&page=2", "previous": null, "results": [ { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": null, "user": null, "author": null, "timestamp": "2025-12-27T03:59:39.208557Z", "action": 47, "target": "", "id": 2257325, "action_name": "Alert triggered", "url": "https://weblate.osgeo.org/api/changes/2257325/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/robe/?format=api", "author": null, "timestamp": "2025-09-26T06:54:22.972621Z", "action": 17, "target": "", "id": 2224333, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2224333/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99592/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/robe/?format=api", "author": "https://weblate.osgeo.org/api/users/robe/?format=api", "timestamp": "2025-09-26T06:49:48.434766Z", "action": 2, "target": "El vacuuming es tan crítico para la ejecución eficiente de la base de datos que PostgreSQL proporciona una facilidad de \"autovacuum\" predeterminada.", "id": 2224328, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2224328/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99592/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/robe/?format=api", "author": "https://weblate.osgeo.org/api/users/robe/?format=api", "timestamp": "2025-09-26T06:49:48.426179Z", "action": 45, "target": "", "id": 2224327, "action_name": "Contributor joined", "url": "https://weblate.osgeo.org/api/changes/2224327/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": null, "author": null, "timestamp": "2025-09-04T23:47:42.685924Z", "action": 17, "target": "", "id": 2217837, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2217837/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99574/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T22:07:59.014205Z", "action": 2, "target": "`ST_Equals <http://postgis.net/docs/ST_Equals.html>`_", "id": 2217776, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2217776/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": null, "author": null, "timestamp": "2025-08-31T22:39:39.852125Z", "action": 17, "target": "", "id": 2216720, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2216720/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:43:34.519941Z", "action": 1, "target": "", "id": 2216685, "action_name": "Translation completed", "url": "https://weblate.osgeo.org/api/changes/2216685/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2264921/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:43:34.451913Z", "action": 2, "target": "Para añadir aceleración por índices a otras funciones que no están en esta lista (la más habitual, `ST_Relate <http://postgis.net/docs/ST_Relate.html>`_) hay que añadir una clausula de indexación como la descrita debajo.", "id": 2216684, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2216684/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99600/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:42:53.713023Z", "action": 5, "target": "http://postgis.net/docs/support/rtree.pdf", "id": 2216683, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216683/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99598/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:42:53.632784Z", "action": 5, "target": "`ST_Intersects(geometry_a, geometry_b) <http://postgis.net/docs/ST_Intersects.html>`_: Devuelve TRUE si las geometrías/geografías \"intersectan espacialmente\" (comparten alguna porción del espacio) y FALSE si no lo hacen (son disjuntas).", "id": 2216682, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216682/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2264923/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:42:43.040584Z", "action": 5, "target": "`geometry_a ~= geometry_b <http://postgis.net/docs/ST_Geometry_Same.html>`_: Devuelve TRUE si la caja envolvente de A es igual a la caja envolvente de B.", "id": 2216681, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216681/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2264922/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:42:34.968888Z", "action": 5, "target": "`geometry_a = geometry_b <http://postgis.net/docs/ST_Geometry_EQ.html>`_: Antes de PostGIS 2.4 devuelve TRUE si la caja envolvente de A es la misma que la de B. A partir de la versión 2.4 devuelve TRUE solo si la geometría de A es la misma que la de B.", "id": 2216680, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216680/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99596/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:42:28.293869Z", "action": 5, "target": "`geometry_a && geometry_b <http://postgis.net/docs/geometry_overlaps.html>`_: Devuelve TRUE si la caja envolvente de A se superpone con la de B.", "id": 2216679, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216679/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99594/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:42:21.107967Z", "action": 5, "target": "Vacuuming y analizar la base de datos pueden realizarse por separado según sea necesario. Ejecutar el comando ``VACUUM`` no actualizará las estadísticas de la base de datos; del mismo modo, ejecutar un comando ``ANALYZE`` no recuperará filas de tabla no usadas. Ambos comandos pueden ejecutarse contra toda la base de datos, una sola tabla o una sola columna.", "id": 2216678, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216678/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99593/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:42:14.499667Z", "action": 5, "target": "Autovacuum tanto vacía (recupera espacio) como analiza (actualiza estadísticas) tus tablas en intervalos razonables determinados por el nivel de actividad. Aunque esto es esencial para bases de datos altamente transaccionales, no es recomendable esperar una ejecución de autovacuum después de añadir índices o cargar datos masivamente. Siempre que se realice una actualización en lote grande, debes ejecutar manualmente ``VACUUM``.", "id": 2216677, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216677/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99592/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:42:04.475761Z", "action": 5, "target": "El vacuuming es tan crítico para la ejecución eficiente de la base de datos que PostgreSQL proporciona una facilidad de \"autovacuum\" predeterminda.", "id": 2216676, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216676/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99591/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:41:47.586011Z", "action": 5, "target": "Vale la pena enfatizar que simplemente crear un índice no es suficiente para permitir que PostgreSQL lo use de manera efectiva. Se debe realizar VACUUM siempre que se ejecuten un gran número de UPDATEs, INSERTs o DELETEs contra una tabla. El comando ``VACUUM`` le pide a PostgreSQL recuperar cualquier espacio no usado en las páginas de la tabla dejado por actualizaciones o eliminaciones de registros.", "id": 2216675, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216675/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99590/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:41:36.390503Z", "action": 5, "target": "Vacuuming", "id": 2216674, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216674/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99589/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:41:36.173915Z", "action": 5, "target": "El comando ``ANALYZE`` le pide a PostgreSQL recorrer la tabla y actualizar sus estadísticas internas usadas para la estimación de planes de consulta (el análisis de planes de consulta se discutirá más adelante).", "id": 2216673, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216673/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99588/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:41:28.317527Z", "action": 5, "target": "Para asegurarte de que las estadísticas coincidan con el contenido de tu tabla, es recomendable ejecutar el comando ``ANALYZE`` después de cargas masivas de datos y eliminaciones en tus tablas. Esto fuerza al sistema de estadísticas a recopilar datos de todas tus columnas indexadas.", "id": 2216672, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216672/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99587/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:41:21.917756Z", "action": 5, "target": "Para determinar con qué situación se enfrenta (leer una pequeña parte de la tabla versus leer una gran porción de la tabla), PostgreSQL mantiene estadísticas sobre la distribución de datos en cada columna indexada de la tabla. Por defecto, PostgreSQL recopila estadísticas de forma regular. Sin embargo, si cambias dramáticamente el contenido de tu tabla en un corto periodo de tiempo, las estadísticas no estarán actualizadas.", "id": 2216671, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216671/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99585/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:41:13.082410Z", "action": 5, "target": "Saber el tamaño del rectángulo de la consulta no es suficiente para determinar si una consulta devolverá un número grande o pequeño de registros. Abajo, el cuadrado rojo es pequeño, pero devolverá muchos más registros que el cuadrado azul.", "id": 2216670, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216670/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99584/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:41:05.699261Z", "action": 5, "target": "El planificador de consultas de PostgreSQL elige de forma inteligente cuándo usar o no usar índices para evaluar una consulta. Contraintuitivamente, no siempre es más rápido hacer una búsqueda con índice: si la búsqueda va a devolver todos los registros de la tabla, recorrer el árbol del índice para obtener cada registro será en realidad más lento que leer secuencialmente toda la tabla desde el principio.", "id": 2216669, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216669/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99583/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:40:58.483931Z", "action": 5, "target": "Analizando", "id": 2216668, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216668/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99582/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:40:54.777277Z", "action": 5, "target": "¡Una respuesta mucho menor! La primera consulta sumó todos los bloques cuya caja envolvente intersecta la caja envolvente del vecindario; la segunda consulta solo sumó aquellos bloques que intersectan el vecindario mismo.", "id": 2216667, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216667/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99580/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:40:48.754392Z", "action": 5, "target": "Comparemos una consulta solo con índice para la población de 'West Village' con una consulta más exacta. Usando :command:`&&` nuestra consulta solo con índice se ve así:", "id": 2216666, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216666/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99579/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:40:43.426750Z", "action": 5, "target": "Para hacer una búsqueda por bounding-box usando el índice (y sin filtrado), usa el operador :command:`&&`. Para geometrías, el operador :command:`&&` significa \"las cajas envolventes se superponen o se tocan\" de la misma forma en que para números el operador :command:`=` significa \"los valores son iguales\".", "id": 2216665, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216665/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99577/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:40:33.589716Z", "action": 5, "target": "Consultas solo con índice", "id": 2216664, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216664/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99550/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-31T21:40:25.539178Z", "action": 5, "target": "En la figura anterior, el número de líneas que intersectan la estrella amarilla es **una**, la línea roja. Pero las cajas envolventes de las entidades que intersectan la caja amarilla son **dos**, la roja y la azul.", "id": 2216663, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216663/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": null, "author": null, "timestamp": "2025-08-29T06:47:42.162526Z", "action": 17, "target": "", "id": 2215072, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2215072/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99599/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:54:49.442837Z", "action": 5, "target": "Nota al pie", "id": 2214813, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214813/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99599/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:54:49.440230Z", "action": 45, "target": "", "id": 2214812, "action_name": "Contributor joined", "url": "https://weblate.osgeo.org/api/changes/2214812/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-06T06:30:52.597473Z", "action": 17, "target": "", "id": 2136211, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2136211/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340143/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-06T06:23:24.976188Z", "action": 2, "target": "Det är värt att betona att det inte räcker att bara skapa ett index för att PostgreSQL ska kunna använda det effektivt. VACUUMING måste utföras när ett stort antal UPDATEs, INSERTs eller DELETEs utfärdas mot en tabell. Kommandot ``VACUUM`` ber PostgreSQL att återta allt oanvänt utrymme på tabellsidorna som lämnas av uppdateringar eller raderingar till poster.", "id": 2136198, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2136198/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340102/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-06T06:23:00.992933Z", "action": 2, "target": "Klausulen ``USING GIST`` säger till PostgreSQL att använda den generiska indexstrukturen (GIST) när man bygger indexet. Om du får ett fel som ser ut som ``FEL: indexrad kräver 11340 byte, maximal storlek är 8191`` när du skapar ditt index, har du sannolikt försummat att lägga till klausulen ``USING GIST``.", "id": 2136197, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2136197/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-06T06:20:23.669744Z", "action": 17, "target": "", "id": 2136182, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2136182/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340141/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-06T05:55:26.256783Z", "action": 2, "target": "Kommandot ``ANALYZE`` ber PostgreSQL att korsa tabellen och uppdatera dess interna statistik som används för uppskattning av frågeplan (frågeplananalys kommer att diskuteras senare).", "id": 2136114, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2136114/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340152/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": null, "author": "https://weblate.osgeo.org/api/users/anonymous/?format=api", "timestamp": "2025-06-05T00:40:21.386789Z", "action": 29, "target": "Fotnoter", "id": 2135743, "action_name": "Suggestion removed during cleanup", "url": "https://weblate.osgeo.org/api/changes/2135743/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340147/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": null, "author": "https://weblate.osgeo.org/api/users/anonymous/?format=api", "timestamp": "2025-06-05T00:40:21.325885Z", "action": 29, "target": "Funktionslista", "id": 2135742, "action_name": "Suggestion removed during cleanup", "url": "https://weblate.osgeo.org/api/changes/2135742/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T17:47:56.746400Z", "action": 17, "target": "", "id": 2135697, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2135697/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340153/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:29:22.193900Z", "action": 9, "target": "http://postgis.net/docs/support/rtree.pdf", "id": 2134585, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134585/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340152/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:29:22.174164Z", "action": 9, "target": "Fotnoter", "id": 2134584, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134584/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340151/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:29:22.141612Z", "action": 9, "target": "`ST_Intersects(geometry_a, geometry_b) <http://postgis.net/docs/ST_Intersects.html>`_: Returnerar TRUE om geometrierna/geografin \"spatialt korsar varandra\" - (delar någon del av utrymmet) och FALSE om de inte gör det (de är disjunkta).", "id": 2134583, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134583/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340150/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:29:22.110034Z", "action": 9, "target": "`geometry_a ~= geometry_b <http://postgis.net/docs/ST_Geometry_Same.html>`_: Returnerar SANT om A:s avgränsande box är lika med B:s avgränsande box.", "id": 2134582, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134582/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340149/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:29:22.089145Z", "action": 9, "target": "`geometry_a = geometry_b <http://postgis.net/docs/ST_Geometry_EQ.html>`_: Före PostGIS 2.4 returnerar true om A:s bounding box är densamma som B:s. Från 2.4 och framåt Returnerar SANT endast om A:s geometri är densamma som B:s.", "id": 2134581, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134581/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340148/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:29:22.068284Z", "action": 9, "target": "`geometry_a && geometry_b <http://postgis.net/docs/geometry_overlaps.html>`_: Returnerar SANT om A:s avgränsande box överlappar B:s.", "id": 2134580, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134580/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340147/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:29:22.047141Z", "action": 9, "target": "Funktionslista", "id": 2134579, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134579/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340146/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:29:21.661024Z", "action": 9, "target": "Vacuuming och analys av databasen kan utföras separat efter behov. Kommandot ``VACUUM`` uppdaterar inte databasstatistiken, och kommandot ``ANALYZE`` återställer inte heller oanvända tabellrader. Båda kommandona kan köras mot hela databasen, en enstaka tabell eller en enstaka kolumn.", "id": 2134577, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134577/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340145/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/indexing/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:29:21.639594Z", "action": 9, "target": "Autovacuum både dammsuger (återställer utrymme) och analyserar (uppdaterar statistik) dina tabeller med förnuftiga intervall som bestäms av aktivitetsnivån. Även om detta är viktigt för databaser med många transaktioner, är det inte tillrådligt att vänta på en autovacuum-körning efter att ha lagt till index eller laddat upp data. Varje gång en stor batchuppdatering utförs bör du manuellt köra ``VACUUM``.", "id": 2134576, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134576/?format=api" } ] }