מדרש אויף תהילים 16:4

יִרְבּ֥וּ עַצְּבוֹתָם֮ אַחֵ֪ר מָ֫הָ֥רוּ בַּל־אַסִּ֣יךְ נִסְכֵּיהֶ֣ם מִדָּ֑ם וּֽבַל־אֶשָּׂ֥א אֶת־שְׁ֝מוֹתָ֗ם עַל־שְׂפָתָֽי׃

זאָלן מערן זײערע געצן די װאָס אײַלן צו אַן אַנדערן; איך װעל ניט גיסן זײערע גיסאָפּפֿער פֿון בלוט, און ניט נעמען זײערע נעמען אױף מײַנע ליפּן.

Midrash Tehillim

You said something else to God. David said before the Almighty, "Even though I was a king, Your Kingship is upon me." The Almighty replied, "I don't hold your goodness against you, but to whom do I hold the Saints in the land? The Almighty doesn't call the righteous holy until they are given the land and until the day of death. Why did the Evil Inclination make people in this world and not believe in them until the day of death? Similarly, Solomon said, "There is no righteous person on earth who does good and does not sin" (Ecclesiastes 7:20). Therefore, one is not called holy until they are given the land. Even the Patriarchs were not called holy until they were given the land. As it says, "Behold, in His holy ones He will not trust" (Job 15:15). And when did He trust them? When He said to Moses, "Go and gather the elders of Israel" (Exodus 3:16). From this, Moses inferred and said, "Remember Abraham, Isaac, and Israel, Your servants" (Exodus 32:13). Rabbi Pinchas said, "The forefathers of the world wanted their dwelling to be above, and even so, they were not called holy until they were given the land and the exile was closed before them." Rabbi Chama asked, "What is the verse that states, 'He drags the mighty with His power'? This is the Evil Inclination. 'Mighty with his power' refers to the generation of Enosh, the generation of the Flood, the generation of the Dispersion, and the people of Sodom, as it is written, 'In pain shall you eat of it' (Genesis 3:17), and it says, 'I will increase your pain and your travail' (Genesis 3:16). He increased their pain, referring to the forefathers of the world. Did they lose anything? Scripture says, 'I will not pour out their drink offerings of blood' (Psalm 16:4). As we learned, they went down and returned from the war and recited the Shema in the chamber of hewn stone....
פֿרעגט אַ רבֿBookmarkShareCopy

Midrash Tehillim

Another thing that angered them was when King David said that many of his generation would suffer greatly and die for the sanctification of God's name. The Lord said to him that their sacrifices were not in vain, for their blood was more precious to Him than sacrifices. Rabbi Yehudah said in the name of Rabbi Idi that suffering was divided into three parts: one part was taken by the ancestors and all generations, one part by the generation of the destruction of the Temple, and one part by the generation of the Messiah. What did the generation of the destruction of the Temple do? They would bring iron balls and flatten them under their breasts, giving up their lives for the sanctification of God's name. And they would also bring reeds and put them under their fingernails, and in this way, they died for the sanctification of God's name.
פֿרעגט אַ רבֿBookmarkShareCopy

Midrash Tehillim

Another thing that will increase their frustration. David said before the Creator of the world that people who rush to come before Him but delay in leaving cause them much distress. And when they were told to pour libations for foreign worship and He said, "I will not pour." "I will not slaughter" "I will not drink water in a red cup." They say to him, "Swear in the name of foreign worship." And He says, "I will not swear." As Moses taught us, "Do not mention the names of other gods or let them be heard from your mouth." But God is my allotted portion and cup. Rabbi Yehuda said in the name of Reish Lakish, "What does 'support my lot' mean? This lot should support me at Sinai."
פֿרעגט אַ רבֿBookmarkShareCopy