Re: [PERFORM] Slow query with indexed ORDER BY and LIMIT when using OR'd conditions

> > No, it doesn't. Read it again ... or read up on row comparisons, > if you're unfamiliar with that notation. The above queries are > exactly equivalent per spec. > Wow, this is great. Thanks.

[PERFORM] estimate btree index size without creating

Dear all, Is it possible to estimate btree index size on text field before creating it. For example i have a table like this: fortest=# \d index_estimate i integer somestring text This is avg bytes in text field fortest=# select round(avg(octet_length(somestring))) from index_estimate ;