Search Postgresql Archives

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

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

To: Pavel Stehule <pavel.stehule@xxxxxxxxx>
Subject: Re: Large tables, ORDER BY and sequence/index scans
From: Milan Zamazal <pdm@xxxxxxxxxxxx>
Date: Tue, 05 Jan 2010 17:20:25 +0100
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <162867791001050803x48dd4488xe89ed0063bc9163a@xxxxxxxxxxxxxx> (sfid-20100105_170410_853510_0532E0C4) (Pavel Stehule's message of "Tue, 5 Jan 2010 17:03:47 +0100")
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux)

>>>>> "PS" == Pavel Stehule <pavel.stehule@xxxxxxxxx> 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);


-- 
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]

Follow-Ups:
- Re: Large tables, ORDER BY and sequence/index scans
  - From: John R Pierce

References:
- Large tables, ORDER BY and sequence/index scans
  - From: Milan Zamazal
- Re: Large tables, ORDER BY and sequence/index scans
  - From: Pavel Stehule
- Re: Large tables, ORDER BY and sequence/index scans
  - From: Milan Zamazal
- Re: Large tables, ORDER BY and sequence/index scans
  - From: Pavel Stehule
- Re: Large tables, ORDER BY and sequence/index scans
  - From: Milan Zamazal
- Re: Large tables, ORDER BY and sequence/index scans
  - From: Pavel Stehule
- Re: Large tables, ORDER BY and sequence/index scans
  - From: Milan Zamazal
- Re: Large tables, ORDER BY and sequence/index scans
  - From: Pavel Stehule

Prev by Date: Re: Using regex to update a table
Next by Date: Re: converting tables to XML and back
Previous by thread: Re: Large tables, ORDER BY and sequence/index scans
Next by thread: Re: Large tables, ORDER BY and sequence/index scans
Index(es):
- Date
- Thread

[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]