Why are my postgresql update times getting less timely?
A customer recently questioned me about why a bulk load into a PostgreSQL table continued slowing down over time. They saw that the trigger on the tab…
My PostgreSQL table does not shrink when I vacuum.
Have you ever wondered why VACUUM does not reduce the size of your PostgreSQL tables? Have you ever pondered the lack of data file compression in VACU…
Oracle RPAD function.
- 23 October 2022
- Database Performance ManagementTechnology Business
The Oracle/PLSQL RPAD function supplements a certain character set from the right side of the string (at non-zero string1)….
Symbolic / string Oracle PL/SQL functions.
- 19 October 2022
- Database Performance ManagementTechnology Business
FunctionDescriptionASCIIThe Oracle/PLSQL ASCII function returns the numeric representation of the leftmost character of the string.ASCIISTRThe Oracl…
Oracle VSIZE function.
The Oracle/PLSQL VSIZE function returns the length in bytes for the internal representation of the expression….
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!