From: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
---|---|
To: | Роман Осипов <osipovromanvladimirovich(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: Incorrect number of rows inserted into partitioned table |
Date: | 2023-04-10 21:39:07 |
Message-ID: | 4561fe9b-e303-dc28-1a3e-1b5aab626395@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 4/10/23 20:42, Роман Осипов wrote:
> Good afternoon
>
> When reloading data from a simple table into a partitioned (through
> inheritance) using a query like:*insert into [new_partition_table]
> select * from [old_table] limit xxxxxxx*;
>
> There is an insertion not of the amount specified in *limit*,, but a
> little more or less than it.
>
Which version? I did try this on master, and I can't reproduce it - the
count at the end returns the correct value (1M).
The rule affects the insert status, which looks e.g. like this:
INSERT 0 611532
instead of 1M, but that's expected because of the rule, I think.
FWIW I wonder why you use rules, it's rather tricky to get that right,
which is why the usual recommendation is not to use this if there's an
alternative way to do stuff (which for partitioning there is).
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Роман Осипов | 2023-04-10 21:58:15 | Re: Incorrect number of rows inserted into partitioned table |
Previous Message | David Rowley | 2023-04-10 21:36:16 | Re: Incorrect number of rows inserted into partitioned table |