High Performance PostgreSQL for Rails (Pragmatic Bookshelf)
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
@andatki
I have encountered a couple of issues in the sections explaining the cloning of tables without constraints, copying all rows, a...
New
I found it challenging to use code examples from this book, particularly because the queries containing non-printing Unicode characters. ...
New
Active Record supports multiple validations becoming listed out for an
attribute.
It took me a couple of tries to understand this, may...
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
@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
“If you’ve used the history command in your terminal, psql supports a similar “reverse search” by typing “ctrl-r”. Type ctrl-r,...
New
@andatki
class AddTripRatingCheckConstraint < ActiveRecord::Migration[7.0]
def change
add_check_constraint :users, "rating >...
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
@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
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
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
In the book, you make a reference to acts_as_paranoid, but given the simplicity and popularity: Category: Active Record Soft De...
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
High Performance PostgreSQL for Rails - wrong code example
The code description does not match the code snippet.
New
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
Title: High Performance PostgreSQL for Rails
@aapsql @andatki
A reader wrote this by email. Re-posting here:
Do you run clusters on y...
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
Build fast, scalable PostgreSQL and Rails apps. Solve data growth, quality, and reliability challenges, for workloads from consumer Inter...
New
Most Active This Week
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
@andatki
I have encountered a couple of issues in the sections explaining the cloning of tables without constraints, copying all rows, a...
New
Hello @andatki ,
I ran into a problem with the migration suggested p. 75:
class AddCheckConstraintTripsCompletedAt < ActiveRecord::M...
New
Title: High Performance PostgreSQL for Rails: Archiving mentions deleted_at column (p338)
The sql command DELETE FROM trip_positions WH...
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
@andatki
The correct migration code for ruby/migration_snippet_virtual_column.rb is
class AlterTempCustomers < ActiveRecord::Migrati...
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
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
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
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
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
In this page, you mention:
The Transaction Pooling Mode for PgBouncer cannot be used with Advisory Locks
Can you expand a tit...
New
@andatki
High Performance PostgreSQL for Rails - wrong code example
The code description does not match the code snippet.
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
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
Most Active Over Three Years
Active Record supports multiple validations becoming listed out for an
attribute.
It took me a couple of tries to understand this, may...
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
Publisher:
Pragmatic Bookshelf
Latest in High Performance PostgreSQL for Rails
Get money off!
The Pragmatic Bookshelf
35% off any eBook
Use the coupon code "devtalk.com" to get 35% off any eBook published by PragProg!
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.
Real-time error tracking, performance insights, and observability for devs.
Develop your skills with books, videos, and courses.
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!"