Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

2009-11-29 Thread Bruce Momjian
Reydan Cankur wrote: You mean that backend does not support threading and everything I try is useless Is there a way to overcome this issue? Is there anything I can adjust on backend to enable threading? Is there any documentation to advise? Uh, no to all those questions. We offer

Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

2009-11-29 Thread Reydan Cankur
So I am trying to understand that can anyone rewrite some functions in postgresql with OpenMP in order to increase performance. does this work? On Nov 29, 2009, at 3:05 PM, Bruce Momjian wrote: Reydan Cankur wrote: You mean that backend does not support threading and everything I try is

Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

2009-11-29 Thread Tom Lane
Reydan Cankur reydan.can...@gmail.com writes: So I am trying to understand that can anyone rewrite some functions in postgresql with OpenMP in order to increase performance. does this work? Not without doing a truly vast amount of infrastructure work first. Infrastructure work that, by and

Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

2009-11-29 Thread Greg Stark
On Sun, Nov 29, 2009 at 1:24 PM, Reydan Cankur reydan.can...@gmail.com wrote: So I am trying to understand that can anyone rewrite some functions in postgresql with OpenMP in order to increase performance. does this work? Well you have to check the code path you're parallelizing for any

Re: [PERFORM] SSD + RAID

2009-11-29 Thread Ron Mayer
Bruce Momjian wrote: Greg Smith wrote: A good test program that is a bit better at introducing and detecting the write cache issue is described at http://brad.livejournal.com/2116715.html Wow, I had not seen that tool before. I have added a link to it from our documentation, and also

Re: [PERFORM] SSD + RAID

2009-11-29 Thread Bruce Momjian
Ron Mayer wrote: Bruce Momjian wrote: Greg Smith wrote: A good test program that is a bit better at introducing and detecting the write cache issue is described at http://brad.livejournal.com/2116715.html Wow, I had not seen that tool before. I have added a link to it from our

[PERFORM] Any have tested ZFS like PostgreSQL installation filesystem?

2009-11-29 Thread Ing . Marcos Luís Ortíz Valmaseda
Regards to all the list. ZFS, the new filesystem developed by the Solaris Development team and ported to FreeBSD too, have many advantages that can do that all sysadmins are questioned about if it is a good filesystem to the PostgreSQL installation. Any of you haved tested this filesystem like

Re: [PERFORM] SSD + RAID

2009-11-29 Thread Greg Smith
Bruce Momjian wrote: I thought our only problem was testing the I/O subsystem --- I never suspected the file system might lie too. That email indicates that a large percentage of our install base is running on unreliable file systems --- why have I not heard about this before? Do the write