Postgres Deadlock when updating other collections in `afterChange` hook

Hi all,

We're using Payload with a Postgres 17 server for the database (using

). Nothing is running in a function, so we aren't using the Vercel package.

However, after switching to Postgres from MongoDB, we've been getting errors like this:

Error processing test: error: canceling statement due to statement timeout
    at async PaymentEvents.hooks.afterChange (src/collections/Test.ts:233:4)
    at async handleCheckoutSessionCompleted (src/app/api/test/route.ts:73:1)
    at async POST (src/app/api/test/route.ts:97:3)
  231 |
  232 |                                 // Update user's credits
> 233 |                                 await req.payload.update({
      |                         ^
  234 |                                         collection: "users",
  235 |                                         id: userId,
  236 |                                         data: { {
  length: 156,
  severity: 'ERROR',
  code: '57014',
  where: 'while locking tuple (0,8) in relation "users"',
  routine: 'ProcessInterrupts'
}

Generally though, Payload will completly freeze and needs to be restarted. The problematic code looks like this:

(the Test collection)

hooks: {
        afterChange: [
            async ({ doc, req, previousDoc }) => {
                const { user, amount, type } = doc;
                const userId = typeof user === "string" ? user : user.id;
                // Get the current user to do something
                const targetUser = await req.payload.findByID({
                    collection: "users",
                    id: userId,
                });
                // Do something with the user
                await req.payload.update({
                    collection: "users",
                    id: userId,
                    data: {
                        some_field: true
                    },
                });
                return doc;

Does anyone have any insight on why this is happening?