Postgres Pro
Downloads
Home   >   mailing lists

Re: Large tables, ORDER BY and sequence/index scans - Mailing list pgsql-general

From Milan Zamazal
Subject Re: Large tables, ORDER BY and sequence/index scans
Date
Msg-id 87637g4j7a.fsf@blackbird.nest.zamazal.org
Whole thread Raw
In response to Re: Large tables, ORDER BY and sequence/index scans  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Large tables, ORDER BY and sequence/index scans  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
>>>>> "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);

pgsql-general by date:

Previous
From: Howard Cole
Date:
Subject: Re: Using regex to update a table
Next
From: Scott Bailey
Date:
Subject: Re: converting tables to XML and back