On Thu, Jul 26, 2001 at 05:38:23PM -0400, Bruce Momjian wrote:
Nathan Myers wrote:
Bruce wrote:
I can confirm that current CVS sources have the same bug.
It's a bug in timestamp output.
# select '2001-07-24 15:55:59.999'::timestamp;
?column
/bin/env perl
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
that the copyright to Gemini be
signed over, before offering forgiveness.
If Red Hat forks PostgreSQL, nobody will have any grounds for complaint.
(It's been forked lots of times already, less visibly.)
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast
-- they shot the dog.
The lesson? Ask somebody competent, first, before you bet your
company playing license games.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
, and is a person who relies on someone
for financial support: Do you have any dependants?
This is not for mailing-list pendantism, but just to make sure
that the right spelling gets into the code. (The page mentioned
above was found by entering dependent dependant into Google.)
Nathan Myers
[EMAIL
NuSphere is doing with MySQL.
This is why characterizing the various licenses as more or less
business-friendly is misleading (i.e. dishonest) -- it evades the
question, friendly to whom?. Businesses sometimes compete...
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast
On Thu, Jul 12, 2001 at 11:08:34PM +0200, Peter Eisentraut wrote:
Nathan Myers writes:
When the system is too heavily loaded (however measured), any further
login attempts will fail. What I suggested is, instead of the
postmaster accept()ing the connection, why not leave the connection
accept() if we
have more than MaxBackend back ends. The OS will keep a small queue
corresponding to our small backlog, and the clients will do our load
shedding for us.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched
not have the effect you imagine, where many short-lived
connections are being made. In some cases it would mean that clients
are rejected that could have been served after a very short delay.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP
truncated to
128 anyway.
The 128 limit is common, applied on BSD and Solaris as well.
It will probably increase in future releases.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister
are supported (besides
AF_INET and AF_LOCAL aka AF_UNIX), the call to listen() might need to
be looked at. AF_INET6 (which PG will need to support someday)
doesn't seem to change matters.
Probably if listen() did fail, then one or other of bind(), accept(),
and read() would fail too.
Nathan Myers
[EMAIL
daemon that deserves higher
priority.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Tue, Jul 10, 2001 at 06:36:21PM -0400, Tom Lane wrote:
[EMAIL PROTECTED] (Nathan Myers) writes:
All the OSes we know of fold it to 128, currently. We can jump it
to 10240 now, or later when there are 20GHz CPUs.
If you want to make it more complicated, it would be more useful
the
mappings could be temporary tables.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
, so the active
range of XIDs might be a lot smaller than 2^32 in that scenario.)
That assumes a pretty frequent system restart. Many of us prefer
to code to the goal of a system that could run for decades.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast
expensive. Does UNIX
allocate a pipe buffer before there's anything to put in it?
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
On Thu, Jun 14, 2001 at 04:27:14PM -0400, Tom Lane wrote:
[EMAIL PROTECTED] (Nathan Myers) writes:
It could open a pipe, and write(2) a byte to it in the signal handler,
and then have select(2) watch that pipe. (SIGHUP could use the same pipe.)
Of course this is still a system call
, but that's far from
isn't broken. It at least merits a TODO entry.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
country's current abbreviations at compile time is madness.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
codes that are not significant;
in particular, EINTR, EAGAIN, and EWOULDBLOCK. Of these, maybe
only the first occurs on a blocking socket.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
didn't notice any problem with the Zend page.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get
are not very common.
There's little point in bookmarking a site that depends on client-side
Javascript or Java, because it won't be up for very long.
But this is *really* off topic, now.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have
or something when it's used -- as experimental. If anybody
complains later that when you ripped it out and redid it correctly,
you broke his code, you can just laugh, and add, if you're feeling
charitable, experimental features are not to be depended on.
--
Nathan Myers
[EMAIL PROTECTED
in with NUL
characters? I'd like to see PG move toward treating them as ordinary
control characters. I realize that at best it will take a long time
to get there. C is irretrievably mired in the NUL is a terminator
swamp, but SQL isn't C.
Nathan Myers
[EMAIL PROTECTED
enough, in important programs, that
worries about unreliability are no better founded than worries about
read().
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe
it easy to leave behind obsolete language
restrictions: if you wonder if it's OK now to use a feature that once
broke some crufty platform, drop it in modern.c and forget about it.
After the next release, you know the answer.
Nathan Myers
[EMAIL PROTECTED]
---(end
:
void Foo::bar() { ... } // existing interface
becomes
void Foo::bar() { ((const Foo*)this)-bar(); }
void Foo::bar() const { ... }
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go
-identical libraries
to be able to run old binaries.
A major-number bump should usually be something planned for
and scheduled.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
. Preferring mostly-full blocks improves active-storage and
cache density because a table tends to occupy fewer total blocks.
Does anybody know of papers that analyze the tradeoffs involved?
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast
on the old database when
you make the switch. But master-to-master replication is *hard* to
make work, and intrusive besides.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
transactions).
I missed the original discussions; apologies if this has already been
beaten into the ground. But... mightn't sub-transactions be a
better-structured way to expose this service?
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast
only as performance
enhancements.
It was written in 1981 and is undiminished by the subsequent decades.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
On Thu, May 17, 2001 at 06:04:54PM +0800, Lincoln Yeoh wrote:
At 12:24 AM 17-05-2001 -0700, Nathan Myers wrote:
For those of you who have missed it, here
http://www.google.com/search?q=cache:web.mit.edu/Saltzer/www/publications/endtoend/endtoend.pdf+clark+end+to+endhl=en
is the paper
On Tue, May 15, 2001 at 05:53:36PM -0400, Bruce Momjian wrote:
But, if I may editorialize a little myself, this is just indicative of a
'Fortress PostgreSQL' attitude that is easy to get into. 'We've always
I have to admit I like the sound of 'Fortress PostgreSQL'. :-)
Ye Olde
Now that 7.1 is safely in the can, is it time to consider
this patch? It provides cursor support in PL.
http://www.airs.com/ian/postgresql-cursor.patch
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists
On Wed, Apr 25, 2001 at 09:41:57AM -0300, The Hermit Hacker wrote:
On Tue, 24 Apr 2001, Nathan Myers wrote:
On Tue, Apr 24, 2001 at 11:28:17PM -0300, The Hermit Hacker wrote:
I have a Dual-866, 1gig of RAM and strip'd file systems ... this past
week, I've hit many times where CPU usage
with it if so ...
I agree that it would be useful. Even more useful would be soft load
shedding, where once some load average level is exceeded the postmaster
delays a bit (proportionately) before accepting a connection.
Nathan Myers
[EMAIL PROTECTED]
---(end
efficient alternative, /proc/loadavg. (I wouldn't
use system(), though.)
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere
.
Reliable WAN replication is harder. Most of the proprietary database
companies will tell you they can do it, but their customers will tell
you they can't.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading
On Fri, Apr 20, 2001 at 04:53:43PM -0700, G. Anthony Reina wrote:
Nathan Myers wrote:
Does the replication have to be reliable? Are you equipped to
reconcile databases that have got out of sync, when it's not?
Will the different labs ever try to update the same existing
record
the press with reasonable-sounding criticisms of PG,
they can prod the PG community into making itself look like idiots,
they will go to town on it.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive
is reset,
such as by a commit. Such a timeout would be meaningful at the
database-interface level. It could serve as a useful building block
for application-level timeouts when the client environment has trouble
applying timeouts on its own.
Nathan Myers
[EMAIL PROTECTED]
--
and do a
longjump out on timeout.
Of course, it begs the question why the client couldn't do that
itself, and leave PG out of the picture. But that's what we've
been talking about all along.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast
his rambling.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
the needed service.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
if
they are ignorant or lazy. It doesn't need any enemies in the press.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Sun, Apr 15, 2001 at 11:44:48AM -0300, The Hermit Hacker wrote:
On Sat, 14 Apr 2001, Nathan Myers wrote:
This is probably a good time to point out that this is the _worst_
_possible_ response to erroneous reportage. The perception by readers
will not be that the reporter failed
writes, and thereby get it mostly right, but the finance magazines
mangle them to total nonsense.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Fri, Apr 13, 2001 at 01:16:43AM -0400, Tom Lane wrote:
[EMAIL PROTECTED] (Nathan Myers) writes:
We have noticed here also that object (e.g. table) names get truncated
in some places and not others. If you create a table with a long name,
PG truncates the name and creates a table
On Fri, Apr 13, 2001 at 02:54:47PM -0400, Tom Lane wrote:
[EMAIL PROTECTED] (Nathan Myers) writes:
Sorry, false alarm. When I got the test case, it turned out to
be the more familiar problem:
create table foo_..._bar1 (id1 ...);
[notice, "foo_..._bar1" truncated to &q
is also a suitable location.
Linux Journal: [EMAIL PROTECTED]
Freshmeat: [EMAIL PROTECTED]
LinuxToday: http://linuxtoday.com/contribute.php3
--
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please
been released,
one of which might be just right for PG.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
; but
if you refer to the table by the same long name, PG reports an error.
(Very long names may show up in machine- generated schemas.) Would
patches for this, e.g. to refuse to create a table with an impossible
name, be welcome?
Nathan Myers
[EMAIL PROTECTED]
---(end
st
ignore the command, and in any case they all default to unsafe mode.)
If the reason that a block CRC isn't on the TODO list is that Vadim
objects, maybe we should hear some reasons why he objects? Maybe
the objections could be dealt with, and everyone satisfied.
Nathan Myers
[EMAIL
the previous text?
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
2001-01/msg00473.html
...
Incidentally, is the page at
http://www.postgresql.org/mhonarc/pgsql-hackers/2001-01/
the best place to find old messages? It's never worked right for me.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: H
uding mine), but it isn't listed here.
--
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to t
with each Linux kernel version.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
ying to do the wrong thing.
You may not have a choice, in some cases, but you should know you are
on the way to architecture meltdown. "She'll blow, Cap'n!"
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
the child's, then pg_dump
had better emit the child field explicitly.
The rule above appears to work even if inherited-default conflicts
are not taken as an error, but just result in a derived-table column
with no default.
Nathan Myers
[EMAIL PROTECTED]
---(end
. For the paranoid,
the actual instructions, extracted, are just
1:
ll %0,%3
bnez %0,2f
li %1,1
sc %1,%2
beqz %1,1b
2:
Nathan Myers
[EMAIL PROTECTED]
---
/* Machine-dependent pthreads configuration and inline functions.
Copyright
size do you think is best?
I've always used size=1 for that line...
Absolute font sizes in HTML are always a mistake. size="-1" would do.
--
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lis
a
date/time: "2001-03-22T12:47:63". To me the ISO date format
is far better than something involving month names.
I'd like to see ISO 8601 as the default data format.
--
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP
On Mon, Mar 05, 2001 at 02:00:59PM -0500, Tom Lane wrote:
[EMAIL PROTECTED] (Nathan Myers) writes:
The CRC-64 code used in the SWISS-PROT genetic database is (now) at:
ftp://ftp.ebi.ac.uk/pub/software/swissprot/Swissknife/old/SPcrc.tar.gz
From the README:
The code
does PG run on that don't have mmap()?
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
it is also a way to automate internal
documentation.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
On Sat, Mar 10, 2001 at 06:29:37PM -0500, Tom Lane wrote:
[EMAIL PROTECTED] (Nathan Myers) writes:
Is this page
http://members.fortunecity.com/nymia/postgres/dox/backend/html/
common knowledge?
Interesting, but bizarrely incomplete. (Yeah, we have only ~100
struct types ... sure
On Fri, Mar 09, 2001 at 12:05:22PM -0500, Tom Lane wrote:
Gettext takes care of this. In the source you'd write
elog(ERROR, "2200G", gettext("type mismatch in CASE expression (%s vs %s)"),
string, string);
Duh. For some reason I was envisioning the localization
,
"if it were done when 'tis done, then 'twere well It were done" cleanly.
--
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
will have reached disk safely).
Actually far more: if the checkpoints are minutes apart, even the
worst disk drive will certainly have flushed any blocks written for
the earlier checkpoint.
--
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
T
by PG. If that
requires changes in the logging protocol, it's worth it.
(What supported platforms don't have mmap?)
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
of) users on garbage hardware.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through
On Tue, Mar 06, 2001 at 04:20:13PM -0500, Lamar Owen wrote:
Nathan Myers wrote:
That is why there is no problem with version skew in the syscall
argument structures on a correctly-configured Linux system. (On a
Red Hat system it is very easy to get them out of sync, but RH fans
are used
it doesn't, blame Red Hat. :-)
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
goal for the next beta, if it's not
possible already. Given the opportunity to change the current WAL format,
it ought to be possible to avoid even needing to run a program to generate
an empty WAL.
Nathan Myers
[EMAIL PROTECTED]
---(end of broadcast
you don't change the algorithm, at least change
the name in the sources. Were you to #ifdef in a real crc-64, and make
a compile-time option to select the old one, you could allow users who
wish to avoid the initdb a way to continue with the existing pair of
CRC-32s.
Nathan Myers
[EMAIL PROTECTED]
ould allow users who
wish to avoid the initdb a way to continue with the existing pair of
CRC-32s.
Added to TODO:
* Correct CRC WAL code to be normal CRC32 algorithm
Um, how about
* Correct CRC WAL code to be a real CRC64 algorithm
instead?
Nathan Myers
[EMAIL PROTECTED]
eems
very odd. Even more odd, it did pretty well at very high loads but had
problems at intermediate loads.
Nathan Myers
[EMAIL PROTECTED]
On Sat, Feb 24, 2001 at 01:07:17AM -0500, Tom Lane wrote:
[EMAIL PROTECTED] (Nathan Myers) writes:
I see, I had it backwards: N=0 corresponds to "always delay", and
N=infinity (~0) is "never delay", or what you call zero delay. N=1 is
not interesting. N=M/2 or
, per customer preference.
Nathan Myers
[EMAIL PROTECTED]
always add
a knob later, after somebody discovers a real need.
Nathan Myers
[EMAIL PROTECTED]
On Fri, Feb 23, 2001 at 05:18:19PM -0500, Tom Lane wrote:
[EMAIL PROTECTED] (Nathan Myers) writes:
Comments? What should the threshold N be ... or do we need to make
that a tunable parameter?
Once you make it tuneable, you're stuck with it. You can always add
a knob later, after
. What we can do is give people parameters where the
default is safe, and they can play and report to us.
Perhaps I misunderstood. I had perceived N=1 as a conservative choice
that was nevertheless preferable to N=0.
Nathan Myers
[EMAIL PROTECTED]
all zero delay. N=1 is
not interesting. N=M/2 or N=sqrt(M) or N=log(M) might be interesting,
where M is the number of backends, or the number of backends with begun
transactions, or something. N=10 would be conservative (and maybe
pointless) just because it would hardly ever trigger a delay.
Nathan Myers
[EMAIL PROTECTED]
from any
other license, that way.
Complaining about the terms on something you got for nothing has to be
the biggest waste of time and attention I've seen on this list.
Nathan Myers
[EMAIL PROTECTED]
s postings about
changes he made to support putting logs on raw volumes.)
Nathan Myers
[EMAIL PROTECTED]
is a bit faster on smart disks.
This has no real implications for PG, but it is one of the reasons that
writing zeroes doesn't really wipe a disk, for forensic purposes.
Nathan Myers
[EMAIL PROTECTED]
o a short, variable time (long enough for other runnable
processes to run and yield) followed by a sequence of 1ms sleeps.
(Some of the numbers above are doubled on really dumb kernels, as
Tom noted.)
Nathan Myers
[EMAIL PROTECTED]
probably expect this to be fixed in an upcoming 2.4.x, i.e.
well before 2.6.
This is moot, though, if you're writing to a raw volume, which
you will be if you are really serious. Then, fsync really is
equivalent to fdatasync.
Nathan Myers
[EMAIL PROTECTED]
for this problem.
Build a set of RPMs without locale support?
Run it with LC_ALL="C".
Nathan Myers
[EMAIL PROTECTED]
of this, but has anyone actually ASKED Dan for permission?
What's the point? I've attached an independent implementation.
It recognizes tags for all seven levels. It needs no command-line
arguments. Untagged messages end up logged as "LOG_NOTICE".
Use it freely.
Nathan Myers
[EMAIL
, without yielding the CPU.
Nathan Myers
[EMAIL PROTECTED]
log() args right? (E.g. should it ask for LOG_PID too?)
5. What am I failing to ask about?
I'd like to turn it over to whoever can answer those questions.
Nathan Myers
[EMAIL PROTECTED]
-
/* pg_logger: stdin-to-syslog gateway for postgresql.
*
* Copyright 2001 by Nathan My
ger
on every message. Maybe stderr messages are infrequent enough that
it doesn't matter.
Nathan Myers
[EMAIL PROTECTED]
-mail. Anybody who cares enough can
apply the patch, and will be prepared for the incompatibility.
Nathan Myers
[EMAIL PROTECTED]
is likely to upset threaded
client code...
ob-ed
To null-terminate strings is an Abomination.
/ob-ed
Nathan Myers
[EMAIL PROTECTED]
at CONNECTION_BAD and
reconnect if they were...
You would have to hold the lock from BEGIN until COMMIT.
Otherwise, connection re-use is normal.
Nathan Myers
[EMAIL PROTECTED]
On Fri, Feb 02, 2001 at 12:03:14PM +, Jun Kuwamura wrote:
Furthermore, the newest version of PyGreSQL is 3.1 instead of 2.5.
Is this on the TODO-7.1 list?
Nathan Myers
[EMAIL PROTECTED]
, and has had plenty of time to stabilize.
With 768M of RAM and running only PG you not using any swap space at
all, and unix sockets don't use any appreciable space either, so the
conflicts Ian describes are impossible in your case.
Nathan Myers
[EMAIL PROTECTED]
, and build a more
PG-friendly locale.
Nathan Myers
[EMAIL PROTECTED]
1 - 100 of 146 matches
Mail list logo