InitializeNL.PgPartitionSmith.Auto 1.0.0

InitializeNL.PgPartitionSmith

A PostgreSQL table partitioning toolkit for .NET 10+. Automatically creates and manages partitions at runtime.

Features

• On-demand partition creation with concurrency-safe locking
• Range partitioning (daily, weekly, monthly, quarterly, yearly)
• List partitioning with static or dynamic auto-created partitions
• Nested sub-partitioning (e.g., list by status, then range by date)
• Optional default/remainder partitions
• CLI tool for migrating existing tables to partitioned tables
• In-memory partition cache for fast lookups
• ASP.NET hosted service integration via Microsoft.Extensions.Hosting
• Advisory lock or table-based distributed locking
• Hashed partition names with COMMENT ON TABLE metadata

Packages

Quick Start

As a library

IPartitionManager manager = new PartitionManagerBuilder()
    .UseConnectionString("Host=localhost;Database=mydb")
    .UseAdvisoryLocks()
    .ForTable("events", t => t
        .RangeBy("created_at")
        .Monthly()
        .WithSchema("public"))
    .Build();

await manager.InitializeAsync();

await manager.EnsurePartitionAsync("events", new Dictionary<string, object>
{
    ["created_at"] = DateTime.UtcNow
});

With ASP.NET hosting

services.AddPgPartitionSmith(builder => builder
    .UseConnectionString(connectionString)
    .UseAdvisoryLocks()
    .ForTable("events", t => t
        .RangeBy("created_at")
        .Monthly()));

With entity mapping

var manager = new PartitionManagerBuilder()
    .UseConnectionString(connectionString)
    .ForTable("events", t => t
        .RangeBy("created_at")
        .Monthly()
        .MappedFrom<Event>(e => e.CreatedAt))
    .Build();

await manager.EnsurePartitionAsync(myEvent);

List partitioning with sub-partitions

var manager = new PartitionManagerBuilder()
    .UseConnectionString(connectionString)
    .ForTable("situations", t => t
        .ListBy("status")
        .WithPartition("active", ["active"], child => child
            .RangeBy("period_start").Monthly())
        .WithPartition("finished", ["finished"], child => child
            .RangeBy("period_start").Monthly()))
    .Build();

Pre-creating partitions

await manager.PreCreatePartitionsAsync("events",
    DateTime.UtcNow,
    DateTime.UtcNow.AddMonths(6));

As a CLI

dotnet run --project InitializeNL.PgPartitionSmith.Cli -- \
    --connection-string "Host=localhost;Database=mydb;Username=postgres;Password=secret" \
    --table-name events \
    --query "SELECT json_build_object('partition', json_build_object('type', 'range', ...))::text" \
    --execute

CLI Options

Configuration Options

License

MIT