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../../..
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
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
Marc G. Fournier wrote:
'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
---(end
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
>
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 ...
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 re
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:
http:
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 as
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 */
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.
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
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 withou
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
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 threa
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,
-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 com
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 articl
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 : http://www.l
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 al
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 lea
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
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
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
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 :)
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 lik
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
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
> > interiu
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 Ga
"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
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
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 a
> -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
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
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:
http:
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:
> http://www-132.ibm.com/content/home/store_IBMPublicUSA/en_US/eServe
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 env
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
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,
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 fo
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 exte
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 PA
[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
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
>
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 handle
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
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
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
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
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
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
---(
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 b
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
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
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 d
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 fo
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
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 is
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
getaddrin
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 non-te
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
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
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
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_T
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 m
> -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
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 __u6_addr.__u6_
"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 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 adds
> -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. Andre
"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 bo
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
"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 bett
> -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 machin
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
--
"M
On Monday 06 January 2003 21:01, Christopher Kings-Lynne wrote:
> 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?
Ack! I forgot to send a thankyou to them! Thanks for the reminder. Yes, I
got
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?
http://archives.postg
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 nee
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
79 matches
Mail list logo
