Node.js with PostgreSQL - Strange 'Cache Hit' Behavior in Sequelize During Bulk Insert
I'm getting frustrated with I'm sure I'm missing something obvious here, but Hey everyone, I'm running into an issue that's driving me crazy... I'm experiencing unexpected behavior when performing bulk inserts using Sequelize with PostgreSQL. Despite running the bulk insert operation, I'm seeing that it sometimes returns cached results rather than reflecting the latest state in the database. This is happening when I run the inserts in quick succession, and the result is that some entries seem to be missing from the database after the operation completes. Here's the code snippet I'm using for the bulk insert: ```javascript const { Sequelize, DataTypes } = require('sequelize'); const sequelize = new Sequelize('postgres://user:password@localhost:5432/mydb'); const Item = sequelize.define('Item', { name: { type: DataTypes.STRING, allowNull: false }, value: { type: DataTypes.INTEGER, allowNull: false } }); async function bulkInsertItems(items) { try { await Item.bulkCreate(items); console.log('Insert complete'); } catch (error) { console.error('Error during bulk insert:', error); } } const itemsToInsert = [ { name: 'Item1', value: 10 }, { name: 'Item2', value: 20 }, { name: 'Item3', value: 30 } ]; bulkInsertItems(itemsToInsert); ``` I also tried disabling caching in PostgreSQL by setting `CACHE_SIZE` to 0, but it didn't seem to help. Additionally, I've confirmed that I am not using the `findAll` method immediately after the insert before the database has had time to update. I’ve even added some logging to see the response from the database, and it still reports a 'Cache Hit'. Could this be related to Sequelize's internal transaction management? Is there a best practice for ensuring that bulk inserts are committed and reflected correctly in the database? Any insights would be greatly appreciated, as I'm starting to think I might be overlooking something fundamental in my use of Sequelize with PostgreSQL. I've been using Javascript for about a year now. Is this even possible?