Re: [HACKERS] pgbench: new feature allowing to launch shell commands

2009-12-02 Thread Michael Paquier
, Michael Paquier NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center pgbenchshell2.1.patch Description: Binary data pgbenchstats.tar.gz Description: GNU Zip compressed data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] pgbench: new feature allowing to launch shell commands

2009-12-03 Thread Michael Paquier
I didn't send the good patch yesterday. = --; Here is the latest version. Regards, -- Michael Paquier NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center diff --git a/contrib/pgbench/pgbench.c b/contrib/pgbench/pgbench.c index 8a6437f..0bc6bfe 100644 --- a/contrib/pgbench

Re: [HACKERS] pgbench: new feature allowing to launch shell commands

2009-12-06 Thread Michael Paquier
-- Michael Paquier NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center diff --git a/contrib/pgbench/pgbench.c b/contrib/pgbench/pgbench.c index 8a6437f..9c33f7e 100644 --- a/contrib/pgbench/pgbench.c +++ b/contrib/pgbench/pgbench.c @@ -159,6 +159,7 @@ typedef struct } Variable

Re: [HACKERS] pgbench: new feature allowing to launch shell commands

2009-12-06 Thread Michael Paquier
The threading bug appears when a duration is set for pgbench tests. Instead of a duration, if a number of xacts is set, this error doesn't happen. If i understood the problem well, when the alarm signal comes, all the threads have to disconnect even the ones looking for a setshell parameter at

Re: [HACKERS] pgbench: new feature allowing to launch shell commands

2009-12-06 Thread Michael Paquier
Please find attached the latest version of the patch, with the threading bug corrected and the documentation updated as well. The origin of the bug was the alarm signal. Once the duration is over, all the threads have to finish and timer_exceeded is set at true. A control on this variable in

Re: [HACKERS] pgbench: new feature allowing to launch shell commands

2009-12-14 Thread Michael Paquier
. If nobody is against it, I will mark it as ready to commit. -- Regards, Michael Paquier NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center diff --git a/contrib/pgbench/pgbench.c b/contrib/pgbench/pgbench.c index 8a6437f..a5b8aeb 100644 --- a/contrib/pgbench/pgbench.c +++ b

Re: [HACKERS] 8.5 vs. 9.0

2010-01-21 Thread Michael Paquier
On Fri, Jan 22, 2010 at 12:29 AM, Andrew Chernow a...@esilo.com wrote: 9.0. You don't have a code-name. All the cool kids have code-names for their projects. Black Dog yup, I'm a zeppelin fan :) +1 :) -- Regards, Michael Paquier NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open

[HACKERS] [PATCH] pgbench: new feature allowing to launch shell commands

2009-08-06 Thread Michael Paquier
in the code that permits to launch a 2PC transaction with a random prepare identifier of the format Txxx. I also created a page in postgresql's wiki about this feature. Please refer to this link: http://wiki.postgresql.org/wiki/Pgbench:_shell_command Regards, -- Michael Paquier NTT OSSC

Re: [HACKERS] [PATCH] pgbench: new feature allowing to launch shell commands

2009-08-06 Thread Michael Paquier
Sorry I forgot to attach the the patch. Regards, Michael On Fri, Aug 7, 2009 at 12:23 PM, Michael Paquier michael.paqu...@gmail.comwrote: Hi all, Here is a short patch implementing a new feature in pgbench so as to allow shell commands to be launched in a transaction file of pgbench

Re: [HACKERS] [PATCH] pgbench: new feature allowing to launch shell commands

2009-08-06 Thread Michael Paquier
:55 PM, Itagaki Takahiro itagaki.takah...@oss.ntt.co.jp wrote: Michael Paquier michael.paqu...@gmail.com wrote: Here is a short patch implementing a new feature in pgbench so as to allow shell commands to be launched in a transaction file of pgbench. \shell ls ~/pg_twophase; +1

Re: [HACKERS] [PATCH] 2PC state files on shared memory

2009-08-09 Thread Michael Paquier
been decided by the user, it will be written to disk instead of shared memory. So it will not represent a danger for teh stability of the system. The case of too many prepared transactions is also covered thanks to max_prepared_transactions. Regards, -- Michael Paquier NTT OSSC

Re: [HACKERS] [PATCH] pgbench: new feature allowing to launch shell commands

2009-08-12 Thread Michael Paquier
Thanks a lot for all of your pieces of advice. I modified the name of the page as well as I deleted the parts linked to the -P option. It just consisted in deleting the right parts. Here is the lighted version. -- Michael Paquier NTT OSSC postgresql-8.4.0-pgbenchshell2.0.patch Description

Re: [HACKERS] [PATCH] pgbench: new feature allowing to launch shell commands

2009-09-16 Thread Michael Paquier
Hi all, Sorry for my late reply. There is no other update for this patch since the 13th of August, at least until today. The new patch is attached By the way I worked on the comments that Dan and Gabriel pointed out. I added a check on system such as to prevent an error from this side. By the

Re: [HACKERS] [PATCH] pgbench: new feature allowing to launch shell commands

2009-09-18 Thread Michael Paquier
you used to run it? Of course, here it is the list of commands I use: pgbench -i dbname (in case your database is called dbname) pgbench -c 10 -t 10 -f transaction_file_name.data dbname (customer and transaction numbers can also bet set as you want). Regards, -- Michael Paquier NTT OSSC

Re: [HACKERS] [PATCH] pgbench: new feature allowing to launch shell commands

2009-09-21 Thread Michael Paquier
Hi, Sorry for my late reply again :o) You will find my answers on-the-line. You really should be returning a value at the point since the function signature defines a return type. If not the function should be void, which it cannot be in this context since it is used for boolean tests

Re: [HACKERS] [PATCH] pgbench: new feature allowing to launch shell commands

2009-09-22 Thread Michael Paquier
...@gregsmith.com wrote: On Tue, 22 Sep 2009, Michael Paquier wrote: Besides, you can also make tests without 2pc transactions, such as: \shell ls -ll /home/ioltas/usr/pgsql/data END; I think that demonstrating the pgbench shell feature with this 2PC example is working against your patch being

Re: [HACKERS] [PATCH] pgbench: new feature allowing to launch shell commands

2009-10-26 Thread Michael Paquier
, but also why not thinking about other statistical distributions? a Gaussian or a Poisson distribution? There are many possibilities. Regards, -- Michael Paquier NTT OSSC pgbenchsetshell.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

[HACKERS] current value support

2010-06-02 Thread Michael Paquier
Hi all, Please see attached a patch that finishes the support for currval. All the structure was in place in GTM but there was still one missing call in sequence.c when calling the function. Now it is possible to get current values for sequences in the whole cluster. Regards, -- Michael

Re: [HACKERS] current value support

2010-06-02 Thread Michael Paquier
Sorry about my previous email, I sent a patch to the wrong mailing list. Once again my apologies about that. Regards, Michael P.

[HACKERS] Re: [pgsql-cluster-hackers] 3rd Cluster Hackers Summit, May 15th in Ottawa

2012-02-28 Thread Michael Paquier
Hi Josh, Second, please RSVP! At this point I've heard from a total of 3 people. I need to know who/how many are coming so that I can book the space, and lunch. Sorry for my late reply. I will join the cluster meeting as a member of Postgres-XC. Regards, -- Michael Paquier http

Re: [HACKERS] logical changeset generation v3

2012-11-14 Thread Michael Paquier
Looks like cool stuff @-@ I might be interested in looking at that a bit as I think I will hopefully be hopefully be able to grab some time in the next couple of weeks. Are some of those patches already submitted to a CF? -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] feature proposal - triggers by semantics

2012-11-15 Thread Michael Paquier
that and avoid reinventing the wheel? -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] [WIP] pg_ping utility

2012-11-15 Thread Michael Paquier
input here? 5) You should not use comments like that: /* Return UNKNOWN*/ Please add a space at the end of comment for clarity like this: /* Return UNKNOWN */ 6) Please use exit(1) instead of exit(3) like the other script utilities. Thanks, -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] feature proposal - triggers by semantics

2012-11-15 Thread Michael Paquier
that I think would work better for you, too. Namely, to have access to OLD and NEW in FOR EACH STATEMENT triggers, where they would be relations rather than records. +1 -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] [WIP] pg_ping utility

2012-11-15 Thread Michael Paquier
On Fri, Nov 16, 2012 at 12:34 PM, Phil Sorber p...@omniti.com wrote: Thanks for the review. On Thu, Nov 15, 2012 at 9:23 PM, Michael Paquier michael.paqu...@gmail.com wrote: Hi Phil, I am currently looking at your patch. A lot of people already had a look at at, but I hope I

Re: [HACKERS] logical changeset generation v3

2012-11-15 Thread Michael Paquier
, November 15, 2012 05:08:26 AM Michael Paquier wrote: Looks like cool stuff @-@ I might be interested in looking at that a bit as I think I will hopefully be hopefully be able to grab some time in the next couple of weeks. Are some of those patches already submitted to a CF? I added

Re: [HACKERS] [PATCH 05/14] Add a new relmapper.c function RelationMapFilenodeToOid that acts as a reverse of RelationMapOidToFilenode

2012-11-15 Thread Michael Paquier
(pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] [PATCH 05/14] Add a new relmapper.c function RelationMapFilenodeToOid that acts as a reverse of RelationMapOidToFilenode

2012-11-17 Thread Michael Paquier
On Fri, Nov 16, 2012 at 7:58 PM, Andres Freund and...@2ndquadrant.comwrote: Hi, On 2012-11-16 13:44:45 +0900, Michael Paquier wrote: This patch looks OK. I got 3 comments: 1) Why changing the OID of pg_class_tblspc_relfilenode_index from 3171 to 3455? It does not look necessary

Re: [HACKERS] logical changeset generation v3

2012-11-18 Thread Michael Paquier
On Fri, Nov 16, 2012 at 5:16 PM, Andrea Suisani sick...@opinioni.netwrote: Il 16/11/2012 05:34, Michael Paquier ha scritto: Do you have a git repository or something where all the 14 patches are applied? I would like to test the feature globally. Sorry I recall that you put a link somewhere

Re: [HACKERS] [WIP] pg_ping utility

2012-11-18 Thread Michael Paquier
On Sat, Nov 17, 2012 at 2:48 AM, Phil Sorber p...@omniti.com wrote: On Thu, Nov 15, 2012 at 10:55 PM, Michael Paquier michael.paqu...@gmail.com wrote: On Fri, Nov 16, 2012 at 12:34 PM, Phil Sorber p...@omniti.com wrote: On Thu, Nov 15, 2012 at 9:23 PM, Michael Paquier michael.paqu

Re: [HACKERS] [WIP] pg_ping utility

2012-11-18 Thread Michael Paquier
. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] [PATCH 13/14] Introduce pg_receivellog, the pg_receivexlog equivalent for logical changes

2012-11-18 Thread Michael Paquier
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Michael Paquier http://michael.otacoo.com 20121119_pg_receivellog_install.patch Description: Binary data -- Sent via pgsql

Re: [HACKERS] logical changeset generation v3

2012-11-18 Thread Michael Paquier
deal, it made the transactions failing though. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] logical changeset generation v3

2012-11-19 Thread Michael Paquier
On Mon, Nov 19, 2012 at 5:50 PM, Andres Freund and...@2ndquadrant.comwrote: Hi Michael, On 2012-11-19 16:28:55 +0900, Michael Paquier wrote: I have been able to fetch your code (thanks Andrea!) and some it. For the time being I am spending some time reading the code and understanding

Re: [HACKERS] logical changeset generation v3

2012-11-20 Thread Michael Paquier
btw. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] logical changeset generation v3

2012-11-20 Thread Michael Paquier
On Tue, Nov 20, 2012 at 8:22 PM, Andres Freund and...@2ndquadrant.comwrote: On 2012-11-20 09:30:40 +0900, Michael Paquier wrote: On Mon, Nov 19, 2012 at 5:50 PM, Andres Freund and...@2ndquadrant.com wrote: On 2012-11-19 16:28:55 +0900, Michael Paquier wrote: I am just looking

Re: [HACKERS] logical changeset generation v3

2012-11-20 Thread Michael Paquier
On Wed, Nov 21, 2012 at 4:31 PM, Andres Freund and...@2ndquadrant.comwrote: On 2012-11-21 14:57:08 +0900, Michael Paquier wrote: On Tue, Nov 20, 2012 at 8:22 PM, Andres Freund and...@2ndquadrant.com wrote: It implies that snapstate-nrrunning has lost touch with reality... Yes, I can

Re: [HACKERS] logical changeset generation v3

2012-11-20 Thread Michael Paquier
On Wed, Nov 21, 2012 at 4:30 PM, Andres Freund and...@2ndquadrant.comwrote: On 2012-11-21 15:28:30 +0900, Michael Paquier wrote: On Tue, Nov 20, 2012 at 8:22 PM, Andres Freund and...@2ndquadrant.com wrote: On 2012-11-20 09:30:40 +0900, Michael Paquier wrote: Btw, here are some extra

Re: [HACKERS] logical changeset generation v3

2012-11-21 Thread Michael Paquier
On Wed, Nov 21, 2012 at 4:34 PM, Andres Freund and...@2ndquadrant.comwrote: On 2012-11-21 14:57:08 +0900, Michael Paquier wrote: Ah, I see. Could you try the following diff? diff --git a/src/backend/replication/logical/snapbuild.c b/src/backend/replication/logical/snapbuild.c index df24b33

Re: [HACKERS] logical changeset generation v3

2012-11-21 Thread Michael Paquier
binary at hand if you want, so can send them at will. I have not been able to read your code yet, but there should be something you are missing. Thanks, -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] [WIP] pg_ping utility

2012-11-23 Thread Michael Paquier
On Sat, Nov 17, 2012 at 2:48 AM, Phil Sorber p...@omniti.com wrote: On Thu, Nov 15, 2012 at 10:55 PM, Michael Paquier michael.paqu...@gmail.com wrote: On Fri, Nov 16, 2012 at 12:34 PM, Phil Sorber p...@omniti.com wrote: On Thu, Nov 15, 2012 at 9:23 PM, Michael Paquier michael.paqu

Re: [HACKERS] [WIP] pg_ping utility

2012-11-25 Thread Michael Paquier
On Mon, Nov 26, 2012 at 11:17 AM, Phil Sorber p...@omniti.com wrote: I am going to be unavailable until Wednesday, so maybe gives us a few more days for feedback. Sure no problem. Thanks. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] [WIP] pg_ping utility

2012-11-26 Thread Michael Paquier
On Tue, Nov 27, 2012 at 12:26 AM, Peter Eisentraut pete...@gmx.net wrote: On 11/23/12 9:48 AM, Michael Paquier wrote: We waited a couple of days for feedback for this feature. So based on all the comments provided by everybody on this thread, perhaps we should move on and implement

Re: [HACKERS] Re: Problem Observed in behavior of Create Index Concurrently and Hot Update

2012-11-26 Thread Michael Paquier
INDEX_IS_IGNORE 'g'. This would avoid the addition of a new column in pg_index and control the status of an index easily. This is not that much backward-compatible though... -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] [WIP] pg_ping utility

2012-11-27 Thread Michael Paquier
to pg_isready? +1, the current version of the patch is already fitted for that and would not need extra options like the number of packages sent. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] pg_basebackup is taking backup of extra files inside a tablespace directory

2012-11-27 Thread Michael Paquier
? -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] Bugs in CREATE/DROP INDEX CONCURRENTLY

2012-11-28 Thread Michael Paquier
to REINDEX only, but other things like CLUSTER, ALTER TABLE and perhaps others. Then once this is done PG will have better prospectives with features using CONCURRENTLY, and we could envisage a clean implementation for REINDEX CONCURRENTLY, Regards, Michael Paquier -- Sent via pgsql-hackers

Re: [HACKERS] Bugs in CREATE/DROP INDEX CONCURRENTLY

2012-11-29 Thread Michael Paquier
(index swapping) is still not done, I am not sure if it is worth to do that yet. Andres, please let me know in case you want a better version for your review. -- Michael Paquier http://michael.otacoo.com

[HACKERS] Forgotten argument description in header of index_create

2012-12-03 Thread Michael Paquier
Hi all, While reading some index-related code, I found that the description of the argument is_internal of index_create in index.c has been forgotten in commit f4c4335. Correction patch attached. Thanks, -- Michael Paquier http://michael.otacoo.com 20121204_index_create_header.patch

Re: [HACKERS] [WIP] pg_ping utility

2012-12-03 Thread Michael Paquier
are fixed, I think this will be ready for committer review as everybody here seem to agree with your approach. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] [WIP] pg_ping utility

2012-12-04 Thread Michael Paquier
On 2012/12/05, at 14:46, Phil Sorber p...@omniti.com wrote: On Mon, Dec 3, 2012 at 11:59 PM, Michael Paquier So I understand what you mean by the ordering might change, but this is actual output from the shell. I'm not sure how to convey that sentiment properly here and still have a real

Re: [HACKERS] [WIP] pg_ping utility

2012-12-06 Thread Michael Paquier
. +1 I'm on board with this. OK. Let's do that and then mark this patch as ready for committer. Thanks, -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] Support for REINDEX CONCURRENTLY

2012-12-08 Thread Michael Paquier
On Fri, Dec 7, 2012 at 10:33 PM, Simon Riggs si...@2ndquadrant.com wrote: On 7 December 2012 12:37, Michael Paquier michael.paqu...@gmail.com wrote: - There is still a problem with toast indexes. If the concurrent reindex of a toast index fails for a reason or another, pg_relation

Re: [HACKERS] Support for REINDEX CONCURRENTLY

2012-12-08 Thread Michael Paquier
On Sat, Dec 8, 2012 at 2:19 AM, Andres Freund and...@2ndquadrant.comwrote: On 2012-12-07 12:01:52 -0500, Tom Lane wrote: Simon Riggs si...@2ndquadrant.com writes: On 7 December 2012 12:37, Michael Paquier michael.paqu...@gmail.com wrote: - There is still a problem with toast indexes

Re: [HACKERS] [WIP] pg_ping utility

2012-12-08 Thread Michael Paquier
On Fri, Dec 7, 2012 at 12:56 PM, Phil Sorber p...@omniti.com wrote: On Thu, Dec 6, 2012 at 8:54 PM, Michael Paquier OK. Let's do that and then mark this patch as ready for committer. Thanks, Those changes have been made. Cool. Thanks. Something I was just thinking about while testing

Re: [HACKERS] Support for REINDEX CONCURRENTLY

2012-12-10 Thread Michael Paquier
-- Michael Paquier http://michael.otacoo.com On 2012/12/10, at 18:28, Simon Riggs si...@2ndquadrant.com wrote: On 10 December 2012 06:03, Michael Paquier michael.paqu...@gmail.com wrote: On 2012-12-08 09:40:43 -0500, Tom Lane wrote: Andres Freund and...@2ndquadrant.com writes: I'm tempted

Re: [HACKERS] Support for REINDEX CONCURRENTLY

2012-12-10 Thread Michael Paquier
of the patch. There should be an elegant way to change the dependencies at the swap phase. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] logical decoding - GetOldestXmin

2012-12-13 Thread Michael Paquier
of NormalTransactionIdPrecedes() was shockingly effective. The two commits coming to my mind are: - ed0b409 (Separate PGPROC into PGPROC and PGXACT) - 0d76b60 (introduction of NormalTransactionIdPrecedes) Those ones really improved concurrency performance. -- Michael Paquier http

Re: [HACKERS] [WIP] pg_ping utility

2012-12-19 Thread Michael Paquier
On Wed, Dec 12, 2012 at 12:06 AM, Bruce Momjian br...@momjian.us wrote: On Sat, Dec 8, 2012 at 08:59:00AM -0500, Phil Sorber wrote: On Sat, Dec 8, 2012 at 7:50 AM, Michael Paquier michael.paqu...@gmail.com wrote: Bruce mentionned that pg_isready could be used directly by pg_ctl -w

Re: [HACKERS] [WIP] pg_ping utility

2012-12-23 Thread Michael Paquier
with the sgml format. Once the 2 small things I noticed are fixed, this patch can be marked as ready for committer. Thanks, -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] [WIP] pg_ping utility

2012-12-24 Thread Michael Paquier
On Mon, Dec 24, 2012 at 12:44 AM, Phil Sorber p...@omniti.com wrote: Updated patch attached. Thanks. I am marking this patch as ready for committer. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] [PATCH 1/2] Provide a common malloc wrappers and palloc et al. emulation for frontend'ish environs

2013-01-09 Thread Michael Paquier
, and in a way that would make the implementation steps clearer than it is now for all the people of this ML. OK this would make the review process longer but the good point is that some hackers who are only specialized in some areas of the PG code would be able to give precious feedback. -- Michael Paquier

Re: [HACKERS] Lock levels for ALTER TABLE

2013-01-09 Thread Michael Paquier
. Docs should be updated in consequence. The 9.1-prior locks can be reenabled by using the flag REDUCED_ALTER_TABLE_LOCK_LEVELS. Perhaps this could also be specified in the docs. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] pg_ctl idempotent option

2013-01-15 Thread Michael Paquier
On Wed, Jan 16, 2013 at 4:29 AM, Bruce Momjian br...@momjian.us wrote: That's Japanese for idempotent. ;-) LOL +1. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] Parallel query execution

2013-01-15 Thread Michael Paquier
, but wouldn't it be the role of the planner to determine if such or such query is worth using parallelism? The executor would then be in charge of actually firing the tasks in parallel that planner has determined necessary to do. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] Parallel query execution

2013-01-15 Thread Michael Paquier
(especially for expression joins, like GIS) parallel data load? :/ -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] Parallel query execution

2013-01-15 Thread Michael Paquier
On Wed, Jan 16, 2013 at 1:32 PM, Bruce Momjian br...@momjian.us wrote: On Wed, Jan 16, 2013 at 01:28:18PM +0900, Michael Paquier wrote: On Wed, Jan 16, 2013 at 1:22 PM, Josh Berkus j...@agliodbs.com wrote: Claudio, Stephen, It really seems like the areas where we could get

Re: [HACKERS] CF3+4

2013-01-16 Thread Michael Paquier
, or people who want to pick up the old patches and resubmit them, will just need to move the items to the 9.4 commit fests once they are officially created. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] Re: Slave enters in recovery and promotes when WAL stream with master is cut + delay master/slave

2013-01-17 Thread Michael Paquier
. That is due to timeline that has not changed on slave2 but better to let you know... The replication delays are still here. -- Michael Paquier http://michael.otacoo.com

[HACKERS] Re: Slave enters in recovery and promotes when WAL stream with master is cut + delay master/slave

2013-01-17 Thread Michael Paquier
notice because I had a testscript inserting stuff continuously and it cause at most lagging by one record... This fix is indeed working. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] dividing privileges for replication role.

2013-01-20 Thread Michael Paquier
its upper cluster node tree and check if there is a master connected. While checking the cluster node tree, you will also need to be aware if a node has already been found when you scanned it to be sure that the same node has not been scanned, what would mean that you are in a cycle. -- Michael

Re: [HACKERS] Request for vote to move forward with recovery.conf overhaul

2013-01-21 Thread Michael Paquier
to know the following: - Simon, are you planning to update this patch? - As we are rushing to finish wrapping up 9.3, do you consider it is too late to begin that? Thanks, -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] Re: Slave enters in recovery and promotes when WAL stream with master is cut + delay master/slave

2013-01-21 Thread Michael Paquier
? -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] Re: Slave enters in recovery and promotes when WAL stream with master is cut + delay master/slave

2013-01-21 Thread Michael Paquier
On Tue, Jan 22, 2013 at 9:06 AM, Michael Paquier michael.paqu...@gmail.comwrote: On Fri, Jan 18, 2013 at 6:20 PM, Heikki Linnakangas hlinnakan...@vmware.com wrote: Hmm, so it's the same issue I thought I fixed yesterday. My patch only fixed it for the case that the timeline switch

Re: [HACKERS] Request for vote to move forward with recovery.conf overhaul

2013-01-21 Thread Michael Paquier
On Tue, Jan 22, 2013 at 9:27 AM, Robert Haas robertmh...@gmail.com wrote: On Mon, Jan 21, 2013 at 6:23 PM, Michael Paquier michael.paqu...@gmail.com wrote: Yes, that is one of the most important patches in the list, and I could put some effort in it for either review or coding. I think

Re: [HACKERS] Event Triggers: adding information

2013-01-22 Thread Michael Paquier
in 9.3. ;) +1 for adding that. I've been wanting it for years. Can we have it back ported to 9.2, please Please, PLEASE!!! New features are not back ported to maintenance branch ;) But... It might be possible to do an exception? -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] Request for vote to move forward with recovery.conf overhaul

2013-01-22 Thread Michael Paquier
On Wed, Jan 23, 2013 at 1:49 PM, Michael Paquier michael.paqu...@gmail.comwrote: I found that support for pg_basebackup -R was in the old patch, and I haven't done anything for that yet. Sorry, I meant that pg_basebackup -R support was NOT in the old patch, and I haven't done anything about

Re: [HACKERS] dividing privileges for replication role.

2013-01-23 Thread Michael Paquier
the cyclic problem? -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] Request for vote to move forward with recovery.conf overhaul

2013-01-23 Thread Michael Paquier
On 2013/01/23, at 18:12, Simon Riggs si...@2ndquadrant.com wrote: On 23 January 2013 04:49, Michael Paquier michael.paqu...@gmail.com wrote: - recovery.conf is removed (no backward compatibility in this version of the patch) If you want to pursue that, you know where it leads

Re: [HACKERS] Support for REINDEX CONCURRENTLY

2013-01-24 Thread Michael Paquier
with something else, like the concurrent Oids, but still even with that the code would be more readable if let as is. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] COPY FREEZE has no warning

2013-01-25 Thread Michael Paquier
the feature. An ERROR would be suited. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] Support for REINDEX CONCURRENTLY

2013-01-26 Thread Michael Paquier
On Sun, Jan 27, 2013 at 1:37 AM, Andres Freund and...@2ndquadrant.comwrote: On 2013-01-25 14:11:39 +0900, Michael Paquier wrote: It sure isn't optimal, but it should do the trick if you use the hash_seq stuff to iterate the hash afterwards. And you could use it to map to the respective locks

Re: [HACKERS] Support for REINDEX CONCURRENTLY

2013-01-26 Thread Michael Paquier
On Sun, Jan 27, 2013 at 1:52 AM, Andres Freund and...@2ndquadrant.comwrote: On 2013-01-25 13:48:50 +0900, Michael Paquier wrote: All the comments are addressed in version 8 attached, except for the hashtable part, which requires some heavy changes. On Thu, Jan 24, 2013 at 3:41 AM, Andres

Re: [HACKERS] Request for vote to move forward with recovery.conf overhaul

2013-01-26 Thread Michael Paquier
On Sun, Jan 27, 2013 at 1:41 PM, Robert Haas robertmh...@gmail.com wrote: On Sat, Jan 26, 2013 at 9:49 PM, Michael Paquier michael.paqu...@gmail.com wrote: On Sun, Jan 27, 2013 at 7:14 AM, Phil Sorber p...@omniti.com wrote: On Wed, Jan 23, 2013 at 6:36 AM, Michael Paquier michael.paqu

Re: [HACKERS] Support for REINDEX CONCURRENTLY

2013-01-28 Thread Michael Paquier
On Mon, Jan 28, 2013 at 7:39 PM, Andres Freund and...@2ndquadrant.comwrote: On 2013-01-27 07:54:43 +0900, Michael Paquier wrote: I think you're misunderstanding how this part works a bit. We don't acquire locks on the table itself, but we get a list of all transactions we would conflict

Re: [HACKERS] Support for REINDEX CONCURRENTLY

2013-01-28 Thread Michael Paquier
the concurrent reindex of a toast index. When server restarts, the toast relation will have an invalid index and this cannot be dropped by an operator via SQL. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] Support for REINDEX CONCURRENTLY

2013-01-28 Thread Michael Paquier
On Mon, Jan 28, 2013 at 8:59 PM, Andres Freund and...@2ndquadrant.comwrote: On 2013-01-28 20:50:21 +0900, Michael Paquier wrote: On Mon, Jan 28, 2013 at 8:44 PM, Andres Freund and...@anarazel.de wrote: Another argument that would be enough for a rejection of this patch

Re: [HACKERS] multi-master pgbench?

2012-08-21 Thread Michael Paquier
the info in a single command? It is of course possible, but command will become easily unreadable, and it might be the cause of many mistakes. However, here are some ideas you might use: 1) pgbench -h host1:port1,host2:port2 ... 2) pgbench -h host1,host2 -p port1:port2 Regards, -- Michael Paquier

[HACKERS] Clean up of postgresql_fdw.c

2012-08-22 Thread Michael Paquier
pgxc_is_expr_shippable that is related to FQS planner. Ashutosh, any thoughts about where to put it? -- Michael Paquier http://michael.otacoo.com 20120823_pgfdw_cleanup.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Clean up of postgresql_fdw.c

2012-08-22 Thread Michael Paquier
Sorry, this was not dedicated to this mailing list. My apologies. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] emacs configuration for new perltidy settings

2012-08-27 Thread Michael Paquier
) (setq perl-brace-imaginary-offset 0) (setq perl-label-offset -2)) (add-hook 'perl-mode-hook (lambda () (if (string-match postgresql buffer-file-name) (pgsql-perl-style Cool thanks! Very helpful. -- Michael Paquier http://michael.otacoo.com

[HACKERS] Some whitespaces in utility.c

2012-09-03 Thread Michael Paquier
Hi all, I found some whitespace characters in utility.c introduced by commit 3a0e4d3. Please find attached a patch fixing that which can be applied on postgres master (commit 2f0c7d5). Thanks, -- Michael Paquier http://michael.otacoo.com 20120906_utility_whitespace.patch Description: Binary

Re: [HACKERS] Some whitespaces in utility.c

2012-09-04 Thread Michael Paquier
On Tue, Sep 4, 2012 at 11:35 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Tue, Sep 4, 2012 at 6:57 AM, Michael Paquier michael.paqu...@gmail.com wrote: I found some whitespace characters in utility.c introduced by commit 3a0e4d3. Please find

[HACKERS] pg_reorg in core?

2012-09-20 Thread Michael Paquier
(tableoid) for a VACUUM FULL reorganization - pg_reorg_table(tableoid, NULL) for a CLUSTER reorganization if table has a CLUSTER key - pg_reorg_table(tableoid, columnname) for a CLUSTER reorganization based on a wanted column. Is it worth the shot? Regards, -- Michael Paquier http

Re: [HACKERS] pg_reorg in core?

2012-09-20 Thread Michael Paquier
On Fri, Sep 21, 2012 at 12:07 PM, Josh Kupershmidt schmi...@gmail.comwrote: On Thu, Sep 20, 2012 at 7:05 PM, Michael Paquier michael.paqu...@gmail.com wrote: Hi all, During the last PGCon, I heard that some community members would be interested in having pg_reorg directly in core. I'm

Re: [HACKERS] pg_reorg in core?

2012-09-21 Thread Michael Paquier
author to keep the ownership. Thanks, I merged your patches with the dev branch for the time being. It would be great to have some input from the maintainers of pg_reorg in pgfoundry to see if they agree about putting it in pgxn. -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] pg_reorg in core?

2012-09-21 Thread Michael Paquier
it be too costly for a core operation as pg_reorg really needs many temporary objects? Could be possible to reduce the number of objects created if added to core though... 2) Do you think the current CLUSTER is enough and are there wishes to implement such an optimization directly in core? -- Michael

Re: [HACKERS] CREATE SCHEMA IF NOT EXISTS

2012-09-21 Thread Michael Paquier
options today.) I had no idea about that functionality. Seems very strange. Isn't it this SQL? CREATE SCHEMA foo CREATE TABLE aa (a int) CREATE TABLE bb (b int); -- Michael Paquier http://michael.otacoo.com

Re: [HACKERS] pg_reorg in core?

2012-09-21 Thread Michael Paquier
On Sat, Sep 22, 2012 at 9:08 AM, sakamoto dsakam...@lolloo.net wrote: (2012/09/21 22:32), Michael Paquier wrote: On Fri, Sep 21, 2012 at 9:33 PM, Daniele Varrazzo daniele.varra...@gmail.com mailto:daniele.varrazzo@**gmail.comdaniele.varra...@gmail.com wrote: On Fri, Sep 21, 2012

Re: [HACKERS] pg_reorg in core?

2012-09-23 Thread Michael Paquier
are looking for here is something that github could perfectly manage. As proposed by Masahiko, a single organization grouping all the tools (one repository per tool) would be enough. Please note that github can also host documentation. Bug tracker would be tool-dedicated in this case. -- Michael Paquier

  1   2   3   4   5   6   7   8   9   10   >