Postgres Pro
Downloads
Home   >   mailing lists

how to calculate or know seq_scan scan how many blocks every time - Mailing list pgsql-general

From leo xu
Subject how to calculate or know seq_scan scan how many blocks every time
Date
Msg-id 1343216316780-5717892.post@n5.nabble.com
Whole thread Raw
Responses Re: how to calculate or know seq_scan scan how many blocks every time  (leo xu <leoxu8703@gmail.com>)
Re: how to calculate or know seq_scan scan how many blocks every time  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-general
Tree view 
hello:
   i know oracle scatter read blocks,can set db_file_multiblock_read_count
every time,
   i see postgres,it exists scatter read blocks,it is seq_scan,how to know
scan many bloks every time?



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-calculate-or-know-seq-scan-scan-how-many-blocks-every-time-tp5717892.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Johann Spies
Date:
Subject: Full text search ts_heading strange result
Next
From: Andrew Hastie
Date:
Subject: Re: PL/pgSQL - Help or advice please on using unbound cursors