how to calculate or know seq_scan scan how many blocks every time

From: leo xu <leoxu8703(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to calculate or know seq_scan scan how many blocks every time
Date: 2012-07-25 11:38:36
Message-ID: 1343216316780-5717892.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Law 2012-07-25 11:54:23 Re: BUG #6742: pg_dump doesn't convert encoding of DB object names to OS encoding
Previous Message Johann Spies 2012-07-25 08:26:15 Full text search ts_heading strange result