each data type in PostgreSQL has a specific alignment requirement. When multiple attributes are stored consecutively in a tuple, padding is inserted before an attribute so that it begins from the required aligned boundary. A better understanding of these alignment requirements may help to min...
A great practice to ensure you’re using as little storage as possible is to consistently monitor the number of dead tuples in each table.This is the first step towards putting together an efficient PostgreSQL storage management strategy. To see pages and tuples in action, you can use pgstatt...
A few weeks back, I discussed how Transparent Data Encryption safeguards your data even in case an attacker gets hold of your files. So this week I would like to talk about how PostgreSQL maps database objects into actual files. Let's dive in. A quick recap In mylast blog postI showed...
Connecting PostgreSql to C# windows forms Connecting to Remote Server (Linux) from .NET application(C#) to run a UNIX script hosted on linux server Connecting to remote server outlook.office365.com failed with the following error message : Access is denied. Connection refused if I use 127.0.0.1...
In PostgreSQL, when a row is updated, the actual process is to mark the original row deleted (old value) and then insert a new row (new value). This causes dead tuple generation, and if not cleared up by vacuum can cause bloat. This bloat can lead to unnecessary spac...
modifications. As you can imagine, PostgreSQL will keep as many versions of the same tuple as the number of concurrent transactions at any time and make the last committed version visible to the consecutive transactions. Eventually, this creates dead tuples in pa...
During the VACUUM run, which may take hours if the database is big, the database is, from a production standpoint, practically dead. Please note: in PostgreSQL version 7.2, basic vacuuming no longer locks tables, thus allowing normal user access during the vacuum. A new VACUUM FULL command...
Connecting PostgreSql to C# windows forms Connecting to Remote Server (Linux) from .NET application(C#) to run a UNIX script hosted on linux server Connecting to remote server outlook.office365.com failed with the following error message : Access is denied. Connection refused if I use 127.0.0.1...
Active Directory problem: Check if a user exists in C#? Active Directory User does not assign User logon name and User Principal Name AD LDS cannot ChangePassword, but it can SetPassword Add <?xml version="1.0" encoding="UTF-8" standalone=...
Connecting PostgreSql to C# windows forms Connecting to Remote Server (Linux) from .NET application(C#) to run a UNIX script hosted on linux server Connecting to remote server outlook.office365.com failed with the following error message : Access is ...