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

From: Milan Zamazal <pdm(at)brailcom(dot)org>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Large tables, ORDER BY and sequence/index scans
Date: 2010-01-05 16:20:25
Message-ID: 87637g4j7a.fsf@blackbird.nest.zamazal.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "PS" == Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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);

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Bailey 2010-01-05 16:44:07 Re: converting tables to XML and back
Previous Message Howard Cole 2010-01-05 16:16:44 Re: Using regex to update a table