| -- Given I have an append-only table |
| create table users( |
| first_name tsvector |
| ) with (appendonly=true); |
| NOTICE: Table doesn't have 'DISTRIBUTED BY' clause, and no column type is suitable for a distribution key. Creating a NULL policy entry. |
| -- And I have a large amount of data in the table |
| insert into users |
| select to_tsvector(md5(random()::text)) |
| from generate_series(1, 6000) i; |
| insert into users values ('John'); |
| -- When I create a GIN index on users |
| set gp_debug_linger=1; |
| CREATE INDEX users_search_idx ON users USING gin (first_name); |
| reset gp_debug_linger; |
| -- Then I should be able to query the table |
| select * from users where first_name = 'John'; |
| first_name |
| ------------ |
| 'John' |
| (1 row) |
| |
