On Wed, Jul 2, 2008 at 9:44 AM, Gauri Kanekar
<[EMAIL PROTECTED]> wrote:
> ok.. But we have set fill_factor = 80 for all the indexes on table1.

You need fill factor for the heap table, not the index.

> Is there a way to check if the page is fill and the update is going on a new
> page ??

IIRC, I don't think so.  I think you'd have to u se something like
pg_filedump to see if you have rows migrated to other blocks due to
updates.

-- 
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | [EMAIL PROTECTED]
Edison, NJ 08837 | http://www.enterprisedb.com/

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to