Skip to content

Split tables based on column hotness  #7908

@Gargron

Description

@Gargron

Because postgres internally copies the entire row when any column is updated (this is cleaned up during a vacuum), having tables with many columns that update often is more IO and faster table growth.

Things like counter caches should be moved out to separate tables and queried with a join.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions