Hello,
I need some ideas for creating a PG based logger. I have got a job, which can run more than one time. So the PK is at
themoment jobid & cycle number.
The inserts in this table are in parallel with the same username from different host (clustering). The user calls in
theexecutable "myprint" and the message
will insert into this table, but at the moment I don't know a good structure of the table. Each print call can be
differentlength, so I think a text field is a good
choice, but I don't know how can I create a good PK value. IMHO a sequence can be create problems that I'm logged in
withthe same user on multiple
hosts, a hash key value like SHA1 based on the content are not a good choice, because content is not unique, so I can
getkey collisions.
I would like to create on each "print" call a own record in the table, but how can I create a good key value and get no
problemsin parallel access.
I think there can be more than 1000 inserts each second.
Does anybody can post a good idea?
Thanks
Phil