Re: Regression failure with PostgreSQL 8beta1 and Intel

From: "Robert E(dot) Bruccoleri" <bruc(at)stone(dot)congenomics(dot)com>
To: postgres(at)cybertec(dot)at (=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?=)
Cc: bruc(at)acm(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Regression failure with PostgreSQL 8beta1 and Intel
Date: 2004-08-12 19:30:53
Message-ID: 200408121930.i7CJUr7i178687@stone.congenomics.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Dear Hans,
>
> Robert,
>
> Are you planning to use Intel's C compiler in production?
> We tried that some time ago and corrupted our database cluster almost
> instantly (for some reason we have not investigated any further).
> I highly recommend to do some stress testing to see if everything works
> nicely.
> I'd be pleased to get some feedback.

We're using the Intel C compiler for all our code on the Altix. We
have encountered a few bugs with optimization, but on the whole, it
works pretty well, and it generates code that runs about 30% faster
than gcc (depending on the application of course). With regard to
PostgreSQL, we are not having massive problems with data
corruption. We have had problems with 7.4.3, and I'm currently testing
8.0.0beta1. I don't believe the problem with 7.4.3 is a compiler issue --
it only happens when we have multiple backends running at the same time.
Other people like Hubert Froehlich
(http://archives.postgresql.org/pgsql-general/2004-07/msg00670.php)
have run into the same problem using a completely different environment.
I'll report on 8.0.0beta1 when our testing is complete. --Bob

+-----------------------------+------------------------------------+
| Robert E. Bruccoleri, Ph.D. | email: bruc(at)acm(dot)org |
| President, Congenair LLC | URL: http://www.congen.com/~bruc |
| P.O. Box 314 | Phone: 609 818 7251 |
| Pennington, NJ 08534 | |
+-----------------------------+------------------------------------+

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message ntufar 2004-08-12 19:47:54 Re: Turkish downcasting in PL/pgSQL
Previous Message Tom Lane 2004-08-12 19:27:29 Re: Turkish downcasting in PL/pgSQL

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-08-12 19:45:11 Re: parameter hints to the optimizer
Previous Message Tom Lane 2004-08-12 19:27:29 Re: Turkish downcasting in PL/pgSQL