User`s guide

1-139
6000 to 6050
The number of index segments that you may use depends on the
file’s page size.
See status codes 26: The number of keys specified is invalid and 29:
The key length is invalid for related information about index
segments and the transactional interface.
See also Choosing a Page Size and Segmentation in the Pervasive
PSQL Programmer's Guide, which is part of the Pervasive PSQL
Software Developer’s Kit (SDK).
6009: Index Name Duplicate
The index name is already being used a column. Use a unique index
name. See Naming Conventions in the online Pervasive PSQL
Page Size (bytes) Maximum Key Segments by File Version
8.x and prior 9.0 9.5
512 8 8 rounded up
2
1,024 23 23 97
1,536 24 24 rounded up
2
2,048 54 54 97
2,560 54 54 rounded up
2
3,072 54 54 rounded up
2
3,584 54 54 rounded up
2
4,096 119 119 119 or 204
3
8,192 n/a
1
119 119 or 420
3
16,384 n/a
1
n/a
1
119 or 420
3
1
”n/a” stands for “not applicable”
2
”rounded up” means that the page size is rounded up to the next size
supported by the file version. For example, 512 is rounded up to 1,024,
2,560 is rounded up to 4,096, and so forth.
3
The maximum number of index segments that can be used with the
relational interface is 119. For the transactional interface, the maximum
number is 204 for a page size of 4,096, and 420 for page sizes 8,192 and
16,384.