21–30 of 126 posts
Co-founder here - AMA.
These queries also deal with permissions & realtime scheduling so endpoint caching doesn't solve it
Have gel users hit any performance issues, and how have they dealt with them?
I mean, I don't need it anymore because I did it myself now, but it definitely annoys me that it's not first class
> PostgreSQL's query planner/optimizer is decidedly state-of-the-art Postgres's cost-based planner is good, but it's a decidedly 1980s design, predating the famous but also outdated Volcano/Cascades systems (used by Microsoft SQL Server and CockroachDB and others). So much has happened in the field of query optimization in the last 30 years, very little of which has ended up in Postgres, I think. Postgres has gotten…
Just wish the local development story wasn't so bound to a installation or the concept of instances. I just want a compose file in my repositories that starts Postgres and "Gel" separately with the option to execute commands within the container I mean, I don't need it anymore because I did it myself now, but it definitely annoys me that it's not first class
Just wish the local development story wasn't so bound to a installation or the concept of instances. I just want a compose file in my repositories that starts Postgres and "Gel" separately with the option to execute commands within the container I mean, I don't need it anymore because I did it myself now, but it definitely annoys me that it's not first class
[1] https://docs.geldata.com/resources/guides/deployment/docker
Just wish the local development story wasn't so bound to a installation or the concept of instances. I just want a compose file in my repositories that starts Postgres and "Gel" separately with the option to execute commands within the container I mean, I don't need it anymore because I did it myself now, but it definitely annoys me that it's not first class
Btw, I want to start them separately because we deploy a standard HA Postgres cluster and want to rely on proven tooling.
[1] https://docs.geldata.com/reference/reference/environment#gel...
Co-founder here - AMA.
How to deal with eventual slow queries? I currently have a system with complex queries with a lot of joins where I had to create a custom materialized table These queries also deal with permissions & realtime scheduling so endpoint caching doesn't solve it Have gel users hit any performance issues, and how have they dealt with them?
Our users do get performance issues, usually because they start really using our data model to its full potential, creating tens / hundreds complex access policies, 100-lines long EdgeQL queries etc. We have EXPLAIN command to deal with, and we also support our customers directly helping them understand and fix their system. All of the findings trickle down to the core product so that the rest can benefit too.
> PostgreSQL's query planner/optimizer is decidedly state-of-the-art Postgres's cost-based planner is good, but it's a decidedly 1980s design, predating the famous but also outdated Volcano/Cascades systems (used by Microsoft SQL Server and CockroachDB and others). So much has happened in the field of query optimization in the last 30 years, very little of which has ended up in Postgres, I think. Postgres has gotten…
Co-founder here - AMA.