Guys, I don't see this theoretical discussion going anywhere. I think
it's time to simply implement this and evaluate it on a bigger
machine.

Sure. I was kind of hoping that someone else would implement it, because I'm a reviewer on this one, and I do not have the bigger machine at hand either:-) If nothing happens and when I have some time, I'll do it.

It can't take very long to implement tosimply just write to one
file instead of the multiple files as now.

Sure.

The posix guaranteed fprintf locking should already take care of the rest.

I think I would try with snprintf to reduce locking.

Note that I'm first trying to evaluate logging overhead, but I'm quite far from Tomas figures at the moment, looks more like 20% overhead (12 threads read-only load, runs at about 130000 tps with full logging, 160000 without, repeated 5 times with the similar results).

In such a case, a mutex would be a bad idea, but I must add that detailed logging is a plain bad idea as well!

--
Fabien.


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to