On 13 June 2013 01:11, Tom Lane t...@sss.pgh.pa.us wrote:
Dean Rasheed dean.a.rash...@gmail.com writes:
The more I read the spec, the less sense it seems to make, and each
time I read it, I seem to reach a different conclusion.
On my latest reading, I've almost convinced myself that updatable
On 11 June 2013 15:59, Tatsuo Ishii is...@postgresql.org wrote:
I wonder why true synchronous replication nor eager replication
are not in the developer TODO list. If we want them in the future,
they should be on it.
I think you still need to explain what true synchronous replication is.
On 13 June 2013 02:18, Stephen Frost sfr...@snowman.net wrote:
* Ants Aasma (a...@cybertec.at) wrote:
In a cluster setting you take the CSN value on the master, then before
starting execution on a standby you wait until that the standby has
replayed enough WAL to reach the CSN point read from
On 06/13/2013 02:22 AM, Tatsuo Ishii wrote:
On Jun 12, 2013 2:02 AM, Tatsuo Ishii is...@postgresql.org wrote:
No, I'm not talking about conflict resolution.
From
http://www.cs.cmu.edu/~natassa/courses/15-823/F02/papers/replication.pdf:
--
Eager
On 9 June 2013 11:14, Dean Rasheed dean.a.rash...@gmail.com wrote:
Here's a rebased version of the patch implementing WITH CHECK OPTION
for auto-updatable views.
It now includes documentation, and a clearer description of the
patch's limitations --- WITH CHECK OPTION is only supported on
Hi,
Attached is a patch implementing a new aggregate function md5_agg() to
compute the aggregate MD5 sum across a number of rows. This is
something I've wished for a number of times. I think the primary use
case is to do a quick check that 2 tables, possibly on different
servers, contain the same
On Thu, Jun 13, 2013 at 11:39 AM, Hannu Krosing ha...@2ndquadrant.com wrote:
Coincidentally getting cluster wide consistent snapshots and delaying
until some specific point in commit ordering is almost trivial to
solve with Commit Sequence Number based snapshot scheme that I
proposed.
Can you
On Thu, Jun 13, 2013 at 11:24 AM, Simon Riggs si...@2ndquadrant.com wrote:
That idea is not dependent upon CSNs.
It is an option for us to implement snapshot synchronisation now, we
just haven't done it yet.
I'm currently working on exporting/importing snapshots on standbys,
which is a
I'm currently implementing DML actions in the informix FDW module and
trying to understand how UPDATE/DELETE actions interact with the various
structures, especially how states between the associated ForeignScan and
ForeignModify actions could be transmitted. As far as i understood, with
e.g.
Bernd Helmle maili...@oopsware.de writes:
During the planning phase, the Informix FDW currently plans a server side
cursor, which identifier i'd like to pass into the planning phase of the
modify action to reuse it in conjunction with UPDATE ... WHERE CURRENT OF.
I understand that the
On Wed, Jun 12, 2013 at 10:00 PM, Brendan Jurd dire...@gmail.com wrote:
On 13 June 2013 04:26, Merlin Moncure mmonc...@gmail.com wrote:
On Wed, Jun 12, 2013 at 1:20 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Josh Berkus j...@agliodbs.com writes:
On 06/12/2013 11:01 AM, Tom Lane wrote:
I'm going
On Jun 12, 2013, at 8:16 PM, Peter Eisentraut pete...@gmx.net wrote:
This has served no purpose except to
1. take up space
2. confuse users
3. produce broken external extension modules that take contrib as an example
4. break builds of PostgreSQL when users try to fix 3. by exporting
On Jun 12, 2013, at 8:00 PM, Brendan Jurd dire...@gmail.com wrote:
array_dims - Returns the dimensions of the array, unless it is empty
in which case NULL.
array_proper_dims - Returns the dimensions of the array.
array_ndims - Returns the number of dimension, unless it is empty in
which case
On Wed, Jun 12, 2013 at 12:55 PM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz wrote:
On 12/06/13 13:15, Stephen Frost wrote:
* Fujii Masao (masao.fu...@gmail.com) wrote:
The attached patch fixes this problem. It just changes walsender so that
it
waits for all the outstanding WAL records to
On Wed, Jun 12, 2013 at 9:55 PM, Andres Freund and...@2ndquadrant.com wrote:
On 2013-06-12 08:48:39 -0400, Stephen Frost wrote:
* Magnus Hagander (mag...@hagander.net) wrote:
On Wed, Jun 12, 2013 at 1:48 PM, Andres Freund and...@2ndquadrant.com
wrote:
On 2013-06-12 07:53:29 +0900, Fujii
On Wed, Jun 12, 2013 at 9:48 PM, Stephen Frost sfr...@snowman.net wrote:
* Magnus Hagander (mag...@hagander.net) wrote:
On Wed, Jun 12, 2013 at 1:48 PM, Andres Freund and...@2ndquadrant.com
wrote:
On 2013-06-12 07:53:29 +0900, Fujii Masao wrote:
The attached patch fixes this problem. It
Hackers,
Revised version of patch for additional information storage in GIN is
attached. Changes are mostly bug fixes.
Resemble GIN interface changes that this patch introduce.
Patch modifies GIN interface as following:
1) Two arguments are added to extractValue
Datum **addInfo, bool
Hackers,
Attached patch contains opclass which demonstrates advantages of GIN
additional information storing itself without other GIN improvements. It
implements inversed task of regex indexing. It works so: you create index
on regexes and search for regexes matched query string. It introduce two
Back before Christmas I complained that elog.c's behavior of
prioritizing LOG-level messages differently in standalone mode had
masked at least one significant bug, as well as causing confusion
in some other cases:
http://www.postgresql.org/message-id/6967.1355520...@sss.pgh.pa.us
I promptly
On Thu, June 13, 2013 22:19, Alexander Korotkov wrote:
[index_on_regexes.1.patch.gz ]
Hi,
Compile of core is OK, but contrib compilation fails:
-- [2013.06.13 23:23:14 idxregex] make contrib
trgm_gin.c: In function gin_regexp_trgm_config:
trgm_gin.c:410:2: error: unknown type name
On Fri, Jun 14, 2013 at 1:30 AM, Erik Rijkers e...@xs4all.nl wrote:
On Thu, June 13, 2013 22:19, Alexander Korotkov wrote:
[index_on_regexes.1.patch.gz ]
Hi,
Compile of core is OK, but contrib compilation fails:
-- [2013.06.13 23:23:14 idxregex] make contrib
trgm_gin.c: In function
On 6/13/13 5:35 AM, Dean Rasheed wrote:
Attached is a patch implementing a new aggregate function md5_agg() to
compute the aggregate MD5 sum across a number of rows.
That seems somewhat useful.
In passing, I've tidied up and optimised the code in md5.c a bit ---
specifically I've removed the
On 06/13/2013 05:35 AM, Amit Kapila wrote:
On Friday, June 07, 2013 9:45 AM Amit Kapila wrote:
On Thursday, June 06, 2013 10:22 PM Robert Haas wrote:
On Wed, Jun 5, 2013 at 7:24 AM, Amit Kapila amit.kap...@huawei.com
wrote:
On Monday, May 27, 2013 4:17 PM Amit Kapila wrote:
On Wednesday,
--On 13. Juni 2013 11:06:31 -0400 Tom Lane t...@sss.pgh.pa.us wrote:
My
recommendation would be to see if you can't save the relevant info in
the RelOptInfo node for the relation, probably during GetForeignPlan,
and then get it from there in PlanForeignModify instead of digging in
the plan
Some places in the docs and elog hints refer to standalone backends,
while the official name as used in app-postgres.html is single-user mode,
and in fact standalone does not appear on that page.
This tries to standardize the other locations to use single-user. I
think I did the right thing with
Bernd Helmle maili...@oopsware.de writes:
What i tried before was to access (in PlanForeignModify) the RelOptInfo
structure through PlannerInfo-simple_rel_array, assuming the the
resultRelation index points to the right array member. However, that didn't
work, the fdw_private List is not
Jeff Janes escribió:
I think I did the right thing with the message translation files, but
I can't figure out how to test that.
Don't do that. These files are automatically generated. Just leave
them alone and translators will get to them in time.
--
Álvaro Herrera
Hi here!
Centos 6.4
Postgres 9.1
I want to automate rsync backups from server1 to server2 via ssh using the
postgres(linux deamon user) and a pair of private/public keys generated by
ssh-keygen
I generated the keys in Server1 and copy and added id_rsa.pub to
/var/lib/pgsql/.ssh/authorized_keys
Daniel,
The pgsql-hackers mailing list is for people working on the PostgreSQL
database engine itself. Please post your question to one of the
following lists instead:
pgsql-general
pgsql-admin
Or you can use our IRC channel: http://www.postgresql.org/community/irc/
Thanks!
--
Josh Berkus
Jeff Davis pg...@j-davis.com writes:
The patch is a bit ugly: I had to copy some code, and copy the entire
checksum.c file (minus some Asserts, which don't work in an external
program). Suggestions welcome.
What I propose we do about this is reduce backend/storage/page/checksum.c
to something
Barring objections, I will branch off REL9_3_STABLE in the git repo
tomorrow afternoon, probably around 1800 UTC.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
- Original Message -
From: Peter Eisentraut pete...@gmx.net
To: pgsql-hackers@postgresql.org
Cc:
Sent: Thursday, 13 June 2013 12:16 PM
Subject: [HACKERS] [PATCH] Remove useless USE_PGXS support in contrib
T his has served no purpose except to
1. take up space
2. confuse users
I think the suggested emacs configuration snippets in
src/tools/editors/emacs.samples no longer represent current best
practices. I have come up with some newer things that I'd like to
propose for review.
First, I propose adding a .dir-locals.el file to the top-level directory
with basic emacs
* Tom Lane (t...@sss.pgh.pa.us) wrote:
I promptly forgot to do anything about it, but I'd still like to get
such a change into 9.3. I've now written and tested a patch that
makes that change without creating any new noise during initdb or in a
manually-started standalone backend. Does anyone
On 14/06/13 07:38, Fujii Masao wrote:
On Wed, Jun 12, 2013 at 12:55 PM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz wrote:
On 12/06/13 13:15, Stephen Frost wrote:
* Fujii Masao (masao.fu...@gmail.com) wrote:
The attached patch fixes this problem. It just changes walsender so that
it
waits
On Friday, June 14, 2013 3:17 AM Josh Berkus wrote:
On 06/13/2013 05:35 AM, Amit Kapila wrote:
On Friday, June 07, 2013 9:45 AM Amit Kapila wrote:
On Thursday, June 06, 2013 10:22 PM Robert Haas wrote:
On Wed, Jun 5, 2013 at 7:24 AM, Amit Kapila
amit.kap...@huawei.com
wrote:
On Monday,
36 matches
Mail list logo