I have created a stored procedure (written in c) and loaded into a
postgresql 7.2.1 database. I have also done a test routine that executes
a bunch (100+) of these stored procedures.
Each test thread does these operations:
- LOCK TABLE XXX IN ACCESS EXCLUSIVE MODE
- SELECT mystoreprocedure()
The strange thing is that the testing process is very slow (seems like
fsync is enabled while i have disabled it in postgresql.conf file).
Then i have installed postgresql 7.1.3 and the testing process is now as
fast as i was expecting...
Why is there such a different behaviour between the two versions? The
configuration files are similar (except for the stats processor that is
present in 7.2.1).
The system is a redhat 7.2 with kernel 2.4.18.
Doct. Eng. Denis Gasparin: denis(at)edistar(dot)com
Programmer & System Administrator - Edistar srl
pgsql-general by date
|Next:||From: Vaclav Kulakovsky||Date: 2002-04-30 12:09:55|
|Subject: Data integrity problem !!!|
|Previous:||From: Joshua Drake||Date: 2002-04-30 09:42:41|
|Subject: Re: Bookbiz database|