2010/1/5 Milan Zamazal <pdm@brailcom.org>:
>>>>>> "PS" == Pavel Stehule <pavel.stehule@gmail.com> writes:
>
> PS> Have you original values random_page_cost and seq_page_cost in
> PS> postgres.conf?
>
> Yes. To be sure I uncommented the values in postgresql.conf
>
> seq_page_cost = 1.0 # measured on an arbitrary scale
> random_page_cost = 4.0 # same scale as above
and value efective_cache_size ???
what is CREATE INDEX stament for index?
Pavel
>
> and restarted PostgreSQL. The result looks basically the same:
>
> explain analyze declare c cursor for select * from foo2 order by value;
> QUERY PLAN
>
-------------------------------------------------------------------------------------------------------------------------
> Sort (cost=1829429.20..1854429.20 rows=9999999 width=10) (actual time=43709.313..49265.244 rows=9999999 loops=1)
> Sort Key: value
> Sort Method: external merge Disk: 204208kB
> -> Seq Scan on foo2 (cost=0.00..154049.99 rows=9999999 width=10) (actual time=0.072..1760.585 rows=9999999
loops=1)
> Total runtime: 54399.967 ms
> (5 rows)
>
>
