[HACKERS] Postgres and 'directio' on Solaris/UFS

2003-02-21 Thread alex avriette
io) and run some benchmarks on a Solaris/UFS database? Thanks alex -- alex avriette, unix geek for hire http://envy.posixnap.net/ [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Irix 6.2, Postgres 7.3.1, some brokenness

2003-02-06 Thread alex avriette
Alex -- alex avriette $^X is my programming language of choice. [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Irix 6.2, Postgres 7.3.1, some brokenness

2003-02-02 Thread alex avriette
When compiled with gcc, it does trap divide by zero. Alex ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Irix 6.2, Postgres 7.3.1, some brokenness

2003-02-02 Thread alex avriette
for a > release. Looking at this more, I see this: [goro:~/postgresql-7.3.1/src] alex% grep LD Makefile* | grep -- '-r' Makefile.global:LDREL = -r Can we just not append LDREL to LD if we're on Irix? alex -- alex avriette $^X is my programming language of choice. [EMAIL

[HACKERS] Irix 6.2, Postgres 7.3.1, some brokenness

2003-02-02 Thread alex avriette
nly* database for SGI MIPS, and I'd really like to see it better supported. SGI machines are awesome for database servers. Anyone needing a shell on the machine can feel free to ask. Alex -- alex avriette $^X is my programming language of choice. [EMAIL PROTECTED] ---(

[HACKERS] problem building pg 7.3 beta 3 on solaris 8 -m64

2002-11-07 Thread alex avriette
Dave Miller ([EMAIL PROTECTED]) tells me this bug is fixed in gcc 3.2.1 (which does not appear to be distributed yet). FYI. alex ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

[HACKERS] problem building pg 7.3 beta 3 on solaris 8 -m64

2002-11-06 Thread alex avriette
make[2]: Entering directory `/data/aja96/postgresql-7.3b3/src/backend/utils/mb/conversion_procs' make[3]: Entering directory `/data/aja96/postgresql-7.3b3/src/backend/utils/mb/conversion_procs/ ascii_and_mic' gcc -shared -h libascii_and_mic.so.0 ascii_and_mic.o -L../../../../../../src/port

pgsql-hackers@postgresql.org

2002-08-08 Thread Alex Avriette
I'm going to be overseeing a move from a Mac-based postgres database (100k transactions/day, roughly 5M rows) to an SGI Octane in the near-ish term.The machine will only be two-way SMP. I'd like to see it working 64-bit and compiled with MIPSpro. I have a friend who has mostly succeeded in getting

[HACKERS] Darwin 1.4 (OS X 10.1) Broken Compile, Snapshot and 7.1.3

2001-10-05 Thread Alex Avriette
I had a catastrophic crash on one of our webservers here and took the opportunity to upgrade it. Unfortunately, after the upgrade, I am unable to compile either 7.1.3 or the current snapshot of postgres. The error I get is rather opaque: /usr/bin/ld: -undefined error must be used when -twolevel_

drop-in-ability (was: RE: [HACKERS] Re: [PATCHES] Select parser at runtime )

2001-08-13 Thread Alex Avriette
I sent the list a message a little while ago about what I do with postgres. I thought, after all this discussion, that it might be important to send a further message to the list indicating why I chose not to use Oracle. I'm going to go out on a limb and say that I have one of the largest postgre

[HACKERS] What I do with PostgreSQL

2001-07-16 Thread alex avriette
This might not be the correct list to send this to, but none of the other lists seemed appropriate. A friend of mine who uses postgres extensively at his job suggested I might send y'all a note outlining what we do with it here. In general, I am discouraged from providing specific data to non-em