> first of all thank You for Your response. But here is the
> reality. Table formula have about 450000 rows at this time.
> The id_formula column is int4 defined as not null primary key.
It is eh? Have you done a VACUUM ANALYZE on this table lately?
4500 rows (1%) would be the default match estimate in the absence of
> And the index have clause unique, but backend still don't use it.
7.2 will know enough to realize that presence of a unique index means
the column is unique, but existing releases only look at the VACUUM
ANALYZE statistics. No statistics = bad plan.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Peter Eisentraut||Date: 2001-08-07 17:40:31|
|Subject: Re: v7.0.2: can't use 'EXTRACT(EPOCH FROM'|
|Previous:||From: pgsql-bugs||Date: 2001-08-07 10:20:49|
|Subject: ecpg: unstable INSERT operation |