HOT doesn't seems to be working in our case.
This is "table1" structure :
id integer not null
code integer not null
crid integer not null
status character varying(1) default 'A'::character varying
delta1 bigint default 0
delta2 bigint default 0
delta3 bigint default 0
delta4 bigint default 0
tz_id integer default 0
Indexes:
"idx1" PRIMARY KEY, btree (id)
"idx2" UNIQUE, btree (code, crid)
"idx3" btree (tz_id)
"idx4" btree (status)
code as crid are foreign key.
Here delta* fields get updated through out the day. and most of the time it
may update the same row again n again.
table1 contains around 12843694 records.
Now not understanding y HOT don't work in our case.
Changed fillfactor to 80, 75,70.... but nothing seems to work.
~Gauri
On Tue, Apr 29, 2008 at 10:18 PM, Shane Ambler <[EMAIL PROTECTED]> wrote:
> Alvaro Herrera wrote:
>
> > Gauri Kanekar escribió:
> >
> > Do we need to do any special config changes or any other setting for
> > > HOT to
> > > work??
> > >
> >
> > No. HOT is always working, if it can. You don't need to configure it.
> >
> >
> Unless you have upgraded since you started this thread you are still
> running 8.1.3.
>
> HOT is only available in 8.3 and 8.3.1
>
> You DO need to upgrade to get the benefits of HOT
>
>
>
>
> --
>
> Shane Ambler
> pgSQL (at) Sheeky (dot) Biz
>
> Get Sheeky @ http://Sheeky.Biz
>
--
Regards
Gauri
