Jens Schipkowski wrote:
Thanks a lot to all for your tips.
Of course, I am doing all the INSERTs using a transaction. So the cost
per INSERT dropped from 30 ms to 3 ms.
The improvement factor matches with the hint by Brian Hurt.
Sorry, I forgot to mention we are using PostgreSQL 8.1.4.
Tha
Hello Hannes,
The text above the pictures on page 13. Translated in my crappy english.
The confrontation between the Opteron and Woodcrest was inevitable in
this article, but who can add 1 and 1 should have known from the
previous two pages that it doesn't look that good for AMD . Under loads
Hello Everyone,
I'm trying to find out/understand what causes my 'out of memory' error.
I do not have enough experience with such logs to understand what is
wrong or how to fix it. So i hope someone can point me in the right
direction.
The 'rpt.rpt_verrichting' table contains about 8.5 milli
e,1,2) not in
('14','15','16','17')/
to (removing the NOT): /substr(t0.code,1,2) in ('14','15','16','17')/
it uses the index, but it's not the query that needs to be run anymore.
Greetings,
Nick
Sven Geisl
2863 width=0) (actual
time=73892.153..73892.153 rows=8761024 loops=1)
Index Cond: (date_part('year'::text, datum) >
2004::double precision)
Total runtime: 631994.172 ms
A lot of improvement also in the select count: 33 minutes vs 10 minutes.
To us, the speeds are good. Very happy with the performance increase on
that select with join, since 90% of the queries are SELECT based.
The query results in 7551616 records, so that's about 4500 inserts per
second. I'm not sure if that is fast or not. Any further tips would be
welcome.
Thanks everyone.
Nicky
---(end of broadcast)---
TIP 6: explain analyze is your friend
py desktop machine with 1gb ram. Windows with
MSSQL 2000 (default installation), same database structure, same
indexes, same query, etc and it takes 17 minutes. The big difference
makes me think that i've made an error with my PostgreSQL
configuration. I just can't seem to figure it out.
Could someone perhaps give me some pointers, advice?
Thanks in advance.
Nicky
