Postgres Pro
Downloads
Home   >   mailing lists

Re: Question on overall design - Mailing list pgsql-general

From Dominique Devienne
Subject Re: Question on overall design
Date
Msg-id CAFCRh-_T34JN-1gfKfNOmLb=C-+wrSHY8qwG2bc+Ord=vbQzew@mail.gmail.com
Whole thread Raw
In response to Re: Question on overall design  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Question on overall design
List pgsql-general
Tree view
On Sun, Dec 10, 2023 at 5:56 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
* We departitioned because SELECT statements were slow.  All partitions were scanned, even when the partition key was specified in the WHERE clause.

Surely that's no the case on newer PostgreSQL, is it? Otherwise what's the point of partitioning?
Also, I remember reading something about recent improvements with a large number of partitions, no?

As someone who's interested on partitioning, I'd appreciate details. Thanks, --DD

pgsql-general by date:

Previous
From: veem v
Date:
Subject: Re: Question on overall design
Next
From: Chris Travers
Date:
Subject: Re: running \copy through perl dbi ?