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
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
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
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
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
> -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
"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
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:
> 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
> -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
[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
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
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
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
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, 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
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
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
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:
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
> -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
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
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
"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
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_
"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
> -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
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
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
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, 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
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, 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
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
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
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
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
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 :)
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
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: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:
> 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 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:
> > 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
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
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
---(
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
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
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
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
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
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, 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
>
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
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
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
-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
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
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 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
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
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
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,
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
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
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
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
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 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.
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 */
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
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:
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
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 ...
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
>
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
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
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 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../../..
79 matches
Mail list logo
