Profile cover photo
Profile photo
Amit Kapila
81 followers -
Database Internals Architect
Database Internals Architect

81 followers
About
Amit's posts

Post has attachment
New feature for PostgreSQL10.

Post has attachment
Hash indexes are faster than Btree indexes?
PostgreSQL supports Hash Index from a long time, but they are not much used in production mainly because they are not durable.  Now, with the next version of PostgreSQL, they will be durable.  The immediate question is how do they perform as compared to Btr...

Post has attachment
Troubleshooting waits in PostgreSQL
Currently when the PostgreSQL database becomes slow especially on systems with high load, it becomes difficult to find the exact reasons.  Currently one can use tools like perf, strace, dynamic tracing  ( http://www.postgresql.org/ docs/devel/static/dynamic...

Post has attachment
Parallel Sequential Scans in PostgreSQL

Post has attachment
Parallel Sequential Scans in PostgreSQL

Post has attachment
Faster Writes in PostgreSQL

Post has attachment
Wait while more posts are being loaded