In Java world, for this purpose I tend to use JPA/Hibernate with Envers
http://www.jboss.org/envers - db vendor agnostic solution.
Kind regards,
Stevo Slavic.
On Tue, Jan 8, 2013 at 6:32 AM, Craig Ringer wrote:
> On 4/01/2013 12:09 AM, Adrian Klaver wrote:
> > On 01/03/2013 07:38 AM, Rich Shep
Hello all,
I've initially brought the question to Nix, so I'll try to clarify
situation.
Whole point is to have multiple services accessing same table and
dividing the work, so locking with waiting for lock to be released is
out of question.
I want to deploy same Java Spring Web applicatio
Hello PostgreSQL community,
Two tables, A and B, both with auto generated technical PK, A and B are in
relationship via nullable non-unique FK a_fk column in B to A's PK. There
are no other relationships involving table A. Lets say A has ~20k rows, and
B ~500k rows.
When there is no index on a_fk
of lack of information of changes in Bs.
Will check and see how that performs for both scenarios.
Kind regards,
Stevo.
On Mon, May 28, 2012 at 4:40 PM, Adrian Klaver wrote:
> On 05/28/2012 07:23 AM, Stevo Slavić wrote:
>
>> Hello PostgreSQL community,
>>
>> Two tabl
