Psalms 146:4 "His spirit goes out, he goes back to his ground; In that day his thoughts do perish."
So, does this scripture deal with the condition of the dead or what happens to it.
Quickely note that there are two compnets to 'his thoughts do perish', a) His spirit goes out, b)he goes back to his ground. We know that when the spirit goes out active thought stops yet, also, the body decomposes or returns to what it is made from, dust. Thus one could conclude the brains knowledge of how to think may be the part which perishes for the reason(s) that Jesus likened death at least, at this stage to a sleep or rest. In other words the things which make you, you to yourself, conscious identity, memories, mental and emotional attitudes and inclinations..., are still there in the body and to Jesus bring this back to life was as simple as awakening one from a sleep. John 11:11
It's true that when you die, you will be non-exsitant to yourself* but to those charged with responsibility in the ressurection its reasonable they will incorporate the particular dust which makes you, you to yourself into the dust which is built, formed, or made into a body. Just for you. Ecclesiastes 9:10
*The scriptures recognise a heavenly ressurection
"I