Andrew Atkinson
Andrew Atkinson
Hello. I wanted to take advantage of `RETURNING` to save a round-trip to the database for an area that is particularly costly. However activerecord-import which we're using (just bumped to...
I've replaced whitelist and blacklist with allowlist and blocklist The test suite is passing for m locally with a couple of newer dependencies and on a more recent version of...
Hi @keithf4 The CLUSTER tip is good, although since this command acquires a AccessExclusiveLock on the table [1], do you think it makes sense to locate this information under the...
Hi Karthik. Thank you for creating the course on LinkedIn Learning. I went through it and found it valuable. One minor issue to bring to your attention. In one of...
The batch size in the SQL is 10000, not 1000
This PR has code samples and examples from the Posette Conf talk "Saas on Rails on PostgreSQL" https://www.citusdata.com/posette/speakers/andrew-atkinson/ Some of the tech examples: - Row Level Security - Composite primary...
This gem reformats the db/structure.sql This could be useful on a team where there are changes to the db/structure.sql file from different team members as they run rails db:migrate on...
- **Start some triggers** - **Add trigger depth example**