On Sun, Apr 24, 2016 at 11:21:01AM +0530, Amit Kapila wrote:
> On Sun, Apr 24, 2016 at 9:28 AM, Bruce Momjian wrote:
> >
> > Why is the parallelism variable called "max_parallel_degree"? Is that a
> > descriptive name? What does "degree" mean?
>
> It is to denote amount of
I noticed that even when they are successful, buildfarm members bowerbird
and jacana tend to spew a lot of messages like this in their bin-check
steps:
Can't remove directory
/home/pgrunner/bf/root/HEAD/pgsql.build/src/bin/scripts/tmp_check/data_main_DdUf/pgdata/global:
Directory not empty at
On Thu, Apr 21, 2016 at 9:47 PM, Kyotaro HORIGUCHI
wrote:
> A lock was already held in BackendPidGetProc(). Is it also
> needless? If so, we should use BackendPidGetProcWithLock() instad
> (the name seems a bit confusing, though).
Oh, that's really sad. No, that
On Mon, Apr 25, 2016 at 4:11 PM, Fujii Masao wrote:
> On Thu, Apr 21, 2016 at 2:32 AM, Magnus Hagander
> wrote:
> > On Wed, Apr 20, 2016 at 1:12 AM, Fujii Masao
> wrote:
> >>
> >> On Sun, Apr 17, 2016 at 1:22 AM, Magnus
On Mon, Apr 25, 2016 at 12:17:56PM +0200, Magnus Hagander wrote:
>
>
> On Mon, Apr 25, 2016 at 5:01 AM, Robert Haas wrote:
>
> On Sun, Apr 24, 2016 at 2:42 PM, Tom Lane wrote:
> > Magnus Hagander writes:
> >> On Sun,
Greetings,
I'm working through the code coverage challenges for pg_dump and thought
I'd take on an easy one- pg_backup_tar.c. Unfortunately, that turned
out to be not quite so simple as I had hoped.
As far as I can see, pg_dump's tar format doesn't support either writing
out or reading in
On Thu, Apr 21, 2016 at 2:32 AM, Magnus Hagander wrote:
> On Wed, Apr 20, 2016 at 1:12 AM, Fujii Masao wrote:
>>
>> On Sun, Apr 17, 2016 at 1:22 AM, Magnus Hagander
>> wrote:
>> > On Wed, Apr 13, 2016 at 4:07 AM, Noah Misch
I wrote:
> Michael Paquier writes:
>> Not worse, and still not enough... bowerbird complained again:
>> http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=bowerbird=2016-04-25%2002%3A13%3A54
> That's a different symptom that seems unrelated:
> cannot remove
On 04/25/2016 07:08 AM, Bruce Momjian wrote:
On Sun, Apr 24, 2016 at 11:21:01AM +0530, Amit Kapila wrote:
On Sun, Apr 24, 2016 at 9:28 AM, Bruce Momjian wrote:
Why is the parallelism variable called "max_parallel_degree"? Is that a
descriptive name? What does "degree"
On 4/24/16 11:49 AM, Stephen Frost wrote:
> * Magnus Hagander (mag...@hagander.net) wrote:
>> On Sun, Apr 24, 2016 at 5:37 AM, Bruce Momjian wrote:
>>
>>> On Fri, Apr 22, 2016 at 11:53:46AM -0400, Robert Haas wrote:
>>>
Frankly, I think that's right. It is one thing to say
* Magnus Hagander wrote:
On Sun, Apr 24, 2016 at 9:56 PM, Christian Ullrich
wrote:
* Magnus Hagander wrote:
Add putenv support for msvcrt from Visual Studio 2013
http://git.postgresql.org/pg/commitdiff/9f633b404cb3be6139f8dfdea00538489ffef9ab
Just noticed something.
On Sat, Apr 23, 2016 at 5:20 PM, Bruce Momjian wrote:
> On Sat, Apr 23, 2016 at 12:48:08PM +0530, Amit Kapila wrote:
> > On Sat, Apr 23, 2016 at 8:34 AM, Bruce Momjian wrote:
> > >
> > > I kind of agreed with Tom about just aborting transactions that held
> >
On Mon, Apr 25, 2016 at 6:04 PM, Alexander Korotkov <
a.korot...@postgrespro.ru> wrote:
> On Sun, Apr 17, 2016 at 7:32 PM, Amit Kapila
> wrote:
>
>> On Thu, Apr 14, 2016 at 8:05 AM, Andres Freund
>> wrote:
>> >
>> > On 2016-04-14 07:59:07 +0530, Amit
On Thu, Dec 25, 2014 at 11:49 AM, Andres Freund wrote:
> Convert the PGPROC->lwWaitLink list into a dlist instead of open coding it.
>
> Besides being shorter and much easier to read it changes the logic in
> LWLockRelease() to release all shared lockers when waking up any.
On Mon, Apr 25, 2016 at 2:58 PM, Alvaro Herrera
wrote:
> Tom Lane wrote:
>> Magnus Hagander writes:
>> > On Sun, Apr 24, 2016 at 8:23 PM, Tom Lane wrote:
>> >> FWIW, I agree with Bruce that using "degree" here is a poor choice.
Robert Haas writes:
>> What about calling it something even simpler, such as "max_parallelism"?
>> This avoids such cargo cult, and there's no implication that it's
>> per-query.
> So what would we call the "parallel_degree" member of the Path data
> structure, and the
On Mon, Apr 25, 2016 at 2:05 PM, Andres Freund wrote:
> Well, I posted a patch. I'd have applied it too (after addressing your
> comments obviously), except that there's some interdependencies with the
> nsmg > 0 thread (some of my tests fail spuriously without that
> fixed).
Hi,
On 2016-04-25 12:38:36 -0400, Robert Haas wrote:
> I think that the point of my message is exactly what I said in my
> message. This isn't really about the last couple of days. The issue
> was reported on March 20th. On March 31st, Noah asked you for a plan
> to get it fixed by April 7th.
On Mon, Apr 25, 2016 at 11:27 AM, Joshua D. Drake
wrote:
> max_parallel_nodes
I hope you are trolling me. It does not bound the maximum number of
parallel nodes, but rather the maximum number of workers per parallel
node. In most cases, a query is only going to have
On 2016-04-24 22:10:19 +0100, Simon Riggs wrote:
> On 18 April 2016 at 13:15, Simon Riggs wrote:
> > (non-reply just because of travel)
> >
> > OK, I'll write up a patch today to fix, with a view to backpatching.
> >
>
> Patch from Tuesday. On various planes.
I posted a
On Mon, Apr 25, 2016 at 9:11 AM, Fujii Masao wrote:
> PostgreSQL resource agent for Pacemaker removes backup_label in
> the case of failover to prevent the standby server from failing
> to recover from the crash.
Yikes! I hope that the providers of Pacemaker document
On Mon, Apr 25, 2016 at 11:56 AM, Andres Freund wrote:
> On 2016-04-25 08:55:54 -0400, Robert Haas wrote:
>> Andres, this issue has now been open for more than a month, which is
>> frankly kind of ridiculous given the schedule we're trying to hit for
>> beta. Do you think
On Mon, Apr 25, 2016 at 6:29 AM, Magnus Hagander wrote:
> guc.c might be better to just stick to alphabetical per group. (Which we
> also don't do today, of course, but it could be a better way to do it there)
For myself, I would rather have guc.c in the order that it's in.
Good summary. Is there a TODO item here?
---
On Tue, Mar 15, 2016 at 08:17:07PM -0400, Tom Lane wrote:
> Pavel Stehule writes:
> >> Robert Haas writes:
> >>> That's not a
On Fri, Apr 22, 2016 at 10:11 PM, David Rowley
wrote:
> The most basic thing I can think of to rationalise my thinking for this is:
>
> # create table v (v varchar);
> # create view v_v as select lower(v) v from v;
> # explain verbose select upper(v) from v_v;
>
On Mon, Apr 25, 2016 at 9:57 AM, Robert Haas wrote:
> For myself, I would rather have guc.c in the order that it's in.
> Related options tend to be next to each other, and being able to look
> up and down to see that they are all consistent has value for me.
+1
The GUC
Shay Rojansky writes:
>> Issuing bulk cancellations sounds like a bad plan.
> I'm not sure why, but at the very least it's a useful thing to have when
> batching several statements together and then wanting to cancel them all.
We really do need "cancel up to" semantics for
Shay Rojansky wrote:
> BTW it seems it's no longer possible for anyone to add things to the TODO
> (no editor privileges).
You need to ask for editor privs on pgsql-www. Make sure to mention
your community user name.
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL
Dean, Robert,
Afaics the problem described below was introduced in b4e07417, do you
have a different/better proposal than
s/CacheInvalidateSmgr/CacheInvalidateRelcache/? Doing that doesn't feel
quite right either, because it only makes the file extension visible at
end-of-xact - which is mostly
On 2016-04-25 08:55:54 -0400, Robert Haas wrote:
> Andres, this issue has now been open for more than a month, which is
> frankly kind of ridiculous given the schedule we're trying to hit for
> beta. Do you think it's possible to commit something RSN without
> compromising the quality of
>
> I definitely agree that simply tracking message sequence numbers on both
>> sides is better. It's also a powerful feature to be able to cancel all
>> messages "up to N" - I'm thinking of a scenario where, for example, many
>> simple queries are sent and the whole process needs to be cancelled.
On 2016-04-23 21:54:07 -0400, Noah Misch wrote:
> I missed a second synchronization bug in generic-xlc.h, but the pgbench test
> suite caught it promptly after commit 008608b.
Nice catch.
> The bug is that the pg_atomic_compare_exchange_*() specifications
> grant "full barrier semantics", but
Hello Andres,
Fixes it for me too.
Yep, for me too.
I'm not at ease with the part of the API the code is dealing with, so I do
not feel like a competent reviewer. I agree with the "more comments"
suggested by Robert.
I have just a small naming point:
/* ereport if segment not
On 04/25/2016 09:04 AM, Robert Haas wrote:
On Mon, Apr 25, 2016 at 11:27 AM, Joshua D. Drake
wrote:
max_parallel_nodes
I hope you are trolling me.
Actually I wasn't. It is usually a little more obvious when I troll,
subtlety is not exactly my strong suit ;)
The
Tom Lane wrote:
> Magnus Hagander writes:
> > On Sun, Apr 24, 2016 at 8:23 PM, Tom Lane wrote:
> >> FWIW, I agree with Bruce that using "degree" here is a poor choice.
> >> It's an unnecessary dependence on technical terminology that many people
> >> will
Is there a function or view that could return a measurable replication lag of
Pglogical ?
Thanks
Yun
I wrote:
> If that is the answer, then the next question is how we can put more
> roadblocks in the way of compile-time evaluation of asin(0.5). Dean
> suggested that creative use of "volatile" might do it, and I agree
> that that sounds like a promising thing to pursue.
It occurred to me that
On 04/25/2016 09:27 AM, Christian Ullrich wrote:
* Magnus Hagander wrote:
On Sun, Apr 24, 2016 at 9:56 PM, Christian Ullrich
wrote:
* Magnus Hagander wrote:
Add putenv support for msvcrt from Visual Studio 2013
Robert, all,
[... comments elsewhere made me realize I hadn't actually sent this when
I thought I had, my apologies on that ...]
* Robert Haas (robertmh...@gmail.com) wrote:
> Great. But there's no particular use case served by a lot of things
> which are natural outgrowths of the rest of the
On Sun, Apr 24, 2016 at 9:27 PM, Stephen Frost wrote:
> * Andrew Dunstan (and...@dunslane.net) wrote:
> > On 04/24/2016 06:02 PM, Sehrope Sarkuni wrote:
> > >AFAIK, there's also no guarantee on the specific order of the
> > >resulting properties in the text representation
On Fri, Apr 8, 2016 at 11:43 AM, Peter Geoghegan wrote:
> I'll do so soon. I was waiting on Peter E to take me up on the offer.
Attached is a series of patches for each supported release branch. As
discussed, I would like to target every released version of Postgres
with this
On Thu, Mar 10, 2016 at 11:48:41AM -0500, Tom Lane wrote:
> Robert Haas writes:
> > Hmm. The meaning of funcs.inline depends on the search_path, not just
> > during dump restoration but all the time. So anything uses it under a
> > different search_path setting than the
Peter Eisentraut writes:
> On 04/25/2016 03:09 PM, Tom Lane wrote:
>> I'm going to go ahead and push this, because it seems clearly more robust
>> than what we have. But I'd appreciate a report on whether it fixes your
>> issue.
> 6b1a213bbd6599228b2b67f7552ff7cc378797bf did
Hello, thank you for understanding.
At Mon, 25 Apr 2016 10:26:49 -0400, Robert Haas wrote
in
> On Thu, Apr 21, 2016 at 9:47 PM, Kyotaro HORIGUCHI
> wrote:
> > A lock was
Hi,
for performance reasons it's a good idea to use the binary protocol. But
doing so between two postgres installations is made unnecessarily hard
by the choice of embedding and verifying oids in composite and array
types. When using extensions, even commonly used ones like hstore, the
datatype
On 04/17/2016 09:28 PM, Bill Moran wrote:
If you have a single line in the pg_hba.conf:
hostssl all all 0.0.0.0/0 md5
Attempting to log in with an incorrect password results in an
error message about there not being a pg_hba.conf entry for the
user.
Reading carefully, the error message states
On Tue, Apr 26, 2016 at 1:13 AM, Andres Freund wrote:
> I think my approach of a separate record is going to be easier to
> backpatch - the new commit record format you took advantage of is
> new.
Sorry for the late reply.
After reading both patches yesterday, I found your
On 04/21/2016 08:18 PM, Tom Lane wrote:
> Hm. This seems to prove that we're not getting exactly 1.0 from
> (asin(x) / asin_0_5) with x = 0.5, but I'm having a hard time guessing
> why that might be so when all the other cases work.
>
> Could you send along the assembler code generated by the
I'm looking at buildfarm member tern's recent failure:
http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=tern=2016-04-25%2001%3A08%3A08
The perl script thinks it's started the postmaster and sent a promote
signal, then it's waited 90 seconds for the postmaster to come out of
standby:
###
* Andrew Dunstan wrote:
On 04/25/2016 09:27 AM, Christian Ullrich wrote:
* Magnus Hagander wrote:
On Sun, Apr 24, 2016 at 9:56 PM, Christian Ullrich
wrote:
Just noticed something. This DLL detection by name has never worked in
debug builds where the DLL names end in
>
> We really do need "cancel up to" semantics for reliable behavior.
> Consider the case where the client has sent the query (or thinks it has)
> but the server hasn't received it yet. If the cancel request can arrive
> at the server before the query fully arrives, and we don't have "cancel
>
On 26/04/16 06:38, Joshua D. Drake wrote:
On 04/25/2016 09:04 AM, Robert Haas wrote:
On Mon, Apr 25, 2016 at 11:27 AM, Joshua D. Drake
wrote:
max_parallel_nodes
I hope you are trolling me.
Actually I wasn't. It is usually a little more obvious when I troll,
On Mon, Apr 25, 2016 at 1:24 PM, Tom Lane wrote:
> I think we should rename all of these to something based on the concept of
> "number of worker processes", and adjust the code if necessary to match.
> I think the "degree" terminology is fundamentally tainted by the question
* Christian Ullrich wrote:
* Andrew Dunstan wrote:
What if both are present? Is a release build prevented from loading a
debug dll and vice versa?
Debug and release are simply two separate CRTs. If your process contains
a module that needs the one, and another that needs the other, you
On 04/25/2016 03:09 PM, Tom Lane wrote:
> I'm going to go ahead and push this, because it seems clearly more robust
> than what we have. But I'd appreciate a report on whether it fixes your
> issue.
6b1a213bbd6599228b2b67f7552ff7cc378797bf did not fix it.
Attached is the assembler output (-O0)
On 2016-04-25 16:29:36 -0400, Robert Haas wrote:
> On Mon, Apr 25, 2016 at 2:05 PM, Andres Freund wrote:
> > Well, I posted a patch. I'd have applied it too (after addressing your
> > comments obviously), except that there's some interdependencies with the
> > nsmg > 0 thread
On Mon, Apr 25, 2016 at 1:45 PM, Robert Haas wrote:
>> I think the "degree" terminology is fundamentally tainted by the question
>> of whether or not it counts the leader, and that we will have bugs (or
>> indeed may have them today) caused by getting that wrong.
>
> This
Shay Rojansky writes:
>> We really do need "cancel up to" semantics for reliable behavior.
>> Consider the case where the client has sent the query (or thinks it has)
>> but the server hasn't received it yet. If the cancel request can arrive
>> at the server before the query fully
On Mon, Apr 25, 2016 at 4:24 PM, Tom Lane wrote:
> Robert Haas writes:
>>> What about calling it something even simpler, such as "max_parallelism"?
>>> This avoids such cargo cult, and there's no implication that it's
>>> per-query.
>
>> So what would
On Fri, Apr 22, 2016 at 6:22 PM, Robert Haas wrote:
> On Fri, Apr 22, 2016 at 8:44 AM, Rajkumar Raghuwanshi
> wrote:
> > I observed below in postgres_fdw.
> >
> > Observation: Update a foreign table which is referring to a local
On Mon, Apr 25, 2016 at 4:29 AM, Christian Ullrich wrote:
> Andrew wrote:
>> OK, here's my final version of the patch, which I will apply in 24 hours
> or so unless there is an objection.
Thanks Andrew for the updated patch!
> This one doesn't matter, but just for
On Sat, Apr 23, 2016 at 9:58 AM, Bruce Momjian wrote:
> On Thu, Mar 3, 2016 at 10:31:26AM +0900, Michael Paquier wrote:
>> On Thu, Mar 3, 2016 at 12:47 AM, Alvaro Herrera
>> wrote:
>> > Well, the CopyData message has an Int32 field for the message
On Mon, Apr 25, 2016 at 5:01 AM, Robert Haas wrote:
> On Sun, Apr 24, 2016 at 2:42 PM, Tom Lane wrote:
> > Magnus Hagander writes:
> >> On Sun, Apr 24, 2016 at 8:23 PM, Tom Lane wrote:
> >>> FWIW, I agree with
On Mon, Apr 25, 2016 at 6:57 AM, Fujii Masao wrote:
> On Mon, Apr 25, 2016 at 4:27 AM, Andres Freund wrote:
> > On 2016-04-21 11:20:38 -0700, Andres Freund wrote:
> >> On 2016-04-18 14:33:28 +0900, Fujii Masao wrote:
> >> > On Fri, Apr 15, 2016 at 6:56
On 24 March 2016 at 01:14, Daniel Verite wrote:
>
> It provides a useful mitigation to dump/reload databases having
> rows in the 1GB-2GB range, but it works under these limitations:
>
> - no single field has a text representation exceeding 1GB.
> - no row as text
On Sun, Apr 24, 2016 at 8:58 PM, Andres Freund wrote:
> Hi,
>
> While working on
>
> http://www.postgresql.org/message-id/cabuevezwma9y+bp4fi4fe4hmpfzmjozomulvtbhhpwtcujr...@mail.gmail.com
> I once more taken aback by the total lack of consistency between the
> three files in
On 22 April 2016 at 18:07, Andres Freund wrote:
> On 2016-04-14 11:09:29 +0530, Abhijit Menon-Sen wrote:
>> At 2016-04-12 09:00:57 -0400, robertmh...@gmail.com wrote:
>> >
>> > On Mon, Apr 11, 2016 at 1:17 PM, Andres Freund wrote:
>> > >
>> > > 3) Actually
On Sun, Apr 24, 2016 at 9:56 PM, Christian Ullrich
wrote:
> * Magnus Hagander wrote:
>
> Add putenv support for msvcrt from Visual Studio 2013
>>
>> This was missed when VS 2013 support was added.
>>
>> Michael Paquier
>>
>> Branch
>> --
>> master
>>
>> Details
>>
The function hyperLogLogMerge() is faulty [1]. It has no current
callers, though. I propose that we rip it out, as in the attached
patch.
[1]
http://www.postgresql.org/message-id/CAM3SWZT-i6R9JU5YXa8MJUou2_r3LfGJZpQ9tYa1BYxfkj0=c...@mail.gmail.com
--
Peter Geoghegan
From
I wrote:
> Evidently, asin() is returning an 80-bit result, and that's not
> getting rounded to double width before we divide by asin_0_5.
I found that I could reproduce this type of assembly-code behavior
on dromedary (gcc version 4.2.1) by using -mfpmath=387. That box
doesn't show the visible
On Tue, Apr 26, 2016 at 11:47 AM, Andres Freund wrote:
> Thanks for looking into this.
>
> On 2016-04-26 11:43:06 +0900, Michael Paquier wrote:
>> On Sun, Apr 24, 2016 at 11:51 AM, Andres Freund wrote:
>> > ISTM we should additionally replace the
On Mon, Apr 25, 2016 at 2:54 AM, Ashutosh Bapat
wrote:
> On Fri, Apr 22, 2016 at 6:22 PM, Robert Haas wrote:
>> On Fri, Apr 22, 2016 at 8:44 AM, Rajkumar Raghuwanshi
>> wrote:
>> > I observed below in
On Tue, Apr 26, 2016 at 9:37 AM, Peter Geoghegan wrote:
> Only the 9.5 backpatch was a simple, conflict-free "git cherry-pick".
> Most of the effort here involved producing a clean 9.4 patch. This was
> largely mechanical, if a little tricky. In release branches for
> releases
Hi,
Thanks for looking into this.
On 2016-04-26 11:43:06 +0900, Michael Paquier wrote:
> On Sun, Apr 24, 2016 at 11:51 AM, Andres Freund wrote:
> > ISTM we should additionally replace the CacheInvalidateSmgr() with a
> > CacheInvalidateRelcache() and document that that
On Tue, Apr 26, 2016 at 12:39 PM, Michael Paquier
wrote:
> On Tue, Apr 26, 2016 at 11:47 AM, Andres Freund wrote:
>> Thanks for looking into this.
>>
>> On 2016-04-26 11:43:06 +0900, Michael Paquier wrote:
>>> On Sun, Apr 24, 2016 at 11:51 AM,
Hi,
At Fri, 22 Apr 2016 17:27:07 +0900, Amit Langote
wrote in <5719e05b.4030...@lab.ntt.co.jp>
>
> Horiguchi-san,
>
> On 2016/04/22 14:21, Kyotaro HORIGUCHI wrote:
> > I came to think that both of you are misunderstanding how
> > synchronous standbys are
At Sat, 23 Apr 2016 10:12:03 -0400, Tom Lane wrote in
<476.1461420...@sss.pgh.pa.us>
> Amit Kapila writes:
> > The main point for this improvement is that the handling for guc s_s_names
> > is not similar to what we do for other somewhat similar
Andreas Karlsson writes:
> On 04/17/2016 09:28 PM, Bill Moran wrote:
>> What I believe is happening, is that the pg connection libs
>> first try to connect via ssl and get a password failed error,
>> then fallback to trying to connect without ssl, and get a "no
>> pg_hba.conf
On 2016-04-26 12:39:37 +0900, Michael Paquier wrote:
> Thinking about the logging of smgr invalidations, this is quite
> interesting. But what would we actually gain in doing that? Do you
> foresee any advantages in doing so? The only case where this would be
> useful now is for vm_extend by
On Mon, Apr 25, 2016 at 6:44 PM, Michael Paquier
wrote:
>> I'm not sure if project policy around backpatching (that commit
>> messages and so on should match exactly) has anything to say about the
>> case where backpatching follows several weeks after commit to the
>>
On 26 April 2016 at 03:08, Guo, Yun wrote:
> Is there a function or view that could return a measurable replication lag
> of Pglogical ?
>
It's the same as normal streaming replication. Use pg_stat_replication
and/or pg_replication_slots to compare the LSN received by the
On Sun, Apr 24, 2016 at 11:51 AM, Andres Freund wrote:
> Here's a patch doing so. Note that, after putting the record into RM_XACT_ID
> first, I've decided to make it a RM_STANDBY_ID type record. I think it's
> likely that this is going to be needed beyond transaction
Hello, attached is the new version v8.
At Tue, 26 Apr 2016 11:02:25 +0900 (Tokyo Standard Time), Kyotaro HORIGUCHI
wrote in
<20160426.110225.35506931.horiguchi.kyot...@lab.ntt.co.jp>
> At Sat, 23 Apr 2016 10:12:03 -0400, Tom Lane wrote in
* Bruce Momjian (br...@momjian.us) wrote:
> On Thu, Mar 10, 2016 at 11:48:41AM -0500, Tom Lane wrote:
> > Robert Haas writes:
> > > Hmm. The meaning of funcs.inline depends on the search_path, not just
> > > during dump restoration but all the time. So anything uses it
On Tue, Apr 26, 2016 at 9:15 AM, Kyotaro HORIGUCHI <
horiguchi.kyot...@lab.ntt.co.jp> wrote:
> Hello, attached is the new version v8.
>
> At Tue, 26 Apr 2016 11:02:25 +0900 (Tokyo Standard Time), Kyotaro
> HORIGUCHI wrote in <
>
Michael Paquier writes:
> On Mon, Apr 25, 2016 at 11:51 PM, Tom Lane wrote:
>> I believe we can fix this by forcing postmaster shutdown in an END
>> routine instead of a DESTROY routine, and hence propose the attached
>> patch, which does things in
Hi,
In PGSQL-9.6, if we create a function with PARALLEL clause and try
displaying it's definition using "*pg_get_functiondef*" we see that the
PARALLEL keyword used during function creation is missing.
Below are the steps to reproduce:
postgres=# CREATE FUNCTION add(integer, integer) RETURNS
Hello,
At Mon, 25 Apr 2016 17:17:13 -0700, Andres Freund wrote in
<20160426001713.hbqdiwvf4mkzk...@alap3.anarazel.de>
> Hi,
>
> for performance reasons it's a good idea to use the binary protocol. But
> doing so between two postgres installations is made unnecessarily hard
On Mon, Apr 25, 2016 at 11:51 PM, Tom Lane wrote:
> I noticed that even when they are successful, buildfarm members bowerbird
> and jacana tend to spew a lot of messages like this in their bin-check
> steps:
>
> Can't remove directory
>
On 24 April 2016 at 23:11, Tom Lane wrote:
> Have you seen this to be a problem in practice, or is it just
> theoretical? I do not recall many, if any, field complaints
> about the issue.
>
It's caused pain for me when working with JDBC in the past.
If libpq gets
On Sun, Apr 17, 2016 at 7:32 PM, Amit Kapila
wrote:
> On Thu, Apr 14, 2016 at 8:05 AM, Andres Freund wrote:
> >
> > On 2016-04-14 07:59:07 +0530, Amit Kapila wrote:
> > > What you want to see by prewarming?
> >
> > Prewarming appears to greatly
On 18 April 2016 at 22:46, Alvaro Herrera wrote:
> Nothing to do with that. The VACUUM FREEZE is executed on the new
> database before migrating the old data over; it's there so that the
> existing data has no trace of any permanent "normal" Xids from the
> original
On Fri, Apr 22, 2016 at 5:26 PM, Robert Haas wrote:
> On Fri, Apr 22, 2016 at 1:07 PM, Andres Freund wrote:
>> The attached patch basically adds the segment size checks to
>> _mdfd_getseg(), and doesn't perform extension, even in recovery, if
>>
On 25 April 2016 at 03:44, Robert Haas wrote:
> On Sun, Apr 24, 2016 at 2:23 PM, Tom Lane wrote:
>> FWIW, I agree with Bruce that using "degree" here is a poor choice.
>> It's an unnecessary dependence on technical terminology that many people
>> will
On Sun, Apr 24, 2016 at 9:58 PM, Andres Freund wrote:
> While working on
>
> http://www.postgresql.org/message-id/cabuevezwma9y+bp4fi4fe4hmpfzmjozomulvtbhhpwtcujr...@mail.gmail.com
> I once more taken aback by the total lack of consistency between the
> three files in
On 24 April 2016 at 23:49, Stephen Frost wrote:
>
> Fixing that means using something more complicated than the old method
> and that's a bit of a pain in psql, but that doesn't mean we should tell
> people that the old method is an acceptable approach.
>
+1
Frankly, I
96 matches
Mail list logo