On Sun, Mar 6, 2011 at 3:23 AM, Robert Haas robertmh...@gmail.com wrote:
On Mon, Feb 28, 2011 at 8:08 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Sun, Feb 27, 2011 at 11:52 AM, Fujii Masao masao.fu...@gmail.com wrote:
There are two things that I think are pretty clear. If the receiver
has
On Sun, 2011-03-06 at 14:27 +0900, Fujii Masao wrote:
On Sun, Mar 6, 2011 at 2:59 AM, Robert Haas robertmh...@gmail.com wrote:
On Sat, Mar 5, 2011 at 11:56 AM, Simon Riggs si...@2ndquadrant.com wrote:
Even though postmaster dies, the waiting backend keeps waiting until
the timeout expires.
On Sun, 2011-03-06 at 16:58 +0900, Fujii Masao wrote:
On Sun, Mar 6, 2011 at 4:51 PM, Fujii Masao masao.fu...@gmail.com wrote:
One comment; what about introducing built-in function to wake up all the
waiting backends? When replication connection is closed, if we STONITH
the standby, we can
On Sun, 2011-03-06 at 01:58 +0900, Fujii Masao wrote:
On Sun, Mar 6, 2011 at 12:42 AM, Fujii Masao masao.fu...@gmail.com wrote:
New comments;
Another one;
+ longtimeout = SyncRepGetWaitTimeout();
snip
+ else if (timeout 0
+
I have improved the check and comments for pg_upgrade when testing for
pre-8.4 toast files in the attached applied patch.
--
Bruce Momjian br...@momjian.ushttp://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be
Right now the backend server has a catalog version number which reports
the version of the system tables and storage format. It would be
helpful if pg_upgrade could access a storage format version number for
plugins like /contrib so it could check to see if the cluster can be
upgraded with the
On 3 March 2011 06:33, Andy Colson a...@squeakycode.net wrote:
On 1/23/2011 5:11 AM, Michael Meskes wrote:
As I already said when the script was introduced, I would love to have a
real
perl solution, but I'm not a perl programmer by any means.
Michael
I thought Kris was going to work on
On 02/03/11 22:28, Jan Urbański wrote:
On 01/03/11 22:12, Peter Eisentraut wrote:
On tis, 2011-03-01 at 21:10 +0100, Jan Urbański wrote:
So you end up with a context message saying PL/Python function %s
and a detail message with the saved detail (if it's present) *and* the
traceback. The
Should we perhaps add a replication line to the default hba file, the
same way we have for regular connections? IIRC we discussed that as a
sub-sub-sub-point in some previous thread, but never mad a decision...
--
Magnus Hagander
Me: http://www.hagander.net/
Work:
On Sat, Mar 5, 2011 at 7:22 AM, Robert Haas robertmh...@gmail.com wrote:
Here's a rough attempt at filtering the post-alpha3 commit log down to
approximately the set of things worth adding to the alpha4 release
notes.
Seems that support LIKE and ILIKE index searches via contrib/pg_trgm
On Sun, Mar 6, 2011 at 5:26 PM, Simon Riggs si...@2ndquadrant.com wrote:
On Sun, 2011-03-06 at 16:58 +0900, Fujii Masao wrote:
On Sun, Mar 6, 2011 at 4:51 PM, Fujii Masao masao.fu...@gmail.com wrote:
One comment; what about introducing built-in function to wake up all the
waiting backends?
On Sun, Mar 6, 2011 at 5:02 PM, Yeb Havinga yebhavi...@gmail.com wrote:
On Sun, Mar 6, 2011 at 8:58 AM, Fujii Masao masao.fu...@gmail.com wrote:
If unfortunately all connection slots are used by backends waiting for
replication, we cannot execute such a function. So it makes more sense
to
El 06/03/2011 03:26, Simon Riggs si...@2ndquadrant.com escribió:
On Sun, 2011-03-06 at 16:58 +0900, Fujii Masao wrote:
If unfortunately all connection slots are used by backends waiting for
replication, we cannot execute such a function. So it makes more sense
to introduce something like
Andres Freund and...@anarazel.de writes:
Ah. Finally after trying to stare down the code for some more time the issue
is pretty simple.
-
fmgr_info_collation(irel-rd_index-indcollation.values[attnum-1],
+ fmgr_info_collation(irel-rd_indcollation[attnum-1],
Good
Andres Freund and...@anarazel.de writes:
-
fmgr_info_collation(irel-rd_index-indcollation.values[attnum-1],
+ fmgr_info_collation(irel-rd_indcollation[attnum-1],
locinfo);
BTW, I went ahead and committed this part,
Hi!
If all things go according to plans, we will be moving the VM that
runs commitfest.postgresql.org to new hw+platform tomorrow, in the AM
European time. Expected downtime is just a couple of minutes, and I
will leave the old server still responding but in read-only mode.
Thus, if you get a
On Mar 6, 2011, at 9:44 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Sun, Mar 6, 2011 at 5:02 PM, Yeb Havinga yebhavi...@gmail.com wrote:
On Sun, Mar 6, 2011 at 8:58 AM, Fujii Masao masao.fu...@gmail.com wrote:
If unfortunately all connection slots are used by backends waiting for
On Mar 5, 2011, at 10:14 AM, Magnus Hagander mag...@hagander.net wrote:
Should we perhaps add a replication line to the default hba file, the
same way we have for regular connections? IIRC we discussed that as a
sub-sub-sub-point in some previous thread, but never mad a decision...
Not sure
On ons, 2011-03-02 at 16:00 -0500, Tom Lane wrote:
That seems like a 100% arbitrary distinction between base types and
domains, to the detriment of base types, which is odd since in most
other ways base types are much more flexible than domains.
Well, base types don't support check constraints
On Sun, 2011-03-06 at 16:51 +0900, Fujii Masao wrote:
One comment; what about introducing built-in function to wake up all the
waiting backends? When replication connection is closed, if we STONITH
the standby, we can safely (for not physical data loss but logical one)
switch the primary to
Magnus Hagander wrote:
I was reading through ref/set_transaction.sgml and noticed that the
only documentation of DEFERRABLE is that it's a PostgreSQL language
extension, not anything about what it actually does. Same for begin
and start_transaction. I see it described in README-SSI and for
On Fri, 2011-03-04 at 16:57 +0900, Fujii Masao wrote:
On Wed, Mar 2, 2011 at 11:30 PM, Fujii Masao masao.fu...@gmail.com wrote:
On Wed, Mar 2, 2011 at 8:22 PM, Simon Riggs si...@2ndquadrant.com wrote:
The WALSender deliberately does *not* wake waiting users if the standby
disconnects.
On Sun, 2011-03-06 at 18:09 -0500, Andrew Dunstan wrote:
On 03/06/2011 05:51 PM, Simon Riggs wrote:
Efficient transaction-controlled synchronous replication.
I'm glad this is in, but I thought we agreed NOT to call it synchronous
replication.
The discussion on the thread was that its
On Sat, 2011-03-05 at 21:11 +0100, Yeb Havinga wrote:
I also got a first first 1000 tps score
The committed version should be even faster. Would appreciate a retest.
--
Simon Riggs http://www.2ndQuadrant.com/books/
PostgreSQL Development, 24x7 Support, Training and Services
Hi all,
I want to construct an Composite Index Structure i.e. a combination of
gist and btree.
What i am thinking is that first creating a Rtree structure that is pointing
to another Btree structure.
For example, Suppose i want to find vehicles between 2 to 4 pm on 14/2/2011
on X road.
I am
On 07.03.2011 08:07, Nick Raj wrote:
I want to construct an Composite Index Structure i.e. a combination of
gist and btree.
What i am thinking is that first creating a Rtree structure that is pointing
to another Btree structure.
For example, Suppose i want to find vehicles between 2 to 4 pm on
On 07.03.2011 01:28, Simon Riggs wrote:
On Sun, 2011-03-06 at 18:09 -0500, Andrew Dunstan wrote:
On 03/06/2011 05:51 PM, Simon Riggs wrote:
Efficient transaction-controlled synchronous replication.
I'm glad this is in, but I thought we agreed NOT to call it synchronous
replication.
The
On Mon, 2011-03-07 at 09:29 +0200, Heikki Linnakangas wrote:
I presume you didn't make allow_synchronous_standby=off the default
behavior.
You presume incorrectly.
--
Simon Riggs http://www.2ndQuadrant.com/books/
PostgreSQL Development, 24x7 Support, Training and Services
On 05.03.2011 20:09, Heikki Linnakangas wrote:
So the number of lines has roughly doubled since, and about a quarter
of the 7.3 lines have changed.
Heikki,
Yeah.
Additionally, German language vocabulary changed in computer area.
E.g. today download is an official German word - ten years
On 07.03.2011 09:48, Simon Riggs wrote:
On Mon, 2011-03-07 at 09:29 +0200, Heikki Linnakangas wrote:
I presume you didn't make allow_synchronous_standby=off the default
behavior.
Sorry, s/allow_synchronous_standby/allow_standalone_master
You presume incorrectly.
Ok, ok then. Thank you!
30 matches
Mail list logo
