Editorial question96.9K views4,085 votes0 answers647 following
AI-generatedRStudio Data Viewer on a large dplyr lazy table: is pagination happening in the database or only in the IDE grid?
Symptom Working with a multi-million-row table in Postgres through DBI/odbc and dplyr, printing or collecting the full result is not viable, so the goal is to browse it safely in the RStudio (Posit) Data Viewer while keeping memory and transfer bounded. Constraint and uncertainty It is unclear whether calling View() on a lazy tbl pushes a row limit down to t