On Wed, Jul 16, 2025 at 8:42 PM Greg Sabino Mullane
wrote:
> On Wed, Jul 16, 2025 at 9:25 AM Amol Inamdar wrote:
>
>>
>>1. NFS mount point is for /nfs-mount/postgres (and permissions locked
>>down so that Postgres cannot create directories in here)
>>2. Postgres data directory is /nf
Hi Dinesh,
Yes, that is correct.
Regards,
Kiran
On Tue, Jul 15, 2025 at 11:43 PM DINESH NAIR
wrote:
>
> Hi Kiran,
>
> Are we trying to perform logical replication from create replication slots
> on a standby server and use logical decoding plugins(JDBC
> PGReplicationStream API) to stream chan
On Thu, Jul 17, 2025 at 8:55 PM Craig Ringer
wrote:
[snip]
>
> FS-based sizing isn't really enough
>
>
> Asking users to monitor at the filesystem level works, kind-of, but
> it'll lead to confusion due to WAL and temp files in simple installs.
> To get decent results they will n
Hi everyone,
I wanted to share a project I've been working on that enables PostgreSQL to run
on S3 storage while maintaining performance comparable to local NVMe. The
approach uses block-level access rather than trying to map filesystem
operations to S3 objects.
ZeroFS: https://github.com/Barr
On Fri, 2025-07-18 at 00:57 +0200, Pierre Barre wrote:
> Looking forward to your feedback and questions!
I think the biggest hurdle you will have to overcome is to
convince notoriously paranoid DBAs that this tall stack
provides reliable service, honors fsync() etc.
Performance is great, but it i
Hi all
(Long time!)
I recently ran into an issue where a monitoring component was calling
pg_catalog.pg_database_size() at a ~15s interval on a large
schema-sharded database. It took so long that the query was timing out
before the next 15s scrape interval would start.
The resulting filesystem m
On Fri, 18 Jul 2025 at 12:54, Craig Ringer
wrote:
> [...]
> I recently ran into an issue where a monitoring component was calling
> pg_catalog.pg_database_size() at a ~15s interval on a large
> schema-sharded database. It took so long that the query was timing out
> before the next 15s scrape inte
