Title: Re: [GENERAL] delete seems to be getting blocked
however if the for every
occuerence of the foreign key there are some 2000 rows in the table, is it
ok to still have an index on that foreign key.
also will index scan still
take place or postgres will itself choose to do
On Mon, Jun 12, 2006 at 12:54:15PM +0530, surabhi.ahuja wrote:
> i have four tables in my database
> TAB1, has one primary key T1
>
> TAB2 , has 2 fields, one is the primary ley T2 and the other one
> is the foreign key T1(from TAB1)
>
> TAB3 also has 2 fields, one is the primary ley T3 and the
Em Segunda 12 Junho 2006 04:24, surabhi.ahuja escreveu:
> hi,
> I am using postgresql 8.0.0.
> i have four tables in my database
> TAB1, has one primary key T1
>
> TAB2 , has 2 fields, one is the primary ley T2 and the other one is the
> foreign key T1(from TAB1)
>
> TAB3 also has 2 fields, one is
hi,
I am using postgresql 8.0.0.
i have four tables in my database
TAB1, has one primary key T1
TAB2 , has 2 fields, one is the primary ley T2 and
the other one is the foreign key T1(from TAB1)
TAB3 also has 2 fields, one is the primary ley T3
and the other is the foreign key T2(from TAB2)
