postgrespro / lsm3 Goto Github PK

I got following error while making it:

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: error: implicit declaration of function ‘BuildDummyIndexInfo’; did you mean ‘BuildIndexInfo’? [-Werror=implicit-function-declaration]
  209 |         IndexInfo* indexInfo = BuildDummyIndexInfo(index);
      |                                ^~~~~~~~~~~~~~~~~~~
      |                                BuildIndexInfo
lsm3.c:209:32: warning: initialization of ‘IndexInfo *’ from ‘int’ makes pointer from integer without a cast [-Wint-conversion]
lsm3.c: In function ‘lsm3_merge_indexes’:
lsm3.c:236:37: error: ‘BTREE_AM_OID’ undeclared (first use in this function); did you mean ‘BTREE_MAGIC’?
  236 |         base_index->rd_rel->relam = BTREE_AM_OID;
      |                                     ^~~~~~~~~~~~
      |                                     BTREE_MAGIC
lsm3.c:236:37: note: each undeclared identifier is reported only once for each function it appears in
lsm3.c:243:21: error: implicit declaration of function ‘BTreeTupleIsPosting’ [-Werror=implicit-function-declaration]
  243 |                 if (BTreeTupleIsPosting(itup))

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 of relations
 Schema | Name | Type  |  Owner   | Persistence |  Size  | Description 
--------+------+-------+----------+-------------+--------+-------------
 public | t    | table | postgres | permanent   | 651 MB | 

 public | idx              | index | postgres | t           | permanent   | 69 GB      | 

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 added shared_preload_libraries ='lsm3' to install/data/postgresql.conf

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) with (unique=true);
ERROR:  relation "idx_top0" already exists

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

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

If I add lsm3 to preloaded libraries I get this error:
cannot request additional shared memory outside shmem_request_hook

I have added several lsm3 indexes to a table and am now bulk-loading data in to it using COPY t FROM STDIN via psql. I am getting "WARNING: you don't own a lock of type RowExclusiveLock" 2-6 times per 100000 rows. The rows do get inserted, so this might be ignore-able?

I just did the same bulk-load using btree indexes without the lsm3 extension loaded and I do not get the warnings.

I am on PostgreSQL 13.3 on Debian. If there is any additional information I can provide, let me know.

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 be between 1 and 3. how to remove that error