Database Usage¶
What Do I Do If Date Type Is Automatically Converted to the Timestamp Type During Table Creation?
Do I Need to Run VACUUM FULL and ANALYZE on Common Tables Periodically?
Do I Need to Set a Distribution Key After Setting a Primary Key?
Is GaussDB(DWS) Compatible with PostgreSQL Stored Procedures?
What Are Partitioned Tables, Partitions, and Partition Keys?
If No Distribution Column Is Specified, How Will Data Be Stored?
How Do I Check Whether a Table Is Row-Stored or Column-Stored?
How Do I Query the Information About GaussDB(DWS) Column-Store Tables?
Why Sometimes the GaussDB(DWS) Query Indexes Become Invalid?
How Do I Use a User-Defined Function to Rewrite the CRC32() Function?
What Are the Schemas Starting with pg_toast_temp* or pg_temp*?
Which System Catalogs That the VACUUM FULL Operation Cannot Be Performed on?
In Which Scenarios Would a Statement Be "idle in transaction"?
How Does GaussDB(DWS) Implement Row-to-Column and Column-to-Row Conversion?
What Are the Differences Between Unique Constraints and Unique Indexes?
What Are the Differences Between Functions and Stored Procedures?