- How can you display the queries that are generated by the psql client to the PostgreSQL server?
- What is the purpose of the pg_class table? What is the difference between pg_catalog and information_schema?
- What does the abbreviation TOAST stand for and what is it used for?
- You work as an administrator and you would like to clean up unused indexes, What are the criteria you can use to find these indexes? Why is it important to monitor usage indexes?
- Assume that you have a table with duplicate data due to the lack of unique and primary key constraints. Which column can be used to distinguish the rows?
- Can a table have duplicate data even if it has a primary key?
- What is the difference between the pg_cancel_backend and pg_terminate_backend functions?
- Which is easier to find: unused tables or unused views? And why?
- List the contype constraint types found in the pg_constraint...
Germany
Slovakia
Canada
Brazil
Singapore
Hungary
Philippines
Mexico
Thailand
Ukraine
Luxembourg
Estonia
Lithuania
Norway
Chile
United States
Great Britain
India
Spain
South Korea
Ecuador
Colombia
Taiwan
Switzerland
Indonesia
Cyprus
Denmark
Finland
Poland
Malta
Czechia
New Zealand
Austria
Turkey
France
Sweden
Italy
Egypt
Belgium
Portugal
Slovenia
Ireland
Romania
Greece
Argentina
Malaysia
South Africa
Netherlands
Bulgaria
Latvia
Australia
Japan
Russia