Hmmm...
I may be mistaken (I think last time I read about optimization params was in
7.3 docs), but doesn't RPC < 1 mean that random read is faster than
sequential read? In your case, do you really think reading randomly is 4x
faster than reading sequentially? Doesn't seem to make sense, even with
Dear Gurus,
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
Sent: Thursday, June 10, 2004 7:14 PM
>
> On Thu, 10 Jun 2004, Stephan Szabo wrote:
>
> >
> > On Thu, 10 Jun 2004, Jean-Luc Lachance wrote:
> >
> > > I agree, but it should be a simple rewrite. No?
> >
> > It's N
"by default" -- do you mean there is a way to tell Linux to favor the second
real cpu over the HT one? how?
G.
--- cut here ---
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 6:26 PM
Subje
A bit OT:
do regex ops (~, ~*) use index scan in non-"C" locales? Is it worth to
convert LIKE to regex?
G.
--- cut here ---
- Original Message -
From: "Richard Huxton" <[EMAIL PROTECTED]>
Sent: Monday, July 07, 2003 4:40 PM
Check
Alexandre,
I missed your orig. post, but AFAIK multiprocessing kernels will handle HT
CPUs as 2 CPUs each. Thus, our dual Xeon 2.4 is recognized as 4 Xeon 2.4
CPUs.
This way, I don't think HT would improve any single query (afaik no postgres
process uses more than one cpu), but overall multi-quer
*happy* :)))
G.
--- cut here ---
- Original Message -
From: "Fernando Papa" <[EMAIL PROTECTED]>
Sent: Thursday, June 26, 2003 3:33 PM
I need to recheck about the "quality" of "active" field. Really I don't know
if I found a lot of
Fernando,
1. Try EXPLAIN ANALYZE. Cost alone isn't an absolute measure. I think it's
only to see which parts of the query are expected to be slowest. However,
EXP ANA will give you exact times in msec (which effectively means it
executes the query).
2. I think calling upper() for each row costs m
Michael,
Actually, you missed an alias :) the select now returned 800k rows!
(according to explain)
pointed it out below. See my prev mail for more.
If it's possible, try your query on a backend and look for notices like
"Adding missing FROM clause for table ..."
G.
Michael,
This whole query looks like a mess to me. Since I don't know the exact model
and the table stats, I don't even try to rewrite your query, however, here
are the weak points I can think of:
* as Rod pointed out, there are more tables in WHERE that aren't in FROM.
This can be a bug, but the
