Re: Large tables, ORDER BY and sequence/index scans

>>>>> "PS" == Pavel Stehule <pavel.stehule@gmail.com> writes:

    PS> and value efective_cache_size ???

effective_cache_size = 128MB

    PS> what is CREATE INDEX stament for index?

create index foo2_value_idx on foo2(value);