On 10/19/22 04:47, Dominique Devienne wrote:
[snip]
> PS: Another drawback of lo is that because it's a single table, it
> still subject to the 32 TB limit on a relation.
> The 4TB limit per lo is way more than we need, but the 32 TB limit
> may actually be more of an issue for
> our larger clients, which have thousands of projects, each with
> upwards of a few millions of those blobs.
Partition the table on the first segment of the Primary Key. From
experience, anything else can lead to serious query degradation.
--
Angular momentum makes the world go 'round.