• The way PG store null value in record - Highgo Software Inc.

  

  highgo.ca

  How Postgres Stores 'null' Values — Good news – you almost certainly don’t need to know this, but intrigue always gets the better of me..

  • Add  

  1

Appears in lists (1)

• Issue 378 - How medium-sized text columns can impact table performance

More like this (3)

• Exploring SQL command changes in PG-14 - Highgo Software Inc.

  

  highgo.ca

  A Few SQL Command Changes Coming in Postgres 14 — CREATE TRIGGER gets an OR REPLACE...

  A Few SQL Command Changes Coming in Postgres 14 — CREATE TRIGGER gets an OR REPLACE option to create a trigger even if one exists with the same name already. You’ll also be able to specify column aliases without AS in many situations.

  • Read
  • Add  

  
• The mapping of oid and relfilenode in PG - Highgo Software Inc.

  

  highgo.ca

  The Mapping of oid and relfilenode — Technical ‘under the covers’ stuff about how the location...

  The Mapping of oid and relfilenode — Technical ‘under the covers’ stuff about how the location of tables are tracked internally. Few people need to understand this, but perhaps many more would like to :-)

  • Read
  • Add  

  1
• Types of Indexes in PostgreSQL

  

  highgo.ca

  Types of Indexes in PostgreSQL B-Tree index is the default index. But you know we have...

  Types of Indexes in PostgreSQL B-Tree index is the default index. But you know we have no one size fit all data structure for fast look up. What if we just want an exact match? Well, a hash index might faster there.

  • Read
  • Add  

  1