Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2010/1/5 Milan Zamazal <pdm@xxxxxxxxxxxx>:
>>>>>> "PS" == Pavel Stehule <pavel.stehule@xxxxxxxxx> 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)
>
>

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux