Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizer not using index on 120M row table - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: Optimizer not using index on 120M row table
Date
Msg-id 20030407225421.N31861@flake.decibel.org
Whole thread Raw
In response to Re: Optimizer not using index on 120M row table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Optimizer not using index on 120M row table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On Mon, Apr 07, 2003 at 11:51:17PM -0400, Tom Lane wrote:
> or just declare project_id to be integer (hint: the space savings are
> completely illusory in this example, anyway, because of alignment
> requirements).

Hrm... where can I find more info about that?
--
Jim C. Nasby (aka Decibel!)                    jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Optimizer not using index on 120M row table
Next
From: Jonathan Bartlett
Date:
Subject: Re: Why no performance boost although I added an index?