On Thu, 2007-07-05 at 21:50 +0100, Heikki Linnakangas wrote:
All test runs were also patched to count the # of buffer allocations,
and # of buffer flushes performed by bgwriter and backends. Here's those
results (I hope the intendation gets through properly):
On Fri, 2007-07-06 at 10:55 +0100, Heikki Linnakangas wrote:
We need to get the requirements straight.
One goal of bgwriter is clearly to keep just enough buffers clean in
front of the clock hand so that backends don't need to do writes
themselves until the next bgwriter iteration. But
On Fri, 2007-07-06 at 15:43 +0900, Tatsuo Ishii wrote:
I'm wondering if a tsearch's configuration is bound to a language or
an encoding. If it's bound to a language, there's a serious design
problem, I would think. An encoding or charset is not necessarily
bound to single language. We can
Hi,
We are currently generating the patch and are ready to discuss about all
issues in the hackers list. Since this process will take some time, is it
permissible for us to release our version on our institute
http://dsl.serc.iisc.ernet.in website?
Thanks and Regards,
Rupesh Sharat
On
rupesh bajaj wrote:
We are currently generating the patch and are ready to discuss about all
issues in the hackers list. Since this process will take some time, is it
permissible for us to release our version on our institute
http://dsl.serc.iisc.ernet.in website?
Yes, sure.
You should read
hello all ...
does anybody remember why threaded python is not allowed on some
flavors of BSD?
i was surprised to read this in the configure script ...
# threaded python is not supported on bsd's
echo $as_me:$LINENO: checking whether Python is compiled with thread
support 5
echo $ECHO_N
On 7/9/07, Hans-Juergen Schoenig [EMAIL PROTECTED] wrote:
does anybody remember why threaded python is not allowed on some flavors of BSD?
AFAIR the problem is they use separate libc for threaded things,
and main postgres is (and will be) linked with non-threaded libc.
--
marko
On Jul 9, 2007, at 12:24 PM, Marko Kreen wrote:
On 7/9/07, Hans-Juergen Schoenig [EMAIL PROTECTED] wrote:
does anybody remember why threaded python is not allowed on some
flavors of BSD?
AFAIR the problem is they use separate libc for threaded things,
and main postgres is (and will be)
Today's puzzler for the curious:
Last night the buildfarm reported two ECPG-Check failures
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=salamanderdt=2007-07-08%2017:30:00
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=canarydt=2007-07-08%2017:30:01
which promptly went away again.
We're running a number of warm standby instances on one server. One of them
stalled on Saturday. When I found that this morning, I confirmed that the
files were in the directory from which it should be pulling the WAL files. The
logs showed normal processing up to the stall, with no messages
On Wed, Jul 04, 2007 at 01:03:20PM +0200, Dawid Kuroczko wrote:
Hello.
I think it could be a nice idea to put descriptions from
http://www.postgresql.org/docs/8.2/static/catalogs.html
into system catalogs itself. I.e., make a bunch of
COMMENT ON COLUMN pg_class.relname
IS 'Name of
Kevin Grittner [EMAIL PROTECTED] writes:
[2007-07-07 18:24:27.692 CDT] 5962 LOG: restored log file 0001000=
C00DA from archive
[2007-07-07 18:24:28.051 CDT] 5962 LOG: restored log file 0001000=
C00DB from archive
[2007-07-09 08:21:50.200 CDT] 5904 LOG: received fast
On Mon, Jul 9, 2007 at 10:54 AM, in message
[EMAIL PROTECTED], Kevin Grittner
[EMAIL PROTECTED] wrote:
We're running a number of warm standby instances on one server. One of them
stalled on Saturday. When I found that this morning, I confirmed that the
files were in the directory from
An example being discussed on the jdbc list led me to try this:
regression=# create table a$b$c (f1 int);
CREATE TABLE
regression=# \d a$b$c
Did not find any relation named a$b$c.
It works if you use quotes:
regression=# \d a$b$c
Table public.a$b$c
Column | Type | Modifiers
On Mon, 2007-07-09 at 12:36 -0400, Tom Lane wrote:
Kevin Grittner [EMAIL PROTECTED] writes:
[2007-07-07 18:24:27.692 CDT] 5962 LOG: restored log file 0001000=
C00DA from archive
[2007-07-07 18:24:28.051 CDT] 5962 LOG: restored log file 0001000=
C00DB from archive
On Mon, Jul 9, 2007 at 11:36 AM, in message [EMAIL PROTECTED],
Tom Lane [EMAIL PROTECTED] wrote:
Kevin Grittner [EMAIL PROTECTED] writes:
[2007-07-07 18:24:27.692 CDT] 5962 LOG: restored log file 0001000=
C00DA from archive
[2007-07-07 18:24:28.051 CDT] 5962 LOG: restored log
Tom Lane [EMAIL PROTECTED] writes:
Now, because we surround the pattern with ^...$ anyway, I can't offhand
see a use-case for putting $ with its regexp meaning into the pattern.
It's possible to still usefully use $ in the regexp, but it's existence at the
end means there should always be a
Gregory Stark [EMAIL PROTECTED] writes:
Incidentally, are these really regexps? I always thought they were globs.
They're regexps under the hood, but we treat . as a schema separator
and translate * to .*, which makes it look like mostly a glob scheme.
But you can make use of brackets, |, +,
On Mon, Jul 09, 2007 at 07:04:27PM +0100, Gregory Stark wrote:
Tom Lane [EMAIL PROTECTED] writes:
Now, because we surround the pattern with ^...$ anyway, I can't offhand
see a use-case for putting $ with its regexp meaning into the pattern.
It's possible to still usefully use $ in the
Jim C. Nasby [EMAIL PROTECTED] writes:
Unless you're doing muti-line regex, what's the point of a $ anywhere
but the end of the expression? Am I missing something? Likewise with ^.
Leaving out the backslashes, you can do things like (foo$|baz|qux)(baz|qux|)
to say that all 9 combinations of
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
Do we want something like this which provides a PQescapeByteaParam for
escaping bytea strings before passing them as text-mode parameters in
PQexecParam?
Seems a lot easier and more efficient to just pass out-of-line
Florian G. Pflug wrote:
snipped my own mail
Please disregard - I was confusing xlogid with xlog segments, so
most of my mail was nonsense.
I've fixed my problem by storing not the EndRecPtr, but rather
the ReadRecPtr, in shmem and rereading the last already applied
record in my bgreplay
Hi
After struggling with understanding xlog.c and friends far enough to
be able to refactor StartupXLOG to suit the needs of concurrent recovery,
I think I've finally reached a workable (but still a bit hacky) solution.
My design is centered around the idea of a bgreplay process that
takes over
On Mon, 9 Jul 2007, Tom Lane wrote:
Today's puzzler for the curious:
Last night the buildfarm reported two ECPG-Check failures
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=salamanderdt=2007-07-08%2017:30:00
Kris Jurka [EMAIL PROTECTED] writes:
On Mon, 9 Jul 2007, Tom Lane wrote:
Today's puzzler for the curious:
It turns out that this failure was caused by pulling in pg's own printf
implementation to the resulting ECPG program.
Hah! Nice detective work, Kris.
Calling printf(%.*f\n, -1, 14.7)
25 matches
Mail list logo
