Postgres Pro
Downloads
Home   >   mailing lists

Re: Large number of partitions of a table - Mailing list pgsql-admin

From Ron
Subject Re: Large number of partitions of a table
Date
Msg-id 6c8f3a3d-e3c3-10c6-8311-b01606b937e7@gmail.com
Whole thread Raw
In response to Re: Large number of partitions of a table  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Large number of partitions of a table  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view
On 1/17/22 9:14 AM, David G. Johnston wrote:
On Mon, Jan 17, 2022 at 7:58 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Ron <ronljohnsonjr@gmail.com> writes:
> On 1/16/22 11:38 PM, Victor Sudakov wrote:
>> so no query should ever have to use more than 1 partition.

> I find it hard to believe that you'll *never* run a report against more
> customers than are in a single partition.

Yeah, I'm a little suspicious of that.

Is "never" really the correct threshold here? 

That's what OP wrote, and that's what we're dubious about.  Users who know a bit too much to be dangerous write a scary about of unexpected queries.

--
Angular momentum makes the world go 'round.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Large number of partitions of a table
Next
From: Scott Ribe
Date:
Subject: Re: Large number of partitions of a table