On Mon, Jun 9, 2025 at 3:28 PM Dilip Kumar wrote:
>
> On Mon, Jun 9, 2025 at 2:03 PM Nikita Malakhov wrote:
> > 4) Update-heavy partitioned tables that should run vacuum frequently.
> > Significant
> > vacuum slowdown would result in going beyond SLAs without corresponding
> > significant impro
On Wed, Jun 11, 2025 at 1:08 AM Bruce Momjian wrote:
>
> On Mon, Jun 9, 2025 at 05:51:25PM -0400, Bruce Momjian wrote:
> > On Mon, Jun 9, 2025 at 03:28:38PM +0530, Dilip Kumar wrote:
> > There are certainly use cases where this would be helpful, but I think
> > the big question is whether it wou
On Tue, Jun 10, 2025 at 3:21 AM Bruce Momjian wrote:
Thanks Bruce for your thoughts on this.
> On Mon, Jun 9, 2025 at 03:28:38PM +0530, Dilip Kumar wrote:
> > On Mon, Jun 9, 2025 at 2:03 PM Nikita Malakhov wrote:
> > > Global Indexes is a very interesting functionality that has both
> > > sig
On Mon, Jun 9, 2025 at 05:51:25PM -0400, Bruce Momjian wrote:
> On Mon, Jun 9, 2025 at 03:28:38PM +0530, Dilip Kumar wrote:
> There are certainly use cases where this would be helpful, but I think
> the big question is whether it would have so many negatives that most
> people who try to use it w
On Mon, Jun 9, 2025 at 03:28:38PM +0530, Dilip Kumar wrote:
> On Mon, Jun 9, 2025 at 2:03 PM Nikita Malakhov wrote:
> > Global Indexes is a very interesting functionality that has both
> > significant advantages
> > and drawbacks, and the community seems not ready to accept it without very
> >
On Mon, Jun 9, 2025 at 2:03 PM Nikita Malakhov wrote:
>
> Hi Dilip!
Thanks Nikita for your response and reading my proposal.
> Global Indexes is a very interesting functionality that has both significant
> advantages
> and drawbacks, and the community seems not ready to accept it without very
Hi Dilip!
Global Indexes is a very interesting functionality that has both
significant advantages
and drawbacks, and the community seems not ready to accept it without very
strong
motivation.
There was a more recent approach to Global index problem [1], please check
it out.
I've read you proposal
On Fri, Jun 6, 2025 at 1:01 PM wenhui qiu wrote:
>
> Hi Dilip Kumar
>Thank you for your working on this ,I remember six years ago there was
> talk about global index ，You can see if this mailing list has any references
> to
> (https://www.postgresql.org/message-id/CALtqXTcurqy1PKXzP9XO%3Dof
Hi Dilip Kumar
Thank you for your working on this ,I remember six years ago there was
talk about global index ，You can see if this mailing list has any
references to (
https://www.postgresql.org/message-id/CALtqXTcurqy1PKXzP9XO%3DofLLA5wBSo77BnUnYVEZpmcA3V0ag%40mail.gmail.com
)
Thanks
On Fri
PostgreSQL’s table partitioning allows large tables to be broken into
smaller, more manageable pieces for better performance. However, a key
limitation currently is the absence of global indexes, which restricts
using partitioned tables, especially when you need unique constraints
on columns that a
10 matches
Mail list logo
