I am correct though that the local DB for gossip does store my posts too right?
Discussion
Yes it would store them. It was not designed to be a permanent record though, and if you "Prune Database" under settings it will erase all text notes older than 1 week, including the ones you created.