Re: [HACKERS] WIP patch for TODO Item: Add prompt escape to display the client and server versions

2009-07-14 Thread Jaime Casanova
2009/5/7 Dickson S. Guedes lis...@guedesoft.net: Em Qui, 2009-05-07 às 10:11 +0300, Peter Eisentraut escreveu: On Thursday 07 May 2009 05:23:41 Dickson S. Guedes wrote: This is a WIP patch (for the TODO item in the subject) that I'm putting in the Commit Fest queue for 8.5. How about you

Re: [HACKERS] COPY WITH CSV FORCE QUOTE *

2009-07-14 Thread Itagaki Takahiro
Jaime Casanova jcasa...@systemguards.com.ec wrote: i can find value for FORCE QUOTE * but what's the use case for FORCE NOT NULL? NULLs are not quoted (to be ,, ) because empty strings are written as . It comes from original implementation and not from my patch. I think we don't need to

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-14 Thread Chuck McDevitt
-Original Message- From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers- ow...@postgresql.org] On Behalf Of Tom Lane Sent: Monday, July 13, 2009 7:43 PM To: Andrew Dunstan Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Upgrading our minimum required flex version

Re: [HACKERS] COPY WITH CSV FORCE QUOTE *

2009-07-14 Thread Itagaki Takahiro
is an updated version of patch; just add documenation to copy.sgml. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center force_quote_all-20090714.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] pg_dump Add dumping of comments on index columns

2009-07-14 Thread Jaime Casanova
On Thu, Mar 26, 2009 at 2:39 AM, higeponhige...@gmail.com wrote: Hi. Here is a patch for pg_dump Commenting on a composite-type column. This patch is for Todo item named Add dumping of comments on index columns and composite type columns. this one looks good to me, the only adjust i made to

Re: [HACKERS] WIP patch for TODO Item: Add prompt escape to display the client and server versions

2009-07-14 Thread Peter Eisentraut
On Tuesday 14 July 2009 09:12:21 Jaime Casanova wrote: 2009/5/7 Dickson S. Guedes lis...@guedesoft.net: Em Qui, 2009-05-07 às 10:11 +0300, Peter Eisentraut escreveu: On Thursday 07 May 2009 05:23:41 Dickson S. Guedes wrote: This is a WIP patch (for the TODO item in the subject) that I'm

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-14 Thread Andrew Dunstan
Chuck McDevitt wrote: Flex 2.5.33 and bison 2.3 are available from mingw for windows. http://sourceforge.net/projects/mingw/files/ Since mingw programs don't need Cygwin installed, these should probably be OK for most Windows people. But if really needed, flex 2.5.33 could be ported (m4

Re: [HACKERS] COPY WITH CSV FORCE QUOTE *

2009-07-14 Thread Jaime Casanova
On Tue, Jul 14, 2009 at 2:26 AM, Itagaki Takahiroitagaki.takah...@oss.ntt.co.jp wrote: Jaime Casanova jcasa...@systemguards.com.ec wrote: i can find value for FORCE QUOTE * but what's the use case for FORCE NOT NULL? Oh, sorry. I misread your mail. The patch adds * options FORCE QUOTE

Re: [HACKERS] Index-only scans

2009-07-14 Thread Heikki Linnakangas
Simon Riggs wrote: On Mon, 2009-07-13 at 10:16 +0300, Heikki Linnakangas wrote: Implementing index-only scans requires a few changes: I would like to see a clear exposition of the use cases and an an analysis of the costs and benefits of doing this. It sounds cool, but I want to know it

Re: [HACKERS] Index-only scans

2009-07-14 Thread Heikki Linnakangas
Simon Riggs wrote: On Mon, 2009-07-13 at 10:16 +0300, Heikki Linnakangas wrote: Implementing index-only scans requires a few changes: I would like to see a clear exposition of the use cases and an an analysis of the costs and benefits of doing this. It sounds cool, but I want to know it

Re: [HACKERS] Index-only scans

2009-07-14 Thread Simon Riggs
On Tue, 2009-07-14 at 11:23 +0300, Heikki Linnakangas wrote: The single SQL example mentioned already has at least two mechanisms for improving performance of that type of query. We probably don't need another, or at least we need a good analysis of why. Well, another class of queries

[HACKERS] Index-only quals

2009-07-14 Thread Heikki Linnakangas
I already posted the patch to satisfy quals using data from index yesterday (http://archives.postgresql.org/message-id/4a5b5386.3070...@enterprisedb.com), but here's some more thoughts about the patch: 1, The patch adds a flag to IndexScanDesc (needIndexTuple) that you can set to request the

[HACKERS] Comments on automatic DML routing and explicit partitioning subcommands

2009-07-14 Thread Simon Riggs
(submitting review slightly earlier than start of commitfest) Kedar, Thank you very much for the patch. Well done for getting to this stage. There is definitely much support for your work. My thoughts after initial review are fairly wide ranging. Overall, the patch is not ready/close to commit

[HACKERS] Sampling profiler updated

2009-07-14 Thread Itagaki Takahiro
is platform-independent. A new feature compared with previous patch is function pgstat_register_condition(condition, name). We can add user-defined conditions in extended modules. Comments welcome. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center profiler-20090714.gz Description

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

2009-07-14 Thread Tsutomu Yamada
Hello, This patch using VirtualAlloc()/VirtualFree() to avoid failing in reattach to shared memory. Can this be added to CommitFest ? Recent threads in pgsql-bugs are http://archives.postgresql.org/pgsql-bugs/2009-07/msg00036.php This fix is almost same as previous patch. debug code is

Re: [HACKERS] *_collapse_limit, geqo_threshold

2009-07-14 Thread marcin mank
On Thu, Jul 9, 2009 at 5:38 AM, Noah Mischn...@leadboat.com wrote: z Describing in those terms illuminates much.  While the concepts do suggest 2^N worst-case planning cost, my artificial test case showed a rigid 4^N pattern; what could explain that? Isn`t that just so that the planner has to

Re: [HACKERS] Index-only scans

2009-07-14 Thread Peter Eisentraut
On Monday 13 July 2009 16:38:18 Bruce Momjian wrote: Heikki Linnakangas wrote: Even if we don't solve the visibility map problem, just allowing the executor to evaluate quals that are not directly indexable using data from the index, would be useful. For example, SELECT * FROM foo WHERE

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

2009-07-14 Thread Robert Haas
On Tue, Jul 14, 2009 at 6:22 AM, Tsutomu Yamadatsut...@sraoss.co.jp wrote: Hello, This patch using VirtualAlloc()/VirtualFree() to avoid failing in reattach to shared memory. Can this be added to CommitFest ? Patches for CommitFest should be added here:

Re: [HACKERS] [GENERAL] pg_migrator not setting values of sequences?

2009-07-14 Thread Bruce Momjian
bruce wrote: Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Tilmann Singer wrote: However, all of the sequences were at the initial values and not bumped up to the last used value as I would have expected. The first nextval call on any sequence in the migrated 8.4 database

Re: [HACKERS] [GENERAL] pg_migrator not setting values of sequences?

2009-07-14 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: Did we change sequence table format from 8.3 to 8.4? Oh, yes we did: we added a start_value column. So this is going to take more work than that :-( regards, tom lane -- Sent via pgsql-hackers mailing list

Re: [HACKERS] [GENERAL] pg_migrator not setting values of sequences?

2009-07-14 Thread Alvaro Herrera
Bruce Momjian wrote: Something is certainly wrong. Did we change sequence table format from 8.3 to 8.4? 8.3 does not have start_value. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers

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

2009-07-14 Thread Alvaro Herrera
Tsutomu Yamada wrote: This patch using VirtualAlloc()/VirtualFree() to avoid failing in reattach to shared memory. Can this be added to CommitFest ? Since this fixes a very annoying bug present in older versions, I think this should be backpatched all the way back to 8.2. Some notes about

Re: [HACKERS] Comments on automatic DML routing and explicit partitioning subcommands

2009-07-14 Thread Alvaro Herrera
Simon, Simon Riggs escribió: Kedar, Thank you very much for the patch. Well done for getting to this stage. There is definitely much support for your work. Thanks for the thorough review. Please when you add a comment to the commitfest app, make sure you specify the message-id where you

Re: [HACKERS] WIP: generalized index constraints

2009-07-14 Thread Jeff Davis
Updated patch attached. Changes: * Added syntax support: CREATE INDEX foo_idx ON foo ... (a CONSTRAINT =, b CONSTRAINT ); * More aggressively clear the shared memory entries to avoid unnecessary checks * Code cleanup TODO: * When adding constraint to table with data already in it,

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

2009-07-14 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Tsutomu Yamada wrote: This patch using VirtualAlloc()/VirtualFree() to avoid failing in reattach to shared memory. Since this fixes a very annoying bug present in older versions, I think this should be backpatched all the way back to 8.2.

[HACKERS] Prefix support for synonym dictionary

2009-07-14 Thread Oleg Bartunov
Hi there, attached is our patch for CVS HEAD, which adds prefix support for synonym dictionary. Quick example: cat $SHAREDIR/tsearch_data/synonym_sample.syn postgrespgsql postgresql pgsql postgre pgsql gogle googl indices index* =# create text search dictionary syn(

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

2009-07-14 Thread Alvaro Herrera
Tom Lane wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Tsutomu Yamada wrote: This patch using VirtualAlloc()/VirtualFree() to avoid failing in reattach to shared memory. Since this fixes a very annoying bug present in older versions, I think this should be backpatched all

Re: [HACKERS] [PATCH 1/2 v3] [libpq] rework sigpipe-handling macros

2009-07-14 Thread Alvaro Herrera
Jeremy Kerr wrote: Also, since we don't need to declare variables in the macros, we can change the code to be implemented as static inlines. Does this work in compilers other than GCC? I think we use some kludges to protect against them ... see pg_list.h for the canonical example. -- Alvaro

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

2009-07-14 Thread Heikki Linnakangas
Alvaro Herrera wrote: Tsutomu Yamada wrote: This patch using VirtualAlloc()/VirtualFree() to avoid failing in reattach to shared memory. Can this be added to CommitFest ? Since this fixes a very annoying bug present in older versions, I think this should be backpatched all the way back

Re: [HACKERS] Sampling profiler updated

2009-07-14 Thread Jaime Casanova
On Tue, Jul 14, 2009 at 4:47 AM, Itagaki Takahiroitagaki.takah...@oss.ntt.co.jp wrote: I updated Sampling profiler patch to be applied to HEAD cleanly. shouldn't pg_stat_reset() reset these values? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de

Re: [HACKERS] Predicate migration on complex self joins

2009-07-14 Thread Sam Mason
On Mon, Jul 13, 2009 at 07:06:40PM +0100, Simon Riggs wrote: On Mon, 2009-07-13 at 13:33 -0400, Tom Lane wrote: It's hard to believe this sort of case comes up often enough to justify the cycles that would be expended (on *every* join query) to try to recognize it. Yeh, damn ORMs seem to

Re: [HACKERS] [pgsql-www] Launching commitfest.postgresql.org

2009-07-14 Thread Stefan Kaltenbrunner
Brendan Jurd wrote: 2009/7/14 Robert Haas robertmh...@gmail.com: +1 for redirecting the whole site. I don't think the extra CPU load of SSL is going to bother anyone for the amount of traffic we're likely to have on that site. Simplicity is good. +1 for SSL on all pages from me also.

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

2009-07-14 Thread Heikki Linnakangas
Tom Lane wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Since this fixes a very annoying bug present in older versions, I think this should be backpatched all the way back to 8.2. Agreed, but first we need some evidence that it actually fixes the problem. How can we acquire such

Re: [HACKERS] COPY WITH CSV FORCE QUOTE *

2009-07-14 Thread Andrew Dunstan
Itagaki Takahiro wrote: Jaime Casanova jcasa...@systemguards.com.ec wrote: i can find value for FORCE QUOTE * but what's the use case for FORCE NOT NULL? Oh, sorry. I misread your mail. The patch adds * options FORCE QUOTE and FORCE NOT NULL, too. Both of * mean all-columns for

Re: [HACKERS] WIP: Deferrable unique constraints

2009-07-14 Thread Jeff Davis
On Sun, 2009-07-12 at 14:14 +0100, Dean Rasheed wrote: Here is an updated version of this patch which should apply to HEAD, with updated docs, regression tests, pg_dump and psql \d. It works well for small numbers of temporary uniqueness violations, and at least as well (in fact about twice

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

2009-07-14 Thread Jaime Casanova
On Tue, Jul 14, 2009 at 10:28 AM, Alvaro Herreraalvhe...@commandprompt.com wrote: Tom Lane wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Tsutomu Yamada wrote: This patch using VirtualAlloc()/VirtualFree() to avoid failing in reattach to shared memory. Since this fixes a very

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-14 Thread Andrew Dunstan
Andrew Dunstan wrote: Chuck McDevitt wrote: Flex 2.5.33 and bison 2.3 are available from mingw for windows. http://sourceforge.net/projects/mingw/files/ Since mingw programs don't need Cygwin installed, these should probably be OK for most Windows people. But if really needed, flex

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-14 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: What I have done is built a version of flex 2.5.35 with Cygwin, and bundled the .exe with the Cygwin DLL (the only other thing it should need, for our purposes) in a zip file. It can currently be fetched from

Re: [HACKERS] Index-only scans

2009-07-14 Thread Mischa Sandberg
Now I'm back where I can go look at the source code :-) Thanks. -Original Message- From: Jaime Casanova [mailto:jcasa...@systemguards.com.ec] Sent: Monday, July 13, 2009 8:40 PM To: Mischa Sandberg Cc: Heikki Linnakangas; PostgreSQL-development Subject: Re: [HACKERS] Index-only

Re: [HACKERS] Alpha release process

2009-07-14 Thread Josh Berkus
== Announcing == Announce to: * PostgreSQL News * pgsql-hackers * pgsql-general(?) * pgsql-packagers Also pgsql-announce, no? I'm happy to write announcements. I'm also happy to give someone else some practice ... I'll see if anyone is interested on -advocacy. -- Josh Berkus PostgreSQL

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

2009-07-14 Thread Dave Page
On Tuesday, July 14, 2009, Alvaro Herrera alvhe...@commandprompt.com wrote: Tom Lane wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Tsutomu Yamada wrote: This patch using VirtualAlloc()/VirtualFree() to avoid failing in reattach to shared memory. Since this fixes a very

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

2009-07-14 Thread Heikki Linnakangas
Jaime Casanova wrote: - identify some people with the problem and talk to them for: 1) get a way to reproduce the error (a lot dificult, IIRC we try a few times i fail to fail) or 2) get their support for test For back-patching, we'd be maybe even more interested in getting people who *don't*

Re: [HACKERS] Alpha release process

2009-07-14 Thread Josh Berkus
On 7/13/09 12:49 PM, Bruce Momjian wrote: Peter Eisentraut wrote: * Release notes [Note: We'll have to work out exactly how to do this one as we go.] I am not planning to assist with this item for alpha releases. Anyone want to volunteer to organize the alpha release notes? This seems

Re: [HACKERS] WIP: Deferrable unique constraints

2009-07-14 Thread Kenneth Marshall
On Tue, Jul 14, 2009 at 09:56:48AM -0700, Jeff Davis wrote: On Sun, 2009-07-12 at 14:14 +0100, Dean Rasheed wrote: Here is an updated version of this patch which should apply to HEAD, with updated docs, regression tests, pg_dump and psql \d. It works well for small numbers of temporary

Re: [HACKERS] Synch Rep for CommitFest 2009-07

2009-07-14 Thread Heikki Linnakangas
Fujii Masao wrote: On Fri, Jul 3, 2009 at 1:32 PM, Fujii Masaomasao.fu...@gmail.com wrote: This patch no longer applies cleanly. Can you rebase and resubmit it for the upcoming CommitFest? It might also be good to go through and clean up the various places where you have trailing whitespace

Re: [HACKERS] WIP: Deferrable unique constraints

2009-07-14 Thread Alvaro Herrera
Jeff Davis wrote: The only problem there is telling the btree AM whether or not to do the insert or not (i.e. fake versus real insert). Perhaps you can just do that with careful use of a global variable? Sure, all of this is a little ugly, but we've already acknowledged that there is some

Re: [HACKERS] [GENERAL] large object does not exist after pg_migrator

2009-07-14 Thread Alvaro Herrera
Jamie Fox wrote: Here's what I have found that got broken during pg_migrate: In two side by side databases (an 8.3.7 copy and 8.4.0 migrated with pg_migrator) the pg_largeobject table has the same number of rows. However, in the 8.4 database any select for an loid in pg_largeobject returns

Re: [HACKERS] [GENERAL] large object does not exist after pg_migrator

2009-07-14 Thread Jamie Fox
On Mon, Jul 13, 2009 at 8:03 PM, Bruce Momjian br...@momjian.us wrote: Alvaro Herrera wrote: Bruce Momjian wrote: Alvaro Herrera wrote: Bruce Momjian wrote: Jamie Fox wrote: I can also see that the pg_largeobject table is different, in the pg_restore version the

Re: [HACKERS] WIP: Deferrable unique constraints

2009-07-14 Thread Jeff Davis
On Tue, 2009-07-14 at 13:29 -0500, Kenneth Marshall wrote: I am looking at adding unique support to hash indexes for 8.5 and they will definitely need to visit the heap. Have you seen this patch? http://archives.postgresql.org/message-id/1246840119.19547.126.ca...@jdavis This patch will

[HACKERS] Filtering dictionaries support and unaccent dictionary

2009-07-14 Thread Oleg Bartunov
Hi there, we'd like to introduce filtering dictionaries support for text search and new contrib module unaccent, which provides useful example of filtering dictionary. It finally solves the known problem of incorrect generation of headlines of text with accents. Also, this module provides

Re: [HACKERS] [pgsql-www] Launching commitfest.postgresql.org

2009-07-14 Thread Robert Haas
On Jul 14, 2009, at 12:21 PM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: Brendan Jurd wrote: 2009/7/14 Robert Haas robertmh...@gmail.com: +1 for redirecting the whole site. I don't think the extra CPU load of SSL is going to bother anyone for the amount of traffic we're likely to

Re: [HACKERS] WIP: Deferrable unique constraints

2009-07-14 Thread Jeff Davis
On Tue, 2009-07-14 at 15:00 -0400, Alvaro Herrera wrote: My 2c on this issue: if this is ugly (and it is) and needs revisiting to extend it, please by all means let's make it not ugly instead of moving the ugliness around. I didn't read the original proposal in detail so IMBFOS, but it

Re: [HACKERS] Merge Append Patch merged up to 85devel

2009-07-14 Thread Heikki Linnakangas
I've added this to the July commitfest. Gregory Stark wrote: Here's a copy of the merge-append patch that I sent months ago merged up to head. I haven't really added any additional functionality since then. Heikki suggested I separate the Append and MergeAppend nodes into two executor

Re: [HACKERS] WIP: Deferrable unique constraints

2009-07-14 Thread Alvaro Herrera
Jeff Davis wrote: 1. Are you saying that an AM API change is the best route? If so, we should probably start a discussion along those lines. Heikki is already changing the API for index-only scans, and Dean's API change proposal may be useful for Kenneth's unique hash indexes. You might as

[HACKERS] more than one index in a single heap pass?

2009-07-14 Thread Andrew Dunstan
I was just wondering idly today if we could usefully build a number of indexes at the same time in a single pass over the heap, or could it be that we wouldn't gain much? I haven't even got around to thinking about any syntax for it. cheers andrew -- Sent via pgsql-hackers mailing list

Re: [HACKERS] WIP: Deferrable unique constraints

2009-07-14 Thread Dean Rasheed
2009/7/14 Alvaro Herrera alvhe...@commandprompt.com: Jeff Davis wrote: The only problem there is telling the btree AM whether or not to do the insert or not (i.e. fake versus real insert). Perhaps you can just do that with careful use of a global variable? Sure, all of this is a little

Re: [HACKERS] more than one index in a single heap pass?

2009-07-14 Thread Alvaro Herrera
Andrew Dunstan wrote: I was just wondering idly today if we could usefully build a number of indexes at the same time in a single pass over the heap, or could it be that we wouldn't gain much? I haven't even got around to thinking about any syntax for it. Could we make it work on two

Re: [HACKERS] WIP: Deferrable unique constraints

2009-07-14 Thread Jeff Davis
On Tue, 2009-07-14 at 20:32 +0100, Dean Rasheed wrote: Well the ugliness referred to here (btree accessing the heap) seems like a necessary evil. I don't think I want to add to it by introducing global variables. Ok, try to coordinate with Kenneth to make sure that the API change satisfies

Re: [HACKERS] more than one index in a single heap pass?

2009-07-14 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Andrew Dunstan wrote: I was just wondering idly today if we could usefully build a number of indexes at the same time in a single pass over the heap, or could it be that we wouldn't gain much? I haven't even got around to thinking about

Re: [HACKERS] [GENERAL] large object does not exist after pg_migrator

2009-07-14 Thread Jamie Fox
Here's what I have found that got broken during pg_migrate: In two side by side databases (an 8.3.7 copy and 8.4.0 migrated with pg_migrator) the pg_largeobject table has the same number of rows. However, in the 8.4 database any select for an loid in pg_largeobject returns zero rows.

[HACKERS] improvements for dict_xsyn extended synonym dictionary

2009-07-14 Thread Sergey V. Karpov
Greetings, attached is a simple patch that extends the functionality of dict_xsyn extended synonym dictionary (from contrib) by adding the following configuration option: - mode option controls the current dictionary mode of operation. Can be one of: - in simple mode it accepts the

[HACKERS] navigation menu for documents

2009-07-14 Thread Andrew Dunstan
For a very long time I have thought that it would be useful to have some sort of navigation menu for the docs similar to what you get with doxygen. I had a brief look at it today but I am lost for a place to start with it. Does anyone sufficiently understand how the docs work to be able to

Re: [HACKERS] Alpha release process

2009-07-14 Thread Peter Eisentraut
On Tuesday 14 July 2009 21:20:51 Josh Berkus wrote: Also, what about producing Docs? I'm working on making the documentation build part of the normal release building rules. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] Alpha release process

2009-07-14 Thread Peter Eisentraut
On Tuesday 14 July 2009 21:17:14 Josh Berkus wrote: == Announcing == Announce to: * PostgreSQL News * pgsql-hackers * pgsql-general(?) * pgsql-packagers Also pgsql-announce, no? Yes. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] WIP: Deferrable unique constraints

2009-07-14 Thread Kenneth Marshall
On Tue, Jul 14, 2009 at 12:13:33PM -0700, Jeff Davis wrote: On Tue, 2009-07-14 at 13:29 -0500, Kenneth Marshall wrote: I am looking at adding unique support to hash indexes for 8.5 and they will definitely need to visit the heap. Have you seen this patch?

[HACKERS] [PATCH] DefaultACLs

2009-07-14 Thread Petr Jelinek
Hello, this is first public version of our DefaultACLs patch as described on http://wiki.postgresql.org/wiki/DefaultACL . It allows GRANT/REVOKE permissions to be inherited by objects based on schema permissions at create type by use of ALTER SCHEMA foo SET DEFAULT PRIVILEGES ON TABLE SELECT

Re: [HACKERS] [pgsql-www] Launching commitfest.postgresql.org

2009-07-14 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Jul 14, 2009, at 12:21 PM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: Brendan Jurd wrote: 2009/7/14 Robert Haas robertmh...@gmail.com: +1 for redirecting the whole site. I don't think the extra CPU load of SSL is going to bother anyone for the amount of

Re: [HACKERS] navigation menu for documents

2009-07-14 Thread Dimitri Fontaine
Hi, Le 14 juil. 09 à 22:17, Andrew Dunstan a écrit : For a very long time I have thought that it would be useful to have some sort of navigation menu for the docs Oh yes, pretty please :) Navigating the docs requires far too much use of the back button and up links, IMNSHO. A menu frame

Re: [HACKERS] Sampling profiler updated

2009-07-14 Thread Stefan Moeding
Hi! Itagaki Takahiro writes: I updated Sampling profiler patch to be applied to HEAD cleanly. [...] Comments welcome. I believe the profiler could give us a better understanding of where different parts of the user visible response time originate from. The problem with DTrace in my

Re: [HACKERS] navigation menu for documents

2009-07-14 Thread Andrew Dunstan
Dimitri Fontaine wrote: Hi, Le 14 juil. 09 à 22:17, Andrew Dunstan a écrit : For a very long time I have thought that it would be useful to have some sort of navigation menu for the docs Oh yes, pretty please :) Navigating the docs requires far too much use of the back button and up links,

[HACKERS] Make planning via GEQO repeatable

2009-07-14 Thread Andres Freund
Hi, Query planning via GEQO currently can yield a different plan on every invokation of the planner due to its non-exhaustive nature. This often can be inconvenient because at times there may be a very bad plan. It also makes it very hard to reproduce a problem with GEQO. [PATCH 1/3] Add

[HACKERS] [PATCH 1/3] Add erand48() implementation for non-unixoid systems.

2009-07-14 Thread Andres Freund
--- src/include/port.h |2 ++ src/port/rand.c|8 2 files changed, 10 insertions(+), 0 deletions(-) diff --git a/src/include/port.h b/src/include/port.h index cbf9dcf..af96620 100644 *** a/src/include/port.h --- b/src/include/port.h *** extern FILE

[HACKERS] [PATCH 3/3] Document geqo_seed variable.

2009-07-14 Thread Andres Freund
--- doc/src/sgml/config.sgml | 16 1 files changed, 16 insertions(+), 0 deletions(-) diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 99d25d7..5d8eca9 100644 *** a/doc/src/sgml/config.sgml --- b/doc/src/sgml/config.sgml *** archive_command =

[HACKERS] [PATCH 2/3] Support a 'geqo_seed' GUC to make planning via GEQO repeatable.

2009-07-14 Thread Andres Freund
--- src/backend/optimizer/geqo/Makefile |1 + src/backend/optimizer/geqo/geqo_copy.c |4 +- src/backend/optimizer/geqo/geqo_cx.c|6 +- src/backend/optimizer/geqo/geqo_erx.c | 47 ++-- src/backend/optimizer/geqo/geqo_eval.c

Re: [HACKERS] navigation menu for documents

2009-07-14 Thread Dimitri Fontaine
Le 15 juil. 09 à 00:21, Andrew Dunstan a écrit : Yes, really. What you suggest here is just not adequate, IMNSHO. I don't want to have to scroll to the top or bottom of the page to get navigation, and I want to be able to see the navigation and go where I want directly. Ok we don't share

Re: [HACKERS] navigation menu for documents

2009-07-14 Thread Richard Huxton
Andrew Dunstan wrote: Yes, really. What you suggest here is just not adequate, IMNSHO. I don't want to have to scroll to the top or bottom of the page to get navigation, and I want to be able to see the navigation and go where I want directly. Are you talking about the online manuals, or

Re: [HACKERS] more than one index in a single heap pass?

2009-07-14 Thread Greg Stark
On Tue, Jul 14, 2009 at 8:50 PM, Tom Lanet...@sss.pgh.pa.us wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Andrew Dunstan wrote: I was just wondering idly today if we could usefully build a number of indexes at the same time in a single pass over the heap, or could it be that we

Re: [HACKERS] navigation menu for documents

2009-07-14 Thread Andrew Dunstan
Richard Huxton wrote: Andrew Dunstan wrote: Yes, really. What you suggest here is just not adequate, IMNSHO. I don't want to have to scroll to the top or bottom of the page to get navigation, and I want to be able to see the navigation and go where I want directly. Are you talking about

Re: [HACKERS] navigation menu for documents

2009-07-14 Thread Richard Huxton
Andrew Dunstan wrote: Richard Huxton wrote: Andrew Dunstan wrote: Yes, really. What you suggest here is just not adequate, IMNSHO. I don't want to have to scroll to the top or bottom of the page to get navigation, and I want to be able to see the navigation and go where I want directly.

Re: [HACKERS] more than one index in a single heap pass?

2009-07-14 Thread Andrew Dunstan
Greg Stark wrote: On Tue, Jul 14, 2009 at 8:50 PM, Tom Lanet...@sss.pgh.pa.us wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Andrew Dunstan wrote: I was just wondering idly today if we could usefully build a number of indexes at the same time in a single pass over

[HACKERS] CommitFest 2009-07 is Now Closed

2009-07-14 Thread Robert Haas
The time is now Wed Jul 15 00:18:00 UTC 2009 and CommitFest 2009-07 is now closed. Please submit all new patches at: http://commitfest.postgresql.org/action/commitfest_view/open Reviewing assignments will be sent to pgsql-rrreviewers in the next few hours. I believe everyone who has

Re: [HACKERS] Index-only scans

2009-07-14 Thread Ron Mayer
Heikki Linnakangas wrote: ... CREATE TABLE manytomany (aid integer, bid integer); CREATE INDEX a_b ON manytomany (aid, bid); CREATE INDEX b_a ON manytomany (bid, aid); ... new and interesting indexing strategies. Covered indexes are also one kind of materialized view. It may be better to

Re: [HACKERS] more than one index in a single heap pass?

2009-07-14 Thread Glen Parker
Andrew Dunstan wrote: Well, yes, it's some of it, and in theory Tom's late addition of a queue that gets all the dependencies of a table as soon as the table data is restored should make that work better. But of course, that's not the only time indexes are created, and each index creation

Re: [HACKERS] [PATCH 1/2 v3] [libpq] rework sigpipe-handling macros

2009-07-14 Thread Jeremy Kerr
Hi, Alvaro, Does this work in compilers other than GCC? I think we use some kludges to protect against them ... see pg_list.h for the canonical example. As I understand it, we're not using static inlines in pg_list.h to prevent multiple objects from exporting the same symbols if the

Re: [HACKERS] Index-only scans

2009-07-14 Thread Greg Stark
On Wed, Jul 15, 2009 at 1:21 AM, Ron Mayerrm...@cheapcomplexdevices.com wrote: Really?  I'd have thought that index is similar to materializing these views:  create view a_b as select aid,bid from manytomany order by aid,bid;  create view b_a as select bid,aid from manytomany order by bid,aid;

Re: [HACKERS] CommitFest 2009-07 is Now Closed

2009-07-14 Thread Robert Haas
On Tue, Jul 14, 2009 at 8:55 PM, Tatsuo Ishiiis...@postgresql.org wrote: Tsutomu was asking to add his patches to July commit festa: http://archives.postgresql.org/pgsql-hackers/2009-07/msg00782.php But it does not seem all subsequent replies agree that. What shall he do?  Just waits for

Re: [HACKERS] CommitFest 2009-07 is Now Closed

2009-07-14 Thread Tatsuo Ishii
Tsutomu was asking to add his patches to July commit festa: http://archives.postgresql.org/pgsql-hackers/2009-07/msg00782.php But it does not seem all subsequent replies agree that. What shall he do?  Just waits for next commitfest? Adding a patch to the CommitFest doesn't require

Re: [HACKERS] CommitFest 2009-07 is Now Closed

2009-07-14 Thread Tatsuo Ishii
Robert, Tsutomu was asking to add his patches to July commit festa: http://archives.postgresql.org/pgsql-hackers/2009-07/msg00782.php But it does not seem all subsequent replies agree that. What shall he do? Just waits for next commit festa? -- Tatsuo Ishii SRA OSS, Inc. Japan The time is

Re: [HACKERS] navigation menu for documents

2009-07-14 Thread Brendan Jurd
2009/7/15 Andrew Dunstan and...@dunslane.net: Dimitri Fontaine wrote: What I'm thinking about is to extend current breadcumb at the top of the page to include chapter, section, subsection. So that for exemple the following page:  

[HACKERS] execute on log_rotation

2009-07-14 Thread Jaime Casanova
Hi, I was thinking that could be useful to have a guc to indicate some command to execute on rotation of logs (ok, i'm not inventing warm water here, but...). it could be useful for: - load data from a csvlog to a table - execute some magic to analyze logs - archive logs (compress, move to

Re: [HACKERS] Sampling profiler updated

2009-07-14 Thread Itagaki Takahiro
Stefan Moeding pg...@moeding.net wrote: Have you thought about keeping the counters for each backend isolated? I think in the end it would be beneficial to be able to break down the response time for a critical business transaction in isolation instead of having all backends in one figure.

Re: [HACKERS] [PATCH 3/3] Document geqo_seed variable.

2009-07-14 Thread Robert Haas
On Tue, Jul 14, 2009 at 6:34 PM, Andres Freundand...@anarazel.de wrote: ---  doc/src/sgml/config.sgml |   16  1 files changed, 16 insertions(+), 0 deletions(-) diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 99d25d7..5d8eca9 100644 ***

Re: [HACKERS] navigation menu for documents

2009-07-14 Thread Alvaro Herrera
Brendan Jurd escribió: 2009/7/15 Andrew Dunstan and...@dunslane.net: Dimitri Fontaine wrote: Would have at its top:  Home → Documentation → Manuals → PostgreSQL 8.3 → Data Types → Geometric Types → Points Yes, really. What you suggest here is just not adequate, IMNSHO. I don't want

Re: [HACKERS] [PATCH 1/2 v3] [libpq] rework sigpipe-handling macros

2009-07-14 Thread Robert Haas
On Tue, Jul 14, 2009 at 8:42 PM, Jeremy Kerrj...@ozlabs.org wrote: Hi, Alvaro, Does this work in compilers other than GCC?  I think we use some kludges to protect against them ... see pg_list.h for the canonical example. As I understand it, we're not using static inlines in pg_list.h to

Re: [HACKERS] pg_dump Add dumping of comments on index columns

2009-07-14 Thread higepon
Jaime Casanova wrote: this one looks good to me, the only adjust i made to the patch is Thank you for your review! --- Taro Minowa(Higepon) http://www.monaos.org/ http://code.google.com/p/mosh-scheme/ On Tue, Jul 14, 2009 at 4:34 PM, Jaime Casanovajcasa...@systemguards.com.ec wrote: On

Re: [HACKERS] Synch Rep for CommitFest 2009-07

2009-07-14 Thread Fujii Masao
Hi, On Wed, Jul 15, 2009 at 3:56 AM, Heikki Linnakangasheikki.linnakan...@enterprisedb.com wrote: Here's one little thing in addition to all the stuff already discussed: Thanks for the comment! If that's the only such caller, let's introduce a new function for that and keep the XLogFlush()

[HACKERS] Index AM API changes for deferability

2009-07-14 Thread Jeff Davis
I am reviewing the following patch: http://archives.postgresql.org/message-id/8e2dbb700907071138y4ebe75cw81879aa513cf8...@mail.gmail.com In order to provide useful feedback, I would like to reach a consensus on a possible index AM API change to make it easier to support deferrable constraints