Partitioning: INSERT 0 0 but want INSERT 0 1

From: "Nikolas Everett" <nik9000(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Partitioning: INSERT 0 0 but want INSERT 0 1
Date: 2008-05-12 16:18:57
Message-ID: d4e11e980805120918v3e225defm7f6d48a722cecfdb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I figure this subject belongs on the performance mailing list because it is
about partitioning, which is a performance issue.

I'm working on partitioning some of the tables used by an application that
uses OpenJPA. It turns out that OpenJPA is sensitive to the numbers
returned when you do an insert. So I put together a test and attached it.
My postgres version is 8.3.1 compiled from source.

My problem is that this:
test=> INSERT INTO ttt (a, b) VALUES ('5-5-08', 'test11212');
INSERT 0 0
Time: 21.646 ms
needs to show:
INSERT 0 1

or OpenJPA will not accept it. The insert works, but OpenJPA does not
believe it and aborts the current transaction.

Is it possible to have partitioning and have insert show the right number of
rows inserted?

Thanks,

--Nik

Attachment Content-Type Size
testdump.sql text/plain 11.0 KB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Neil Peter Braggio 2008-05-12 22:27:55 Re: Partitioning: INSERT 0 0 but want INSERT 0 1
Previous Message Tom Lane 2008-05-11 00:30:39 Re: Re: Re: Re: Query Optimization with Kruskal’s Algorithm