I have comitted the fix to parser/parse_coarse.c. My previous patches
was not correct and I changed the checking right after
typeInheritsFrom.
--
Tatsuo Ishii
> vacuum analyze on pg_type fails if bogus entries remain in pg_operator.
> Here is a sample script to reproduce the problem.
>
> drop t
Hello Tom,
Tuesday, February 27, 2001, 12:45:18 PM, you wrote:
TL> Bruce Momjian <[EMAIL PROTECTED]> writes:
>> I know it is easy for you, but the number of reports and problems we
>> hear about shows it is an issue for some.
TL> We hear some reports, but not a lot. We have no idea whatever wh
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I know it is easy for you, but the number of reports and problems we
> hear about shows it is an issue for some.
We hear some reports, but not a lot. We have no idea whatever what
problems might ensue if we used mmap instead. I'm dubious that SysV
shm
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > I thought "typeidIsValid(targetTypeId) == false" is better than
> > "!typeidIsValid(targetTypeId)"?
>
> I've always thought that "== true" and "== false" on something that's
> already a boolean are not good style. It's a matter of taste I suppose.
>
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> I thought "typeidIsValid(targetTypeId) == false" is better than
> "!typeidIsValid(targetTypeId)"?
I've always thought that "== true" and "== false" on something that's
already a boolean are not good style. It's a matter of taste I suppose.
But note that
> > But the mmap() limits are much larger than the SysV limits, aren't they,
> > to the point where you would never have to fiddle with the mmap() limits
> > to get 100mb of buffers, right?
>
> Not necessarily ... it depends on the admin of the server ... then again,
> I don't consider it a hassl
On Mon, 26 Feb 2001, Bruce Momjian wrote:
> > Okay ... same applies to MMAP() though, I had to disappoint ... there are
> > kernel limits that, at least under FreeBSD, do require a kernel
> > recompile in order to exceed ... alot of them have been moved (maybe all
> > now) to sysctl settable valu
> I'd suggest not arbitrarily erroring out when there is no need for
> a conversion, and not doing the cache lookup implied by typeidIsValid
> when it's not necessary to touch the type at all. Hence, I'd recommend
> moving this down a few lines. Also, conform to the surrounding coding
> style an
> Okay ... same applies to MMAP() though, I had to disappoint ... there are
> kernel limits that, at least under FreeBSD, do require a kernel
> recompile in order to exceed ... alot of them have been moved (maybe all
> now) to sysctl settable values ... but, again, under some of the
> commercial O
This looks very safe and I believe should be applied.
> vacuum analyze on pg_type fails if bogus entries remain in pg_operator.
> Here is a sample script to reproduce the problem.
>
> drop table t1;
> create table t1(i int);
> drop function foo(t1,t1);
> create function foo(t1,t1) returns bool a
> > the only problem is because if we need to tune Postermaster to use
> > large buffer while system havn't so many SYSV shared memory, in many
> > systemes, we need to recompile OS kernel, this is a small problem to install
> > PGSQL to product environment.
>
> What? You don't automatically rec
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> *** parse_coerce.c.orig Sat Feb 3 20:07:53 2001
> --- parse_coerce.cTue Feb 27 11:33:01 2001
> ***
> *** 190,195
> --- 190,201
> Oid inputTypeId = input_typeids[i];
> Oid
On Mon, 26 Feb 2001, Bruce Momjian wrote:
> > > the only problem is because if we need to tune Postermaster to use
> > > large buffer while system havn't so many SYSV shared memory, in many
> > > systemes, we need to recompile OS kernel, this is a small problem to install
> > > PGSQL to product e
vacuum analyze on pg_type fails if bogus entries remain in pg_operator.
Here is a sample script to reproduce the problem.
drop table t1;
create table t1(i int);
drop function foo(t1,t1);
create function foo(t1,t1) returns bool as 'select true' language 'sql';
create operator = (
leftarg =
On Tue, 27 Feb 2001, jamexu wrote:
> Hello The,
>
> Tuesday, February 27, 2001, 11:00:05 AM, you wrote:
>
> THH> On Tue, 27 Feb 2001, jamexu wrote:
>
> >> Hello Tom,
> >>
> >> Tuesday, February 27, 2001, 12:23:25 AM, you wrote:
> >>
> >> TL> This looks a lot like exchanging the devil we know (Sys
Jaume Teixi <[EMAIL PROTECTED]> writes:
> I finally percated that when data contains 'ñ' or 'à' it's impossible to
> parse trought:
> COPY products FROM '/var/lib/postgres/dadesi.txt' USING DELIMITERS '|' \g
> it causes:
> SELECT edicion FROM products;
> edicion
> -
>
Hello The,
Tuesday, February 27, 2001, 11:00:05 AM, you wrote:
THH> On Tue, 27 Feb 2001, jamexu wrote:
>> Hello Tom,
>>
>> Tuesday, February 27, 2001, 12:23:25 AM, you wrote:
>>
>> TL> This looks a lot like exchanging the devil we know (SysV shmem) for a
>> TL> devil we don't know. Do I need t
>> the only problem is because if we need to tune Postermaster to use
>> large buffer while system havn't so many SYSV shared memory, in many
>> systemes, we need to recompile OS kernel, this is a small problem to install
>> PGSQL to product environment.
Of course, if you haven't got mmap(), a re
On Tue, 27 Feb 2001, jamexu wrote:
> Hello Tom,
>
> Tuesday, February 27, 2001, 12:23:25 AM, you wrote:
>
> TL> This looks a lot like exchanging the devil we know (SysV shmem) for a
> TL> devil we don't know. Do I need to remind you about, for example, the
> TL> mmap bugs in early Linux releases
Peter Schindler <[EMAIL PROTECTED]> writes:
> FATAL: s_lock(fcc01067) at xlog.c:2088, stuck spinlock. Aborting.
Judging from the line number, this is in CreateCheckPoint. I'm
betting that your platform (Solaris 2.7, you said?) has the same odd
behavior that I discovered a couple days ago on HPUX
Hello Tom,
Tuesday, February 27, 2001, 12:23:25 AM, you wrote:
TL> This looks a lot like exchanging the devil we know (SysV shmem) for a
TL> devil we don't know. Do I need to remind you about, for example, the
TL> mmap bugs in early Linux releases? (I still vividly remember having to
TL> aband
> There is also a component of netsaint (www.netsaint.org) that will
> check PostgreSQL postmasters. I hope to add to that the ability to
Thanks.
I've also seen a lot of announcements of OpenNMS at freshmeat. All I know is
that it's Java based, and as fas as I can tell will work without agents.
is regression.out and/or regression.diff deleted if the tests pass? I've
never seen all tests pass so I don't know but I just had someone tell me
that it does.
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTEC
I just put the regress test tool online. It's just a simple form, I'll
add the borders and stuff later. No reporting tool yet, but I'm working
on that now.
http://www.postgresql.org/~vev/regress/
Be prepared, it's gonna ask you for your regression.out and
regression.diff files. I just upload
Can anyone tell me what is going on, when I get a stuck spinlock?
Is there a data corruption or anything else to worry about ?
I've found some references about spinlocks in the -hackers list,
so is that fixed with a later version than beta4 already?
Actually I was running a stack of pgbench jobs
One thing that I remember from a performance test we once did is, that the results
are a lot more realistic, better and more stable, if you try to decouple the startup
of
the different clients a little bit, so they are not all in the same section of code at
the same time.
We inserted random u
[ Charset ISO-8859-1 unsupported, converting... ]
>
> > Are there any major outstandings that ppl have on their plates,
> > that should prevent a release?
>
> Imho startup after a failing WAL recovery is a 'must do' before release,
> as Tom pointed out. Remember that you can currently run in
[ Charset ISO-8859-1 unsupported, converting... ]
>
> > Regardless of whether this particular behavior is fixable, this brings
> > up something that I think we *must* do before 7.1 release: create a
> > utility that blows away a corrupted logfile to allow the system to
> > restart with whatever i
Tom Lane <[EMAIL PROTECTED]> writes:
> > Since mmap() is how everybody implements shared libraries,
>
> Now *there's* a sweeping generalization. Documentation of this
> claim, please?
I've seen a lot of shared library implementations (I used to be the
GNU binutils maintainer), and Nathan is ap
[EMAIL PROTECTED] (Nathan Myers) writes:
> This is supported on Linux and BSD, but not on Solarix 7. It's not
> necessary; you can just map /dev/zero on SysV systems that don't
> have MAP_ANON.
HPUX says:
The mmap() function is supported for regular files. Support for any
other typ
> On Sun, Feb 25, 2001 at 11:28:46PM -0500, Tom Lane wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > It allows no backing store on disk.
>
> I.e. it allows you to map memory without an associated inode; the memory
> may still be swapped. Of course, there is no problem with mapping a
> Are there any major outstandings that ppl have on their plates,
> that should prevent a release?
Imho startup after a failing WAL recovery is a 'must do' before release,
as Tom pointed out. Remember that you can currently run into this situation
with as easy a mistake as running out of d
Morning all ...
Are there any major outstandings that ppl have on their plates,
that should prevent a release? I'd like to put out an RC1 by Friday this
week, with a full release schedualed for March 15th ... this would give
Thomas his two weeks for the docs freeze ...
Basicall
> > Imho this write at logfile init time adds a substantial amount of IO,
> > that would better be avoided. If we really need this, it would imho
> > be better to preallocate N logfiles and reuse them after checkpoint.
>
> Already done. See the WAL_FILES parameter.
I meant something else. I d
Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
> Imho this write at logfile init time adds a substantial amount of IO,
> that would better be avoided. If we really need this, it would imho
> be better to preallocate N logfiles and reuse them after checkpoint.
Already done. See the WAL_FILES
Hmmm... that's good to know. Basically, I'm trying to model fixed order
tables in another application through a proxy mechanism (see
http://rpgsql.sourceforge.net/). I guess I will have to force row
ordering on all proxied tables.
Tim
Tom Lane wrote:
> "Timothy H. Keitt" <[EMAIL PROTECTED]
hi i'm re-sending this mail again to seek more help since i haven't got
any solution as yet. Additionaly , could it be an oracle taking up so much
resource so that i postgres can't get any of them?
Katsu
-- Forwarded message --
Date: Sun, 18 Feb 2001 15:27:47 +1100 (EST)
From
Vince Vielhaber wrote:
>
> On Sun, 25 Feb 2001, Kaare Rasmussen wrote:
>
> > Hi
> >
> > I've tried to search the site, but no usable pages turned up.
> >
> > My question is about monitoring PostgreSQL and if it turns out to be "down"
> > to notify a person to take action.
> >
> > I'm surprised t
I finally percated that when data contains 'ñ' or 'à' it's impossible to
parse trought:
COPY products FROM '/var/lib/postgres/dadesi.txt' USING DELIMITERS '|' \g
it causes:
SELECT edicion FROM products;
edicion
-
España|Nacional <---puts on the same cell either th
> > I am having some problems with our proxy server (wget times out on header)
> > and would like to know whether it would be possible to install http access
> > to the snapshots and other download files ?
> >
> > This would probably also benefit others, no ?
>
> See if this works: http://www.p
Just an FYI -- It works well from behind my proxy..
-Mitch
- Original Message -
From: "Vince Vielhaber" <[EMAIL PROTECTED]>
To: "Zeugswetter Andreas SB" <[EMAIL PROTECTED]>
Cc: "'The Hermit Hacker'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 26, 2001 7:53 AM
Subject:
On Mon, 26 Feb 2001, Nathan Myers wrote:
> > While I've said before that I don't think it's really necessary for
> > processes that aren't children of the postmaster to access the shared
> > memory, I'm not sure that I want to go over to a mechanism that makes it
> > *impossible* for that to be d
On Mon, 26 Feb 2001, Zeugswetter Andreas SB wrote:
>
> I am having some problems with our proxy server (wget times out on header)
> and would like to know whether it would be possible to install http access
> to the snapshots and other download files ?
>
> This would probably also benefit others,
> Regardless of whether this particular behavior is fixable, this brings
> up something that I think we *must* do before 7.1 release: create a
> utility that blows away a corrupted logfile to allow the system to
> restart with whatever is in the datafiles. Otherwise, there is no
> recovery techn
On Sat, 24 Feb 2001 18:48:15 -0800 "Richard T. Robino"
<[EMAIL PROTECTED]> wrote:
> Use binary type for transferring files via FTP.
it's the same
On Sat, 24 Feb 2001 09:27:43 +0100 Stefan Huber
<[EMAIL PROTECTED]> wrote:
> wild guess: maybe you must escape the pipe-symbol: ...USING DELIMITERS
'\|
test/bench/{create|runtest}.sh uses switch '-Q' for
postgres, but postgres gives error on it. Otherwise
seems working, only lots of debug output is seen.
--
marko
I am having some problems with our proxy server (wget times out on header)
and would like to know whether it would be possible to install http access
to the snapshots and other download files ?
This would probably also benefit others, no ?
Thanks
Andreas
On Sun, Feb 25, 2001 at 11:28:46PM -0500, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > It allows no backing store on disk.
I.e. it allows you to map memory without an associated inode; the memory
may still be swapped. Of course, there is no problem with mapping an
inode too
48 matches
Mail list logo
