pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres on L2ARC
2+ messages / 2 participants
[nested] [flat]
* Postgres on L2ARC
@ 2023-01-24 01:18 Joseph Hammerman <joe.hammerman@datadoghq.com>
0 siblings, 1 reply; 2+ messages in thread
From: Joseph Hammerman @ 2023-01-24 01:18 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres on L2ARC
@ 2023-01-24 03:39 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Joseph Hammerman <joe.hammerman@datadoghq.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Ribe @ 2023-01-24 03:39 UTC (permalink / raw)
To: Joseph Hammerman <joe.hammerman@datadoghq.com>; +Cc: pgsql-admin@lists.postgresql.org
> On Jan 23, 2023, at 6:18 PM, Joseph Hammerman <joe.hammerman@datadoghq.com> wrote:
>
> 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.
Yes. It worked fine, but much smaller and less busy than what you're probably planning for. Originally, Ubuntu 16 & older ZFS, PG data was on mirrorz SSD, with other SSD partitions for L2ARC & ZIL. Later, at a major update, I did some benchmarking, and got rid of the SSD dedicated to ZFS. Then the SSD became entirely ZIL & L2ARC, and PG shared L2ARC with other data.
So, to be clear, in this case the reason for having PG use L2ARC with spinning rust behind it was that the PG did not need dedicated SSD for performance...
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-01-24 03:39 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-01-24 01:18 Postgres on L2ARC Joseph Hammerman <joe.hammerman@datadoghq.com>
2023-01-24 03:39 ` Scott Ribe <scott_ribe@elevated-dev.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox