When interfacing a PostgreSQL DB using prisma do I still nee Prisma #orm-help

When interfacing a PostgreSQL DB using prisma, do ...

Soumitra Shewale

07/08/2021, 6:23 AM

When interfacing a PostgreSQL DB using prisma, do I still need to run

VACUUM

to reduce disk usage? If yes, how?

Ryan

07/08/2021, 7:19 AM

@Soumitra Shewale 👋 Yes you would need to use

vacuum

as Prisma doesn’t do any of that automatically. You can use

prisma.$executeRaw(vacuum "tableName")

to vacuum the table.

Ryan

07/08/2021, 7:22 AM

In another case, you can also enable autovacuum: https://www.postgresql.org/docs/12/routine-vacuuming.html#AUTOVACUUM I would recommend this so you do not need to do this manually.

👍 1

Soumitra Shewale

07/08/2021, 8:02 AM

Ooh, thanks a lot!

👍 1

4 Views