High Performance PostgreSQL for Rails (Pragmatic Bookshelf)

Latest Threads About This Book Top

douglasshuang
The book states the following: The main difference for domains compared with enums is that the NOT NULL constraint portion is part of t...
2 23 2
New
douglasshuang
@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...
3 35 4
New
douglasshuang
@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...
3 40 3
New
douglasshuang
I’m having trouble understanding the intent of the start and count arguments to SUBSTR in the SCRUB_EMAIL function. I understand that we...
3 39 3
New
yagosansz
Hello @andatki, On Chapter 8, page 145, in the Generating Data for Experiments section, one of the paragraphs stars with the following: ...
1 25 2
New
AndyGauge
Title: High Performance PostgreSQL for Rails: Archiving mentions deleted_at column (p338) The sql command DELETE FROM trip_positions WH...
1 34 3
New
sanctusgee
@andatki The correct migration code for ruby/migration_snippet_virtual_column.rb is class AlterTempCustomers < ActiveRecord::Migrati...
1 33 3
New
cleaver-party
Hello @andatki , I ran into a problem with the migration suggested p. 75: class AddCheckConstraintTripsCompletedAt < ActiveRecord::M...
3 28 3
New
viktorianer
Dear Andrew, @andatki I found the explanation regarding the use of .includes() with a limit in the context of vehicle reservations to b...
2 35 1
New
martinstreicher
Please use the following format for the title of this thread (then simply delete/replace this text with the content for the thread): Tit...
1 39 2
New
viktorianer
@andatki I have encountered a couple of issues in the sections explaining the cloning of tables without constraints, copying all rows, a...
1 88 3
New
viktorianer
I found it challenging to use code examples from this book, particularly because the queries containing non-printing Unicode characters. ...
3 127 5
New
abr
Active Record supports multiple validations becoming listed out for an attribute. It took me a couple of tries to understand this, may...
1 127 2
New
abr
Hi, I’m reading chapter 3 (B8.0), in particular the part about cloning sequences and indexes to the scrubbed tables. This part confused ...
1 138 3
New
tothpeter08
@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...
1 230 2
New
tothpeter08
@andatki “If you’ve used the history command in your terminal, psql supports a similar “reverse search” by typing “ctrl-r”. Type ctrl-r,...
1 379 2
New
tothpeter08
@andatki class AddTripRatingCheckConstraint < ActiveRecord::Migration[7.0] def change add_check_constraint :users, "rating >...
1 240 3
New
daniela
@andatki On page 171, it shows how to change the autovacuum scale factor for a particular table, eg: ALTER TABLE trips SET (autovacuum_...
1 431 3
New
daniela
@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 ...
1 238 3
New
BraisonCrece
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...
2 344 6
New
yann
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...
2 409 4
New
fidalgo
@andatki In the book, you make a reference to acts_as_paranoid, but given the simplicity and popularity: Category: Active Record Soft De...
3 411 3
New
fidalgo
@andatki In this page, you mention: The Transaction Pooling Mode for PgBouncer cannot be used with Advisory Locks Can you expand a tit...
1 364 2
New
ka8725
@andatki High Performance PostgreSQL for Rails - wrong code example The code description does not match the code snippet.
1 352 3
New
andatki
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...
0 629 1
New
andatki
Title: High Performance PostgreSQL for Rails @aapsql @andatki A reader wrote this by email. Re-posting here: Do you run clusters on y...
0 426 1
New
pzac
@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...
3 642 6
New
PragmaticBookshelf
Build fast, scalable PostgreSQL and Rails apps. Solve data growth, quality, and reliability challenges, for workloads from consumer Inter...
17 2059 7
New

Most Active This Week Top

Most Active This Month Top

viktorianer
Dear Andrew, @andatki I found the explanation regarding the use of .includes() with a limit in the context of vehicle reservations to b...
2 35 1
New

Most Active This Year Top

PragmaticBookshelf
Build fast, scalable PostgreSQL and Rails apps. Solve data growth, quality, and reliability challenges, for workloads from consumer Inter...
17 2059 7
New
viktorianer
@andatki I have encountered a couple of issues in the sections explaining the cloning of tables without constraints, copying all rows, a...
1 88 3
New
cleaver-party
Hello @andatki , I ran into a problem with the migration suggested p. 75: class AddCheckConstraintTripsCompletedAt < ActiveRecord::M...
3 28 3
New
AndyGauge
Title: High Performance PostgreSQL for Rails: Archiving mentions deleted_at column (p338) The sql command DELETE FROM trip_positions WH...
1 34 3
New
douglasshuang
@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...
3 40 3
New
douglasshuang
@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...
3 35 4
New
sanctusgee
@andatki The correct migration code for ruby/migration_snippet_virtual_column.rb is class AlterTempCustomers < ActiveRecord::Migrati...
1 33 3
New
martinstreicher
Please use the following format for the title of this thread (then simply delete/replace this text with the content for the thread): Tit...
1 39 2
New
douglasshuang
I’m having trouble understanding the intent of the start and count arguments to SUBSTR in the SCRUB_EMAIL function. I understand that we...
3 39 3
New
yagosansz
Hello @andatki, On Chapter 8, page 145, in the Generating Data for Experiments section, one of the paragraphs stars with the following: ...
1 25 2
New
douglasshuang
The book states the following: The main difference for domains compared with enums is that the NOT NULL constraint portion is part of t...
2 23 2
New

Most Active Last Three Years Top

andatki
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...
0 629 1
New
pzac
@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...
3 642 6
New
tothpeter08
@andatki “If you’ve used the history command in your terminal, psql supports a similar “reverse search” by typing “ctrl-r”. Type ctrl-r,...
1 379 2
New
daniela
@andatki On page 171, it shows how to change the autovacuum scale factor for a particular table, eg: ALTER TABLE trips SET (autovacuum_...
1 431 3
New
BraisonCrece
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...
2 344 6
New
fidalgo
@andatki In the book, you make a reference to acts_as_paranoid, but given the simplicity and popularity: Category: Active Record Soft De...
3 411 3
New
andatki
Title: High Performance PostgreSQL for Rails @aapsql @andatki A reader wrote this by email. Re-posting here: Do you run clusters on y...
0 426 1
New
yann
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...
2 409 4
New
fidalgo
@andatki In this page, you mention: The Transaction Pooling Mode for PgBouncer cannot be used with Advisory Locks Can you expand a tit...
1 364 2
New
ka8725
@andatki High Performance PostgreSQL for Rails - wrong code example The code description does not match the code snippet.
1 352 3
New
tothpeter08
@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...
1 230 2
New
tothpeter08
@andatki class AddTripRatingCheckConstraint < ActiveRecord::Migration[7.0] def change add_check_constraint :users, "rating >...
1 240 3
New
daniela
@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 ...
1 238 3
New
viktorianer
I found it challenging to use code examples from this book, particularly because the queries containing non-printing Unicode characters. ...
3 127 5
New
abr
Hi, I’m reading chapter 3 (B8.0), in particular the part about cloning sequences and indexes to the scrubbed tables. This part confused ...
1 138 3
New

Most Active Over Three Years Top

abr
Active Record supports multiple validations becoming listed out for an attribute. It took me a couple of tries to understand this, may...
1 127 2
New

Latest in High Performance PostgreSQL for Rails

View all High Performance PostgreSQL for Rails threads ❯

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!

Related Portals

    None added yet