end use the index. I
can't understand to that. If you will need other informations, please ask me.
Thank You very much
Zdenek Habala
>
> Od : Tom Lane <[EMAIL PROTECTED]>
> Datum : 2001/08/07 Út dop. 01:55:56 GMT+02:00
> Komu : [EMAIL PROTECTED], [EMAIL PROTECTED]
> Pře
<[EMAIL PROTECTED]> writes:
> first of all thank You for Your response. But here is the
> reality. Table formula have about 45 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%) wou
[EMAIL PROTECTED] writes:
> backend don't use index when querying by indexed column
This is not necessarily a bug.
> when i try to explain this select i will got this:
> explain select * from formula where id_formula = 1;
> NOTICE: QUERY PLAN:
> Seq Scan on formula (cost=0.00..10919.89 rows=4
Zdenek Habala ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
backend don't use index when querying by indexed column
Long Description
I have a table named formula with this structure:
id_formula | intege
