Empty Tables
For some reason after a day or two, I find all my tables empty (no records). Only tables. Is that something normal (I have a Free tier)?
4 Replies
wise-white•16mo ago
Hey đź‘‹
I don't think that it is normal for your tables to be empty after a day or two, even on the free tier. Do you by any chance have any cron jobs setup in your application that could be causing this? Or are you exposing any delete routes via your API that could allow users to truncate your tables?
wise-white•16mo ago
On another note, are you by any chance using unlogged tables?
https://neon.tech/docs/reference/compatibility#unlogged-tablesIf so, keep in mind that unlogged tables in Neon are maintained on compute local storage and do not survive compute restarts so this could explain the behavior that you are seeing
Neon
Postgres compatibility - Neon Docs
Neon is Postgres. However, as a managed Postgres service, there are some differences you should be aware of. Postgres versions Neon supports Postgres 14, 15, and 16. You can select the Postgres versio...
solid-orangeOP•16mo ago
Thanks, this is quite clear explanation. I will have to study this a bit further
wise-white•16mo ago
No worries at all! Let me know if anything else pops up