From: | Martin Foster <martin(at)ethereal-realms(dot)org> |
---|---|
To: | PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Efficiency of timestamps |
Date: | 2003-07-09 06:51:42 |
Message-ID: | 3F0BBB7E.6080008@ethereal-realms.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)ethereal-realms(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Bowlby | 2003-07-09 17:29:38 | Some very weird behaviour.... |
Previous Message | Stephan Szabo | 2003-07-09 05:01:33 | Re: Efficiency of timestamps |