Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/tuning/changes/?format=api
{ "count": 318, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/changes/?format=api&page=2", "previous": null, "results": [ { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/es/?format=api", "user": null, "author": null, "timestamp": "2025-09-04T23:47:44.282080Z", "action": 17, "target": "", "id": 2217845, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2217845/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102142/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:09:13.051096Z", "action": 2, "target": "Por lo tanto, debes considerar cuántas conexiones habrá y la complejidad de las consultas esperadas antes de aumentar este valor. El **beneficio** de aumentarlo es el procesamiento de más operaciones —incluyendo cláusulas ORDER BY y DISTINCT, uniones merge y hash, agregaciones basadas en hash y procesamiento de subconsultas con hash— puede realizarse sin incurrir en escrituras a disco. El **costo** de aumentarlo es que la memoria que se usará por conexión, lo que puede ser bastante elevado en niveles de producción con muchas conexiones.", "id": 2217786, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2217786/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/es/?format=api", "user": null, "author": null, "timestamp": "2025-08-29T06:47:43.387654Z", "action": 17, "target": "", "id": 2215076, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2215076/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:35:27.838505Z", "action": 1, "target": "", "id": 2214726, "action_name": "Translation completed", "url": "https://weblate.osgeo.org/api/changes/2214726/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102178/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:35:27.782990Z", "action": 5, "target": "De vuelta en pgAdmin, haz clic nuevamente en el servidor y selecciona *Disconnect*.", "id": 2214725, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214725/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102177/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:35:06.706462Z", "action": 5, "target": "En Servicios de Windows (services.msc), haz clic derecho en **PostgreSQL** y selecciona *Restart*.", "id": 2214724, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214724/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102176/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:34:46.833130Z", "action": 5, "target": "En pgAdmin, haz clic derecho en el servidor **PostGIS (localhost:5432)** y selecciona *Disconnect*.", "id": 2214723, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214723/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102174/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:34:21.650506Z", "action": 5, "target": "Después de realizar estos cambios, guarda y recarga la configuración. La forma más sencilla de hacerlo es reiniciando el servicio de PostgreSQL.", "id": 2214722, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214722/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102173/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:34:11.457333Z", "action": 5, "target": "Recargar configuración", "id": 2214721, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214721/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102172/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:34:07.383965Z", "action": 5, "target": "Valor recomendado: 1.0", "id": 2214720, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214720/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102170/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:33:59.129899Z", "action": 5, "target": "Este parámetro controla el costo de un acceso secuencial a páginas. Generalmente no requiere ajustes, pero la diferencia entre este valor y random_page_cost afecta en gran medida a las decisiones tomadas por el planificador de consultas. Este valor también puede configurarse por sesión.", "id": 2214719, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214719/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102169/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:33:46.213909Z", "action": 5, "target": "seq_page_cost", "id": 2214718, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214718/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102168/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:33:46.090719Z", "action": 5, "target": "Valor recomendado: 2.0 para discos mecánicos, 1.0 para SSD", "id": 2214717, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214717/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102165/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:33:39.368565Z", "action": 5, "target": "Este valor puede establecerse por sesión usando el comando SET random_page_cost TO 2.0, lo cual puede ser útil para probar cómo afecta a los planes de consulta.", "id": 2214716, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214716/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102164/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:33:28.256503Z", "action": 5, "target": "Este es un valor sin unidades que representa el costo de un acceso aleatorio a una página en disco. Este valor es relativo a otros parámetros de costo, incluyendo el acceso secuencial a páginas y los costos de operación de CPU. Aunque no existe un valor único perfecto, el valor predeterminado suele ser conservador y está pensado para bases de datos que funcionan sobre discos mecánicos (spinning media). Para SSD, el costo de acceso aleatorio debería configurarse aún más bajo.", "id": 2214715, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214715/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102163/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:33:13.536444Z", "action": 5, "target": "random_page_cost", "id": 2214714, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214714/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102150/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:33:13.454593Z", "action": 2, "target": "*Valor recomendado*: 128MB", "id": 2214713, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2214713/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102156/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:33:03.666671Z", "action": 2, "target": "*Valor recomendado*: 1MB", "id": 2214712, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2214712/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102162/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:32:46.942872Z", "action": 2, "target": "*Valor recomendado*: 6", "id": 2214711, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2214711/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102162/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:32:33.247314Z", "action": 5, "target": "*Recommended value*: 6", "id": 2214710, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214710/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102160/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:32:33.093086Z", "action": 5, "target": "Como el proceso de punto de control requiere vaciar todas las páginas de datos sucias al disco, crea una carga de E/S significativa. El mismo argumento anterior aplica aquí: los datos geoespaciales son lo bastante grandes para desequilibrar las optimizaciones no geoespaciales. Aumentar este valor evitará puntos de control excesivos, aunque puede hacer que el servidor tarde más en reiniciarse en caso de fallo.", "id": 2214709, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214709/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102158/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:32:24.225607Z", "action": 5, "target": "Este valor define el número máximo de segmentos de archivo de registro (típicamente 16MB) que pueden llenarse entre puntos de control automáticos de WAL (checkpoints). Un punto de control es un punto en la secuencia de transacciones WAL en el que se garantiza que los archivos de datos se han actualizado con toda la información anterior al punto de control. En ese momento, todas las páginas de datos sucias se vacían al disco y se escribe un registro de punto de control en el archivo de log. Esto permite que el proceso de recuperación tras un fallo encuentre el último registro de punto de control y aplique todos los segmentos posteriores para completar la recuperación de datos.", "id": 2214708, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214708/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102157/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:32:09.551570Z", "action": 5, "target": "checkpoint_segments", "id": 2214707, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214707/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102156/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:32:03.405591Z", "action": 5, "target": "*Recommended value*: 1MB", "id": 2214706, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214706/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102154/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:32:03.261674Z", "action": 5, "target": "El tamaño de este búfer solo necesita ser lo suficientemente grande para contener los datos WAL de una transacción típica. Aunque el valor predeterminado suele ser suficiente para la mayoría de los datos, los datos geoespaciales tienden a ser mucho más grandes. Por lo tanto, se recomienda aumentar el tamaño de este parámetro.", "id": 2214705, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214705/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102153/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:31:57.165302Z", "action": 5, "target": "Define la cantidad de memoria utilizada para los registros de escritura anticipada (WAL, write-ahead log). Los WAL proporcionan un mecanismo de alto rendimiento para garantizar la integridad de los datos. Durante cada comando de modificación, los efectos de los cambios se escriben primero en los archivos WAL y se vacían en el disco. Solo una vez que los archivos WAL se han vaciado, los cambios se escriben en los archivos de datos. Esto permite que los archivos de datos se escriban en el disco de manera óptima y asíncrona, asegurando que, en caso de un fallo, todos los cambios de datos puedan recuperarse a partir del WAL.", "id": 2214704, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214704/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102152/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:31:39.232501Z", "action": 5, "target": "wal_buffers", "id": 2214703, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214703/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102150/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:31:35.812878Z", "action": 5, "target": "*Recommended value*: 128MB", "id": 2214702, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214702/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102148/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:31:35.710411Z", "action": 5, "target": "Define la cantidad de memoria utilizada para operaciones de mantenimiento, incluyendo vaciado (vacuum), creación de índices y de claves foráneas. Como estas operaciones no son muy comunes, un valor más alto solo tendrá un costo ocasional y puede acelerar sustancialmente las actividades de mantenimiento. Este parámetro también puede aumentarse para una sola sesión antes de ejecutar varios :command:CREATE INDEX o :command:VACUUM, como se muestra a continuación.", "id": 2214701, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214701/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102146/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:30:12.937180Z", "action": 5, "target": "maintenance_work_mem", "id": 2214700, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214700/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102145/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:30:08.623452Z", "action": 5, "target": "*Recommended value*: 32MB", "id": 2214699, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214699/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102142/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:30:08.499574Z", "action": 5, "target": "Por lo tanto, debes considerar cuántas conexiones habrá y la complejidad de las consultas esperadas antes de aumentar este valor. El\n**beneficio** de aumentarlo es el procesamiento de más operaciones —incluyendo cláusulas ORDER BY y DISTINCT, uniones merge y hash, agregaciones basadas en hash y procesamiento de subconsultas con hash— puede realizarse sin incurrir en escrituras a disco. El **costo** de aumentarlo es que la memoria que se usará por conexión, lo que puede ser bastante elevado en niveles de producción con muchas conexiones.", "id": 2214698, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214698/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102141/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:28:45.821723Z", "action": 5, "target": "Define la cantidad de memoria que las operaciones internas de ordenamiento, operaciones de indexación y tablas hash pueden consumir antes de que la base de datos cambie a usar archivos en disco. Este valor define la memoria disponible para cada operación; las consultas complejas pueden tener varias operaciones de ordenamiento o hash ejecutándose en paralelo, y cada sesión conectada puede estar ejecutando una consulta.", "id": 2214697, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214697/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102140/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:28:27.879455Z", "action": 5, "target": "work_mem", "id": 2214696, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214696/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102139/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:28:27.764924Z", "action": 2, "target": "*Recommended value*: cualquier cantidad de memoria “libre” que se espere tener bajo condiciones normales de operación", "id": 2214695, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2214695/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102139/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:28:16.969497Z", "action": 5, "target": "*Recommended value*: any amount of \"free\" memory expected to be around under ordinary operating conditions", "id": 2214694, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214694/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102138/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:28:16.922177Z", "action": 2, "target": "*Default value*: típicamente 4GB", "id": 2214693, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2214693/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102138/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:28:04.400834Z", "action": 5, "target": "*Default value*: typically 4GB", "id": 2214692, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214692/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102137/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:28:04.281103Z", "action": 2, "target": "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.", "id": 2214691, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2214691/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102137/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:27:54.379954Z", "action": 5, "target": "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.", "id": 2214690, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214690/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102136/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:27:34.279117Z", "action": 5, "target": "effective_cache_size", "id": 2214689, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214689/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102134/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:27:34.114247Z", "action": 2, "target": "*Recommended value*: alrededor del 75% de la memoria de la base de datos hasta un máximo de aproximadamente 2GB", "id": 2214688, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2214688/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102134/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:27:19.886796Z", "action": 5, "target": "*Recommended value*: about 75% of database memory up to a max of about 2GB", "id": 2214687, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214687/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102133/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:27:19.749581Z", "action": 2, "target": "*Default value*: típicamente 32MB", "id": 2214686, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2214686/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102133/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:27:07.796870Z", "action": 5, "target": "Valor por defecto: típicamente 32MB", "id": 2214685, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214685/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102132/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:26:58.262442Z", "action": 5, "target": "Define la cantidad de memoria que el servidor de base de datos utiliza para los búferes de memoria compartida. Estos se comparten entre los procesos de back-end, como su nombre lo indica. Los valores predeterminados suelen ser totalmente inadecuados para bases de datos en producción.", "id": 2214684, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214684/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102131/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:26:41.917122Z", "action": 5, "target": "shared_buffers", "id": 2214683, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214683/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102129/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:26:41.783639Z", "action": 5, "target": "Estos valores son solo recomendaciones; cada entorno será diferente y se requiere hacer pruebas para determinar la configuración óptima. Pero esta sección debería servirte como un buen punto de partida.", "id": 2214682, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214682/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102128/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:26:31.784544Z", "action": 5, "target": "Esta sección describe algunos de los parámetros de configuración que pueden ajustarse para una base de datos geoespacial más preparada para producción.", "id": 2214681, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214681/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102127/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/tuning/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/tuning/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:26:23.034526Z", "action": 5, "target": "Todos estos parámetros de configuración pueden editarse en el archivo de configuración de la base de datos postgresql.conf. Este es un archivo de texto normal y puede editarse con cualquier editor de texto. Los cambios no tendrán efecto hasta que se reinicie el servidor.", "id": 2214680, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214680/?format=api" } ] }