Re: [HACKERS] Synchronous replication

2010-07-20 Thread Fujii Masao
On Fri, Jul 16, 2010 at 7:43 PM, Heikki Linnakangas wrote: > On 16/07/10 10:40, Fujii Masao wrote: >> >> So we should always prevent the standby from applying any WAL in pg_xlog >> unless walreceiver is in progress. That is, if there is no WAL available >> in the archive, the standby ignores pg_xl

Re: [HACKERS] patch (for 9.1) string functions

2010-07-20 Thread Pavel Stehule
2010/7/21 Itagaki Takahiro : > I reviewed the core changes of the patch. I don't think we need > mb_string_info() at all. Instead, we can just call pg_mbxxx() functions. > > I rewrote the patch to use pg_mbstrlen_with_len() and pg_mbcharcliplen(). > What do you think the changes? It requires re-cou

Re: [HACKERS] patch: to_string, to_array functions

2010-07-20 Thread Pavel Stehule
2010/7/21 Itagaki Takahiro : > 2010/7/20 Pavel Stehule : >> here is a new version - new these functions are not a strict and >> function to_string is marked as stable. > > We have array_to_string(anyarray, text) and string_to_array(text, text), > and you'll introduce to_string(anyarray, text, text)

Re: [HACKERS] leaky views, yet again

2010-07-20 Thread KaiGai Kohei
(2010/07/20 2:19), Heikki Linnakangas wrote: > On 19/07/10 20:08, Robert Haas wrote: >> 2010/7/8 KaiGai Kohei: >>> (2010/07/08 22:08), Robert Haas wrote: I think we pretty much have conceptual agreement on the shape of the solution to this problem: when a view is created with CREATE SECUR

Re: [HACKERS] psql \conninfo command (was: Patch: psql \whoami option)

2010-07-20 Thread Fujii Masao
On Tue, Jul 20, 2010 at 11:14 PM, Robert Haas wrote: > OK, committed. When I specify the path of the directory for the Unix-domain socket as the host, \conninfo doesn't mention that this connection is based on the Unix-domain socket. Is this intentional? $ psql -h"/tmp" -c"\conninfo" You are con

Re: [HACKERS] leaky views, yet again

2010-07-20 Thread KaiGai Kohei
(2010/07/20 2:13), Heikki Linnakangas wrote: > On 09/07/10 06:47, KaiGai Kohei wrote: >> When leaky and non-leaky functions are chained within a WHERE clause, >> it will be ordered by the cost of functions. So, we have possibility >> that leaky functions are executed earlier than non-leaky function

Re: [HACKERS] patch: to_string, to_array functions

2010-07-20 Thread Itagaki Takahiro
2010/7/20 Pavel Stehule : > here is a new version - new these functions are not a strict and > function to_string is marked as stable. We have array_to_string(anyarray, text) and string_to_array(text, text), and you'll introduce to_string(anyarray, text, text) and to_array(text, text, text). Do we

Re: [HACKERS] patch (for 9.1) string functions

2010-07-20 Thread Itagaki Takahiro
I reviewed the core changes of the patch. I don't think we need mb_string_info() at all. Instead, we can just call pg_mbxxx() functions. I rewrote the patch to use pg_mbstrlen_with_len() and pg_mbcharcliplen(). What do you think the changes? It requires re-counting lengths of multi-byte strings in

Fwd: [HACKERS] Streaming Replication: Checkpoint_segment and wal_keep_segments on standby

2010-07-20 Thread Fujii Masao
On Sat, Jul 17, 2010 at 4:22 AM, Heikki Linnakangas wrote: >> The patch adds the document about the relationship between a restartpoint >> and checkpoint_segments parameter. > > Thanks, committed with minor editorialization Thanks. > There will always be at least one WAL segment file, and w

[HACKERS] pg_config problem on Solaris 10u7 X64

2010-07-20 Thread Amber
Hi, I am trying to build RPostgreSQL on Solaris 10u7 X64, but have problems with pg_config, the configure script of RPostgreSQL checks for pg_config and got “checking for pg_config... /usr/bin/pg_config”. In Solaris 10u7 X64, three versions of PostgreSQL are installed, there are in /usr/postgres/8

Re: [HACKERS] multibyte charater set in levenshtein function

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 3:37 AM, Itagaki Takahiro wrote: > 2010/7/13 Alexander Korotkov : >> Anyway I think that overhead is not ignorable. That's why I have splited >> levenshtein_internal into levenshtein_internal and levenshtein_internal_mb, >> and levenshtein_less_equal_internal into levenshte

Re: [HACKERS] Query optimization problem

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 3:33 PM, Dimitri Fontaine wrote: > Robert Haas writes: >> On Tue, Jul 20, 2010 at 11:23 AM, Dimitri Fontaine >> wrote: >>>   JOIN DocPrimary d2 ON d2.BasedOn=d1.ID >>> - WHERE (d1.ID=234409763) or (d2.ID=234409763) >>> + WHERE (d2.BasedOn=234409763) or (d2.ID=234409763) >

Re: [HACKERS] Finding slave WAL application time delay

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 3:13 PM, Bruce Momjian wrote: > Someone at OSCON just asked if there is a way to find the _time_ delay > between received and applied WAL.  Right now > pg_last_xlog_replay_location() only reports the information in WAL > scale.  It would be nice to report that in time, e.g.

Re: [HACKERS] Status report on writeable CTEs

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 5:13 PM, Merlin Moncure wrote: 2. Use temp table instead of tuplestore list. Since we agreed we need to execute each plan one by one starting and shutting down executor, it now looks very simple strategy. >>> >>> I didn't look at this because I thought using

Re: [HACKERS] antisocial things you can do in git (but not CVS)

2010-07-20 Thread Andrew Dunstan
Robert Haas wrote: On Tue, Jul 20, 2010 at 3:12 PM, Peter Eisentraut wrote: Well, I had looked forward to actually putting the real author into the author field. What if there's more than one? What if you make changes yourself? How will you credit the reviewer? I think our cu

Re: [HACKERS] Patch for 9.1: initdb -C option

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 6:00 PM, Kevin Grittner wrote: > What will make everyone happy here? Nothing. But on a more serious note, the basic dilemma with this patch is whether it's useful enough to justify the extra code. I think it's pretty clearly harmless (modulo the fact that it might have b

Re: [HACKERS] Patch for 9.1: initdb -C option

2010-07-20 Thread KaiGai Kohei
(2010/07/21 7:33), Kevin Grittner wrote: > David Christensen wrote: >> On Jul 20, 2010, at 5:00 PM, Kevin Grittner wrote: > >>> my shop has chosen to never touch the default postgresql.conf >>> file any more, beyond adding one line to the bottom of it which >>> is an include directive, to bring i

Re: [HACKERS] dynamically allocating chunks from shared memory

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 5:46 PM, Alvaro Herrera wrote: > Excerpts from Markus Wanner's message of mar jul 20 14:54:42 -0400 2010: > >> > With respect to imessages specifically, what is the motivation for >> > using shared memory rather than something like an SLRU?  The new >> > LISTEN implementati

Re: [HACKERS] Patch for 9.1: initdb -C option

2010-07-20 Thread Kevin Grittner
David Christensen wrote: > On Jul 20, 2010, at 5:00 PM, Kevin Grittner wrote: >> my shop has chosen to never touch the default postgresql.conf >> file any more, beyond adding one line to the bottom of it which >> is an include directive, to bring in our overrides. > So you'll now issue: > > $

Re: [HACKERS] antisocial things you can do in git (but not CVS)

2010-07-20 Thread Andrew Dunstan
Robert Haas wrote: I have some concerns related to the upcoming conversion to git and how we're going to avoid having things get messy as people start using the new repository. git has a lot more flexibility and power than CVS, and I'm worried that it would be easy, even accidentally, to screw

Re: [HACKERS] Patch for 9.1: initdb -C option

2010-07-20 Thread David Christensen
On Jul 20, 2010, at 5:00 PM, Kevin Grittner wrote: > Top posting. On purpose. :p > > This patch seems to be foundering in a sea of opinions. It seems > that everybody wants to do *something* about this, but what? > > For one more opinion, my shop has chosen to never touch the default > postg

Re: [HACKERS] Patch for 9.1: initdb -C option

2010-07-20 Thread Kevin Grittner
Top posting. On purpose. :p This patch seems to be foundering in a sea of opinions. It seems that everybody wants to do *something* about this, but what? For one more opinion, my shop has chosen to never touch the default postgresql.conf file any more, beyond adding one line to the bottom of

Re: [HACKERS] dynamically allocating chunks from shared memory

2010-07-20 Thread Alvaro Herrera
Excerpts from Markus Wanner's message of mar jul 20 14:54:42 -0400 2010: > > With respect to imessages specifically, what is the motivation for > > using shared memory rather than something like an SLRU? The new > > LISTEN implementation uses an SLRU and handles variable-size messages, > > so it

Re: [HACKERS] antisocial things you can do in git (but not CVS)

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 3:12 PM, Peter Eisentraut wrote: > Well, I had looked forward to actually putting the real author into the > author field. What if there's more than one? What if you make changes yourself? How will you credit the reviewer? -- Robert Haas EnterpriseDB: http://www.enterpr

Re: [HACKERS] antisocial things you can do in git (but not CVS)

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 2:42 PM, Magnus Hagander wrote: > On Tue, Jul 20, 2010 at 20:34, Robert Haas wrote: >> I have some concerns related to the upcoming conversion to git and how >> we're going to avoid having things get messy as people start using the >> new repository.  git has a lot more fl

Re: [HACKERS] Status report on writeable CTEs

2010-07-20 Thread Merlin Moncure
On Fri, Jul 16, 2010 at 12:15 PM, Hitoshi Harada wrote: > 2010/7/17 Marko Tiikkaja : >> On 7/16/10 6:15 PM +0300, Hitoshi Harada wrote: >>> >>> 1. Use MaterialNode instead of adding DtScanNode. Since MaterialNode >>> is exsiting one that work with single tuplestore, it might be sane to >>> modify

Re: [HACKERS] Status report on writeable CTEs

2010-07-20 Thread David Fetter
On Sat, Jul 17, 2010 at 01:15:22AM +0900, Hitoshi Harada wrote: > 2010/7/17 Marko Tiikkaja : > > On 7/16/10 6:15 PM +0300, Hitoshi Harada wrote: > >> > >> 1. Use MaterialNode instead of adding DtScanNode. Since MaterialNode > >> is exsiting one that work with single tuplestore, it might be sane to

Re: [HACKERS] managing git disk space usage

2010-07-20 Thread Andrew Dunstan
Robert Haas wrote: Tom and, I believe, also Andrew have expressed some concerns about the space that will be taken up by having multiple copies of the git repository on their systems. While most users can probably get by with a single repository, committers will likely need one for each back-b

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread David Christensen
On Jul 20, 2010, at 2:18 PM, Alvaro Herrera wrote: > Excerpts from Robert Haas's message of mar jul 20 11:48:29 -0400 2010: > >>> That seems sub-optimal; I can see people wanting to use this feature to do >>> something like: >>> >>> psql -c 'set work_mem = blah' -f script.sql >>> >>> and then

Re: [HACKERS] standard_conforming_strings

2010-07-20 Thread Peter Eisentraut
On tis, 2010-07-20 at 13:31 +0300, Marko Kreen wrote: > > http://wiki.postgresql.org/wiki/Standard_conforming_strings > > There is two sorts of support: > > 1. Detect stdstr on startup and use that setting. > > 2. Detect online changes to stdstr and follow them. > > AFAICS psycopg does not sup

Re: [HACKERS] Query optimization problem

2010-07-20 Thread Dimitri Fontaine
Robert Haas writes: > On Tue, Jul 20, 2010 at 11:23 AM, Dimitri Fontaine > wrote: >>   JOIN DocPrimary d2 ON d2.BasedOn=d1.ID >> - WHERE (d1.ID=234409763) or (d2.ID=234409763) >> + WHERE (d2.BasedOn=234409763) or (d2.ID=234409763) > > I was thinking of the equivalence class machinery as well. I

Re: [HACKERS] managing git disk space usage

2010-07-20 Thread Peter Eisentraut
On tis, 2010-07-20 at 13:04 -0400, Robert Haas wrote: > 2. Clone the origin n times. Use more disk space. Live with it. :-) Well, I plan to use cp -a to avoid cloning over the network n times, but other than that that was my plan. My .git directory currently takes 283 MB, so I think I can just

Re: [HACKERS] Some git conversion issues

2010-07-20 Thread Magnus Hagander
+On Tue, Jul 20, 2010 at 21:15, Peter Eisentraut wrote: > On tis, 2010-07-20 at 15:12 +0200, Magnus Hagander wrote: >> Working on the git conversion > > What's the tool that is being used now?  Can you keep us up to date on > the options etc. you plan to use? I'm currently running tests with a bu

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Alvaro Herrera
Excerpts from Robert Haas's message of mar jul 20 11:48:29 -0400 2010: > > That seems sub-optimal; I can see people wanting to use this feature to do > > something like: > > > > psql -c 'set work_mem = blah' -f script.sql > > > > and then being surprised when it works differently than just `psql

Re: [HACKERS] Some git conversion issues

2010-07-20 Thread Peter Eisentraut
On tis, 2010-07-20 at 15:12 +0200, Magnus Hagander wrote: > Working on the git conversion What's the tool that is being used now? Can you keep us up to date on the options etc. you plan to use? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscr

Re: [HACKERS] dynamically allocating chunks from shared memory

2010-07-20 Thread Markus Wanner
Hi, On 07/20/2010 09:05 PM, Alvaro Herrera wrote: Hmm, deriving code from a paper published by IBM sounds like bad news -- who knows what patents they hold on the techniques there? Yeah, that might be an issue. Note, however, that the lock-based variant differs substantially from what's been

Re: [HACKERS] Some git conversion issues

2010-07-20 Thread Peter Eisentraut
On tis, 2010-07-20 at 20:46 +0200, Magnus Hagander wrote: > For one thing, this showed up in a lot of .po files for 8.1.0RC1. > Peter, can you comment on if this coincides with the tools you use to > do those things? There are/were some games being played with the key words, so this effect sounds

[HACKERS] Finding slave WAL application time delay

2010-07-20 Thread Bruce Momjian
Someone at OSCON just asked if there is a way to find the _time_ delay between received and applied WAL. Right now pg_last_xlog_replay_location() only reports the information in WAL scale. It would be nice to report that in time, e.g. milliseconds. Because an idle master will not generate WAL, I

Re: [HACKERS] antisocial things you can do in git (but not CVS)

2010-07-20 Thread Peter Eisentraut
On tis, 2010-07-20 at 14:34 -0400, Robert Haas wrote: > Right now, it's easy to find all the commits by a particular > committer, and it's easy to see who committed a particular patch, and > the number of distinct committers is pretty small. I'd hate to give > that up. > > git log | grep '^Author

Re: [HACKERS] dynamically allocating chunks from shared memory

2010-07-20 Thread Alvaro Herrera
Excerpts from Markus Wanner's message of mar jul 20 14:36:55 -0400 2010: > > I'm also unconvinced that spinlocks are the best locking primitive here. > > Why not lwlocks? > > It's derived from a completely lock-free algorithm, as proposed by Maged > M. Michael in: Scalable Lock-Free Dynamic Memo

Re: [HACKERS] dynamically allocating chunks from shared memory

2010-07-20 Thread Markus Wanner
Hi, On 07/20/2010 08:23 PM, Robert Haas wrote: Well, you can't really fix that problem with this infrastructure, No, but it would allow you to better use the existing amount of shared memory. Possibly avoiding the problem is certain scenarios. The failure might manifest itself in a totally

Re: [PATCH] Re: [HACKERS] Adding XMLEXISTS to the grammar

2010-07-20 Thread Peter Eisentraut
On tis, 2010-06-29 at 12:22 +0100, Mike Fowler wrote: > Mike Fowler wrote: > > Thanks again for your help Robert, turns out the fault was in the > > pg_proc entry (the 3 up there should've been a two!). Once I took the > > grammar out it was quickly obvious where I'd gone wrong. > > > > Attache

Re: [HACKERS] Some git conversion issues

2010-07-20 Thread Bruce Momjian
Magnus Hagander wrote: > > I have reproduced this by modifying just the CVS tag: > > > > ? ? ? ?$PostgreSQL: pgsql/src/backend/catalog/README,v 1.15 2010/07/20 > > ? ? ? ?18:38:53 momjian Exp $ > > To clarify with what Bruce said on IM to me, the situation is when the > workflow is to manually cop

Re: [HACKERS] Some git conversion issues

2010-07-20 Thread Magnus Hagander
On Tue, Jul 20, 2010 at 20:42, Bruce Momjian wrote: > Magnus Hagander wrote: >> Working on the git conversion with keywords, and I've noticed a couple of >> strange things that don't come up the same way in git. All of these are in >> non-code files, but they do defeat the "identical tarball" mode

Re: [HACKERS] antisocial things you can do in git (but not CVS)

2010-07-20 Thread Magnus Hagander
On Tue, Jul 20, 2010 at 20:34, Robert Haas wrote: > I have some concerns related to the upcoming conversion to git and how > we're going to avoid having things get messy as people start using the > new repository.  git has a lot more flexibility and power than CVS, > and I'm worried that it would

Re: [HACKERS] Some git conversion issues

2010-07-20 Thread Bruce Momjian
Magnus Hagander wrote: > Working on the git conversion with keywords, and I've noticed a couple of > strange things that don't come up the same way in git. All of these are in > non-code files, but they do defeat the "identical tarball" mode. > > For example, a number of files have commits showing

Re: [HACKERS] dynamically allocating chunks from shared memory

2010-07-20 Thread Markus Wanner
Hello Alvaro, thank you for looking through this code. On 07/20/2010 07:50 PM, Alvaro Herrera wrote: Interesting, thanks. I gave it a skim and found that it badly needs a lot more code comments. Hm.. yeah, the dynshmem stuff could probably need more comments. (The bgworker stuff is probably

[HACKERS] antisocial things you can do in git (but not CVS)

2010-07-20 Thread Robert Haas
I have some concerns related to the upcoming conversion to git and how we're going to avoid having things get messy as people start using the new repository. git has a lot more flexibility and power than CVS, and I'm worried that it would be easy, even accidentally, to screw up our history. 1. In

Re: [HACKERS] managing git disk space usage

2010-07-20 Thread Peter Eisentraut
On tis, 2010-07-20 at 13:28 -0400, Aidan Van Dyk wrote: > But *all* dependancies need to be proper in the build system, or you > end > up needing a git-clean-type-cleanup between branch switches, forcing a > new configure run too, which takes too much time... This realization, while true, doesn't

Re: [HACKERS] dynamically allocating chunks from shared memory

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 1:50 PM, Alvaro Herrera wrote: > I'm not sure what kind of resistance you'll see to the idea of a > dynamically allocatable shmem area.  Maybe we could use this in other > areas such as allocating space for heavyweight lock objects.  Right now > the memory usage for them co

Re: [HACKERS] crash-recovery replay of CREATE TABLESPACE is broken in HEAD

2010-07-20 Thread Bruce Momjian
Bruce Momjian wrote: > Bruce Momjian wrote: > > > The attached patch does as suggested. I added the recovery code to the > > > create tablespace function so I didn't have to duplicate all the code > > > that computes the path names. > > > > > > Attached. > > > > Uh, another question. Looking at

[HACKERS] SAVEPOINTs and COMMIT performance

2010-07-20 Thread Simon Riggs
As part of a performance investigation for a customer I've noticed an O(N^2) performance issue on COMMITs of transactions that contain many SAVEPOINTs. I've consistently measured COMMIT times of around 9 seconds, with 49% CPU, mostly in LockReassignCurrentOwner(). BEGIN; INSERT... SAVEPOINT ... I

Re: [HACKERS] Parsing of aggregate ORDER BY clauses

2010-07-20 Thread Daniel Grace
On Mon, Jul 19, 2010 at 4:08 PM, Hitoshi Harada wrote: > > 2010/7/19 Tom Lane : > > I looked into the problem reported here: > > http://archives.postgresql.org/pgsql-bugs/2010-07/msg00119.php > > [...] > > > > > 2. Split the processing of aggregates with ORDER BY/DISTINCT so that the > > sorting/

Re: [HACKERS] managing git disk space usage

2010-07-20 Thread Kevin Grittner
Robert Haas wrote: > 2. Clone the origin n times. Use more disk space. Live with it. :-) But each copy uses almost 0.36% of the formatted space on my 150GB drive! -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://ww

Re: [HACKERS] dynamically allocating chunks from shared memory

2010-07-20 Thread Alvaro Herrera
Excerpts from Markus Wanner's message of vie jul 02 19:44:46 -0400 2010: > Having written a very primitive kind of a dynamic memory allocator for > imessages [1], I've always wanted a better alternative. So I've > investigated a bit, refactored step-by-step, and finally came up with > the attac

Re: [HACKERS] managing git disk space usage

2010-07-20 Thread Aidan Van Dyk
* Robert Haas [100720 13:04]: > 3. Clone the origin once. Apply patches to multiple branches by > switching branches. Playing around with it, this is probably a > tolerable way to work when you're only going back one or two branches > but it's certainly a big nuisance when you're going back 5-

[HACKERS] managing git disk space usage

2010-07-20 Thread Robert Haas
Tom and, I believe, also Andrew have expressed some concerns about the space that will be taken up by having multiple copies of the git repository on their systems. While most users can probably get by with a single repository, committers will likely need one for each back-branch that they work wi

Re: [HACKERS] [COMMITTERS] pgsql: pgindent run for 9.0, second run

2010-07-20 Thread Andrew Dunstan
Magnus Hagander wrote: On Tue, Jul 20, 2010 at 18:13, Robert Haas wrote: On Tue, Jul 20, 2010 at 12:01 PM, Kevin Grittner wrote: Andrew Dunstan wrote: I despaired of this repo being anything like reliable months ago. AFAIK it is using a known to be broken version of fromcv

Re: [HACKERS] [COMMITTERS] pgsql: pgindent run for 9.0, second run

2010-07-20 Thread Magnus Hagander
On Tue, Jul 20, 2010 at 18:32, Kevin Grittner wrote: > Robert Haas wrote: > >> It would result in a massive merge commit and the duplication of >> the entire history. > > Ah, well, if the two repositories don't share the same IDs, it a > clear no-go.  Now that I think about it, it would be a bit

Re: [HACKERS] [COMMITTERS] pgsql: pgindent run for 9.0, second run

2010-07-20 Thread Kevin Grittner
Robert Haas wrote: > It would result in a massive merge commit and the duplication of > the entire history. Ah, well, if the two repositories don't share the same IDs, it a clear no-go. Now that I think about it, it would be a bit much to expect those to match on independent conversions from

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 12:08 PM, Mark Wong wrote: > On Tue, Jul 20, 2010 at 4:06 AM, Robert Haas wrote: >> On Tue, Jul 20, 2010 at 3:20 AM, Simon Riggs wrote: >>> On Mon, 2010-07-19 at 23:40 -0400, Robert Haas wrote: >>> Since it has been over a month since this review was posted and no ne

Re: [HACKERS] [COMMITTERS] pgsql: pgindent run for 9.0, second run

2010-07-20 Thread Andrew Dunstan
Kevin Grittner wrote: Andrew Dunstan wrote: I despaired of this repo being anything like reliable months ago. AFAIK it is using a known to be broken version of fromcvs. Could we have it pull (using git) from the repo you have working correctly? (Or would that be too Rube Goldber

Re: [HACKERS] [COMMITTERS] pgsql: pgindent run for 9.0, second run

2010-07-20 Thread Magnus Hagander
On Tue, Jul 20, 2010 at 18:13, Robert Haas wrote: > On Tue, Jul 20, 2010 at 12:01 PM, Kevin Grittner > wrote: >> Andrew Dunstan wrote: >> >>> I despaired of this repo being anything like reliable months ago. >>> AFAIK it is using a known to be broken version of fromcvs. >> >> Could we have it pu

Re: [HACKERS] [COMMITTERS] pgsql: pgindent run for 9.0, second run

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 12:01 PM, Kevin Grittner wrote: > Andrew Dunstan wrote: > >> I despaired of this repo being anything like reliable months ago. >> AFAIK it is using a known to be broken version of fromcvs. > > Could we have it pull (using git) from the repo you have working > correctly?  (

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Mark Wong
On Tue, Jul 20, 2010 at 4:06 AM, Robert Haas wrote: > On Tue, Jul 20, 2010 at 3:20 AM, Simon Riggs wrote: >> On Mon, 2010-07-19 at 23:40 -0400, Robert Haas wrote: >> >>> Since it has been over a month since this review was posted and no new >>> version of the patch has appeared, I think we should

Re: [HACKERS] Solaris Sparc - dblink regression test failure

2010-07-20 Thread Dave Page
On Tue, Jul 20, 2010 at 4:53 PM, Robert Haas wrote: > On Tue, Jul 20, 2010 at 11:08 AM, Dave Page wrote: >> Any ideas? > > Are you by any chance running off of the broken git mirror? > > http://archives.postgresql.org/pgsql-hackers/2010-07/msg00916.php I might be, yes :-) -- Dave Page Enterpr

Re: [HACKERS] [COMMITTERS] pgsql: pgindent run for 9.0, second run

2010-07-20 Thread Kevin Grittner
Andrew Dunstan wrote: > I despaired of this repo being anything like reliable months ago. > AFAIK it is using a known to be broken version of fromcvs. Could we have it pull (using git) from the repo you have working correctly? (Or would that be too Rube Goldbergesque?) -Kevin -- Sent via

Re: [HACKERS] Solaris Sparc - dblink regression test failure

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 11:08 AM, Dave Page wrote: > Any ideas? Are you by any chance running off of the broken git mirror? http://archives.postgresql.org/pgsql-hackers/2010-07/msg00916.php -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via p

Re: [HACKERS] Query optimization problem

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 11:23 AM, Dimitri Fontaine wrote: > Robert Haas writes: >> All that having been said, I think the issue here is that the query >> planner isn't inferring that d1.ID= implies d2.ID=> constant>, even though there's a join clause d1.ID=d2.ID. > > I think that's what the Equiv

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 11:23 AM, David Christensen wrote: >> Well, IIRC, one of -c and -f suppresses psqlrc, and the other does >> not.  This doesn't seem very consistent to me, but I'm not sure >> there's much to be done about it at this point.  I guess if you use >> whichever one suppresses psq

Re: [HACKERS] [PATCH] "could not reattach to shared memory" on Windows

2010-07-20 Thread Etienne Dube
On 09/02/2010 4:09 PM, Etienne Dube wrote: Magnus Hagander wrote: IIRC, we've had zero reports on whether the patch worked at all on 8.2 in an environment where the problem actually existed. So yes, some testing and feedback would be much apprecaited. //Magnus Thanks for your quick reply. We

Re: [HACKERS] sql/med review - problems with patching

2010-07-20 Thread Pavel Stehule
2010/7/20 David Fetter : > On Tue, Jul 20, 2010 at 11:40:18AM +0200, Pavel Stehule wrote: >> 2010/7/20 Itagaki Takahiro : >> > 2010/7/14 Pavel Stehule : >> >> please, can you refresh patch, please? >> > >> > Updated patch attached. The latest version is always in the git >> > repo.  http://repo.or.

Re: [HACKERS] reducing NUMERIC size for 9.1

2010-07-20 Thread Robert Haas
On Fri, Jul 16, 2010 at 2:39 PM, Tom Lane wrote: > Robert Haas writes: >> I'm not entirely happy with the way I handled the variable-length >> struct, although I don't think it's horrible, either. I'm willing to >> rework it if someone has a better idea. > > I don't like the way you did that eith

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread David Christensen
On Jul 20, 2010, at 9:05 AM, Robert Haas wrote: > On Tue, Jul 20, 2010 at 10:00 AM, David Christensen > wrote: >> Sorry for the delays in response. This is fine; I think there are some >> semantic questions that should still be resolved at this point, particularly >> if we're moving toward s

Re: [HACKERS] Query optimization problem

2010-07-20 Thread Dimitri Fontaine
Robert Haas writes: > All that having been said, I think the issue here is that the query > planner isn't inferring that d1.ID= implies d2.ID= constant>, even though there's a join clause d1.ID=d2.ID. I think that's what the Equivalence Classes are for. Or at least that's what they do in my hea

[HACKERS] Solaris Sparc - dblink regression test failure

2010-07-20 Thread Dave Page
Continuing my fun setting up some new Solaris buildfarm critters, I'm seeing this failure in the dblink test, on 9.0 and 9.1: gmake[1]: Leaving directory `/export/home/dpage/postgresql/contrib/cube' gmake[1]: Entering directory `/export/home/dpage/postgresql/contrib/dblink' gmake -C ../../src/test

Re: [HACKERS] sql/med review - problems with patching

2010-07-20 Thread David Fetter
On Tue, Jul 20, 2010 at 11:40:18AM +0200, Pavel Stehule wrote: > 2010/7/20 Itagaki Takahiro : > > 2010/7/14 Pavel Stehule : > >> please, can you refresh patch, please? > > > > Updated patch attached. The latest version is always in the git > > repo. http://repo.or.cz/w/pgsql-fdw.git   (branch: fdw

Re: [HACKERS] Query optimization problem

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 1:57 AM, Zotov wrote: > i wrote to >   pgsql-b...@postgresql.org > they tell me write to >   pgsql-performa...@postgresql.org > they tell me write here > > I don`t whant know how optimize query myself (i know it), and i think it > must do planner. According to the EXPLAIN

Re: [HACKERS] Query results differ depending on operating system (using GIN)

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 5:41 AM, Artur Dabrowski wrote: > I have been redirected here from pg-general. > > I tested full text search using GIN index and it turned out that the results > depend on operating system. Not all the rows are found when executing some > of queries on pg server installed o

Re: [HACKERS] psql \conninfo command (was: Patch: psql \whoami option)

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 12:16 AM, David Christensen wrote: > On Jul 19, 2010, at 11:10 PM, Robert Haas wrote: > >> On Tue, Jul 20, 2010 at 12:07 AM, Robert Haas wrote: >>> On Tue, Jul 20, 2010 at 12:02 AM, David Christensen >>> wrote: > I would propose to print instead: > > You are

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 10:00 AM, David Christensen wrote: > Sorry for the delays in response.  This is fine; I think there are some > semantic questions that should still be resolved at this point, particularly > if we're moving toward supporting multiple -c and -f lines as expressed (an > ide

Re: [HACKERS] Some git conversion issues

2010-07-20 Thread Kevin Grittner
Magnus Hagander wrote: >> I believe revision 1.1.1.1 is normally seen only for file brought >> in through the "cvs import" command. "vendor branch" would make >> some sense as a commit message for an import. > > Yeah, something like that. But why do we for the file above have > one "initial re

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread David Christensen
On Jul 19, 2010, at 10:40 PM, Robert Haas wrote: > On Wed, Jun 23, 2010 at 9:22 AM, Robert Haas wrote: >> On Wed, Jun 23, 2010 at 9:17 AM, gabrielle wrote: >>> On Mon, Jun 21, 2010 at 6:16 PM, Robert Haas wrote: Well, that might be a good idea, too, but my expectation is that:

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 9:23 AM, Kevin Grittner wrote: > Robert Haas wrote: > >> we gain something quite specific and tangible, namely, the >> expectation that patch authors will stay on top of their patches >> if they want them reviewed by the community. > > Barring some operational emergency he

Re: [HACKERS] Some git conversion issues

2010-07-20 Thread Magnus Hagander
On Tue, Jul 20, 2010 at 15:31, Kevin Grittner wrote: > Magnus Hagander wrote: > >> I'm also seeing some entries tagged with "vendor branch", such as: >> > http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/smgr/README >> revision 1.1.1.1 >> >> Same issue there, the file comes out

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Kevin Grittner
Simon Riggs wrote: > I don't think so. We can assume people wrote a patch because they > want it included in Postgres. Bumping them doesn't help them or > us, since there is always an issue other than wish-to-complete. > Not everybody is able to commit time in the way we do and we > should respe

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Simon Riggs
On Tue, 2010-07-20 at 09:05 -0400, Robert Haas wrote: > On Tue, Jul 20, 2010 at 8:21 AM, Simon Riggs wrote: > > On Tue, 2010-07-20 at 07:49 -0400, Robert Haas wrote: > >> A further point is that it's very difficult to > >> keep track of progress if the CF page reflects a whole bunch of > >> suppos

Re: [HACKERS] Some git conversion issues

2010-07-20 Thread Kevin Grittner
Magnus Hagander wrote: > I'm also seeing some entries tagged with "vendor branch", such as: > http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/smgr/README > revision 1.1.1.1 > > Same issue there, the file comes out on the other end with the > wrong keyword (in this case, list

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Kevin Grittner
Robert Haas wrote: > we gain something quite specific and tangible, namely, the > expectation that patch authors will stay on top of their patches > if they want them reviewed by the community. Barring some operational emergency here, I'll be reviewing the status of all the open patches in the

[HACKERS] Some git conversion issues

2010-07-20 Thread Magnus Hagander
Working on the git conversion with keywords, and I've noticed a couple of strange things that don't come up the same way in git. All of these are in non-code files, but they do defeat the "identical tarball" mode. For example, a number of files have commits showing up in cvs with nothing at all ch

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 8:21 AM, Simon Riggs wrote: > On Tue, 2010-07-20 at 07:49 -0400, Robert Haas wrote: >> A further point is that it's very difficult to >> keep track of progress if the CF page reflects a whole bunch of >> supposedly "Waiting on Author" patches that are really quite >> thorou

Re: [HACKERS] review: psql: edit function, show function commands patch

2010-07-20 Thread Pavel Stehule
Hello 2010/7/16 Jan Urbański : > Hi, > > here's a review of the \sf and \ef [num] patch from > http://archives.postgresql.org/message-id/162867791003290927y3ca44051p80e697bc6b19d...@mail.gmail.com > > == Formatting == > > The patch has some small tabs/spaces and whitespace  issues and it applies >

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Simon Riggs
On Tue, 2010-07-20 at 07:49 -0400, Robert Haas wrote: > A further point is that it's very difficult to > keep track of progress if the CF page reflects a whole bunch of > supposedly "Waiting on Author" patches that are really quite > thoroughly dead. True, but the point under discussion is what t

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 7:41 AM, Simon Riggs wrote: > So focus your effort by leaving this alone until the end of the CF. > Actively terminating things early doesn't help at all with the review > work you mention above, but it looks good if we are measuring "cases > resolved per day". Are we measu

Re: [HACKERS] lock_timeout GUC patch - Review

2010-07-20 Thread Marc Cousin
Hi, I've been reviewing this patch for the last few days. Here it is : * Submission review * Is the patch in context diff format? Yes * Does it apply cleanly to the current CVS HEAD? Yes * Does it include reasonable tests, necessary doc patches, etc? Doc patches are there. There are no reg

Re: [HACKERS] patch: to_string, to_array functions

2010-07-20 Thread Pavel Stehule
Hello here is a new version - new these functions are not a strict and function to_string is marked as stable. both functions share code with older version. Regards Pavel 2010/7/16 Brendan Jurd : > On 17 July 2010 04:52, Pavel Stehule wrote: >> 2010/7/16 Brendan Jurd : >>> Also, if we're goin

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Simon Riggs
On Tue, 2010-07-20 at 07:06 -0400, Robert Haas wrote: > To me, the definition of a fair shake is that people get 4-5 days to > respond to review comments. This patch has had 33. It's not unfair > to anyone to say, you know, since you didn't get around to updating > this patch for over a month, yo

Re: [HACKERS] patch: preload dictionary new version

2010-07-20 Thread Pavel Stehule
Hello 2010/7/20 Itagaki Takahiro : > 2010/7/14 Pavel Stehule : >> this patch is significantly reduced original patch. It doesn't propose >> a simple allocator - just eliminate a high memory usage for ispell >> dictionary. > > I don't think introducing new methods is a good idea. If you want a > si

Re: [HACKERS] Explicit psqlrc

2010-07-20 Thread Robert Haas
On Tue, Jul 20, 2010 at 3:20 AM, Simon Riggs wrote: > On Mon, 2010-07-19 at 23:40 -0400, Robert Haas wrote: > >> Since it has been over a month since this review was posted and no new >> version of the patch has appeared, I think we should mark this patch >> as Returned with Feedback. > > Mark pos

Re: [HACKERS] standard_conforming_strings

2010-07-20 Thread Marko Kreen
On 7/20/10, Peter Eisentraut wrote: > On sön, 2010-07-18 at 09:42 -0700, David E. Wheeler wrote: > > On Jul 18, 2010, at 1:35 AM, Peter Eisentraut wrote: > > > > > I think there are two ways we can do this, seeing that most appear to be > > > in favor of doing it in the first place: Either we

  1   2   >