Re: Timestamp indexes - Mailing list pgsql-sql

From Tom Lane
Subject Re: Timestamp indexes
Date
Msg-id 17224.964201572@sss.pgh.pa.us
Whole thread Raw
In response to Re: Timestamp indexes  ("Mitch Vincent" <mitch@venux.net>)
List pgsql-sql
"Mitch Vincent" <mitch@venux.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


pgsql-sql by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: Timestamp indexes
Next
From: Jon Lapham
Date:
Subject: Why do I need to set UPDATE permissions for fkey check?