Horton

Re: Collect frequency statistics for arrays

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nathan Boley <npboley@gmail.com>
Cc: Alexander Korotkov <aekorotkov@gmail.com>, Noah Misch <noah@leadboat.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2012-03-01T22:19:22Z
Lists: pgsql-hackers 
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