Indexes.constants.ts33 lines · main

1	export const INDEX_TYPES = [
2	{
3	name: 'B-Tree',
4	value: 'btree',
5	description:
6	'For querying data with equality or range conditions on columns.\nThis is the default index type that Postgres uses.',
7	},
8	{
9	name: 'Hash',
10	value: 'hash',
11	description: 'For querying exact matches on columns',
12	},
13	{
14	name: 'GiST',
15	value: 'gist',
16	description: 'For querying complex data types or custom-defined operators',
17	},
18	{
19	name: 'SP-GiST',
20	value: 'spgist',
21	description: 'Similar to GiST, but is more specialized and customizable',
22	},
23	{
24	name: 'GIN',
25	value: 'gin',
26	description: 'For querying multi-valued data such as arrays or full-text search scenarios',
27	},
28	{
29	name: 'BRIN',
30	value: 'brin',
31	description: 'For querying large tables with sorted data',
32	},
33	]