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
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
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
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
'\|
> 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 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,
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
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:
> > 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
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
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
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]
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
> > 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
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
> 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
> 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
[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
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
[ 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
[ 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
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
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
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
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
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
> 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.
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
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
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
>> 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
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
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
> -
>
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
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 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
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
> > 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
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
> 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
> 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
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
> > 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
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
> 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.
>
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
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
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
48 matches
Mail list logo
