SELECT
    v.c
FROM dbo.Posts AS p
CROSS APPLY
(
    SELECT
        c = COUNT_BIG(*)
    FROM dbo.Votes AS v
    WHERE v.PostId >= p.Id
    AND   v.PostId <= p.Id
) AS v
WHERE p.Id = 11227809
OPTION
(
    RECOMPILE,
    QUERYTRACEON 8649
);

SELECT
    c = COUNT_BIG(*)
FROM dbo.Votes AS v
WHERE v.Id IN
(
    67850443,
    60039034,
    60039033,
    59983271,
    59973912,
    59973911,
    59965675,
    59965674
)
AND 1 = (SELECT 1)
OPTION
(
    USE HINT('ENABLE_PARALLEL_PLAN_PREFERENCE'),
    QUERYTRACEON 8649
);

<span id="span-8-117606" class="ct-span">Why do I have a slow COMMIT in PostgreSQL?</span>

<title>
    Why do I have a slow COMMIT in PostgreSQL? | CYBERTEC PostgreSQL | Services &amp; Support
</title>

Msg 701, Level 17, State 28
There is insufficient system memory in resource pool 'default' to run this query.

Optimization Queue (internal)
---------------------------------
80.16 gb

Message
Failed allocate pages: FAIL_PAGE_ALLOCATION 1

SELECT
    p.Id,
    v.c
FROM dbo.Posts AS p
CROSS APPLY
(
    SELECT
        c = COUNT_BIG(*)
    FROM dbo.Votes AS v
    WHERE v.PostId >= p.Id
    AND   v.PostId <= p.Id
) AS v
WHERE p.Id IN
(
    11227806, 11227810, 11227820, 11227824,
    11227826, 11227827, 11227831, 11227833,
    1368149, 17463071, 11227809
)
ORDER BY
    p.Id
OPTION
(
    RECOMPILE,
    QUERYTRACEON 8649
);

DECLARE @100 integer = 100;

SELECT TOP (@100) PERCENT
    u.Id,
    u.Reputation,
    u.DisplayName,
    p.AvgScore
FROM dbo.Users AS u
JOIN
(
    SELECT
        p.OwnerUserId,
        p.PostTypeId,
        AvgScore =
            AVG(p.Score)
    FROM dbo.Posts AS p
    WHERE p.PostTypeId IN (1, 2)
    AND   EXISTS
    (
        SELECT
            1/0
        FROM dbo.Votes AS v
        WHERE v.PostId  = p.Id
        AND   v.VoteTypeId IN (2, 3)
    )
    GROUP BY
        p.OwnerUserId,
        p.PostTypeId

CREATE TABLE #Results
(
    Id integer NOT NULL,
    Reputation integer NOT NULL,
    DisplayName nvarchar(40) COLLATE DATABASE_DEFAULT NOT NULL,
    AvgScore integer NOT NULL,
    INDEX c CLUSTERED (AvgScore DESC)
);