lsm3

lsm3 copied to clipboard

If you stop a concurrently created index, the drop fails with an error.

cavallium

During the concurrent index creation on a big table, I was executing parallel inserts, and at some point the inserts deadlocked on "LWLock: lsm3"

cavallium

does lsm3 work with Postgres 12 or Greenplum?

1

I got following error while making it: ```c lsm3.h:46:9: error: unknown type name ‘BTOptions’ 46 | BTOptions nbt_opts; /* Standard B-Tree options */ | ^~~~~~~~~ lsm3.c: In function ‘lsm3_truncate_index’: lsm3.c:209:32:...

lij55

WHen i run postgres in eclipse this error is shown. ERROR: Lsm3: this extension should be loaded via shared_preload_libraries but when i run them in psql its doing fine. I...

SmrutiRanjan-Ai

ERROR: invalid function number 4, must be between 1 and 3

5

Hi i am running for postgres version 13.0. when issuing command "create extension lsm3" after make install and shared library . I am getting ERROR: invalid function number 4, must...

paras-garg12

lsm3 index bloat?

1

HI, lsm3 index more larger than btree index: ``` postgres=# create index idx on t using lsm3(id) with (unique=true); postgres=# insert into t select generate_series(1,10000000), md5(random()::text); postgres=# \dt+ t List...

digoal

ERROR: relation "idx_top0" already exists

1

HI, when i drop the lsm3 index and reindex it, will generate error like below: ``` postgres=# drop index idx; DROP INDEX postgres=# create index idx on t using lsm3(id)...

digoal

Reproducibility info: - Postgres 15.3 - Ubuntu 22.04 - the basic_archive extension is also from the contrib directory of Postgres 15.3 - shared_preload_libraries has lsm3,basic_archive in that order Here are...

abigalekim