The Noachian flood was targeted at destroying the world of corruption there was a reason for the deluge.
The creation account in Psalm 104 is describing the pre Noachian world so the flood could have been extensive but not global.
The only global flood is found in Genesis 1 which we know today is a fact.
The Creation Genesis 1 HCSB
1 In the beginning God created the heavens and the earth.
[a]
2 Now the earth was
[b] formless and empty, darkness covered the surface of the watery depths, and the Spirit of God was hovering over the surface of the waters.
It does not really matter if one holds to a global flood or not for the Christian audience it has no impact regarding the message of the gospel it is an example of total destruction of evil which the old testament demonstrates God's will, but if you are interested scripture makes it clear there will be no global flood found after Genesis 1 in reality it is an adiaphoron.
.