On tor, 2010-06-10 at 09:52 -0400, Tom Lane wrote:
Peter Eisentraut pete...@gmx.net writes:
Quick testing shows that clang doesn't get through the configure stage
on this Debian system -- it looks like some amount of better integration
with glibc might be needed. Building with llvm-gcc
On tis, 2010-06-08 at 16:17 -0400, Robert Haas wrote:
Perhaps
-
That's already in use to mean something else.
Btw., the SQL standard also defines - for something else, so if you
wanted to be really visionary, you could deprecate that one as an
operator at the same time.
--
Sent via
Why are you cloning over http?
Me too I've used http, since I'm behind a proxy and I couldn't
find a simple way of having the git:// method working behind
a proxy...
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On 09/06/10 08:24, Fujii Masao wrote:
On Wed, Jun 9, 2010 at 12:52 PM, Andrew Dunstanand...@dunslane.net wrote:
There is precedent for .pgpass being a bit ambiguous. See the way
localhost is used.
OK. The attached patch allows us to use replication in the database
field of the .pgpass file,
On 11/06/10 05:36, Fujii Masao wrote:
vacuum_defer_cleanup_age is categorized as Statement Behavior
parameter in the document. On the other hand, it's categorized
as Hot Standby one in postgresql.conf. Why do we need to do so?
Yeah, there's clearly a mismatch. I think Hot Standby is the right
On Fri, Jun 11, 2010 at 2:51 AM, Peter Eisentraut pete...@gmx.net wrote:
On tis, 2010-06-08 at 16:17 -0400, Robert Haas wrote:
Perhaps
-
That's already in use to mean something else.
Btw., the SQL standard also defines - for something else, so if you
wanted to be really visionary, you
On fre, 2010-06-11 at 07:10 -0400, Robert Haas wrote:
On Fri, Jun 11, 2010 at 2:51 AM, Peter Eisentraut pete...@gmx.net wrote:
On tis, 2010-06-08 at 16:17 -0400, Robert Haas wrote:
Perhaps
-
That's already in use to mean something else.
Btw., the SQL standard also defines - for
On tis, 2010-06-08 at 15:38 -0400, Robert Haas wrote:
I'm happy to do whatever the consensus is. I thought it would be
easier to remember if the two operators were spelled at least somewhat
similarly, but I just work here.
How about no operator at all? It won't be as cool to read, but
On Sun, May 30, 2010 at 13:00, Peter Eisentraut pete...@gmx.net wrote:
It has been discussed several times in the past that there is no way for
a client to authenticate a server over Unix-domain sockets. So
depending on circumstances, a local user could easily insert his own
server and
On Sun, May 30, 2010 at 13:00, Peter Eisentraut pete...@gmx.net wrote:
It has been discussed several times in the past that there is no way for
a client to authenticate a server over Unix-domain sockets. So
depending on circumstances, a local user could easily insert his own
server and
On tis, 2010-06-08 at 10:21 -0400, Tom Lane wrote:
The question is why bother to recognize *any* cases of this form.
I find it really semantically ugly to have the parser effectively
doing one deduction of this form when the main engine for that type
of deduction is elsewhere; so unless there
On tis, 2010-06-08 at 10:05 -0400, Tom Lane wrote:
Perhaps the correct fix would be to mark stored query trees as having
a
dependency on the index, so that dropping the index/constraint would
force a drop of the rule too. Just pushing the check to plan time, as
I suggested yesterday, isn't a
* Peter Eisentraut (pete...@gmx.net) wrote:
The patch needs some portability work and possible refactoring because
of that, but before I embark on that, comments on the concept?
I definitely like the idea but I dislike requiring the user to do
something to implement it. Thinking about how
On Fri, Jun 11, 2010 at 14:07, Stephen Frost sfr...@snowman.net wrote:
* Peter Eisentraut (pete...@gmx.net) wrote:
The patch needs some portability work and possible refactoring because
of that, but before I embark on that, comments on the concept?
I definitely like the idea but I dislike
Hi,
I understand this is very early to ask this.. but, is there any tentative
timeline has been planned / available for the PostgreSQL 9.1 release, like for
the alpha or beta releases before the general release?
Also, is there any synchronous replication patch planned for the PostgreSQL 9.0
* Magnus Hagander (mag...@hagander.net) wrote:
On Fri, Jun 11, 2010 at 14:07, Stephen Frost sfr...@snowman.net wrote:
I definitely like the idea but I dislike requiring the user to do
something to implement it. Thinking about how packagers might want to
use it, could we make it possible to
* Pr, Solaiyappan (NSN - IN/Bangalore) (solaiyappan...@nsn.com) wrote:
I understand this is very early to ask this.. but, is there any tentative
timeline has been planned / available for the PostgreSQL 9.1 release, like
for the alpha or beta releases before the general release?
The tentative
On Thu, 2010-06-10 at 09:57 -0400, Robert Haas wrote:
On Mon, Jun 7, 2010 at 9:21 AM, Fujii Masao masao.fu...@gmail.com
wrote:
When an error is found in the WAL streamed from the master, a
warning
message is repeated without interval forever in the standby. This
consumes CPU load very
On Fri, 2010-06-11 at 19:56 +0800, Pr, Solaiyappan (NSN - IN/Bangalore)
wrote:
Also, is there any synchronous replication patch planned for the
PostgreSQL 9.0 version?
Cybertec announced new version of Cybercluster, which includes sync
replication -- I haven't tested it though.
--
Devrim
On 11/06/10 07:18, Fujii Masao wrote:
On Fri, Jun 11, 2010 at 1:01 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
We're talking about a corrupt record (incorrect CRC, incorrect backlink
etc.), not errors within redo functions. During crash recovery, a corrupt
record means
Devrim GÜNDÜZ wrote:
On Fri, 2010-06-11 at 19:56 +0800, Pr, Solaiyappan (NSN - IN/Bangalore)
wrote:
Also, is there any synchronous replication patch planned for the
PostgreSQL 9.0 version?
Cybertec announced new version of Cybercluster, which includes sync
replication -- I haven't tested it
On Fri, Jun 11, 2010 at 7:14 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
On 09/06/10 08:24, Fujii Masao wrote:
On Wed, Jun 9, 2010 at 12:52 PM, Andrew Dunstanand...@dunslane.net
wrote:
There is precedent for .pgpass being a bit ambiguous. See the way
localhost is
On 06/11/2010 02:25 PM, Devrim GÜNDÜZ wrote:
On Fri, 2010-06-11 at 19:56 +0800, Pr, Solaiyappan (NSN - IN/Bangalore)
wrote:
Also, is there any synchronous replication patch planned for the
PostgreSQL 9.0 version?
Cybertec announced new version of Cybercluster, which includes sync
replication
Hi,
In 9.0, walsender reads WAL always from the disk and sends it to the standby.
That is, we cannot send WAL until it has been written (and flushed) to the disk.
This degrades the performance of synchronous replication very much since a
transaction commit must wait for the WAL write time *plus*
On Fri, Jun 11, 2010 at 8:19 AM, Simon Riggs si...@2ndquadrant.com wrote:
On Thu, 2010-06-10 at 09:57 -0400, Robert Haas wrote:
On Mon, Jun 7, 2010 at 9:21 AM, Fujii Masao masao.fu...@gmail.com
wrote:
When an error is found in the WAL streamed from the master, a
warning
message is repeated
On Fri, Jun 11, 2010 at 7:25 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Yeah, there's clearly a mismatch. I think Hot Standby is the right place,
altough you could argue that it should be together with
vacuum_freeze_min_age and vacuum_freeze_table_age too.
We seem to be
On Fri, Jun 11, 2010 at 9:14 AM, Fujii Masao masao.fu...@gmail.com wrote:
Thought? Comment? Objection?
What happens if the WAL is streamed to the standby and then the master
crashes without writing that WAL to disk?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise
On Fri, Jun 11, 2010 at 9:32 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Hmm, right now it doesn't even reconnect when it sees a corrupt record
streamed from the master. It's really pointless to retry in that case,
reapplying the exact same piece of WAL surely won't work.
On Thu, 2010-06-10 at 19:01 +0300, Heikki Linnakangas wrote:
What warning message are we talking about? All the error cases I can
think of in WAL-application are ERROR, or likely even PANIC.
We're talking about a corrupt record (incorrect CRC, incorrect backlink
etc.), not errors
Why does pg_upgrade create its output directory in the user's home
directory (or TMP on Windows)? I should have thought that the current
working directory would be a more suitable choice. At the very least
there should be an option for where to create it. Also, this location
doesn't seem to
On Fri, Jun 11, 2010 at 9:43 AM, Simon Riggs si...@2ndquadrant.com wrote:
On Thu, 2010-06-10 at 19:01 +0300, Heikki Linnakangas wrote:
What warning message are we talking about? All the error cases I can
think of in WAL-application are ERROR, or likely even PANIC.
We're talking about a
On Fri, Jun 11, 2010 at 10:22 PM, Robert Haas robertmh...@gmail.com wrote:
On Fri, Jun 11, 2010 at 9:14 AM, Fujii Masao masao.fu...@gmail.com wrote:
Thought? Comment? Objection?
What happens if the WAL is streamed to the standby and then the master
crashes without writing that WAL to disk?
On Fri, Jun 11, 2010 at 9:57 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Fri, Jun 11, 2010 at 10:22 PM, Robert Haas robertmh...@gmail.com wrote:
On Fri, Jun 11, 2010 at 9:14 AM, Fujii Masao masao.fu...@gmail.com wrote:
Thought? Comment? Objection?
What happens if the WAL is streamed to
Fujii Masao masao.fu...@gmail.com writes:
In 9.0, walsender reads WAL always from the disk and sends it to the standby.
That is, we cannot send WAL until it has been written (and flushed) to the
disk.
I believe the above statement to be incorrect: walsender does *not* wait
for an fsync to
On 06/11/2010 04:31 PM, Tom Lane wrote:
Fujii Masaomasao.fu...@gmail.com writes:
In 9.0, walsender reads WAL always from the disk and sends it to the standby.
That is, we cannot send WAL until it has been written (and flushed) to the disk.
I believe the above statement to be incorrect:
Stefan Kaltenbrunner ste...@kaltenbrunner.cc writes:
hmm not sure that is what fujii tried to say - I think his point was
that in the original case we would have serialized all the operations
(first write+sync on the master, network afterwards and write+sync on
the slave) and now we could
Peter Eisentraut pete...@gmx.net writes:
Btw., the SQL standard also defines - for something else, so if you
wanted to be really visionary, you could deprecate that one as an
operator at the same time.
Ouch. What does it define it to mean?
Similar to C: Dereferencing a reference and
Hi,
per $SUBJECT.
Cheers,
Jan
diff --git a/src/test/regress/pg_regress.c b/src/test/regress/pg_regress.c
index 9de4189..ebdf812 100644
--- a/src/test/regress/pg_regress.c
+++ b/src/test/regress/pg_regress.c
@@ -1870,6 +1870,7 @@ help(void)
printf(_((can be used
Peter Eisentraut pete...@gmx.net writes:
How about no operator at all? It won't be as cool to read, but
consider, the arguments are text and text, not involving any hstore type
at all, so whatever operator you choose is in practice blocked from
everyone everywhere. No one could ever
On 06/11/2010 04:47 PM, Tom Lane wrote:
Stefan Kaltenbrunnerste...@kaltenbrunner.cc writes:
hmm not sure that is what fujii tried to say - I think his point was
that in the original case we would have serialized all the operations
(first write+sync on the master, network afterwards and
Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp writes:
Peter Eisentraut pete...@gmx.net wrote:
max_locks_per_xact != max_locks_per_xact)
Looks like a bug.
Ah, it should be compared with the same name field in ControlFile.
Yeah, obvious typo, please commit.
On Jun 11, 2010, at 7:59 AM, Tom Lane wrote:
How about no operator at all? It won't be as cool to read, but
consider, the arguments are text and text, not involving any hstore type
at all, so whatever operator you choose is in practice blocked from
everyone everywhere. No one could ever
* Andrew Dunstan (and...@dunslane.net) wrote:
Luxenberg, Scott I. wrote:
I have been trying to create/run a build farm as part of a project I am
working on.
That seems an odd thing to do since we have one ...
To clarify, he's setting up a build farm *member*. :)
However, I have noticed
David E. Wheeler da...@kineticode.com writes:
On Jun 11, 2010, at 7:59 AM, Tom Lane wrote:
Yeah, that's a good point. Maybe we should just deprecate the operator
altogether.
That would make it so that the use of = in hstore strings would be less
consistent. Makes sense to me.
Less
On Jun 11, 2010, at 9:58 AM, Tom Lane wrote:
That would make it so that the use of = in hstore strings would be less
consistent. Makes sense to me.
Less inconsistent, ITYM? But yeah, then we would have no reason to
fiddle with hstore_in, which is good.
Yes, sorry.
David
--
Sent via
On Thursday 10 June 2010 19:30:00 Magnus Hagander wrote:
On Thu, Jun 10, 2010 at 18:20, Stephen Frost sfr...@snowman.net wrote:
* Andrew Dunstan (and...@dunslane.net) wrote:
I don't see why not. Buildfarm members are going to have to reset their
repos when we finally cut over in a few
On Fri, Jun 11, 2010 at 19:12, Andres Freund and...@anarazel.de wrote:
On Thursday 10 June 2010 19:30:00 Magnus Hagander wrote:
On Thu, Jun 10, 2010 at 18:20, Stephen Frost sfr...@snowman.net wrote:
* Andrew Dunstan (and...@dunslane.net) wrote:
I don't see why not. Buildfarm members are
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes:
So to clean up all WAL files older than those needed by that base backup,
you would simply copy-paste that location and call pg_cleanuparchive:
pg_cleanuparchive /walarchive/ 0001002F
Ok, idle though: what about
On Fri, Jun 11, 2010 at 10:59 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Peter Eisentraut pete...@gmx.net writes:
How about no operator at all? It won't be as cool to read, but
consider, the arguments are text and text, not involving any hstore type
at all, so whatever operator you choose is in
Joseph Adams joeyadams3.14...@gmail.com writes:
To repeat an earlier question (which was in turn repeating an earlier
question), would it be possible to do one of these, yielding '
key=this, key2=that '::hstore :
hstore(key := 'this', key2 := 'that')
hstore(key = 'this', key2 = 'that')
Well, we're already not waiting for fsync, which is the slowest part.
If there's a performance problem, it may be because FADVISE_DONTNEED
disables kernel buffering so that we're forced to actually read the data
back from disk before sending it on down the wire.
Well, that's fairly direct to
Folks,
Looks like someone accidentally deleted the -Z option from vacuumdb.
Patch attached, one character. ;-)
(thanks Gabrielle, and Jan Urbanski)
--
-- Josh Berkus
PostgreSQL Experts Inc.
On 6/11/10 3:44 PM, Josh Berkus wrote:
Folks,
Looks like someone accidentally deleted the -Z option from vacuumdb.
Patch attached, one character. ;-)
Make that 3 characters; Jan pointed out that we ought to have the
command-string in the same order as the switch options.
--
Josh Berkus j...@agliodbs.com writes:
Looks like someone accidentally deleted the -Z option from vacuumdb.
Forgot to add it in the first place, looks like.
Patch attached, one character. ;-)
Make that 3 characters; Jan pointed out that we ought to have the
command-string in the same order
On Jun 11, 2010, at 16:31 , Tom Lane wrote:
Fujii Masao masao.fu...@gmail.com writes:
In 9.0, walsender reads WAL always from the disk and sends it to the standby.
That is, we cannot send WAL until it has been written (and flushed) to the
disk.
I believe the above statement to be
On Fri, Jun 11, 2010 at 5:23 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Joseph Adams joeyadams3.14...@gmail.com writes:
To repeat an earlier question (which was in turn repeating an earlier
question), would it be possible to do one of these, yielding '
key=this, key2=that '::hstore :
hstore(key
Hm, but then Robert's failure case is real, and streaming replication might
break due to an OS-level crash of the master. Or am I missing something?
Well, in the failover case this isn't a problem, it's a benefit: the
standby gets a transaction which you would have lost off the master.
Robert Haas wrote:
If my streaming replication stops working, I want to know about it as
soon as possible. WARNING just doesn't cut it.
This needs some better thought.
If we PANIC, then surely it will PANIC again when we restart unless we
do something. So we can't do that. But we
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello
I am testing HS + SR in a system running 9.0beta2. What I am doing is
just trying all kind of crazy combinations and see how the system
handles them.
One of the test I knew was going to fail was to create a tablespace in
the master node with
Andrew Dunstan wrote:
Why does pg_upgrade create its output directory in the user's home
directory (or TMP on Windows)? I should have thought that the current
working directory would be a more suitable choice. At the very least
there should be an option for where to create it. Also, this
On fre, 2010-06-11 at 08:15 -0400, Stephen Frost wrote:
* Pr, Solaiyappan (NSN - IN/Bangalore) (solaiyappan...@nsn.com) wrote:
I understand this is very early to ask this.. but, is there any tentative
timeline has been planned / available for the PostgreSQL 9.1 release, like
for the alpha
61 matches
Mail list logo