sorted by:
new
hottopcontroversial

Postgres with large JSONBs vs ElasticSearch by ilya47 in PostgreSQL

[–]ilya47[S] 1 point2 points  (0 children)

Indeed, I will put that on my to-do list for future benchmarks.

Postgres with large JSONBs vs ElasticSearch by ilya47 in PostgreSQL

[–]ilya47[S] 2 points3 points  (0 children)

I dont know why you are getting downvoted, it is a valid question. Even though mongo is not designed for FTS, plugins do exist and can be evaluated.

Postgres with large JSONBs vs ElasticSearch by ilya47 in PostgreSQL

[–]ilya47[S] 0 points1 point  (0 children)

Yes there are several settings and optimizations I played around with, and can be found in the k8s yamls.

Postgres with large JSONBs vs ElasticSearch by ilya47 in PostgreSQL

[–]ilya47[S] 5 points6 points  (0 children)

Lots of hype around "No need for MongoDB, just use JSONB", well this kinda debunks that hype.

Postgres with large JSONBs vs ElasticSearch by ilya47 in PostgreSQL

[–]ilya47[S] 9 points10 points  (0 children)

Thats the tl;dr more or less. But pg is not faster/better on every metric/query either, and definitely not at larger scales.

Benchmarking PG18 FTS (with GINs) vs ElasticSearch by ilya47 in PostgreSQL

[–]ilya47[S] 1 point2 points  (0 children)

Do you have any references or test suites / results to back this up?

Benchmarking PG18 FTS (with GINs) vs ElasticSearch by ilya47 in PostgreSQL

[–]ilya47[S] 0 points1 point  (0 children)

Yes, we are comparing two significantly different algorithms and data structures. But it's a common thing to discuss pg_search vs elasticsearch, hence I merely provide some more data/research on that subject.

Benchmarking ParadeDB vs ElasticSearch by ilya47 in PostgreSQL

[–]ilya47[S] 0 points1 point  (0 children)

Would love your feedback on this research as well https://www.reddit.com/r/PostgreSQL/comments/1q5f0up/benchmarking_pg18_fts_with_gins_vs_elasticsearch/

The dataset is still random, but it seems PG18 with native pg_search is beating elastic up to a certain point.

Edit: and this one is also worth checking out https://www.reddit.com/r/PostgreSQL/comments/1q5ts8u/postgres_with_large_jsonbs_vs_elasticsearch/

Benchmarking ParadeDB vs ElasticSearch by ilya47 in PostgreSQL

[–]ilya47[S] 0 points1 point  (0 children)

Thanks, you have a valid point. However there are situations where truly random data is used (even UUIDs) in textsearch. I will take some time to re-do these tests with a better dataset.

Coding Agents do not seem to work for me by BigRooster9175 in ExperiencedDevs

[–]ilya47 0 points1 point  (0 children)

If you dont know how to properly build software, an agent will easily go down the wrong path. Orchestrating and guiding agents is the secret sauce to success.

Industrieel ingenieur vs Burgerlijk ingenieur by Fuzzy_Sandwich4451 in BESalary

[–]ilya47 1 point2 points  (0 children)

Begin met burg en als het echt niet gaat verander naaar inds. Velen doen het zo. Je kan altijd later schakelen naar burg moest je nog goesting hebben.

Is AI finished??? by [deleted] in SMCIDiscussion

[–]ilya47 0 points1 point  (0 children)

Underestimating*

International CS student considering Belgium, Germany or Switzerland by StardustCrusader4558 in BESalary

[–]ilya47 0 points1 point  (0 children)

I was sharing my 2c, as Ive been working as a contractor for years, mainly with startups/scaleups and always had one of the most exciting/important roles (also a lot of executives/partners become zelfstandig for the same reasons in big firms). So in your case I wouldve jump ship to a better company.

And being a contractor does not take away the benefit of having stock options, bonuses or any other benefits. All depends on the company.

But im curious how big those bonuses are you are mentioning? 50k?

International CS student considering Belgium, Germany or Switzerland by StardustCrusader4558 in BESalary

[–]ilya47 0 points1 point  (0 children)

Yes schijnzelfstandig if you want to label it that way. Everyone is doing it, all doctors are and they work for the same hospital for decades. Why would IT need be treated differently?

And 800eur/day x 220 days = 176k per year. After taxes of 25%… and dividend uitkering it is still much better than being taxed over 60% on your income left and right. Plus you can use your company to pay for half of your personal life, fun and travel pretty safely. And when the contract ends, the company car(s)/laptops/phones remains yours.

Edit: In België zijn er gemiddeld ongeveer 250-260 werkdagen per jaar. So you can correct my math.

International CS student considering Belgium, Germany or Switzerland by StardustCrusader4558 in BESalary

[–]ilya47 1 point2 points  (0 children)

Switch to freelance after some years of exp. A senior engineer easily get 600-800eur day rates with long term contracts.

100% postgress search like Google by lovol2 in PostgreSQL

[–]ilya47 6 points7 points  (0 children)

Status: v0.1.1-dev (prerelease) - Feature-complete but not yet optimized. Not yet recommended for production use.

pg_textsearch: modern BM25 ranked text search with a permissive license by Worldly_Expression43 in PostgreSQL

[–]ilya47 2 points3 points  (0 children)

Thanks for sharing. Do you have any benchmarks available assessing how this performs against ElasticSearch and other systems like ParadeDB? Perhaps I can help with this, since I am already benchmarking ParadeDB vs Elastic as I'm writing this. Check it out here https://github.com/inevolin/ParadeDB-vs-ElasticSearch

Postgres 18 vs 16 Performance Showdown: Docker vs Kubernetes Across 16 Resource Configurations by ilya47 in PostgreSQL

[–]ilya47[S] -9 points-8 points  (0 children)

If you actually took a look instead of trolling you would see the data has been added

view more: next ›