"Nik" <[EMAIL PROTECTED]> wrote
> I have an application that executes an INSERT statement every second or
> two. In my old design this data was inserted into one table. However, I
> changed the design to have one table with multiple partitions. Now when
> I run the application it runs for some random amount of time (random
> number of INSERTs) and then it gets stuck at the INSERT query and it
> never finishes (at least not in some reasonable time - aka few hours).
> If I restart the application it continues inserting the data normally
> for a while before getting stuck again.
>
Do you do INSERT concurrently? Can you post a self-contained example to
reproduce it?
Regards,
Qingqing
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
