Re: [HACKERS] postgres is not using tas

postgres is compiled with Mipspro compiler, how may i prepare it for profiling. Thanks and regards ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL P

Re: [HACKERS] postgres is not using tas

Theoriginal problem was the low cpu usage due to semaphores, most of orange zone is due to sems thanks and regards <> ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] postgres is not using tas

hi tom how may we have believable statistics? what do u think about the graph i've sent to you, there are retrieved using hardware counters, i believe they are exact. Any idea? Thanks and regards ---(end of broadcast)--- TIP 2: you can get off all

Re: [HACKERS] postgres is not using tas

"Luis Alberto Amigo Navarro" <[EMAIL PROTECTED]> writes: > If i track a single backend during an 8 read-only queries parallel execution > these are the results( > System call summary: > Average Total > Name #Calls Time(ms) Time(ms) >

Re: [HACKERS] postgres is not using tas

hi tom If i track a single backend during an 8 read-only queries parallel execution these are the results( System call summary: Average Total Name #Calls Time(ms) Time(ms) - semop3803 0.20774.03 se

Re: [HACKERS] postgres is not using tas

"Luis Alberto Amigo Navarro" <[EMAIL PROTECTED]> writes: > could you please tell me where to find info on when and why is semop used, It's used when we need to block the current process (or to unblock another process that had been waiting). Look for calls to IpcSemaphoreLock and IpcSemaphoreUnlo

Re: [HACKERS] postgres is not using tas

hi tom could you please tell me where to find info on when and why is semop used, this thread began because i had excessive sem usage as u can see thanks and regards ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an

Re: [HACKERS] postgres is not using tas

"Luis Alberto Amigo Navarro" <[EMAIL PROTECTED]> writes: > As i know, it's only using semop, even with TAS_AND_SET defined, this is an > extract from postmaster's process registry The fact that there are some semops in the strace doesn't prove anything. We do use semaphores when we have to block

Re: [HACKERS] postgres is not using tas

here is the execution of one backend summary: System call summary: Average Total Name #Calls Time(ms) Time(ms) - semop 39305 0.06 2497.53 select 7 19.86139.01 unlink 1

Re: [HACKERS] postgres is not using tas

As i know, it's only using semop, even with TAS_AND_SET defined, this is an extract from postmaster's process registry 2515.934mS(+ 5914uS)[ 4]postgres(38089): read(25, <00 00 00 00 68 a9 6e 10 00 00 00 22 00 a8 00 c8>..., 8192) = 8192 2520.497mS(+ 4562uS)[ 4]postgres(38089): r

Re: [HACKERS] postgres is not using tas

hi tom It is compiled with mips pro compilers I've tried to remove if defined in s_lock.h, but it's still using semop, is there any other side it could be defined. thanks and regards. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] postgres is not using tas

"Luis Alberto Amigo Navarro" <[EMAIL PROTECTED]> writes: > i'm working with pg7.2 on irix6.5 platform and i've realized that postgres = > is using semop instead of tas, pg_config_os.h has define HAVE_TEST_AND_SET,= > and i don't kwow where could be the mistake. s_lock.h seems to think that __sgi

[HACKERS] postgres is not using tas

hi all i'm working with pg7.2 on irix6.5 platform and i've realized that postgres is using semop instead of tas, pg_config_os.h has define HAVE_TEST_AND_SET, and i don't kwow where could be the mistake. any suggestion? thanks and regards