PinnedWaltton MoraisWhat is this 1=1 doing here?I’ve been working with SQL for almost 10 years now and everywhere I go it seems that I leave a trail of 1=1, and I get this question…Oct 21, 20223Oct 21, 20223
Waltton MoraisUsing views and triggers to ease refactoringHow to use views and trigger to enable big changes on a table schema without forcing a single big refactoring effortOct 8, 2023Oct 8, 2023
Waltton MoraisSpeed up your queries by avoiding to hit the TOASTIn PostgreSQL, rows are usually limited to 2KB and if we try to insert more than that we trigger the TOAST mechanism.Aug 26, 2023Aug 26, 2023
Waltton MoraisIntroduction to Vacuum in PostgreSQLTo understand vacuuming in PostgreSQL we need to look a bit down to a lower level, at the data structures behind our tables.Jan 19, 2023Jan 19, 2023
Waltton MoraisHow to use multi-line \copy from psqlShort story even shorter: it does not work, use COPY and finish the statement with \g <filename> instead.Jan 15, 2023Jan 15, 2023
Waltton MoraisUsing the window function row_number to remove duplicates in PostgreSQLRemoving duplicated data is a common task, it may appear as a result of a bug, could be changes in the business requirements, or just the…Jan 8, 2023Jan 8, 2023
Waltton MoraisWhat do you get after running an UPDATE in PostgreSQL?If your response is: updated records, that is fair, it’s true, but you can get much more from your updates.Nov 7, 2022Nov 7, 2022
Waltton MoraisUsing CTEs to make your SQL code more readableWe can make use of the WITH clause to extract parts of our statements to build CTEs, that can be used as any table or viewOct 31, 2022Oct 31, 2022
Waltton MoraisOrdering aggregate in PostgreSQLTo get a consistent result from some aggregate functions we only need to specify the order by clause at the end of the function call.Oct 28, 2022Oct 28, 2022