Postgres on L2ARC

From: Joseph Hammerman <joe(dot)hammerman(at)datadoghq(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Postgres on L2ARC
Date: 2023-01-24 01:18:33
Message-ID: CAHs7QM-SHvb8kwHXCat4WEP0RP7BzQv9aF-HUDP2qbKx2jB-pw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi pgsql admins,

Has anyone built a Postgers architecture using L2ARC, and potentially
TABLESPACES to mount the ZFS pools (dedicated one per table). I am
imagining the ZFS pools would be backed by EBS volumes.

Theoretically this seems like it would map well to a random read workload,
make it possible to organically grow the devices by adding new RAID
volumes, and help make the individual nodes more "stateless".

Thanks in advance for any insight or guidance anyone can providence on this
matter,
Joe

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2023-01-24 03:39:45 Re: Postgres on L2ARC
Previous Message Erik Wienhold 2023-01-23 21:41:20 Re: Upgrade 12->13 stuck due to postgis / raster issue