Difference between bulk update with FROM VALUES and without it?

await conn.executemany(
    """
    UPDATE user SET login=$2, name=$3, age=$4, sex=$5
    WHERE id=$1
    """,
    users,
)

await conn.executemany(
    """
    UPDATE user SET login=actual_user.login, name=actual_user.name, age=actual_user.age, sex=actual_user.sex
    FROM (VALUES ($1, $2, $3, $4, $5)) AS actual_user (id, login, name, age::integer, sex::integer)
    WHERE user.id=actual_user.id
    """,
    users,
)

The first is cleaner. But I worry about performance. I know the second is performed as one request. But the first is the same?

Is there any reason to use the second way?

从 asyncpg 的 executemany 入口点和 PostgreSQL 的 UPDATE ... FROM VALUES 语义入手，同时比较 SQL 示例及其请求行为。完成标准是清楚地记录并解释这些方法在性能或用途上是否存在差异，以及第二种形式何时有用。