↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Configuration Parameters

seq_page_cost

Sets the planner's estimate of the cost of a disk page fetch that is part of a series of sequential fetches. The default is 1.0. This value can be overridden for tables and indexes in a particular tablespace by setting the tablespace parameter of the same name (see ALTER TABLESPACE).

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

boot val
1
category
Query Tuning / Planner Cost Constants
context
user
documented
true
enumvals
Unknown
extra desc
Unknown
lang
en
max val
1.79769e+308
metadata version
18
min val
0
name
seq_page_cost
short desc
Sets the planner's estimate of the cost of a sequentially fetched disk page.
source
pg-settings-source-snapshot
unit
Unknown
vartype
real

Definition PG 18

Sets the planner's estimate of the cost of a disk page fetch that is part of a series of sequential fetches. The default is 1.0. This value can be overridden for tables and indexes in a particular tablespace by setting the tablespace parameter of the same name (see ALTER TABLESPACE).

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:2143d54d25902b5d872d8b67a4802b3dc25661086fe448604869acfbfe91d4db

Text language: en · wiki-repair-20261023:2143d54d25902b5d872d8b67a4802b3dc25661086fe448604869acfbfe91d4db