Fly.io is offering free Postgres databases for small projects, which includes 3GB of persistent volume space. The free tier is designed for side projects and allows for easy setup and deployment of Postgres databases. The company requires a credit card number to prevent abuse, such as crypto mining, but promises not to charge for the free services. The free Postgres offering is part of Fly.io's larger platform, which allows for easy deployment and management of applications.