Sameer Kumar

PostgreSQL has matured into one of the most trusted databases for mission-critical workloads, but scaling it to tens or even hundreds of terabytes is a different game altogether.

SQL Server to PostgreSQL migrations present a complex array of technical differences that can challenge even experienced DBAs - we've seen this firsthand across hundreds of hours spent with customers managing databases from tens of GiBs to several terabytes.

SQL Server to PostgreSQL migrations present a complex array of technical differences that can challenge even experienced DBAs - we've seen this firsthand across hundreds of hours spent with customers managing databases from tens of GiBs to several terabytes.

If you run highly concurrent workload on PostgreSQL, you must have run into some or the other performance issues. Do you know PostgreSQL provides information on where are your queries spending their time via wait events in pg_stat_activity?