Trickle Loading Data
After an initial bulk data load is complete, use COPY...TRICKLE
to load data incrementally with new and changed data.
By default, your database uses transaction isolation level READ COMMITTED
. Using this isolation level has these benefits:
- Users can see the most recently committed data without holding any locks.
- New data can be loaded while concurrent queries are running.