Perform scan on Toast table

From: classical_89 <luongnx512(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Perform scan on Toast table
Date: 2012-12-06 03:08:07
Message-ID: 1354763287777-5735406.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi everyone ,I have a question. I have a table with large data (i was used
bytea datatype and insert a binary content to table ) so that Postgres help
me get a TOAST table to storage out-of-line values .
Assume that my table is " tbl_test " and toast table oid is 16816

When i peform EXPLAIN ANALYZE select query on tbl_test ( EXPLAIN ANALYZE
SELECT * FROM tbl_test).It show that sequential scan was performed on
tbl_test ,but when i check pg_toast table with this query :

SELECT
relid,
schemaname,
relname,
seq_scan,
seq_tup_read,
idx_scan,
FROM pg_stat_all_tables
WHERE relid IN ( SELECT oid
FROM pg_class
WHERE relkind = 't' ) AND relid = 16816

I saw that seq_tup_read = 0 and the seq_scan is always is 1 .idx_scan is
increase arcording to the number of query on tbl_test

I was wordering : Do have a sequential scan perform on tbl_test and other
index scan will be peforming on TOAST after this sequential scan ?
Can you explain this dump question to me ,please ?
P/S : sorry for my bad English .Thanks ! :)

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Perform-scan-on-Toast-table-tp5735406.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stuart Bishop 2012-12-06 07:51:41 Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance
Previous Message Scott Marlowe 2012-12-06 00:54:09 Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance