Re: Schema design: user account deletion vs. keeping family tree data - Mailing list pgsql-general

Christoph Pieper <christoph@fecra.de> wrote:
> Question:
> From a PostgreSQL point of view (database best practices, data integrity, performance and long‑term maintainability
atmillions of rows), which approach would you prefer, or is there a better pattern for this kind of “account can be
deleted,but genealogy should remain” use case? 

I can tell you what I'm doing. It solved many design problems, but I
don't claim it's "best practice". I split my table in two.
    1 - columns that I can keep indefinitely
    2 - personal data
That way I just delete the personal data row when I want to remove it.

Thanks, Bernice