PostgreSQL - DROP posthog_event table

[guidoiaquinti]

Is your feature request related to a problem?

As we don't host events into PostgreSQL anymore, we should:

1. cleanup all the code still referencing the table
2. drop the table

Describe the solution you'd like

See above

Describe alternatives you've considered

Do nothing

Additional context

See internal Slack conversation.

[sreeo]

Can I pick this up?

[guidoiaquinti]

👋 Hey @sreeo, thank you for volunteering but I think @macobo is already working on it. See:

• Remove more pg Events table usage #8662
• Delete postgres/events-related code: pg queries #8638

[macobo]

Took a few PRs but the posthog_events table is no longer being read in any of our code.

PRs:

• Delete old events-model adjacent code #8623
• Remove action.calculate_events() #8624
• Remove dead actions endpoint code #8625
• Delete postgres/events-related code: pg queries #8638
• Remove weekly email code #8643
• Clear clickhouse in delete_events/ test endpoint #8661
• Remove more pg Events table usage #8662
• properties_to_Q: don't support event model anymore #8667

We still have the model in codebase (as it's referenced via some other tables) and haven't dropped the actual table. I think this is good enough for now and we can TRUNCATE this in production.

I'd avoid adding a migration to drop/truncate to avoid potential pain with postgres-users accidentally updating at some future date.

[guidoiaquinti]

Nice work 👏 Let's keep this issue open till we actually drop the table.

[posthog-bot]

This issue hasn't seen activity in two years! If you want to keep it open, post a comment or remove the stale label – otherwise this will be closed in two weeks.

[posthog-bot]

This issue was closed due to lack of activity. Feel free to reopen if it's still relevant.