postgre 8.0.0 usually "hang" after data reach 10k. How to fix it?
You need to provide a lot more information about your problem:
- DDL for the tables involved
- The SQL being executed
- What exactly does "hang" mean?
- What exactly does "after data reach 10k" mean? The size of the table? The number of rows retrieved? The number of rows inserted? The number of rows deleted?
- Why don't you use a recent version of 8.0 (8.0.24 is the current version of the 8.0 branch)