Postgres
How do I check the files that are in my postgres database, and delete files that are not needed?
ID Project: 166d3751-42cb-4032-8849-ca8f64aac2f7
5 Replies
Project ID:
166d3751-42cb-4032-8849-ca8f64aac2f7what is your use case for doing this? You should not be messing with the files used in your database unless you know what you’re doing
I need to get 2000 PDF files from Google Drive and send them to OpenAi, but my Postgres was full when I started downloading the binary file, I needed to increase my limit. It would be interesting to store them in a temporary file.
Postgres should not be used for object storage. Use a cloud bucket like Amazon S3 https://aws.amazon.com/s3/
Amazon Web Services, Inc.
Amazon S3 - Cloud Object Storage - AWS
Amazon S3 is cloud object storage with industry-leading scalability, data availability, security, and performance. S3 is ideal for data lakes, mobile applications, backup and restore, archival, IoT devices, ML, AI, and analytics.
so theoretically it's not the binary files that are in postgres. I'll do more tests