On Friday, June 23rd, 2023 at 2:52 PM, Laurenz Albe
wrote:
>
>
> On Fri, 2023-06-23 at 12:08 +, Nicolas Seinlet wrote:
>
> > we faced an issue with a select query on a relatively large table on our
> > database.
> > The query involves one single table. The table has more than 10 mill
On Fri, 2023-06-23 at 12:08 +, Nicolas Seinlet wrote:
> we faced an issue with a select query on a relatively large table on our
> database.
> The query involves one single table. The table has more than 10 million
> records.
> It's mainly composed of varchar fields, have a primary key (id) o
Hello, we faced an issue with a select query on a relatively large table on our
database. The query involves one single table. The table has more than 10
million records. It's mainly composed of varchar fields, have a primary key
(id) of type serial, and when records of this table are shown to u
Jack Orenstein writes:
> I guess the top-level question is this: Is it possible in principle for the
> btree index to subsume GIN index capabilities?
Well, you could write a completely different index AM that happened to
share the same on-disk representation, perhaps. But it would be a
different
I am working on a research project involving a datatype, D, with the
following characteristics:
- A value of D is a variable-length binary string.
- A value of D usually gives rise to a single index term, but there could
occasionally be more, (up to some configurable maximum).
- The index terms
