On Mon, Jul 10, 2017 at 3:36 PM, Noah Misch wrote:
> I recommend pushing your patch so the August back-branch releases have it.
> One can see by inspection that your patch has negligible effect on systems
> healthy today. I have a reasonable suspicion it will help some systems. If
> others remai
On 2017/07/10 15:32, Craig Ringer wrote:
> On 8 July 2017 at 00:03, David Fetter wrote:
>
>> On Fri, Jul 07, 2017 at 10:29:26AM +0900, Amit Langote wrote:
>>> Hi Mark,
>>>
>>> On 2017/07/07 9:02, Mark Kirkwood wrote:
I've been trying out the new partitioning in version 10. Firstly, I
>> must
On Mon, Jul 10, 2017 at 12:19 PM, Alik Khilazhev wrote:
> Hello, Fabien!
>
> Your description is not very precise. What version of Postgres is used? If
> there is a decline, compared to which version? Is there a link to these
> results?
>
>
> Benchmark have been done in master v10. I am attaching
On Mon, Jul 10, 2017 at 10:39 AM, Kyotaro HORIGUCHI
wrote:
> At Sat, 8 Jul 2017 16:41:27 +0530, Amit Kapila
> wrote in
>> On Sat, Jul 8, 2017 at 9:08 AM, Robert Haas wrote:
>> > On Fri, Jul 7, 2017 at 11:36 PM, Amit Kapila
>> > wrote:
>> >> I think we should do that as a separate patch (I ca
Hello,
At Thu, 6 Jul 2017 21:05:21 +0530, Ashutosh Bapat
wrote in
> If a partitioned table is proven dummy, set_rel_pathlist() doesn't mark the
> partition relations dummy and thus doesn't set any (dummy) paths in the
> partition relations. The lack of paths in the partitions means that we can
On 06/09/2017 04:26 PM, Robert Haas wrote:
On Fri, Jun 9, 2017 at 6:36 AM, Heikki Linnakangas wrote:
Right. I think it's a usability fail as it is; it certainly fooled me. We
could make the error messages and documentation more clear. But even better
to allow multiple host addresses, so that it
On Thu, Jun 1, 2017 at 6:29 AM, Andres Freund wrote:
> On May 31, 2017 11:28:18 AM PDT, Robert Haas wrote:
>>> On 2017-05-31 13:27:28 -0400, Dilip Kumar wrote:
[ ... various discussion in support of using DHT ... ]
Ok, good.
Here's a new version that introduces a per-session DSM segment to hold
Hi,
At Mon, 10 Jul 2017 14:58:13 +0530, Amit Kapila wrote
in
> On Mon, Jul 10, 2017 at 10:39 AM, Kyotaro HORIGUCHI
> wrote:
> > At Sat, 8 Jul 2017 16:41:27 +0530, Amit Kapila
> > wrote in
> >
> >> On Sat, Jul 8, 2017 at 9:08 AM, Robert Haas wrote:
> >> > On Fri, Jul 7, 2017 at 11:36 PM, A
> "Thomas" == Thomas Munro writes:
Thomas> Here it is. Added to open items.
On it.
--
Andrew (irc:RhodiumToad)
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Mon, Jul 10, 2017 at 6:30 PM, Heikki Linnakangas
wrote:
> Allow multiple hostaddrs to go with multiple hostnames.
>
> Also fix two other issues, while we're at it:
>
> * In error message on connection failure, if multiple network addresses
> were given as the host option, as in "host=127.0.0.1,
> "Andrew" == Andrew Gierth writes:
> "Thomas" == Thomas Munro writes:
Thomas> Here it is. Added to open items.
Andrew> On it.
Committed.
--
Andrew (irc:RhodiumToad)
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
Hello,
2017-07-10 12:30 GMT+03:00 Heikki Linnakangas :
>
>
> I just remembered that this was still pending. I made the documentation
> changes, and committed this patch now.
>
> We're uncomfortably close to wrapping the next beta, later today, but I
> think it's better to get this into the hands o
Hello Alik,
Your description is not very precise. What version of Postgres is used?
If there is a decline, compared to which version? Is there a link to
these results?
Benchmark have been done in master v10. I am attaching image with results:
.
Ok, thanks.
More precision would be helpful,
On Mon, Jul 10, 2017 at 2:59 PM, Kyotaro HORIGUCHI
wrote:
> Hello,
Thanks for the review.
>> If a partitioned table is proven dummy, set_rel_pathlist() doesn't mark the
>> partition relations dummy and thus doesn't set any (dummy) paths in the
>> partition relations. The lack of paths in the par
Hi, all!
It seems to me that we're allocating shared memory for SLRU lwlocks twice,
unless I'm missing something.
SimpleLruShmemSize() calculates total SLRU shared memory size including
lwlocks size.
SimpleLruInit() starts with line
shared = (SlruShared) ShmemInitStruct(name,
On 07/10/2017 01:47 PM, Arthur Zakirov wrote:
Hello,
2017-07-10 12:30 GMT+03:00 Heikki Linnakangas :
I just remembered that this was still pending. I made the documentation
changes, and committed this patch now.
We're uncomfortably close to wrapping the next beta, later today, but I
think it
On 07/03/2017 05:16 PM, Rafael Martinez wrote:
> We have a discussion about this some time ago and we created a wiki page
> where we tried to write down some ideas/proposals and links to threads
> discussing the subject:
>
> https://wiki.postgresql.org/wiki/Pg_dump_improvements
Thanks for this li
On 07/10/2017 01:27 PM, Masahiko Sawada wrote:
This commit seems be cause of the documentation compilation error. I
think is missing.
...
Attached small patch fixes this.
Thanks, committed!
Strangely, it worked on my system, despite that clear mistake. Looks
like the 'osx' tool is more str
On Mon, Jul 10, 2017 at 3:27 PM, Kyotaro HORIGUCHI
wrote:
> Hi,
>
> At Mon, 10 Jul 2017 14:58:13 +0530, Amit Kapila
> wrote in
>
>> I am also not 100% comfortable with adding flush at two new places,
>> but that makes the code for fix simpler and fundamentally there is no
>> problem in doing so
Hello everyone!
There's the second version of my patch for pgbench. Now transactions
with serialization and deadlock failures are rolled back and retried
until they end successfully or their number of attempts reaches maximum.
In details:
- You can set the maximum number of attempts by the ap
Noah Misch writes:
> On Mon, Jun 05, 2017 at 09:56:33AM -0400, Tom Lane wrote:
>> Yeah, being able to reproduce the problem reliably enough to say whether
>> it's fixed or not is definitely the sticking point here. I have some
>> ideas about that: ...
> I tried this procedure without finding a s
On Jul 10, 2017 16:08, "Tom Lane" wrote:
Noah Misch writes:
> On Mon, Jun 05, 2017 at 09:56:33AM -0400, Tom Lane wrote:
>> Yeah, being able to reproduce the problem reliably enough to say whether
>> it's fixed or not is definitely the sticking point here. I have some
>> ideas about that: ...
>
Magnus Hagander writes:
> On Jul 10, 2017 16:08, "Tom Lane" wrote:
>> Okay, so that leaves us with a decision to make: push it into beta2, or
>> wait till after wrap? I find it pretty scary to push a patch with
>> portability implications so soon before wrap, but a quick look at the
>> buildfarm
On Mon, Jul 10, 2017 at 10:08:53AM -0400, Tom Lane wrote:
> Noah Misch writes:
> > I recommend pushing your patch so the August back-branch releases have it.
> > One can see by inspection that your patch has negligible effect on systems
> > healthy today. I have a reasonable suspicion it will hel
On Mon, Jul 10, 2017 at 10:46:09AM -0400, Tom Lane wrote:
> Magnus Hagander writes:
> > On Jul 10, 2017 16:08, "Tom Lane" wrote:
> >> Okay, so that leaves us with a decision to make: push it into beta2, or
> >> wait till after wrap? I find it pretty scary to push a patch with
> >> portability im
Noah Misch writes:
> On Mon, Jul 10, 2017 at 10:46:09AM -0400, Tom Lane wrote:
>> Shall we go for broke and also remove the ASLR-disabling patch in beta2?
> As I mentioned in my message eight hours ago, no.
Ah, sorry, I'd managed to swap out that bit of info already. However,
I've now gone and
On Mon, Jul 10, 2017 at 04:15:28PM +0900, Amit Langote wrote:
> On 2017/07/10 15:32, Craig Ringer wrote:
> > On 8 July 2017 at 00:03, David Fetter wrote:
> >
> >> On Fri, Jul 07, 2017 at 10:29:26AM +0900, Amit Langote wrote:
> >>> Hi Mark,
> >>>
> >>> On 2017/07/07 9:02, Mark Kirkwood wrote:
> >>
I've created a new Wiki page that describes a scheme for normalizing
internal page items within B-Tree indexes, and the many optimizations
that this can enable:
https://wiki.postgresql.org/wiki/Key_normalization
Key normalization means creating a representation for internal page
items that we alw
On Mon, Jul 10, 2017 at 3:40 PM, Peter Geoghegan wrote:
> It might appear excessive to talk about several different techniques
> in one place, but that seemed like the best way to me, because there
> are subtle dependencies. If most of the optimizations are pursued as a
> project all at once (say,
Claudio Freire wrote:
> A missing optimization is that having tid unification allows VACUUM to
> implement a different strategy when it needs to clean up only a tiny
> fraction of the index. It can do the lookup by key-tid instead of
> scanning the whole index, which can be a win if the index is l
On Mon, Jul 10, 2017 at 1:23 PM, Alvaro Herrera
wrote:
> Claudio Freire wrote:
>
>> A missing optimization is that having tid unification allows VACUUM to
>> implement a different strategy when it needs to clean up only a tiny
>> fraction of the index. It can do the lookup by key-tid instead of
>>
On Mon, Jul 10, 2017 at 12:53 PM, Claudio Freire wrote:
> I do have a patch that attacks suffix truncation, heap tid unification
> and prefix compression all at once.
That's great! I'll certainly be able to review it.
> It's on a hiatus ATM, but, as you say, the implementations are highly
> corr
On Sun, Jul 9, 2017 at 3:06 AM, Noah Misch wrote:
> On Fri, Jul 07, 2017 at 06:47:26PM +0900, Amit Langote wrote:
>> On 2017/07/06 16:06, Etsuro Fujita wrote:
>> > Looks odd to me because the error message doesn't show any DETAIL info;
>> > since the CTE query, which produces the message, is the s
On Thu, Jun 29, 2017 at 6:20 AM, Etsuro Fujita
wrote:
> So, I dropped the COPY part.
Ouch. I think we should try to figure out how the COPY part will be
handled before we commit to a design.
I have to admit that I'm a little bit fuzzy about why foreign insert
routing requires all of these chang
On Mon, Jul 10, 2017 at 2:15 AM, Amit Langote
wrote:
> I posted a patch upthread which makes \d hide partitions (relispartition =
> true relations) and include them if the newly proposed '!' modifier is
> specified. The '+' modifier is being used to show additional detail of
> relations chosen to
On Mon, Jul 10, 2017 at 05:33:34PM -0500, Robert Haas wrote:
> On Mon, Jul 10, 2017 at 2:15 AM, Amit Langote
> wrote:
> > I posted a patch upthread which makes \d hide partitions
> > (relispartition = true relations) and include them if the newly
> > proposed '!' modifier is specified. The '+' mo
On 10 July 2017 at 19:40, Peter Geoghegan wrote:
> Key normalization means creating a representation for internal page
> items that we always just memcmp(), regardless of the details of the
> underlying datatypes.
One thing I would like to see is features like this added to the
opclasses (or opfa
On 10 July 2017 at 23:46, David Fetter wrote:
> On Mon, Jul 10, 2017 at 05:33:34PM -0500, Robert Haas wrote:
>> On Mon, Jul 10, 2017 at 2:15 AM, Amit Langote
>> wrote:
>> > I posted a patch upthread which makes \d hide partitions
>> > (relispartition = true relations) and include them if the newl
On Mon, Jul 10, 2017 at 4:08 PM, Greg Stark wrote:
> One thing I would like to see is features like this added to the
> opclasses (or opfamilies?) using standard PG functions that return
> standard PG data types. So if each opclass had a function that took
> the data type in question and returned
Alvaro Herrera wrote:
> I'll next update this on or before Monday 10th at 19:00 CLT.
I couldn't get to this today as I wanted. Next update on Wednesday
12th, same time.
--
Álvaro Herrerahttps://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Se
On Mon, Jul 10, 2017 at 10:01 PM, Heikki Linnakangas wrote:
> On 07/10/2017 01:27 PM, Masahiko Sawada wrote:
>>
>> This commit seems be cause of the documentation compilation error. I
>> think is missing.
>>
>> ...
>>
>> Attached small patch fixes this.
>
>
> Thanks, committed!
>
> Strangely, it
On Mon, Jul 10, 2017 at 11:56 AM, Michael Paquier
wrote:
> On Sat, Jul 8, 2017 at 12:50 AM, Masahiko Sawada
> wrote:
>> On Fri, Jul 7, 2017 at 3:48 PM, Michael Paquier
>> wrote:
>>> So I would suggest the following things to address this issue:
>>> 1) Generate a backup history file for backups
On 2017/07/11 7:33, Robert Haas wrote:
> On Mon, Jul 10, 2017 at 2:15 AM, Amit Langote
> wrote:
>> Actually, if \d had shown RELKIND_PARTITIONED_TABLE tables as of Type
>> "partitioned table", we wouldn't need a separate flag for marking a table
>> as having partitions.
>
> I think that is false
At Mon, 10 Jul 2017 18:37:34 +0530, Amit Kapila wrote
in
> On Mon, Jul 10, 2017 at 3:27 PM, Kyotaro HORIGUCHI
> wrote:
> > Hi,
> >
> > At Mon, 10 Jul 2017 14:58:13 +0530, Amit Kapila
> > wrote in
> >
> >
> >> I am also not 100% comfortable with adding flush at two new places,
> >> but that
> Also, there seems to be at least some preference
> for excluding partitions by default from the \d listing.
As another user of partitions I'll chime in and say that would be very
nice! On the other hand, with pre-10 partitions you do see all the
child tables with `\d`, so showing declarative par
On Fri, Jun 9, 2017 at 11:09 AM, Robert Haas wrote:
>> Isn't that what strxfrm() is?
>
> Yeah, just with bugs. If ICU has a non-buggy equivalent, then we can
> make this work.
I agree that it probably isn't worth using strxfrm() again, simply
because the glibc implementation is buggy, and glibc
On 2017/07/11 10:34, Paul A Jungwirth wrote:
>> Also, there seems to be at least some preference
>> for excluding partitions by default from the \d listing.
>
> As another user of partitions I'll chime in and say that would be very
> nice! On the other hand, with pre-10 partitions you do see all t
On Tue, Jul 11, 2017 at 6:51 AM, AP wrote:
> On Fri, Jul 07, 2017 at 05:58:25PM +0530, Amit Kapila wrote:
>> On Fri, Jul 7, 2017 at 8:22 AM, AP wrote:
>> > On Thu, Jul 06, 2017 at 05:19:59PM +0530, Amit Kapila wrote:
>> >> I think if you are under development, it is always advisable to create
>>
Amit Kapila wrote:
> On Tue, Jul 11, 2017 at 6:51 AM, AP wrote:
> > On Fri, Jul 07, 2017 at 05:58:25PM +0530, Amit Kapila wrote:
> >> I can understand your concerns. To address first concern we need to
> >> work on one or more of following work items: (a) work on vacuums that
> >> can be trigger
If I have a slow function which is evaluated in a simple seq scan, I do not
get parallel execution, even though it would be massively useful. Unless
force_parallel_mode=ON, then I get a dummy parallel plan with one worker.
explain select aid,slow(abalance) from pgbench_accounts;
CREATE OR REPLAC
Robert Haas wrote:
> On Mon, Jul 10, 2017 at 2:15 AM, Amit Langote
> wrote:
> > Actually, if \d had shown RELKIND_PARTITIONED_TABLE tables as of Type
> > "partitioned table", we wouldn't need a separate flag for marking a table
> > as having partitions.
>
> I think that is false. Whether someth
On Tue, Jul 11, 2017 at 9:02 AM, Jeff Janes wrote:
> If I have a slow function which is evaluated in a simple seq scan, I do not
> get parallel execution, even though it would be massively useful. Unless
> force_parallel_mode=ON, then I get a dummy parallel plan with one worker.
>
> explain selec
On Sun, Jul 09, 2017 at 08:42:32AM +0100, Dean Rasheed wrote:
> On 6 July 2017 at 22:43, Joe Conway wrote:
> > I agree we should get this right the first time and I also agree with
> > Dean's proposal, so I guess I'm a +2
> >
>
> On 7 July 2017 at 03:21, Amit Langote wrote:
> > +1 to releasing t
53 matches
Mail list logo
