[HACKERS] unaccent module - two params function should be immutable

2013-02-18 Thread Pavel Stehule
Hello There was a proposal to change flag of function to immutable - should be used in indexes CREATE FUNCTION unaccent(regdictionary, text) RETURNS text AS 'MODULE_PATHNAME', 'unaccent_dict' LANGUAGE C STABLE STRICT; is there any progress? Regards Pavel Stehule --

Re: PATCH: Split stats file per database WAS: [HACKERS] autovacuum stress-testing our system

2013-02-18 Thread Alvaro Herrera
Alvaro Herrera wrote: > I have pushed it now. Further testing, of course, is always welcome. Mastodon failed: http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=mastodon&dt=2013-02-19%2000%3A00%3A01 probably worth investigating a bit; we might have broken something. -- Álvaro Herrera

Re: [HACKERS] pgsql: Clean up c.h / postgres.h after Assert() move

2013-02-18 Thread Alvaro Herrera
Jeff Janes escribió: > commit 381d4b70a9854a7b5b9f12d828a0824f8564f1e7 introduced some > compiler warnings: > > assert.c:26: warning: no previous prototype for 'ExceptionalCondition' > elog.c: In function 'pg_re_throw': > elog.c:1628: warning: implicit declaration of function 'ExceptionalCondition

Re: [HACKERS] Materialized views WIP patch

2013-02-18 Thread Kevin Grittner
Noah Misch wrote: > On Mon, Feb 18, 2013 at 06:49:14AM -0800, Kevin Grittner wrote: >> Alvaro Herrera wrote: >>> Maybe it would be a good idea to try to put such commands at >>> the very end of the dump, if possible. > >> 25,    /* DO_POST_DATA_BOUNDARY */ >> 26,  

Re: [HACKERS] [pgsql-advocacy] Call for Google Summer of Code mentors, admins

2013-02-18 Thread Magnus Hagander
On Thu, Feb 14, 2013 at 7:02 PM, Josh Berkus wrote: > Folks, > > Once again, Google is holding Summer of Code. We need to assess whether > we want to participate this year. > > Questions: > > - Who wants to mentor for GSOC? Sign me up on that list. Depending on projects, of course. -- Magnus

Re: [HACKERS] [pgsql-advocacy] Call for Google Summer of Code mentors, admins

2013-02-18 Thread Andres Freund
On 2013-02-14 10:02:13 -0800, Josh Berkus wrote: > - Please suggest project ideas for GSOC pg_upgrade support for debian's pg_upgradecluster Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -

Re: PATCH: Split stats file per database WAS: [HACKERS] autovacuum stress-testing our system

2013-02-18 Thread Alvaro Herrera
Tomas Vondra wrote: > On 18.2.2013 16:50, Alvaro Herrera wrote: > > Also, it seems to me that the new pgstat_db_requested() logic is > > slightly bogus (in the "inefficient" sense, not the "incorrect" sense): > > we should be comparing the timestamp of the request vs. what's already > > on disk i

Re: [HACKERS] Materialized views WIP patch

2013-02-18 Thread Noah Misch
On Mon, Feb 18, 2013 at 06:49:14AM -0800, Kevin Grittner wrote: > Alvaro Herrera wrote: > > Maybe it would be a good idea to try to put such commands at the > > very end of the dump, if possible. >     25,    /* DO_POST_DATA_BOUNDARY */ >     26,   

Re: PATCH: Split stats file per database WAS: [HACKERS] autovacuum stress-testing our system

2013-02-18 Thread Tomas Vondra
On 18.2.2013 16:50, Alvaro Herrera wrote: > Tomas Vondra wrote: > >> So, here's v10 of the patch (based on the v9+v9a), that implements the >> approach described above. >> >> It turned out to be much easier than I expected (basically just a >> rewrite of the pgstat_read_db_statsfile_timestamp() fu

Re: [HACKERS] 9.2.3 crashes during archive recovery

2013-02-18 Thread Heikki Linnakangas
On 16.02.2013 10:40, Ants Aasma wrote: On Fri, Feb 15, 2013 at 3:49 PM, Heikki Linnakangas wrote: While this solution would help solve my issue, it assumes that the correct amount of WAL files are actually there. Currently the docs for setting up a standby refer to "24.3.4. Recovering Using a

Re: PATCH: Split stats file per database WAS: [HACKERS] autovacuum stress-testing our system

2013-02-18 Thread Alvaro Herrera
Tomas Vondra wrote: > So, here's v10 of the patch (based on the v9+v9a), that implements the > approach described above. > > It turned out to be much easier than I expected (basically just a > rewrite of the pgstat_read_db_statsfile_timestamp() function. Thanks. I'm giving this another look now

Re: [HACKERS] JSON Function Bike Shedding

2013-02-18 Thread Merlin Moncure
On Fri, Feb 15, 2013 at 11:25 AM, Robert Haas wrote: >> Note that I have given json_get() and json_get_path() the same names, as it >> seems to me that the former is the same as the latter, with only one >> parameter. Same for json_get_as_text() and json_get_path_as_text(). > > I realize I'm in

Re: [HACKERS] Materialized views WIP patch

2013-02-18 Thread Kevin Grittner
Thom Brown wrote: > On 16 February 2013 01:01, Kevin Grittner wrote: >> Unless something else comes up in review or I get feedback to >> the contrary I plan to deal with the above-mentioned issues and >> commit this within a week or two. > > At the moment it's not possible to rename a column with

Re: [HACKERS] Materialized views WIP patch

2013-02-18 Thread Kevin Grittner
Alvaro Herrera wrote: > Kevin Grittner escribió: > >> I'm OK with that approach, and in the absence of anyone pushing >> for another direction, will make that change to pg_dump.  I'm >> thinking I would only do this for materialized views which were >> not scannable, but which cause REFRESH failur

Re: [HACKERS] pg_basebackup with -R option and start standby have problems with escaped password

2013-02-18 Thread Boszormenyi Zoltan
2013-01-29 11:15 keltezéssel, Magnus Hagander írta: On Thu, Jan 24, 2013 at 7:04 AM, Hari Babu wrote: On Wed, Jan 23, 2013 11:48 PM, Magnus Hagander wrote: On Wed, Jan 23, 2013 at 10:18 AM, Hari Babu wrote: Test scenario to reproduce: 1. Start the server 2. create the user

Re: [HACKERS] [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq

2013-02-18 Thread Amit Kapila
On Monday, February 18, 2013 1:41 PM Heikki Linnakangas wrote: > On 18.02.2013 06:07, Amit Kapila wrote: > > On Sunday, February 17, 2013 8:44 PM Phil Sorber wrote: > >> On Sun, Feb 17, 2013 at 1:35 AM, Amit kapila > >> wrote: > >>> Now the patch of Phil Sober provides 2 new API's > >> PQconninfoPa

Re: [HACKERS] Materialized views WIP patch

2013-02-18 Thread Alvaro Herrera
Kevin Grittner escribió: > I'm OK with that approach, and in the absence of anyone pushing for > another direction, will make that change to pg_dump.  I'm thinking > I would only do this for materialized views which were not > scannable, but which cause REFRESH failures on other materialized > vie

Re: [HACKERS] [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq

2013-02-18 Thread Amit Kapila
On Monday, February 18, 2013 1:41 PM Heikki Linnakangas wrote: > On 18.02.2013 06:07, Amit Kapila wrote: > > On Sunday, February 17, 2013 8:44 PM Phil Sorber wrote: > >> On Sun, Feb 17, 2013 at 1:35 AM, Amit kapila > >> wrote: > >>> Now the patch of Phil Sober provides 2 new API's > >> PQconninfoPa

Re: [HACKERS] [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq

2013-02-18 Thread Heikki Linnakangas
On 18.02.2013 06:07, Amit Kapila wrote: On Sunday, February 17, 2013 8:44 PM Phil Sorber wrote: On Sun, Feb 17, 2013 at 1:35 AM, Amit kapila wrote: Now the patch of Phil Sober provides 2 new API's PQconninfoParseParams(), and PQconninfodefaultsMerge(), using these API's I can think of below w

Re: [HACKERS] posix_fadvise missing in the walsender

2013-02-18 Thread Heikki Linnakangas
On 17.02.2013 14:55, Joachim Wieland wrote: In access/transam/xlog.c we give the OS buffer caching a hint that we won't need a WAL file any time soon with posix_fadvise(openLogFile, 0, 0, POSIX_FADV_DONTNEED); before closing the WAL file, but only if we don't have walsenders. That's reason