Search Postgresql Archives

Re: Regarding use of single column as primary key on partitioned table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ron Johnson <ronljohnsonjr@xxxxxxxxx> writes:
> On Sat, Sep 28, 2024 at 12:39 AM David G. Johnston <
> david.g.johnston@xxxxxxxxx> wrote:
>> On Friday, September 27, 2024, Durgamahesh Manne <
>>> Can't we use primary key on singal column(betid) on partitioned table
>>> rather than using composite key (placedon,betid)?

>> No.  It would be misleading to allow such a thing because a unique index
>> can only span a single partition.

> That is IMO a serious (and probably unfixable, given how PG stores tables)
> flaw in PG's partitioning design.

You can call it a flaw if you want, but it's an intentional design
limitation.  The only way to relax it would be to invent global
indexes (that is, single indexes covering the entire partitioning
tree), which would basically throw away every advantage of making
a partitioned structure in the first place.  If that's what you
want, don't partition your table.

			regards, tom lane





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux