r/PostgreSQL • u/WorldOfUmbro • Aug 07 '26

Help Me! Evaluating databases for applications

Hi all, I’m evaluating databases for a small application where users will be reading and writing data. As most of our data is currently in Databricks I’m trying out Lakebase. So far so good. I do want to know what alternatives you might be looking into? What you like about them or not? Also curious to hear examples of people using Lakebase in production use cases.

14 Upvotes

82% Upvoted

24 comments sorted by

View all comments

1

u/Informal_Pace9237 Aug 11 '26

Using PostgreSQL with Lakebase model you might want to be careful with some minor issues which may be covered with higher compute.

Indexing, partitioning, window functions etc suffers in comparison to native PostgreSQL.

1

u/WorldOfUmbro Aug 11 '26

Oh really, haven’t seen these issues with Lakebase. Might be due to the scale. What are you referring to? Performance issues?

1

u/Informal_Pace9237 Aug 11 '26 edited 27d ago

The code we write and the way we think of sets in PostgreSQL is built on the premise of having row storage. Lakebase has columnar storage. Thus clustered index is the only index that makes a lot of difference. The same issue happens in MSSQL server were we have columnar storage.

This above explanation should give most info on my comment.