openpolitics.com

  • writing
  • quotes
  • Topics
    • academia
    • corruption
    • economics
    • education
    • environment
    • finance
    • history
    • hypertext
    • media
    • philosophy
    • psychology
    • religion
    • russia
    • ted nelson
  • about
← Previous Next →

Tuning Filesystem for Postgres (page 63/101)

Turns out default ZFS block size is 128 Kb, and Postgres page size is 8K

Every small write that touched a page, had to write 128 Kb of a ZFS block to the disk

This may be good for huge sequential writes, but not for random access, lots of tiny writes

source: $link[host]

Tags: postgres, scalability

Read Original Source

Tim Langeman © 2026 · Genesis Framework · WordPress · Log in