POSTGRESQL Questions
1. What is vacuum & vacuumfull?
2. What are the database created during installation?
3. Difference between pg_dump, pg_dump all
4. Explain pg_upgrade
5. Explain replication set up
6. Explain migration set up
7. What is CTID in postgres?
8. What is temp buffer used for?
9. What is work mem used for?
10. What is WAL?
11. Explain architecture?
12. difficulties faced in migration
13. equivalent of BLOB, CLOB in postgres?
14. What is token?
15. Types of tablespaces?
16. What are types of index?
17. Which index will be used for jsonb datatype?
18. How will u start server?
19. Types of server start?
20. Fetch first five rows?
21. Transaction control in postgres?
22. Types of operator in postgres?
23. How will you dry run upgrade?
24. Can we restore a backup taken from version 12 to version 13?
25. Syntax for pg_basebackup with parameters explanation?
26. What is MVCC?
27. How to check idle and active sessions n postgres?
28. How and Why will you rebuild index?
29. How to check table fragmentation?
30. explain pg_badger?
31. What is schema?
32. What is role?
33. How to take incremental backup?(pg_backrest - third party tool)?
34. What is explain plan?
35. What is analyze?
36. What is pg_basebackup..steps?
37. What is PITR and explain steps?
38. What is freeze?
39. Type of authentication in pg_hba?
40. What is peer authentication?
41. backup of data alone?
42. How to find locks??
43. What are the steps to follow if my query is slow?
44. How to schedule jobs in postgres?
45. What is max size of table in postgres?
46. What is CLOG?
47. Why BYTEA is used for?
48. What is sequence in postgres?
49. What is pg_repack?
50. How will you change standby to primary?
51. Find database, table size?
52. Change default tablespace of table/schema to user defined TBS?
53. What is DBlink?
54. Where is WAL file located and how to change the max value?
55. What will you analyze in pg_badger?
56. work of BGwriter?