Re: [HACKERS] Bgwriter strategies

2007-07-09 Thread Simon Riggs
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):

Re: [HACKERS] Bgwriter strategies

2007-07-09 Thread Simon Riggs
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

Re: [HACKERS] tsearch2: language or encoding

2007-07-09 Thread Simon Riggs
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

Re: [HACKERS] Implementation of new operators inside the PostgreSQL

2007-07-09 Thread rupesh bajaj
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

Re: [HACKERS] Implementation of new operators inside the PostgreSQL

2007-07-09 Thread Heikki Linnakangas
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

[HACKERS] Threaded Python on BSD ...

2007-07-09 Thread Hans-Juergen Schoenig
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

Re: [HACKERS] Threaded Python on BSD ...

2007-07-09 Thread Marko Kreen
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

Re: [HACKERS] Threaded Python on BSD ...

2007-07-09 Thread Hans-Juergen Schoenig
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)

[HACKERS] Weird ecpg failures on buildfarm NetBSD members

2007-07-09 Thread Tom Lane
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.

[HACKERS] Warm standby stall -- what debug info would help?

2007-07-09 Thread Kevin Grittner
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

Re: [HACKERS] Idea: Comments on system catalogs?

2007-07-09 Thread Jim C. Nasby
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

Re: [HACKERS] Warm standby stall -- what debug info would help?

2007-07-09 Thread Tom Lane
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

Re: [HACKERS] Warm standby stall -- what debug info would help?

2007-07-09 Thread Kevin Grittner
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

[HACKERS] psql/pg_dump vs. dollar signs in identifiers

2007-07-09 Thread Tom Lane
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

Re: [HACKERS] Warm standby stall -- what debug info would help?

2007-07-09 Thread Simon Riggs
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

Re: [HACKERS] Warm standby stall -- what debug info would help?

2007-07-09 Thread Kevin Grittner
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

Re: [HACKERS] psql/pg_dump vs. dollar signs in identifiers

2007-07-09 Thread Gregory Stark
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

Re: [HACKERS] psql/pg_dump vs. dollar signs in identifiers

2007-07-09 Thread Tom Lane
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, |, +,

Re: [HACKERS] psql/pg_dump vs. dollar signs in identifiers

2007-07-09 Thread Jim C. Nasby
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

Re: [HACKERS] psql/pg_dump vs. dollar signs in identifiers

2007-07-09 Thread Gregory Stark
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

Re: [HACKERS] PQescapeBytea* version for parameters

2007-07-09 Thread Gregory Stark
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

[HACKERS] ReadRecord, EndRecPtr and XLOG_SWITCH

2007-07-09 Thread Florian G. Pflug
Hi When ReadRecord encounters an XLOG_SWITCH record, it does EndRecPtr.xrecoff += XLogSegSize - 1; EndRecPtr.xrecoff -= EndRecPtr.xrecoff % XLogSegSize; which seems to set xrecoff to either 0 (if it was 0) or to XLogSegSize (if it was 0). Note that xrecoff == XLogSegSize is kind of

Re: [HACKERS] ReadRecord, EndRecPtr and XLOG_SWITCH

2007-07-09 Thread Florian G. Pflug
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

[HACKERS] Running readonly queried on PITR slaves status update

2007-07-09 Thread Florian G. Pflug
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

Re: [HACKERS] Weird ecpg failures on buildfarm NetBSD members

2007-07-09 Thread Kris Jurka
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

Re: [HACKERS] Weird ecpg failures on buildfarm NetBSD members

2007-07-09 Thread Tom Lane
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)