Re: Optimizer not using index on 120M row table

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimizer not using index on 120M row table
Date: 2003-04-08 03:54:21
Message-ID: 20030407225421.N31861@flake.decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)nasby(dot)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?"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Bartlett 2003-04-08 03:55:36 Re: Why no performance boost although I added an index?
Previous Message Tom Lane 2003-04-08 03:51:17 Re: Optimizer not using index on 120M row table