I hereby claim:
- I am mkubala on github.
- I am mkubala (https://keybase.io/mkubala) on keybase.
- I have a public key ASDR5WCVFAepuSkvhNSR82FgoBwh8t9XmDLI15MBYakSHAo
To claim this, I am signing this object:
psql> select * from journal where deleted = false and tags @> ARRAY[3] and ordering > 1000 and ordering <= 3000 ORDER BY ordering asc limit 1000; | |
ordering | sequence_number | deleted | persistence_id | message | tags | |
----------+-----------------+---------+----------------+----------+--------- | |
1003 | 100 | f | p-3 | \x348b31 | {3,101} | |
1013 | 101 | f | p-3 | \x348b31 | {3,102} | |
1023 | 102 | f | p-3 | \x348b31 | {3,103} | |
… | |
Time: 1129.634 ms (00:01.130) |
-- Loads the module | |
CREATE EXTENSION intarray; | |
-- Recreate the index | |
DROP INDEX journal_tags_idx; | |
CREATE INDEX journal_tags_idx ON public.journal USING GIN(tags gin__int_ops); |
CREATE INDEX journal_tags_idx ON public.journal USING GIN (tags); |
SELECT * FROM public.journal WHERE deleted = false AND tags @> ARRAY[3] AND ordering > 1000 AND ordering <= 3000 ORDER BY ordering ASC LIMIT 1000; |
psql> \d+ journal_0 | |
Partitioned table “public.journal_0" | |
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description | |
-----------------+-----------+-----------+----------+-----------------------------------------------+----------+--------------+------------- | |
ordering | bigint | | not null | nextval('journal_ordering_seq'::regclass) | plain | | | |
sequence_number | bigint | | not null | | plain | | | |
deleted | boolean | | not null | false | plain | | | |
persistence_id | text | | not null | | extended | | | |
message | bytea | | not null | | extended | | |
psql> \d+ journal | |
Partitioned table "public.journal" | |
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description | |
-----------------+-----------+-----------+----------+-----------------------------------------------+----------+--------------+------------- | |
ordering | bigint | | not null | nextval('journal_ordering_seq'::regclass) | plain | | | |
sequence_number | bigint | | not null | | plain | | | |
deleted | boolean | | not null | false | plain | | | |
persistence_id | text | | not null | | extended | | | |
message | bytea | | not null | | extended | | | |
ta |
I hereby claim:
To claim this, I am signing this object: