I have a table of ~ 41 000 rows with an index on the result of a function applied to a certain text column (the function basically removes "neutral" or common words like "the","on","a", etc. from the string).
I then execute a query with a where clause on this function result with an order by on the
Hi,I've created a table like this : CREATE TABLE tmp_A (c "char",i int4);And another one CREATE TABLE tmp_B (i int4,ii int4);I then inerted a bit more than 19 million rows in each table (exactly the same number of rows in each).
The end result is that the physical size on disk used by table tmp_A