Hi Folks,
As a SQLDBA, I am currently learning PSTGR Administration, and I have gone through Database Architecture.
SQL database has two files: a data file and a log file, and all DML transactions are logged to the log file before writing to the data file.. when log files gets full, we shrink the files.
How does Postgre compare to SQL log file?
Thanks,
Reddy
As a SQLDBA, I am currently learning PSTGR Administration, and I have gone through Database Architecture.
SQL database has two files: a data file and a log file, and all DML transactions are logged to the log file before writing to the data file.. when log files gets full, we shrink the files.
How does Postgre compare to SQL log file?
Thanks,
Reddy