Re: Timestamp indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mitch Vincent" <mitch(at)venux(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Timestamp indexes
Date: 2000-07-21 17:46:12
Message-ID: 17224.964201572@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Mitch Vincent" <mitch(at)venux(dot)net> writes:
> Looks like that index scan is very unattractive...

Yes, though not as bad as the cost estimator thinks (almost a 5:1 ratio
in estimated cost, but hardly any difference in real runtime). Still
have some work to do in tweaking the estimates, obviously.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jon Lapham 2000-07-21 19:36:16 Why do I need to set UPDATE permissions for fkey check?
Previous Message Mitch Vincent 2000-07-21 17:40:19 Re: Timestamp indexes