Hi everybody,
One of our clients was using SQL-Server and decided to switch to
PostgreSQL 8.0.1.
Hardware: Dual processor Intel(R) Xeon(TM) CPU 3.40GHz
OS: Enterprise Linux with 2.6.9-5 SMP kernel
Filesystem: ext3
SHMMAX: $ cat /proc/sys/kernel/shmmax
6442450944 --- beleive that's ~6.5 GB,
here's explain sorry about the mess: I can attach it as text-file if you
like.
ausclimate=# explain ANALYZE select count(*) from getfutureausclimate;
QUERY PLAN
1055 99786 54 20
21 5
0 1 25820 9128 6345768 167468401 2868 3016 1049 98301 55 21
19 6
2 1 25820 8160 6345828 167557600 3079 3056 1050 93725 55 19
21 5
On Thu, 21 Apr 2005, Shoaib Burq (VPAC) wrote:
here's explain sorry about the mess: I can attach it as text
Is this an IO intensive query? If running both in parellel results in
2x the run time and you have sufficient cpus it would (to me) indicate
you don't have enough IO bandwidth to satisfy the query.
any tips on how to verify this?
---(end of
=
CurrentAusClimate.AusPosNum) AND (CurrentAusClimate.iMonth =
outer.iMonth))
Total runtime: 462218.120 ms
(23 rows)
On Thu, 21 Apr 2005, Russell Smith wrote:
On Thu, 21 Apr 2005 10:44 pm, Shoaib Burq (VPAC) wrote:
- Nested Loop (cost=2.19..1069345.29 rows=16 width=58) (actual
time=135.390
on ClimateChangeModel40.
regards, tom lane
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
--
Shoaib Burq
--
VPAC