Hi,
I have about 6 tables that inherit from one table. They all have the
exact same indexes but when i try to query all by a row (which is
indexed, btree) the QP decides to do sequential scan for some of them
(the bigger tables) rather than use the index.
Any ideas why that may happen?
I am using
ows=4073 loops=1)
Index Cond: ((word2)::text = 'the'::text)
Total runtime: 219.987 ms
(9 rows)
On 4/9/07, Jan de Visser <[EMAIL PROTECTED]> wrote:
On Monday 09 April 2007 05:09:53 s d wrote:
> Hi,
> I am trying to figure out how to debug a perf
Hi,
I am trying to figure out how to debug a performance problem / use psql explain.
The table in question is:
# \d word_association;
Table "public.word_association"
Column | Type | Modifiers
++
word1 | character
