
yagosansz
High Performance PostgreSQL for Rails: Data Scan Definition (Chapter 8, page 145)
Hello @andatki,
On Chapter 8, page 145, in the Generating Data for Experiments section, one of the paragraphs stars with the following: "When does it flip from sequential scans to index scans?..”
I believe this should be "When does it flip from index scans to sequential scans?..” instead.
This makes more sense, since it then goes on to explain that a query that specifies many fields of data, using an index that does not cover all fields may trigger PostgreSQL to resort to a table sequential scan.
First Post!

andatki
Hello @yagosansz. Thanks for taking the time to write this up.
I agree that the order you described makes more sense (index scans to sequential scans), as that’s the type of plan change that would harm performance.
I’ll see if we can get a correction in place and follow up. Thanks again!
Popular Pragmatic topics










Other popular topics










Latest in PragProg
Latest (all)
Categories:
Popular Portals
- /elixir
- /rust
- /wasm
- /ruby
- /erlang
- /phoenix
- /keyboards
- /js
- /rails
- /python
- /security
- /go
- /swift
- /vim
- /clojure
- /java
- /haskell
- /emacs
- /svelte
- /onivim
- /typescript
- /crystal
- /c-plus-plus
- /tailwind
- /kotlin
- /gleam
- /react
- /flutter
- /elm
- /ocaml
- /vscode
- /opensuse
- /ash
- /centos
- /php
- /deepseek
- /zig
- /scala
- /html
- /debian
- /nixos
- /lisp
- /agda
- /textmate
- /sublime-text
- /react-native
- /kubuntu
- /arch-linux
- /revery
- /ubuntu
- /manjaro
- /spring
- /django
- /diversity
- /nodejs
- /lua
- /slackware
- /julia
- /c
- /neovim