Search Postgresql Archives

Re: Indexes on character type columns

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

To: PostgreSQL General <pgsql-general@xxxxxxxxxxxxxx>
Subject: Re: Indexes on character type columns
From: Guido Neitzer <guido.neitzer@xxxxxxxxxxxxx>
Date: Thu, 22 Dec 2005 11:28:54 +0100
In-reply-to: <20051222102703.GD21783@xxxxxxxxx>
References: <255A707C-36AC-4C71-8D63-DBD0E34A5BC6@xxxxxxxxxxxxx> <20051222102703.GD21783@xxxxxxxxx>

On 22.12.2005, at 11:27 Uhr, Martijn van Oosterhout wrote:

For btrees at least, yes. Around a third of a page or about 2713 bytes
by default. For bigger things you probably want tsearch anyway.


Thanks.

cug

Attachment: smime.p7s
Description: S/MIME cryptographic signature

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

References:
- Indexes on character type columns
  - From: Guido Neitzer
- Re: Indexes on character type columns
  - From: Martijn van Oosterhout

Prev by Date: Re: Indexes on character type columns
Next by Date: About Maximum number of columns
Previous by thread: Re: Indexes on character type columns
Next by thread: About Maximum number of columns
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]

Powered by Linux