Re: Efficiency of timestamps

Stephan Szabo wrote:
>
> Well, the reason I asked is to see both whether the estimates for the
> various columns were somewhere near reality (if not, then you may need to
> raise the statistics target for the column) which might affect whether
> it'd consider using a multi-column index for the conditions and sort
> rather than the index scan it was using.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

I'm going to have to pull out the 'Practical PostgreSQL' book and brush
up on optimizing.   This level of optimization is not something I have
had to deal with in the past.

Also to make this interesting.  The sub-query method is faster at times
and slower in others.   But doing two separate queries and working on
the PostIDNumber field exclusively is always blazingly fast...

     Martin Foster
     Creator/Designer Ethereal Realms
     martin@ethereal-realms.org