Search Postgresql Archives

How to know detailed information about HOT(Heap-Only Tuples)?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
Subject: How to know detailed information about HOT(Heap-Only Tuples)?
From: 高健 <luckyjackgao@xxxxxxxxx>
Date: Thu, 22 Aug 2013 10:20:43 +0800

Hi:

I have heard that Heap-Only Tuples is introduce from 8.3.

And I am searching information for it.

How can I get a detailed information of HOT?

For example:

according to a table, How many tuples are heap only tuples , and how many are not?

And also , Is there any options which can influence HOT occurrance?

Best Regards

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: How to know detailed information about HOT(Heap-Only Tuples)?
  - From: Adrian Klaver
- Re: How to know detailed information about HOT(Heap-Only Tuples)?
  - From: Luca Ferrari

Prev by Date: Re: No caching sql query
Next by Date: Re: PostgreSQL 9.2 Logging
Previous by thread: No caching sql query
Next by thread: Re: How to know detailed information about HOT(Heap-Only Tuples)?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux