Postgres Pro
Downloads
Home   >   mailing lists

Postgres on L2ARC - Mailing list pgsql-admin

From Joseph Hammerman
Subject Postgres on L2ARC
Date
Msg-id CAHs7QM-SHvb8kwHXCat4WEP0RP7BzQv9aF-HUDP2qbKx2jB-pw@mail.gmail.com
Whole thread Raw
Responses Re: Postgres on L2ARC  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: Upgrade 12->13 stuck due to postgis / raster issue
Next
From: Scott Ribe
Date:
Subject: Re: Postgres on L2ARC