Comments on: PostgreSQL Column Alignment and Padding – How To Improve Performance With Smarter Table Design https://www.percona.com/blog/postgresql-column-alignment-and-padding-how-to-improve-performance-with-smarter-table-design/ Fri, 01 Mar 2024 07:04:01 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Rishabh https://www.percona.com/blog/postgresql-column-alignment-and-padding-how-to-improve-performance-with-smarter-table-design/#comment-10974273 Fri, 01 Mar 2024 07:04:01 +0000 https://www.percona.com/blog/?p=94370#comment-10974273 “We are not considering variable-length data types here because they are not as straightforward” – Please write an article on this.

Also does the same concept apply to MySQL (InnoDB)?

]]> By: David Burns https://www.percona.com/blog/postgresql-column-alignment-and-padding-how-to-improve-performance-with-smarter-table-design/#comment-10974269 Mon, 19 Feb 2024 14:19:55 +0000 https://www.percona.com/blog/?p=94370#comment-10974269 I would be very interested in a follow-on article on variable-length columns.

]]> By: Aravinth Manogaran https://www.percona.com/blog/postgresql-column-alignment-and-padding-how-to-improve-performance-with-smarter-table-design/#comment-10974265 Wed, 14 Feb 2024 07:21:20 +0000 https://www.percona.com/blog/?p=94370#comment-10974265 Ideally it should have designed to store all the fixed length data types serially and should be handled with meta data definition during run time.

]]>