3 tips to manage large Postgres databases

Try these handy solutions to common problems when dealing with huge databases. » Elizabeth Garrett Christensen | opensource.com

28 de febrero de 2023 · 1 min · 18 palabras · Nacho Cano

Optimitzar servidor de PostgreSQL usando PGTune

Tener un servidor de bases de datos optimizado es crucial para una buena respuesta de nuestra aplicación web. Ya sea un blog personal o una instancia de Peertube, es recomendable configurar correctamente los servidores de bases datos para que las consultas sean lo más rápidas… » _ voidNull | voidnull.es

14 de septiembre de 2022 · 1 min · 50 palabras · Nacho Cano

Top Heroku Alternatives for free

Recently Heroku will shutdown free Heroku Dynos, free Heroku Postgres, and free Heroku Data… » DEV Community | dev.to

8 de septiembre de 2022 · 1 min · 19 palabras · Nacho Cano

How to optimize PostgreSQL queries from Django using pgMustard

Slow queries happen, and when they do, it can be tough to dissect why they’re slow. This difficulty is compounded by using Django’s ORM, since it generates the SQL for you, so you may have little idea of the actual queries “under the hood”. » adamj.eu | adamj.eu

14 de julio de 2022 · 1 min · 48 palabras · Nacho Cano

Django News - Django, HTMX and Alpine.js - Dec 3rd 2021

PostgreSQL views in Django, the well maintained test, encrypting data archives, and more. » django-news.com | django-news.com

26 de diciembre de 2021 · 1 min · 17 palabras · Nacho Cano

Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL

How and why Linux HugePages are important for PostgreSQL database servers. » Jobin Augustine | percona.com

12 de octubre de 2021 · 1 min · 16 palabras · Nacho Cano

PostgreSQL 14 – Performance, Security, Usability, and Observability

Today saw the launch of PostgreSQL14, so let’s look at what the community has done to improve performance for heavy transactional workloads and additional support for distributed data. » Umair Shahid | percona.com

4 de octubre de 2021 · 1 min · 33 palabras · Nacho Cano

Django News - Python 3.10 and PostgreSQL 14 Release - Oct 1st 2021

Django 4.0 test features, tutorials on templates and DRF, Django for Everybody videos, and more. » django-news.com | django-news.com

2 de octubre de 2021 · 1 min · 19 palabras · Nacho Cano

How to Install and Run PostgreSQL Using Docker

Learn how to install and run PostgreSQL using Docker, as well as the benefits of using PostgreSQL Docker containers to enable efficient database management. » Rafael Galinari | percona.com

12 de septiembre de 2021 · 1 min · 29 palabras · Nacho Cano

Creating concurrent indexes without down time in Django + PostgreSQL

We need to add indexes to tables to speed up the select query time. Applying indexes on the large databases is quite expensive. so, for this kinds of cases we need to create the indexes concurrently. Let » agiliq.com | agiliq.com

31 de julio de 2021 · 1 min · 41 palabras · Nacho Cano