High Performance PostgreSQL for Rails (Pragmatic Bookshelf)
Hot This:
Latest Threads About This Book
The book states the following:
The main difference for domains compared with enums is that the NOT NULL constraint portion is part of t...
New
@andatki
The book states:
How can we safely add UNIQUE and NOT NULL constraints to tables, though, and make sure that all rows are eve...
New
@andatki
The SCRUB_BATCHES procedure has an off-by-one bug that causes it to skip one row after each batch. Here is output showing the i...
New
I’m having trouble understanding the intent of the start and count arguments to SUBSTR in the SCRUB_EMAIL function.
I understand that we...
New
Hello @andatki,
On Chapter 8, page 145, in the Generating Data for Experiments section, one of the paragraphs stars with the following: ...
New
Title: High Performance PostgreSQL for Rails: Archiving mentions deleted_at column (p338)
The sql command DELETE FROM trip_positions WH...
New
@andatki
The correct migration code for ruby/migration_snippet_virtual_column.rb is
class AlterTempCustomers < ActiveRecord::Migrati...
New
Hello @andatki ,
I ran into a problem with the migration suggested p. 75:
class AddCheckConstraintTripsCompletedAt < ActiveRecord::M...
New
Dear Andrew, @andatki
I found the explanation regarding the use of .includes() with a limit in the context of vehicle reservations to b...
New
Please use the following format for the title of this thread (then simply delete/replace this text with the content for the thread):
Tit...
New
Most Active This Week
@andatki
The book states:
How can we safely add UNIQUE and NOT NULL constraints to tables, though, and make sure that all rows are eve...
New
Most Active This Month
Most Active This Year
Build fast, scalable PostgreSQL and Rails apps. Solve data growth, quality, and reliability challenges, for workloads from consumer Inter...
New
I found it challenging to use code examples from this book, particularly because the queries containing non-printing Unicode characters. ...
New
Hi,
I’m reading chapter 3 (B8.0), in particular the part about cloning sequences and indexes to the scrubbed tables. This part confused ...
New
Active Record supports multiple validations becoming listed out for an
attribute.
It took me a couple of tries to understand this, may...
New
@andatki
I have encountered a couple of issues in the sections explaining the cloning of tables without constraints, copying all rows, a...
New
Dear Andrew, @andatki
I found the explanation regarding the use of .includes() with a limit in the context of vehicle reservations to b...
New
Title: High Performance PostgreSQL for Rails: Archiving mentions deleted_at column (p338)
The sql command DELETE FROM trip_positions WH...
New
Please use the following format for the title of this thread (then simply delete/replace this text with the content for the thread):
Tit...
New
Hello @andatki ,
I ran into a problem with the migration suggested p. 75:
class AddCheckConstraintTripsCompletedAt < ActiveRecord::M...
New
@andatki
The correct migration code for ruby/migration_snippet_virtual_column.rb is
class AlterTempCustomers < ActiveRecord::Migrati...
New
Hello @andatki,
On Chapter 8, page 145, in the Generating Data for Experiments section, one of the paragraphs stars with the following: ...
New
@andatki
The SCRUB_BATCHES procedure has an off-by-one bug that causes it to skip one row after each batch. Here is output showing the i...
New
The book states the following:
The main difference for domains compared with enums is that the NOT NULL constraint portion is part of t...
New
I’m having trouble understanding the intent of the start and count arguments to SUBSTR in the SCRUB_EMAIL function.
I understand that we...
New
Most Active Last Three Years
Roshan asked:
Is this useful for non Rails users?
As the author, I’m biased, but I think so. While all of the application code exampl...
New
@andatki
Hi, page 26 says
Data cannot be split across pages.
But two paragraphs later
Data may not fit in a single page, may be spl...
New
@andatki
“If you’ve used the history command in your terminal, psql supports a similar “reverse search” by typing “ctrl-r”. Type ctrl-r,...
New
High Performance PostgreSQL for Rails: How to show autovacuum_vacuum_scale_factor per table (p. 171)
@andatki
On page 171, it shows how to change the autovacuum scale factor for a particular table, eg:
ALTER TABLE trips SET (autovacuum_...
New
Hi @andatki! First of all, thank you so much for this amazing book! :muscle:
I’ve found something that can cause a bit of confusion.
Af...
New
@andatki
In the book, you make a reference to acts_as_paranoid, but given the simplicity and popularity: Category: Active Record Soft De...
New
Title: High Performance PostgreSQL for Rails
@aapsql @andatki
A reader wrote this by email. Re-posting here:
Do you run clusters on y...
New
Hi and thank you for this fantastic book,
I ran in the following error while trying to run db/scripts/bulk_load.sh:
Bulk loading 10_000...
New
@andatki
High Performance PostgreSQL for Rails - wrong code example
The code description does not match the code snippet.
New
@andatki
In this page, you mention:
The Transaction Pooling Mode for PgBouncer cannot be used with Advisory Locks
Can you expand a tit...
New
@andatki
bin/rails db:reset doesn’t work if there is no socket file locally which is the case if I’m running Postgres from a Docker cont...
New
@andatki
class AddTripRatingCheckConstraint < ActiveRecord::Migration[7.0]
def change
add_check_constraint :users, "rating >...
New
@andatki
Minor typo - extra U:
“To free up the space, you’ll need to VACUUUM FULL users;…”
Fix:
To free up the space, you’ll need to ...
New
Most Active Over Three Years
Book Info
Publisher:
Pragmatic Bookshelf
Get money off!
The Pragmatic Bookshelf
35% off any eBook
Simply use coupon code "devtalk.com" at checkout. See full details here.
Latest
Filter by Type:
Related Portals
-
None added yet
Devtalk Sponsors
Practical resources that improve the lives of professional developers.
We build trusted fault-tolerant systems that scale to billions of users.
Catch errors, track performance, monitor hosts and more.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"