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
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 kapilaamit.kap...@huawei.com
wrote:
Now the patch of Phil Sober provides 2 new API's
PQconninfoParseParams(), and PQconninfodefaultsMerge(),
using these API's
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 kapilaamit.kap...@huawei.com
wrote:
Now the patch of Phil Sober provides 2 new API's
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
views
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 kapilaamit.kap...@huawei.com
wrote:
Now the patch of Phil Sober provides 2 new API's
2013-01-29 11:15 keltezéssel, Magnus Hagander írta:
On Thu, Jan 24, 2013 at 7:04 AM, Hari Babu haribabu.ko...@huawei.com wrote:
On Wed, Jan 23, 2013 11:48 PM, Magnus Hagander wrote:
On Wed, Jan 23, 2013 at 10:18 AM, Hari Babu haribabu.ko...@huawei.com
wrote:
Test scenario to reproduce:
Alvaro Herrera alvhe...@2ndquadrant.com 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
Thom Brown t...@linux.com wrote:
On 16 February 2013 01:01, Kevin Grittner kgri...@ymail.com 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
On Fri, Feb 15, 2013 at 11:25 AM, Robert Haas robertmh...@gmail.com 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
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. I
On 16.02.2013 10:40, Ants Aasma wrote:
On Fri, Feb 15, 2013 at 3:49 PM, Heikki Linnakangas
hlinnakan...@vmware.com 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
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() function.
On Mon, Feb 18, 2013 at 06:49:14AM -0800, Kevin Grittner wrote:
Alvaro Herrera alvhe...@2ndquadrant.com 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,
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 instead of
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
--
On Thu, Feb 14, 2013 at 7:02 PM, Josh Berkus j...@agliodbs.com 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.
--
Noah Misch n...@leadboat.com wrote:
On Mon, Feb 18, 2013 at 06:49:14AM -0800, Kevin Grittner wrote:
Alvaro Herrera alvhe...@2ndquadrant.com wrote:
Maybe it would be a good idea to try to put such commands at
the very end of the dump, if possible.
25, /*
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'
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=mastodondt=2013-02-19%2000%3A00%3A01
probably worth investigating a bit; we might have broken something.
--
Álvaro Herrera
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
--
20 matches
Mail list logo