Doesn't postgres have a columnar option? If so, you could prob get better performance for your analytical interactions if you switched some tables to columnar.

Doesn't postgres have a columnar option? If so, you could prob get better performance for your analytical interactions if you switched some tables to columnar. Otherwise check out postgres scanner. https://github.com/duckdblabs/postgres_scanner https://github.com/duckdblabs/postgres_scanner They have a blog entry about it too: https://motherduck.com/blog/duckdb-ecosystem-newsletter-two/ https://motherduck.com/blog/duckdb-ecosystem-newsletter-two/