Sql

In 2004, I was a new math graduate(Junior Dev) working on an in‑house CRM that was evolving into an ERP. It was a Windows Forms application built with VB.NET and SQL Server (think .NET Framework 1.0/1.1 days - Or we were using that version). One day, a form field became painfully slow. The screen generated a mandate_id that could later become an order_id. The ID was created automatically in the database—an auto-increment primary key plus a few validation checks. Unfortunately, pulling that ID started taking 2–3 minutes. Sales and marketing teams were often on the phone with customers, waiting for the number before they could continue. It was a terrible experience. ...

Fine tuning and optimizing the fill factor in PostgreSQL can significantly impact the performance of your database. The fill factor is a parameter that determines the percentage of a data page to be filled with rows, leaving space for future updates to minimize page splits and improve performance on frequently updated tables. By adjusting the fill factor, you can optimize storage efficiency and reduce the overhead of page splits. To fine-tune the fillfactor for tables and indexes, consider the following: ...

Fillfactor in PostgreSQL is a parameter that sets the percentage of a data page to be filled with rows, leaving space for future updates to minimize page splits and improve performance on frequently updated tables. If you are having a table with a lot of updates, you can set the fillfactor to a lower value to leave space for future updates. The default fillfactor is 100, which means that the table is completely packed with rows. ...