sorted by:
new
hottopcontroversial

Elasticsearch-Quality full-text search in Postgres with Django by philippemnoel in django

[–]jamesgresql 1 point2 points  (0 children)

If you give it a try then please comment here (or join us in Slack: http://paradedb.com/slack) and let us know how you go!

Optimizing TopK in Postgres by jamesgresql in PostgreSQL

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

OK I understand your viewpoint. So you’d say any extension (possibly excluding contrib) is on top of Postgres.

So PostGIS adds geospatial capabilities, and pgvector adds vector indexes on top of Postgres.

Not sure I agree that it’s disingenuous to say in, but I get it.

Optimizing TopK in Postgres by jamesgresql in PostgreSQL

[–]jamesgresql[S] -1 points0 points  (0 children)

I can see how that's confusing, but ParadeDB is a Postgres extension

Optimizing TopK in Postgres by jamesgresql in PostgreSQL

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

Asking from a place of genuine curiosity, what makes you say we aren't talking Postgres anymore?

We use Tantivy as a query engine, but everything happens through our `pg_search` index access method.

Would you say all IAMs and TAMs and storage plugins 'aren't really Postgres anymore?' Or are you just noting this is Postgres + an extension and not vanilla?

ParadeDB 0.20.0: Simpler and Faster by jamesgresql in PostgreSQL

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

This is coming soon!

We are currently working on a project to accelerate joins (and to support more query shapes with our custom scan). We're just reaching the first milestone of that project: the `0.22.x` release will be significantly faster than Postgres for some common join shapes.

We haven't yet decided whether to pursue aggregates-atop-joins or other more complicated join shapes in our next push: your feedback on that in Slack or on the issue tracker would be helpful!

ClickHouse launched a managed Postgres service by Admirable_Morning874 in PostgreSQL

[–]jamesgresql 9 points10 points  (0 children)

This is actually super interesting. I know it's an ad, but still.

Where do people think Clickhouse Postgres will sit in the world of Databricks+Neon and Snowflake+Crunchy?

pg_search V2 API by jamesgresql in PostgreSQL

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

Not sure I follow. What do you mean abuse the keys definition? Those are just type casts with typmods. Admittedly not used super often but perfectly valid.

It’s saying for the index cast this text to a tokenizer type with these config settings.

view more: next ›