report on 8.0.0beta1 when our testing is complete. --Bob
+---------+----+
| Robert E. Bruccoleri, Ph.D. | email: [EMAIL PROTECTED]|
| President, Congenair LLC| URL: http://www.congen.com/~bruc |
| P.O. Box 314| Pho
ot;, l, st, endp);
}
using the Intel compiler provided libraries prints
l = -1234 st = 6fffb720 endp = 6fffb726
whereas gcc and glibc yields
l = 0 st = 6fffb710 endp = 6fffb710
Boo hiss...
+-+---
+-++
| Robert E. Bruccoleri, Ph.D. | email: [EMAIL PROTECTED]|
| President, Congenomics Inc. | URL: http://www.congen.com/~bruc |
| P.O. Box 314| Phone: 609 818 7251|
| Pennington, NJ
ted. --Bob
+-+----+
| Robert E. Bruccoleri, Ph.D. | email: [EMAIL PROTECTED]|
| President, Congenomics Inc. | URL: http://www.congen.com/~bruc |
| P.O. Box 314| Phone: 609 818 7251|
| Pennington
Dear Devrim,
I have been using Postgres on Irix for over 8 years, and I have only
used the SGI provided compilers. GCC doesn't work well on Irix. In addition,
you can build a 64 bit version of PostgreSQL. Here's the script we used for
PostgreSQL 7.3.2:
#!/bin/ksh -x
./copy_local_files_for
Bristol-Myers Squibb, and I will spend some time to keep it working.
Sincerely,
Bob
>
>
> "Robert E. Bruccoleri" <[EMAIL PROTECTED]> writes:
> > There are differences in the regression test
947 23:59:12')::int4;
int4
-714589248
(1 row)
--Bob
>
>
> "Robert E. Bruccoleri" <[EMAIL PROTECTED]> writes:
> > There are differences in the regression tests for PostgreSQL
> > 7.3b2 with handling of times before 1970. I recently sent ou
7.2
works fine on Irix for these cases.
Can anyone familiar with the code please take a look
at the diffs and identify where the trouble may be? I'd be happy
to rerun the regression tests to help diagnose the problem.
--Bob
+-+-----
o WRT to this
diff. --Bob
+-++
| Robert E. Bruccoleri, Ph.D. | email: [EMAIL PROTECTED]
Dear Tom,
>
>
> "Robert E. Bruccoleri" <[EMAIL PROTECTED]> writes:
> > gmake[4]: Entering directory `/pg/postgresql-7.3b2/src/backend/utils/hash'
> > cc -64 -g -woff 1164,1171,1185,1195,1552 -I../../../../src/include
>-I/stf/sys64/include -
^
Looks like a bug to me.
All the regression tests pass except for tests involving Savings Time
which are off by one hour. --Bob
+-+------------+
| Robert E. Bruccoleri, Ph.D. | email: [EMAIL PROTECTED]|
| P.O
elp you improve your
> performance.
> Regards
+-+--------+
| Robert E. Bruccoleri, Ph.D. | email: [EMAIL PROTECTED]|
| P.O. Box 314| URL: http://www.c
000 system available to
you with hardware support, would the group be willing to tailor the
SGI port for better performance?
Sincerely,
Bob
>
>
> "Robert E. Bruccoleri" <[EMAIL PROTECTED]> w
Tom Lane writes:
>
>
> "Robert E. Bruccoleri" <[EMAIL PROTECTED]> writes:
> > On SGI multiprocessor machines, I suspect that a spinlock
> > implementation of LWLockAcquire would give better performance than
> > using IPC semaphores. Is there any speci
?
+-++
| Robert E. Bruccoleri, Ph.D. | email: [EMAIL PROTECTED]|
| P.O. Box 314| URL: http://www.congen.com/~bruc |
| Pennington, NJ 08534
reation and sorting), but without success.
+-+----+
| Robert E. Bruccoleri, Ph.D. | email: [EMAIL PROTECTED]|
| P.O. Box 314| URL: http://www.congen.com/~bruc |
| Penningto
the MIPS test_and_set instructions are
really fast and should be used.
+-+----+
| Robert E. Bruccoleri, Ph.D. | email: [EMAIL PROTECTED]|
| P.O. Box 314| URL: http://www.congen.com/~bruc |
| Pennington,
iginal Message -
> From: "Tom Lane" <[EMAIL PROTECTED]>
> To: "Luis Alberto Amigo Navarro" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>; "Robert E. Bruccoleri"
> <[EMAIL PROTECTED]>
> Sent: Monday, March 18, 2002 5:36 PM
Dear Tom,
>
>
> [EMAIL PROTECTED] (Robert E. Bruccoleri) writes:
> > BTW, given the high level of support that you provide to the PostgreSQL
> > community, it's very accurate to state that support for PostgreSQL
> > is far superior to that of Oracle, especiall
Dear Tom,
>
>
> [EMAIL PROTECTED] (Robert E. Bruccoleri) writes:
> > For my immediate problem, would removing the spinlock acquisition
> > be OK?
>
> It'd be interesting to remove the marked lines:
>
> bufHdr = &BufferDescriptors[buffe
for looking into this problem.
Sincerely,
Bob
+--+--------+
| Robert E. Bruccoleri, Ph.D. | Phone: 609 737 6383|
| President, Congenomics, Inc. | Fax: 609 737 7528|
| 114 W Franklin Ave, Suite K1,4,5 | email:
es to improve
PostgreSQL's performance. For example, the XFS filesystem journal can be
placed on a drive different from the data drive. This would substantially
improve write performance.
+--+----+
| Robert E. Bruccoleri, Ph.D.
been with PostgreSQL 6.5.3
which doesn't have the WAL.
If I have some time, I will try the experiment of loading a database
of mine into PG 7.1 using -F or not and I'll report the timing.
+--+------------+
| Robert E. Bruccol
e and
administer (at least on SGI's).
+--+------------+
| Robert E. Bruccoleri, Ph.D. | Phone: 609 737 6383|
| President, Congenomics, Inc. | Fax: 609 737 7528|
| 114 W Franklin Ave, Suite K1,4,5
der.
+--++
| Robert E. Bruccoleri, Ph.D. | Phone: 609 737 6383|
| President, Congenomics, Inc. | Fax: 609 737 7528|
| 114 W Franklin Ave, Suite K1,4,5 | email: [EMAIL PROTECTED]|
| P.O. Box 314 |
more reliable than Irix 6.2. --Bob
+--+------------+
| Robert E. Bruccoleri, Ph.D. | Phone: 609 737 6383|
| President, Congenomics, Inc. | Fax: 609 737 7528|
| 114 W Franklin Ave, Suite K1,4,
Dear Marc,
>
> On Tue, 27 Mar 2001, Robert E. Bruccoleri wrote:
>
> > I contributed the first working s_lock.c code for the SGI's over three
> > years ago (using the test_and_set library calls). It's been working
> > for me ever since in a heavy multi-user
t works well.
BTW, SGI is distributing its compilers for Linux/Intel under an open
source license. Depending on the progress of Intel chips versus MIPS
chips, the cost issue of the compilers on SGI's will eventually
disappear.
Regards, Bob
+------+------
mpiler systems works poorly on SGI's. In this
environment, you need to stick to the SGI provided compilers. Once you
get used to them, they work fairly well.
Sincerely,
Bob
+--+------------+
| Robert E. Bruccoleri, Ph.D.
I've successfully tested release 7.1beta4 on Irix 6.5.11. I'll run another
test on the most recent beta or RC next week.
+--+----+
| Robert E. Bruccoleri, Ph.D. | Phone: 609 737 6383|
| President, C
Dear Hannu,
>
> "Robert E. Bruccoleri" wrote:
> >
> > Dear Hannu,
> > >
> > > "Robert E. Bruccoleri" wrote:
> > > >
> > > > explain select count(*) from comparisons_4 where code = 80003;
> > >
Dear Hannu,
>
> "Robert E. Bruccoleri" wrote:
> >
> > explain select count(*) from comparisons_4 where code = 80003;
> > NOTICE: QUERY PLAN:
> >
> > Aggregate (cost=15659.29..15659.29 rows=1 width=0)
> > -> Seq Scan o
ly, I apologize for being a little strident here. I've been
advocating for and using Postgres for four years, and it's frustrating
when a new version results in a serious and noticeable performance
degradation.
Sincerely,
Bob
+--+-
recently. Thank
you.
+--+--------+
| Robert E. Bruccoleri, Ph.D. | Phone: 609 737 6383|
| President, Congenomics, Inc. | Fax: 609 737 7528|
| 114 W Franklin Ave, Suite K1,4,5 | email: [EMAIL PROTECTED]|
| P.O. Box 314
34 matches
Mail list logo
