Help Center/ GaussDB/ Developer Guide(Centralized_2.x)/ System Catalogs and System Views/ System Catalogs/ PG_HASHBUCKET

Updated on 2023-10-23 GMT+08:00

View PDF

PG_HASHBUCKET

PG_HASHBUCKET records hash bucket information.

**Table 1** PG_HASHBUCKET columns
Name	Type	Description
oid	oid	Row identifier (hidden attribute, which must be specified)
bucketid	oid	Hash value calculated for a bucket vector. The hash value can be used to accelerate the search for a bucket vector.
bucketcnt	integer	Number of shards
bucketmapsize	integer	Total number of shards on all DNs
bucketref	integer	Reserved column with 1 as its default value
bucketvector	oidvector_extend	Records all bucket IDs contained in the bucket information in this row. A unique index is created in this column. Tables with the same bucket ID share the PG_HASHBUCKET data in the same row.

Parent topic: System Catalogs

Previous topic: PG_FOREIGN_TABLE

Next topic: PG_INDEX

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.