[HACKERS] ipv6 build error?

2003-01-06 Thread Christopher Kings-Lynne
On FreeBSD/Alpha: gmake[3]: Entering directory `/home/chriskl/pgsql-head/src/backend/libpq' gcc -pipe -O -g -Wall -Wmissing-prototypes -Wmissing-declarations -I../../.. /src/include -c -o be-fsstubs.o be-fsstubs.c -MMD gcc -pipe -O -g -Wall -Wmissing-prototypes -Wmissing-declarations -I../../..

Re: [HACKERS] Threads

2003-01-06 Thread Ulrich Neumann
Hello all, it's very interesting to see the discussion of threads again. I've portet PostgreSQL to a thread-per-connection model based on pthreads and it is functional. Most of the work was finding all the static globals in the sourcefiles and swapping them between threads and freeing memory if

Re: [HACKERS] Threads

2003-01-06 Thread Shridhar Daithankar
On 6 Jan 2003 at 12:22, Ulrich Neumann wrote: Hello all, If someone is interested in the code I can send a zip file to everyone who wants. I suggest you preserver your work. The reason I suggested thread are mainly two folds. 1) Get I/O time used fuitfully 2) Use multiple CPU better. It

Re: [webmaster] [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread Justin Clift
Marc G. Fournier wrote: snip 'K, but that won't help the mirrors themselves ... what we need to do is pull the users-lounge over to the new VM next ... Do you have access to 64.49.215.8? .9 works for me, but .8 doesn't. :-( Regards and best wishes, Justin Clift

Re: [HACKERS] Threads

2003-01-06 Thread Greg Copeland
On Mon, 2003-01-06 at 05:36, Shridhar Daithankar wrote: On 6 Jan 2003 at 12:22, Ulrich Neumann wrote: Hello all, If someone is interested in the code I can send a zip file to everyone who wants. I suggest you preserver your work. The reason I suggested thread are mainly two folds.

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread mlw
I'll do it on my site. Marc G. Fournier wrote: Any volunteers to act as a tertiary? :) We're actually working on adding a new server online that is offshore, which will also give us another subnet to work off of ... but having a third-party secondary server wouldn't hurt, you are right

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread mlw
The site looks fantastic! Great work! Marc G. Fournier wrote: I'm just announcing here, since I'd like to see some ppl testing this out and let us know if there are any problems ... DNS is going to take a little while to propogate, so the old site may still come up in the interium ... another

[HACKERS] Bison 1.875 RPMs

2003-01-06 Thread Lee Kindness
Guys, for your convenience i've put online a source RPM for Bison 1.875 along with binary RPMs for Redhat 7.2, 7.3 and 8.0. Hunting around the net i didn't find any existing Bison = 1.50 RPMs, so this should be useful for those compiling PostgreSQL (ECPG in particular) from the CVS source:

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread mlw
Marc G. Fournier wrote: Any volunteers to act as a tertiary? :) We're actually working on adding a new server online that is offshore, which will also give us another subnet to work off of ... but having a third-party secondary server wouldn't hurt, you are right ... OK, add 64.46.156.80

Re: [HACKERS] ipv6 build error?

2003-01-06 Thread Bruce Momjian
Interesting. I see in BSD/OS /usr/include/netinet6/in6.h: struct in6_addr { union { u_int8_t __u6_addr8[16]; u_int16_t __u6_addr16[8]; u_int32_t __u6_addr32[4]; } __u6_addr;/* 128-bit IP6 address

[HACKERS] PostgreSQL libraries - PThread Support, but not use...

2003-01-06 Thread Lee Kindness
On a slightly related note to the other threads thread [sic] going on... Over the Christmas/New Year break i've been looking into making the PostgreSQL client libraries (in particular libpq and ecpg) thread-safe - that is they can safely be used by a program which itself is using mutliple threads.

Re: [HACKERS] PostgreSQL libraries - PThread Support, but not use...

2003-01-06 Thread Tom Lane
Lee Kindness [EMAIL PROTECTED] writes: On a slightly related note to the other threads thread [sic] going on... Over the Christmas/New Year break i've been looking into making the PostgreSQL client libraries (in particular libpq and ecpg) thread-safe - that is they can safely be used by a

Re: [HACKERS] PostgreSQL libraries - PThread Support, but not use...

2003-01-06 Thread Jeroen T. Vermeulen
On Mon, Jan 06, 2003 at 11:58:17AM -0500, Tom Lane wrote: AFAIK, libpq is thread-safe already, it's just not thread-aware. What you'd presumably want is a wrapper layer that adds a mutex to prevent multiple threads from manipulating a PGconn at the same time. Couldn't this be done without

Re: [HACKERS] PostgreSQL libraries - PThread Support, but not use...

2003-01-06 Thread Lee Kindness
Tom Lane writes: Lee Kindness [EMAIL PROTECTED] writes: On a slightly related note to the other threads thread [sic] going on... Over the Christmas/New Year break i've been looking into making the PostgreSQL client libraries (in particular libpq and ecpg) thread-safe - that is they

Re: [HACKERS] PostgreSQL libraries - PThread Support, but not use...

2003-01-06 Thread Bruce Momjian
We have definatly had requests for improved thread-safeness for libpq and ecpg in the past, so whatever you can do would be a help. We say libpq is thread-safe, but specifically mention the non-threadsafe calls in the libpq documentation, or at least we should. We have been making marginal

Re: [HACKERS] Upgrading rant.

2003-01-06 Thread Thomas O'Connell
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Bruce Momjian) wrote: Is pg_upgrade too hard to run? Is no one really interested in it? As an end-user, I'm very interested in pg_upgrade, but I think it's kind of a chicken and egg problem. Without much of a guarantee that it's fail-safe,

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread greg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The PHP site shows adds. And I just checked ... so does Sourceforge ... Sourceforge is not a good example: they are not a organization of open source people, but a a site owned by a company (OSDN, Inc.) which in turn is owned by another

Re: [HACKERS] Upgrading rant.

2003-01-06 Thread Thomas O'Connell
Exactly. I've got something that works and is, in fact, the recommended method for upgrading, currently. For me to switch, I'd need something in which the developers were confident enough to recommend. And even to test, I'd need something more than what is available right now. -tfo In

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread Dan Langille
On 6 Jan 2003 at 18:44, [EMAIL PROTECTED] wrote: If the banner ads (as previously stated) do not bring in much revenue, is there a reason to keep them? This has been mentioned more than once AFAIK. It is in payment to those who have provided mirror services. -- Dan Langille :

Re: [HACKERS] PostgreSQL libraries - PThread Support, but not use...

2003-01-06 Thread Lamar Owen
On Monday 06 January 2003 12:28, Lee Kindness wrote: Tom Lane writes: Lee Kindness [EMAIL PROTECTED] writes: are protected, a sqlca for each thread), but of course it relies on libpq which needs work to share a connection between thrreads. AFAIK, libpq is thread-safe already, it's

Re: [HACKERS] PostgreSQL libraries - PThread Support, but not use...

2003-01-06 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: We have definatly had requests for improved thread-safeness for libpq and ecpg in the past, so whatever you can do would be a help. We say libpq is thread-safe, but specifically mention the non-threadsafe calls in the libpq documentation, or at least we

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread mlw
Neil Conway wrote: On Sun, 2003-01-05 at 17:15, Dave Page wrote: There were always ads there Yes -- but AFAIK there were in the process of being phased out (furthermore, the old site only had ads on the initial mirror page, whereas they are much more widespread on the

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread Marc G. Fournier
On Mon, 6 Jan 2003, mlw wrote: The PHP site shows adds. And I just checked ... so does Sourceforge ... ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Upgrading rant.

2003-01-06 Thread Bruce Momjian
I think you are on to something here. Clearly dump/reload works, and testing pg_upgrade is time-consuming, so people aren't as inclined to jump into testing. It isn't quite like testing a bugfix or new feature. --- Thomas

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread Scott Lamb
Marc G. Fournier wrote: I'm just announcing here, since I'd like to see some ppl testing this out and let us know if there are any problems ... DNS is going to take a little while to propogate, so the old site may still come up in the interium ... another reason not to announce it right away :)

[HACKERS] SQL_SIZING view

2003-01-06 Thread Peter Eisentraut
The information schema is supposed to contain a view SQL_SIZING which is defined thus: List the sizing items defined in this standard and, for each of these, indicate the size supported by the SQL-implementation. But the standard does not define any sizing item or anything like

[HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-06 Thread Dann Corbit
I have a query using two postgres tables. One is called CNX_DS_53_SIS_STU_OPT_FEE_TB and the other is called CNX_DS2_53_SIS_STU_OPT_FEE_TB. I am getting 3 times slower performance than Microsoft Access when performing a left outer join. Here are the tables in question: connxdatasync=# \d

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread Marc G. Fournier
On Mon, 6 Jan 2003, Scott Lamb wrote: Marc G. Fournier wrote: I'm just announcing here, since I'd like to see some ppl testing this out and let us know if there are any problems ... DNS is going to take a little while to propogate, so the old site may still come up in the interium ...

[HACKERS] OS/400 support?

2003-01-06 Thread Justin Clift
Hi everyone, We don't support OS/400 yet do we? :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira

Re: [HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-06 Thread Tom Lane
Dann Corbit [EMAIL PROTECTED] writes: Creating the following index had no effect on performance! create unique index i1 on CNX_DS2_53_SIS_STU_OPT_FEE_TB (RT_REC_KEY, cnxarraycolumn, CRC); What does EXPLAIN ANALYZE have to say about the query? If you set enable_seqscan = 0, does the explain

Re: [HACKERS] OS/400 support?

2003-01-06 Thread Tom Lane
Justin Clift [EMAIL PROTECTED] writes: We don't support OS/400 yet do we? Never heard of it. Is it Unix-y? Do you have one available for testing? regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread Peter Eisentraut
Marc G. Fournier writes: I'm just announcing here, since I'd like to see some ppl testing this out and let us know if there are any problems ... DNS is going to take a little while to propogate, so the old site may still come up in the interium ... another reason not to announce it right away

Re: [HACKERS] OS/400 support?

2003-01-06 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 5:27 PM To: Justin Clift Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] OS/400 support? Justin Clift [EMAIL PROTECTED] writes: We don't support OS/400 yet do we? Never heard of it.

Re: [HACKERS] OS/400 support?

2003-01-06 Thread Gavin Sherry
On Mon, 6 Jan 2003, Tom Lane wrote: Justin Clift [EMAIL PROTECTED] writes: We don't support OS/400 yet do we? Never heard of it. Is it Unix-y? Do you have one available for testing? I think Justin is refering to the AS/400 operating system. I have never heard of Postgres supporting this

Re: [HACKERS] OS/400 support?

2003-01-06 Thread Justin Clift
Tom Lane wrote: Justin Clift [EMAIL PROTECTED] writes: We don't support OS/400 yet do we? Never heard of it. Is it Unix-y? Do you have one available for testing? Oops, should have been clearer. OS/400 is the operating system on the IBM AS/400 series of midrange computers: Info:

Re: [HACKERS] OS/400 support?

2003-01-06 Thread Doug McNaught
Justin Clift [EMAIL PROTECTED] writes: OS/400 is the operating system on the IBM AS/400 series of midrange computers: Info: http://search400.techtarget.com/sDefinition/0,,sid3_gci331973,00.html IBM AS/400 page:

Re: [HACKERS] OS/400 support?

2003-01-06 Thread Tom Lane
Justin Clift [EMAIL PROTECTED] writes: Info: http://search400.techtarget.com/sDefinition/0,,sid3_gci331973,00.html That page quoth OS/400 and its related software has added support for: The Portable Application Solutions Environment (PASE), which supports a subset of the AIX

Re: [HACKERS] OS/400 support?

2003-01-06 Thread Dan Langille
On Mon, 6 Jan 2003, Tom Lane wrote: Justin Clift [EMAIL PROTECTED] writes: Info: http://search400.techtarget.com/sDefinition/0,,sid3_gci331973,00.html That page quoth OS/400 and its related software has added support for: The Portable Application Solutions Environment (PASE),

Re: [HACKERS] OS/400 support?

2003-01-06 Thread cbbrowne
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Tom Lane) transmitted: Justin Clift [EMAIL PROTECTED] writes: We don't support OS/400 yet do we? Never heard of it. Is it Unix-y? Do you have one available for testing? No, OS/400 is what replaced IBM System 34,

Re: [HACKERS] OS/400 support?

2003-01-06 Thread Gavin Sherry
On Mon, 6 Jan 2003, Dan Langille wrote: On Mon, 6 Jan 2003, Tom Lane wrote: Justin Clift [EMAIL PROTECTED] writes: Info: http://search400.techtarget.com/sDefinition/0,,sid3_gci331973,00.html That page quoth OS/400 and its related software has added support for: The

[HACKERS] Thank-you to Cybertec Geschwinde Schonig

2003-01-06 Thread Christopher Kings-Lynne
Hi, I just got my Christmas thank-you from Austria! It is by far the coolest letter I have ever received. Have the other contributors got them as well? Thanks you guys, Chris Kings-Lynne ---(end of broadcast)--- TIP 5: Have you checked our

Re: [HACKERS] OS/400 support?

2003-01-06 Thread Tom Lane
Gavin Sherry [EMAIL PROTECTED] writes: It might be pretty simple given PASE support and a hardware/OS manual. The problem is that first assumption: how many OS/400 users have PASE implemented? I'd say, not many. It says here: http://www-919.ibm.com/developer/factory/pase/v5r2.html that PASE

Re: [HACKERS] OS/400 support?

2003-01-06 Thread Tom Lane
[EMAIL PROTECTED] writes: It was based on the CMU Hydra project, Really!? Small world ... I was part of the Hydra team, more years ago than I like to admit in public. Somehow, I'm not sure that PostgreSQL-on-OS/400 is likely to be more than a curiosity. Probably. But a lot of our ports are

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread Vince Vielhaber
On Mon, 6 Jan 2003, Peter Eisentraut wrote: Marc G. Fournier writes: I'm just announcing here, since I'd like to see some ppl testing this out and let us know if there are any problems ... DNS is going to take a little while to propogate, so the old site may still come up in the

Re: [HACKERS] IPv6 patch

2003-01-06 Thread Peter Eisentraut
Bruce Momjian writes: Patch applied. I added a small mention of IPv6 addresses to the pg_hba.conf documentation. Not sure where else to mention it. Can this patch please be cleaned up so the code doesn't contain an #ifdef on every other line? I would also like to discuss how IPv6 is handled

Re: [HACKERS] IPv6 patch

2003-01-06 Thread Greg Copeland
On Mon, 2003-01-06 at 15:29, Peter Eisentraut wrote: (2) A socket type is explicitly enabled for the server to use, and if creation fails, server startup fails. It seems that the current code falls back to IPv4 if IPv6 fails. IIRC, it allows it to fall back to IPv4 in case it's compiled for

Re: [HACKERS] IPv6 patch

2003-01-06 Thread Bruce Momjian
Peter Eisentraut wrote: Bruce Momjian writes: Patch applied. I added a small mention of IPv6 addresses to the pg_hba.conf documentation. Not sure where else to mention it. Can this patch please be cleaned up so the code doesn't contain an #ifdef on every other line? I posted the

Re: [HACKERS] IPv6 patch

2003-01-06 Thread Bruce Momjian
Greg Copeland wrote: On Mon, 2003-01-06 at 15:29, Peter Eisentraut wrote: (2) A socket type is explicitly enabled for the server to use, and if creation fails, server startup fails. It seems that the current code falls back to IPv4 if IPv6 fails. IIRC, it allows it to fall back to IPv4

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread Marc G. Fournier
On Mon, 6 Jan 2003, Vince Vielhaber wrote: On Mon, 6 Jan 2003, Peter Eisentraut wrote: Marc G. Fournier writes: I'm just announcing here, since I'd like to see some ppl testing this out and let us know if there are any problems ... DNS is going to take a little while to propogate,

Re: [HACKERS] IPv6 patch

2003-01-06 Thread Greg Copeland
On Mon, 2003-01-06 at 15:43, Bruce Momjian wrote: Greg Copeland wrote: On Mon, 2003-01-06 at 15:29, Peter Eisentraut wrote: (2) A socket type is explicitly enabled for the server to use, and if creation fails, server startup fails. It seems that the current code falls back to IPv4 if

Re: [HACKERS] SQL_SIZING view

2003-01-06 Thread Joe Conway
Peter Eisentraut wrote: Unless someone can offer an explanation, I am inclined to just supply an empty table and check off this item. I found the definition in FIPS 127-2: http://www.itl.nist.gov/fipspubs/fip127-2.htm The relevant section is section 16.6. Joe

Re: [HACKERS] SQL_SIZING view

2003-01-06 Thread Rod Taylor
According to: http://www.itl.nist.gov/fipspubs/fip127-2.htm#FIPS_TOP 15.2 SQL_Sizing table. The SQL_SIZING table shall consist of exactly one row for each FIPS SQL database construct defined in Section 16.6 of this standard. The SIZING_ID and DESCRIPTION columns identify the database construct

Re: [HACKERS] IPv6 patch

2003-01-06 Thread Bruce Momjian
Greg Copeland wrote: It appears right at the top because creating the socket is the first thing it does. A good question is once we have a way for the user to control IPv4/6, what do we ship as a default? IPv4-only? Both, and if both, do we fail on a kernel that doesn't have IPv6

Re: [HACKERS] IPv6 patch

2003-01-06 Thread Greg Copeland
On Mon, 2003-01-06 at 15:59, Bruce Momjian wrote: Greg Copeland wrote: It appears right at the top because creating the socket is the first thing it does. A good question is once we have a way for the user to control IPv4/6, what do we ship as a default? IPv4-only? Both, and if

Re: [HACKERS] IPv6 patch

2003-01-06 Thread Bruce Momjian
Greg Copeland wrote: On Mon, 2003-01-06 at 15:59, Bruce Momjian wrote: Greg Copeland wrote: It appears right at the top because creating the socket is the first thing it does. A good question is once we have a way for the user to control IPv4/6, what do we ship as a default?

Re: [HACKERS] IPv6 patch

2003-01-06 Thread Greg Copeland
On Mon, 2003-01-06 at 16:17, Bruce Momjian wrote: Greg Copeland wrote: On Mon, 2003-01-06 at 15:59, Bruce Momjian wrote: Greg Copeland wrote: It appears right at the top because creating the socket is the first thing it does. A good question is once we have a way for the user to

Re: [HACKERS] IPv6 patch

2003-01-06 Thread Bruce Momjian
Greg Copeland wrote: Yes, it listens on both. The original author, Nigel, tested in using both IPv4 and IPv6, and the #ipv6 IRC channel and google postings seem to indicate that too. What I am not sure how to do is say _only_ IPv4. Wouldn't you just use an IPv4 address family

Re: [HACKERS] IPv6 patch

2003-01-06 Thread Robert Treat
On Mon, 2003-01-06 at 16:40, Bruce Momjian wrote: Peter Eisentraut wrote: Bruce Momjian writes: The issue is that right now, there isn't any special IPv6 enabling, except for lines in pg_hba.conf. I think it is fine to add some enabling, but we then have an additional user interface issue.

Re: [HACKERS] IPv6 detection

2003-01-06 Thread Peter Eisentraut
Bruce Momjian writes: The IPv6 patch currently checks for the function getaddrinfo() and the include file netinet/ip6.h. getaddrinfo() has nothing to do with IPv6, and netinet/ip6.h isn't included anywhere, so why check for it? I believe we would need to check for a combination of

[HACKERS] Read-only transactions

2003-01-06 Thread Peter Eisentraut
I would like to implement read-only transactions following the SQL spec, so we can check off this item on the supported list. According to the list I gathered, the following commands will fail if the transaction is read-only: alter * analyze checkpoint cluster comment create * delete (from

Re: [HACKERS] Read-only transactions

2003-01-06 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: I would like to implement read-only transactions following the SQL spec, ... I think it's light-weight and marginally useful. Light-weight would depend on your intended implementation, I suppose. Where are you planning to check this? Also, the fact

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread Vince Vielhaber
On Mon, 6 Jan 2003, Marc G. Fournier wrote: On Mon, 6 Jan 2003, Vince Vielhaber wrote: On Mon, 6 Jan 2003, Peter Eisentraut wrote: Marc G. Fournier writes: I'm just announcing here, since I'd like to see some ppl testing this out and let us know if there are any problems ...

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread Neil Conway
On Mon, 2003-01-06 at 13:26, Marc G. Fournier wrote: On Mon, 6 Jan 2003, mlw wrote: The PHP site shows adds. Ok -- but the vast majority (say, 95%) of OSS sites don't show ads. And I just checked ... so does Sourceforge ... Not on project websites, though. In any case, I'd be fine with

Re: [HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-06 Thread Nigel J. Andrews
Added -general list so that the next followup can remove -hackers and everyone there will have had notice. On Mon, 6 Jan 2003, Dann Corbit wrote: I have a query using two postgres tables. One is called CNX_DS_53_SIS_STU_OPT_FEE_TB and the other is called CNX_DS2_53_SIS_STU_OPT_FEE_TB.

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread Marc G. Fournier
On Mon, 6 Jan 2003, Neil Conway wrote: On Mon, 2003-01-06 at 13:26, Marc G. Fournier wrote: On Mon, 6 Jan 2003, mlw wrote: The PHP site shows adds. Ok -- but the vast majority (say, 95%) of OSS sites don't show ads. Guess that makes us part of the elite 5% that do, eh? You had me

Re: [HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-06 Thread Dann Corbit
-Original Message- From: Nigel J. Andrews [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 4:58 PM To: Dann Corbit Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] I feel the need for speed. What am I doing wrong? Added -general list so that the next

Re: [HACKERS] ipv6 build error?

2003-01-06 Thread Christopher Kings-Lynne
Hi Bruce, I seem to have this: struct in6_addr { union { u_int8_t __u6_addr8[16]; u_int16_t __u6_addr16[8]; u_int32_t __u6_addr32[4]; } __u6_addr;/* 128-bit IP6 address */ }; #define s6_addr

Re: [HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-06 Thread Tom Lane
Nigel J. Andrews [EMAIL PROTECTED] writes: select a.RT_REC_KEY, a.cnxarraycolumn, a.CRC from CNX_DS_53_SIS_STU_OPT_FEE_TB a left outer join CNX_DS2_53_SIS_STU_OPT_FEE_TB b on ( a.RT_REC_KEY = b.RT_REC_KEY and a.cnxarraycolumn = b.cnxarraycolumn) where b.oid is null ; I suspect you get no

Re: [HACKERS] New Portal in Place, DNS switched ... Banner Adds

2003-01-06 Thread mlw
I know I participate on this group periodically, but my last position was CTO at a company, and I currently run my own consulting company. I feel I have a pretty neutral perspective. I don't see what the fuss is all about. Banner adds are good, if the PostgreSQL can get some good RELEVANT

Re: [HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-06 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 5:26 PM To: Nigel J. Andrews Cc: Dann Corbit; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] I feel the need for speed. What am I doing wrong? Nigel J. Andrews [EMAIL

Re: [HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-06 Thread Tom Lane
Dann Corbit [EMAIL PROTECTED] writes: Yikes! Five times slower! But then I took Tom's incredibly helpful suggestion to disable the sequential scan: Ideally, you shouldn't have to do that. Now that you have the correct indexes in place, could you show us the EXPLAIN ANALYZE output for both

[HACKERS] PostgreSQL and memory usage

2003-01-06 Thread Dann Corbit
Title: Message I have a machine with 4 CPU's and 2 gigabytes of physical ram. I would like to get PostgreSQL to use as much memory as possible. I can't seem to get PostgreSQL to use more than 100 megabytes or so. How can I optimize the use of PostgreSQL to get the maximum throughput in a

Re: [HACKERS] [GENERAL] PostgreSQL and memory usage

2003-01-06 Thread Tom Lane
Dann Corbit [EMAIL PROTECTED] writes: I have a machine with 4 CPU's and 2 gigabytes of physical ram. I would like to get PostgreSQL to use as much memory as possible. I can't seem to get PostgreSQL to use more than 100 megabytes or so. You should not assume that more is necessarily better.

Re: [HACKERS] [GENERAL] PostgreSQL and memory usage

2003-01-06 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 7:30 PM To: Dann Corbit Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [GENERAL] PostgreSQL and memory usage Dann Corbit [EMAIL PROTECTED] writes: I have a machine with 4 CPU's

[HACKERS] Have people taken a look at pgdiff yet?

2003-01-06 Thread Justin Clift
Hi everyone, Just found out that the pgdiff utility (the one for comparing two different PostgreSQL database's) was released and uploaded to SourceForge in November: http://sourceforge.net/projects/pgdiff Have people already looked at this? :-) Regards and best wishes, Justin Clift -- My

[HACKERS] bug in latest Makefile commit

2003-01-06 Thread Christopher Kings-Lynne
gmake[2]: Entering directory `/home/chriskl/pgsql-head/src/backend' Makefile:145: *** missing separator (did you mean TAB instead of 8 spaces?). Stop. Chris ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [HACKERS] IPv6 detection

2003-01-06 Thread Bruce Momjian
Peter Eisentraut wrote: Bruce Momjian writes: The IPv6 patch currently checks for the function getaddrinfo() and the include file netinet/ip6.h. getaddrinfo() has nothing to do with IPv6, and netinet/ip6.h isn't included anywhere, so why check for it? I believe we would need to check

Re: [HACKERS] IPv6 patch

2003-01-06 Thread Bruce Momjian
OK, what do we ship as a default? --- Nigel Kukard wrote: Sorry i'm not subscribed to hackers, guess i must get soon! Anyway what i think should happen is follows, if in the configuration file we specify that it must