Nathan Boley <npboley@gmail.com> writes:
> Maybe this is bad design, but I've gotten in the habit of storing
> sequences as arrays and I commonly join on them. I looked through my
> code this morning, and I only have one 'range' query ( of the form
> described up-thread ), but there are tons of the form
> SELECT att1, attb2 FROM rela, relb where rela.seq_array_1 = relb.seq_array;
What do you mean by "storing sequences as arrays"? Can you demonstrate
that the existing stats are relevant at all to the query you're worried
about?
regards, tom lane