u/jamesgresql

537 post karma · 451 comment karma · joined Jul 2015

  1. 0points

    Same Query, Three Results: Benchmarking ParadeDB and Postgres FTS (paradedb.com)

    0 comments · source

  2. 0points

    Same Query, Three Results: Benchmarking ParadeDB and Postgres FTS (paradedb.com) [Community]

    1 comments · source

  3. 1points

    paradedb/benchmarker: a workload agnostic, multi-backend benchmarking tool. (github.com)

    0 comments · source

  4. 0points

    paradedb/benchmarker: a workload agnostic, multi-backend benchmarking tool. (github.com) [Show & Tell]

    0 comments · source

  5. 3points

    paradedb/benchmarker: a workload agnostic, multi-backend benchmarking tool. (github.com)

    0 comments · source

  6. 13points

    paradedb/benchmarker: a k6 based database benchmarking tool. (github.com) [:Love: Check it out]

    1 comments · source

  7. 1points

    paradedb/benchmarker: a k6 based database benchmarking tool. (github.com) [Open Source]

    1 comments · source

  8. 10points

    paradedb/benchmarker: a workload agnostic, multi-backend benchmarking tool. (github.com) [Community]

    1 comments · source

  9. 1points

    A Conversation with Paul Masurel, Creator of Tantivy (paradedb.com)

    1 comments · source

  10. 0points

    A Conversation with Paul Masurel, Creator of Tantivy (paradedb.com)

    0 comments · source

  11. 0points

    A Conversation with Paul Masurel, Creator of Tantivy (paradedb.com)

    3 comments · source

  12. 8points

    Top K is a deceptively hard problem in relational databases (paradedb.com)

    8 comments · source

jamesgresql

Interesting. I didn’t know you were built on DuckDB?

jamesgresql

Curious about your storage engine handles MVCC: does it follow Postgres transaction/snapshot semantics, or is index visibility eventually consistent (more like Elastic)?

jamesgresql

Sure but that’s a massive hassle

jamesgresql

These don’t work because after it runs out you can just hit play again.

jamesgresql

I'm sure it could be a lot of things, but a parent controlled turn off feature (time / count-down) would be my number 1.

jamesgresql

Just replying in case someone else reads this, as it's not quite up to date. Canonical source is supported for types with canonicalize_type_information (although maybe you meant something else?).

HAVING is unsupported, but only under some circumstances:HAVING clauses in GROUP BY aggregates which are cross-shard.

jamesgresql

Which features are you referencing here?

jamesgresql

Anthropic today: hold my beer

jamesgresql

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!

jamesgresql

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.

jamesgresql

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

jamesgresql

Curious what you mean here?

jamesgresql

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?