Re: [GENERAL] hyperthreading and pqlib
The Postgres version is 8.2.4 and seems that the operating system is not affected by this application freezing. Thanks.Luca.- Original Message Da: quot;Bruce Momjianquot; lt;[EMAIL PROTECTED]gt; To: Cc: pgsql-general@postgresql.orgOggetto: Re: [GENERAL] hyperthreading and pqlib Data: 08/02/08 18:14 [EMAIL PROTECTED] wrote: gt; Hi all. gt; Has someoneamp;nbsp;encountered a problem using pqlib in a multi-threading gt; application (POSIX or Win32) when the Intel Hyperthreading is enabled? gt; Disabling the hyperthreading option from the bios of the computer all works gt; fine, otherwise the threaded application does freeze randomically after a gt; while (This behaviour is common to Linux and WIndows version of the gt; multi-threaded application).Any idea?Thanks in advance.Luca. What version of Postgres? Does the application freeze or the operating system? We have not heard similar reports. We don#39;t actually recommend hyperthreading usually. -- Bruce Momjian lt;[EMAIL PROTECTED]gt;http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: A San Valentino HIT dÂ’amore e teneri Sfondi per il tuo cell. Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7548d=20080208
Re: [GENERAL] hyperthreading and pqlib
Bruce Momjian [EMAIL PROTECTED] writes: [EMAIL PROTECTED] wrote: Has someonenbsp;encountered a problem using pqlib in a multi-threading application (POSIX or Win32) when the Intel Hyperthreading is enabled? Disabling the hyperthreading option from the bios of the computer all works fine, otherwise the threaded application does freeze randomically after a while (This behaviour is common to Linux and WIndows version of the multi-threaded application).Any idea?Thanks in advance.Luca. What version of Postgres? Does the application freeze or the operating system? We have not heard similar reports. We don't actually recommend hyperthreading usually. What it sounds like to me is that the multithreaded application has bugs (race conditions) that happen to be more easily exposed when HT is on, presumably because it's then possible for more threads to actually execute concurrently. If libpq is involved in this at all, it's probably because you're failing to prevent multiple threads from using the same PGconn object at the same time. But it's just as likely that the bug is completely unrelated to libpq. Anyway, you're going to need to get out your debugger and see where it's getting stuck before you can make much progress fixing it. regards, tom lane ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] hyperthreading and pqlib
Hi all. Has someonenbsp;encountered a problem using pqlib in a multi-threading application (POSIX or Win32) when the Intel Hyperthreading is enabled? Disabling the hyperthreading option from the bios of the computer all works fine, otherwise the threaded application does freeze randomically after a while (This behaviour is common to Linux and WIndows version of the multi-threaded application).Any idea?Thanks in advance.Luca. -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Quanti possono essere i tuoi potenziali clienti? Scoprilo subito con il servizio di Email Marketing di Email.it Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7484d=20080208
Re: [GENERAL] hyperthreading and pqlib
[EMAIL PROTECTED] wrote: Hi all. Has someonenbsp;encountered a problem using pqlib in a multi-threading application (POSIX or Win32) when the Intel Hyperthreading is enabled? Disabling the hyperthreading option from the bios of the computer all works fine, otherwise the threaded application does freeze randomically after a while (This behaviour is common to Linux and WIndows version of the multi-threaded application).Any idea?Thanks in advance.Luca. What version of Postgres? Does the application freeze or the operating system? We have not heard similar reports. We don't actually recommend hyperthreading usually. -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
