On Wed, Dec 28, 2016 at 9:20 AM, Etsuro Fujita
wrote:
> On 2016/12/27 22:03, Ashutosh Bapat wrote:
>>
>> If mergejoin_allowed is true and mergeclauselist is non-NIL but
>> hashclauselist is NIL (that's rare but there can be types has merge
>> operators but not hash operators), we will end up retur
On Wed, Dec 28, 2016 at 12:18 PM, Rafia Sabih
wrote:
> Rebased patch of parallel-index only scan based on the latest version of
> parallel index scan [1] is attached.
>
> [1]
> https://www.postgresql.org/message-id/CAA4eK1LiNi7_Z1%2BPCV4y06o_v%3DZdZ1UThE%2BW9JhthX4B8uifnA%40mail.gmail.com
>
The l
Rebased patch of parallel-index only scan based on the latest version of
parallel index scan [1] is attached.
[1] https://www.postgresql.org/message-id/CAA4eK1LiNi7_Z1%
2BPCV4y06o_v%3DZdZ1UThE%2BW9JhthX4B8uifnA%40mail.gmail.com
On Sat, Dec 24, 2016 at 7:55 PM, Rafia Sabih
wrote:
> Extremely sor
>>
>> We allow creating user attribute with name "oid" so you do not want to
>> search system attribute oid by name. Instead search by attribute id
>> ObjectIdAttributeNumber.
>
> Good point. Although, there can only be one of the two in a table at any
> given time - either the "oid" system column
Currently, queries that have references to SubPlans or
AlternativeSubPlans are considered parallel-restricted. I think we
can lift this restriction in many cases especially when SubPlans are
parallel-safe. To make this work, we need to propagate the
parallel-safety information from path node to p
On Wed, Dec 28, 2016 at 2:14 PM, David Fetter wrote:
> Here's everything that matches ^\w+_hook$ that I've found so far in
> git master. There are very likely false positives in this list.
>
> [... long list of hooks ...]
>
> Some appear to be client-side, some server-side. I hope that no hook
>
On Wed, Dec 28, 2016 at 3:12 AM, Magnus Hagander wrote:
> On Tue, Dec 27, 2016 at 1:16 PM, Michael Paquier
> wrote:
>> On Tue, Dec 27, 2016 at 6:34 PM, Magnus Hagander
>> wrote:
>> > On Tue, Dec 27, 2016 at 2:23 AM, Michael Paquier
>> >
>> > wrote:
>> >> Magnus, you have mentioned me as well th
On Tue, Dec 27, 2016 at 10:15:55PM -0600, Jim Nasby wrote:
> On 12/27/16 7:41 PM, David Fetter wrote:
> > I see it as larger in scope than mine because it changes how we do
> > things as a project. An example of the kind of thing that this raises
> > is enforcement. Will something (or someone) ch
>
> I'm looking forward to seeing your patch.
>
I created a patch.
I marked [WIP] to the title because some documentation is lacked and format
needs some fixing.
I'm going to post this patch to the January CF.
But it's my first time to send a patch so please excuse me if there's something
yo
On 12/27/16 9:10 PM, Craig Ringer wrote:
On 28 December 2016 at 09:58, Jim Nasby wrote:
I've looked at this some more, and ITSM that the only way to do this without
some major surgery is to create a new type of Destination specifically for
SPI that allows for the execution of an arbitrary C fu
On Wed, Dec 28, 2016 at 4:21 PM, Craig Ringer wrote:
> On 28 December 2016 at 08:14, Thomas Munro
> wrote:
>
>> 3. No server must allow a transaction to be visible that hasn't been
>> flushed on N standby servers. We already prevent that on the primary
>
> Only if the primary doesn't restart. W
On 28 December 2016 at 12:15, Jim Nasby wrote:
> Can we reduce the scope of this to a manageable starting point? I'm guessing
> that all existing hooks share certain characteristics that it'd be pretty
> easy to detect. If you can detect the hook (which I guess means finding a
> static variable w
On 12/27/16 7:41 PM, David Fetter wrote:
I see it as larger in scope than mine because it changes how we do
things as a project. An example of the kind of thing that this raises
is enforcement. Will something (or someone) check that new hooks have
this? Will somebody check for comment skew whe
On 12/27/16 4:56 PM, Merlin Moncure wrote:
On Tue, Dec 27, 2016 at 1:54 AM, Pavel Stehule wrote:
First I describe my initial position. I am strongly against introduction
"new" language - plpgsql2 or new plpgsql, or any else. The trust of
developers to us is important and introduction of any not
On 2016/12/27 22:03, Ashutosh Bapat wrote:
If mergejoin_allowed is true and mergeclauselist is non-NIL but
hashclauselist is NIL (that's rare but there can be types has merge
operators but not hash operators), we will end up returning NULL. I
think we want to create a merge join in that case. I t
Fabien, I don't really see the point of "persistent variables". What
benefit do they add over relations?
You can add a simple function to fetch a tuple if you want it not to
look like a subquery. Do it with heap access in C if you like, save
the (trivial) planning costs.
I do see value to two di
Here is a patch to add some information about the systemd RemoveIPC
issue to the documentation, sort of in the spirit of the OOM discussion
nearby.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>From eaf0eda3f4c4
On 28 December 2016 at 08:14, Thomas Munro
wrote:
> 3. No server must allow a transaction to be visible that hasn't been
> flushed on N standby servers. We already prevent that on the primary
Only if the primary doesn't restart. We don't persist the xact masking
used by sync rep at the moment.
On 28 December 2016 at 08:33, Tom Lane wrote:
>> I would not say that the current patch is giant & invasive, if you
>> abstract the two added fields to high-level statements.
>
> It's touching every single utility statement type, which is not only
> pretty invasive in itself, but will break any p
On 28 December 2016 at 09:58, Jim Nasby wrote:
> I've looked at this some more, and ITSM that the only way to do this without
> some major surgery is to create a new type of Destination specifically for
> SPI that allows for the execution of an arbitrary C function for each tuple
> to be sent.
T
On Wed, Dec 28, 2016 at 11:57 AM, Thomas Munro
wrote:
> But I'm starting to think that the best way might be to do BOTH of the
> things I said in my previous message: make dsa.c register on
> create/attach and also unregister before detaching iff the name was
> supplied at creation time for the be
On 12/21/16 8:21 AM, Jim Nasby wrote:
On 12/20/16 10:14 PM, Jim Nasby wrote:
It would be a lot more efficient if we could just grab datums from the
executor and make a single copy into plpython (or R), letting the PL
deal with all the memory management overhead.
I briefly looked at using SPI cu
On Wed, Dec 28, 2016 at 01:33:13AM +, Tsunakawa, Takayuki wrote:
> From: David Fetter [mailto:da...@fetter.org]
> > > How about putting a descriptive comment at the location where each
> > > hook variable is defined, using some convention (e.g. like
> > > Javadoc-style)? A separate document su
On 2016/12/27 19:07, Amit Langote wrote:
> Attached should fix that.
Here are the last two patches with additional information like other
patches. Forgot to do that yesterday.
Thanks,
Amit
>From 5a82b4caa6cec7845eb48e0397fab49c74b8dd98 Mon Sep 17 00:00:00 2001
From: amit
Date: Wed, 28 Dec 2016
From: David Fetter [mailto:da...@fetter.org]
> > How about putting a descriptive comment at the location where each
> > hook variable is defined, using some convention (e.g. like
> > Javadoc-style)? A separate document such as README and wiki can fail
> > to be updated. OTOH, if someone wants to
On Wed, Dec 28, 2016 at 12:47:10AM +, Tsunakawa, Takayuki wrote:
> From: pgsql-hackers-ow...@postgresql.org
> > [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Jim Nasby
> > AFAIK there's no way to get a list of hooks today, short of
> > something like `git grep hook`. I think a simple
On 2016/12/27 22:24, Ashutosh Bapat wrote:
> On Mon, Dec 26, 2016 at 3:36 PM, Amit Langote
> wrote:
>> Attached patches modifies MergeAttributesIntoExisting() such that we
>> increment attinhcount not only for user attributes, but also for the oid
>> system column if one exists.
>>
>> Thoughts?
>
From: pgsql-hackers-ow...@postgresql.org
> [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Jim Nasby
> AFAIK there's no way to get a list of hooks today, short of something like
> `git grep hook`. I think a simple list of what hooks we have, when they
> fire and where to find them in code
Fabien COELHO writes:
>>> How? The issue is that stmtmulti silently skip some ';' when empty
>>> statements are found, [...]
>> Maybe you should undo that.
> I was trying to be minimally invasive in the parser, i.e. not to change
> any rules.
That's fairly silly when the alternative is to be m
On Tue, Dec 27, 2016 at 6:55 PM, Pavel Stehule
wrote:
>
>
> 2016-12-27 21:38 GMT+01:00 Fabrízio de Royes Mello <
fabriziome...@gmail.com>:
>>
>>
>> On Fri, Dec 23, 2016 at 4:00 PM, Joe Conway wrote:
>> >
>> > >> In the long term, What would be the possible scopes?
>> > >>
>> > >> TRANSACTION, SES
> I've noticed that this patch is on CF and needs a reviewer so I decided
> to take a look. Code looks good to me in general, it's well covered by
> tests and passes `make check-world`.
Thanks for your review.
> However it would be nice to have a little more comments. In my opinion
> every proce
Hi,
Sync rep with multiple standbys allows queries run on standbys to see
transactions that haven't been flushed on the configured number of
standbys. That means that it's susceptible to lost updates or a kind
of "dirty read" in certain cluster reconfiguration scenarios. To
close that gap, we wo
2016-12-27 23:56 GMT+01:00 Merlin Moncure :
> On Tue, Dec 27, 2016 at 1:54 AM, Pavel Stehule
> wrote:
> > Hi
> >
> > I reread ideas described on page https://github.com/trustly/plpgsql2
> >
> > Some points are well and can be benefit for PlpgSQL.
> >
> > First I describe my initial position. I am
Andreas Seltenreich writes:
> Thomas Munro writes:
>
>> It is safe, as long as the segment remains mapped. Each backend that
>> attaches calls LWLockRegisterTranche giving it the address of the name
>> in its virtual address space.
>
> Hmok, I was under the impression only backends participating
Thomas Munro writes:
> On Wed, Dec 28, 2016 at 11:38 AM, Andreas Seltenreich
> wrote:
>> Thomas Munro writes:
>>
>>> On Wed, Dec 28, 2016 at 10:40 AM, Thomas Munro
>>> wrote:
On Wed, Dec 28, 2016 at 10:01 AM, Andreas Seltenreich
wrote:
> testing master as of fe591f8bf6 produced
On 12/23/2016 03:58 AM, Amit Kapila wrote:
On Thu, Dec 22, 2016 at 6:59 PM, Tomas Vondra
wrote:
Hi,
But as discussed with Amit in Tokyo at pgconf.asia, I got access to a
Power8e machine (IBM 8247-22L to be precise). It's a much smaller machine
compared to the x86 one, though - it only has 24 c
On Wed, Dec 28, 2016 at 11:38 AM, Andreas Seltenreich
wrote:
> Thomas Munro writes:
>
>> On Wed, Dec 28, 2016 at 10:40 AM, Thomas Munro
>> wrote:
>>> On Wed, Dec 28, 2016 at 10:01 AM, Andreas Seltenreich
>>> wrote:
testing master as of fe591f8bf6 produced a crash reading
pg_stat_acti
On Tue, Dec 27, 2016 at 1:54 AM, Pavel Stehule wrote:
> Hi
>
> I reread ideas described on page https://github.com/trustly/plpgsql2
>
> Some points are well and can be benefit for PlpgSQL.
>
> First I describe my initial position. I am strongly against introduction
> "new" language - plpgsql2 or n
Thomas Munro writes:
> On Wed, Dec 28, 2016 at 10:40 AM, Thomas Munro
> wrote:
>> On Wed, Dec 28, 2016 at 10:01 AM, Andreas Seltenreich
>> wrote:
>>> testing master as of fe591f8bf6 produced a crash reading
>>> pg_stat_activity (backtrace below). Digging around with with gdb
>>> revealed that
On Wed, Dec 28, 2016 at 10:40 AM, Thomas Munro
wrote:
> On Wed, Dec 28, 2016 at 10:01 AM, Andreas Seltenreich
> wrote:
>> testing master as of fe591f8bf6 produced a crash reading
>> pg_stat_activity (backtrace below). Digging around with with gdb
>> revealed that pgstat_get_wait_event() returned
Hello Tom,
How? The issue is that stmtmulti silently skip some ';' when empty
statements are found, [...]
Maybe you should undo that.
I was trying to be minimally invasive in the parser, i.e. not to change
any rules.
I've generally found that trying to put optimizations into the grammar
On 12/27/16 1:43 PM, David Fetter wrote:
So I'm a bit suspicious of this project in the first place, but it's
hard to discuss which hooks should be documented when you haven't
defined what you mean by documentation.
I haven't quite come up with that, but I'd pictured a part of the SGML
docs that
On 12/27/16 11:17 AM, Greg Stark wrote:
On Dec 24, 2016 5:44 PM, "Tom Lane" mailto:t...@sss.pgh.pa.us>> wrote:
I think we'd need at least an order of
magnitude cheaper to consider putting timing calls into spinlock or
lwlock
paths, and that's just not available at all, let alon
On Wed, Dec 28, 2016 at 10:01 AM, Andreas Seltenreich
wrote:
> testing master as of fe591f8bf6 produced a crash reading
> pg_stat_activity (backtrace below). Digging around with with gdb
> revealed that pgstat_get_wait_event() returned an invalid pointer for a
> classId PG_WAIT_LWLOCK.
>
> I thin
Hi,
testing master as of fe591f8bf6 produced a crash reading
pg_stat_activity (backtrace below). Digging around with with gdb
revealed that pgstat_get_wait_event() returned an invalid pointer for a
classId PG_WAIT_LWLOCK.
I think the culprit is dsa.c passing a pointer to memory that goes away
on
2016-12-27 21:38 GMT+01:00 Fabrízio de Royes Mello
:
>
> On Fri, Dec 23, 2016 at 4:00 PM, Joe Conway wrote:
> >
> > >> In the long term, What would be the possible scopes?
> > >>
> > >> TRANSACTION, SESSION, PERSISTANT ?
> > >>
> > >> Would some scopes orthogonal (eg SHARED between sessions for
On Fri, Dec 23, 2016 at 4:00 PM, Joe Conway wrote:
>
> >> In the long term, What would be the possible scopes?
> >>
> >> TRANSACTION, SESSION, PERSISTANT ?
> >>
> >> Would some scopes orthogonal (eg SHARED between sessions for a USER in
a
> >> DATABASE, SHARED at the cluster level?).
> >
> > I hav
On Tue, Dec 27, 2016 at 01:32:46PM -0500, Tom Lane wrote:
> David Fetter writes:
> > One of our hidden treasures is the hook system, documented only in
> > random presentations, if you can find them, and in the source code, if
> > you know to look.
>
> > I'd like to document the hooks that we con
Gilles, all,
* Stephen Frost (sfr...@snowman.net) wrote:
> * Gilles Darold (gilles.dar...@dalibo.com) wrote:
> > Added to next commitfest. To explain more this patch, the completion of
> > SQL command:
> >
> > ALTER DEFAULT PRIVILEGES FOR ROLE xxx [tab]
>
> Here is a cleaned up patch for mas
David Fetter writes:
> One of our hidden treasures is the hook system, documented only in
> random presentations, if you can find them, and in the source code, if
> you know to look.
> I'd like to document the hooks that we consider public APIs.
The main reason we send people to the source code
Fabien COELHO writes:
> How? The issue is that stmtmulti silently skip some ';' when empty
> statements are found, so I need to keep track of that to know where to
> stop, using the beginning location of the next statement, which is
> probably your idea, does not work.
Maybe you should undo th
Folks,
One of our hidden treasures is the hook system, documented only in
random presentations, if you can find them, and in the source code, if
you know to look.
I'd like to document the hooks that we consider public APIs.
To do this, I need to figure out whether there are hooks that we don't
c
On Tue, Dec 27, 2016 at 1:16 PM, Michael Paquier
wrote:
> On Tue, Dec 27, 2016 at 6:34 PM, Magnus Hagander
> wrote:
> > On Tue, Dec 27, 2016 at 2:23 AM, Michael Paquier <
> michael.paqu...@gmail.com>
> > wrote:
> >> Magnus, you have mentioned me as well that you had a couple of ideas
> >> on the
An additional comment on parser(planner?) part.
This patch make planner() copy the location and length from
parse to result, but copying such stuffs is a job of
standard_planner.
I put the copy in planner because standard_planner may not be called by
planner, and in all cases I think that
On Dec 24, 2016 5:44 PM, "Tom Lane" wrote:
I think we'd need at least an order of
magnitude cheaper to consider putting timing calls into spinlock or lwlock
paths, and that's just not available at all, let alone portably.
For spinlocks we could conceivably just bite the bullet and use a raw rdt
Hello Kyotaro-san,
In nonterminal stmtmulti, setQueryLocation is added and used to
calcualte and store the length of every stmt's. This needs an
extra storage in bse_yy_extra_type
The extra storage is one int.
and introduces a bit complicated stuff. But I think raw_parser can do
that withou
On Tue, Dec 27, 2016 at 10:41 AM, Anastasia Lubennikova
wrote:
> Program terminated with signal SIGSEGV, Segmentation fault.
> #0 0x006941e7 in lazy_vacuum_heap (onerel=0x1ec2360,
> vacrelstats=0x1ef6e00) at vacuumlazy.c:1417
> 1417tblk =
> ItemPointerGetBlockNumber(&seg->
On Tue, Dec 27, 2016 at 10:54 AM, Alvaro Herrera
wrote:
> Anastasia Lubennikova wrote:
>
>> I ran configure using following set of flags:
>> ./configure --enable-tap-tests --enable-cassert --enable-debug
>> --enable-depend CFLAGS="-O0 -g3 -fno-omit-frame-pointer"
>> And then ran make check. Here
Andres Freund writes:
> On 2016-12-27 01:35:05 +, Greg Stark wrote:
>> On Dec 26, 2016 10:35 PM, "Tom Lane" wrote:
>>> So it seems like the configure support we'd need is to detect
>>> whether clock_gettime is available (note on Linux there's also
>>> a library requirement, -lrt), and we woul
On Fri, Dec 23, 2016 at 5:48 PM, Rahila Syed wrote:
>>> 5. Comment for _bt_parallel_seize() says:
>>> "False indicates that we have reached the end of scan for
>>> current scankeys and for that we return block number as P_NONE."
>>>
>>> What is the reason to check (blkno == P_NONE) after checkin
On Fri, Dec 23, 2016 at 6:42 PM, Anastasia Lubennikova
wrote:
> 22.12.2016 07:19, Amit Kapila:
>>
>> On Wed, Dec 21, 2016 at 8:46 PM, Anastasia Lubennikova
>> wrote:
>>>
>>> The following review has been posted through the commitfest application:
>>> make installcheck-world: tested, passed
>>> I
Ashutosh,
* Ashutosh Bapat (ashutosh.ba...@enterprisedb.com) wrote:
> We report planning and execution time when EXPLAIN ANALYZE is issued.
> We do not have facility to report planning time as part EXPLAIN
> output. In order to get the planning time, one has to issue EXPLAIN
> ANALYZE which involv
Tom,
* Tom Lane (t...@sss.pgh.pa.us) wrote:
> In practice, there should never be waits on LWLocks (much less spinlocks)
> that exceed order-of-milliseconds; if there are, either we chose the wrong
> lock type or the system is pretty broken in general. So maybe it's
> sufficient if we provide a wa
Anastasia Lubennikova wrote:
> I ran configure using following set of flags:
> ./configure --enable-tap-tests --enable-cassert --enable-debug
> --enable-depend CFLAGS="-O0 -g3 -fno-omit-frame-pointer"
> And then ran make check. Here is the stacktrace:
>
> Program terminated with signal SIGSEGV,
23.12.2016 22:54, Claudio Freire:
On Fri, Dec 23, 2016 at 1:39 PM, Anastasia Lubennikova
wrote:
I found the reason. I configure postgres with CFLAGS="-O0" and it causes
Segfault on initdb.
It works fine and passes tests with default configure flags, but I'm pretty
sure that we should fix segfa
On Mon, Dec 26, 2016 at 3:36 PM, Amit Langote
wrote:
> I suspect the following is a bug:
>
> create table foo (a int) with oids;
> CREATE TABLE
> create table bar (a int);
> CREATE TABLE
> alter table bar inherit foo;
> ERROR: table "bar" without OIDs cannot inherit from table "foo" with OIDs
>
>
On Mon, Dec 26, 2016 at 11:49 AM, Jaime Casanova <
jaime.casan...@2ndquadrant.com> wrote:
> On 2 December 2016 at 07:36, Pavan Deolasee
> wrote:
> >
> > I've updated the patches after fixing the issue. Multiple rounds of
> > regression passes for me without any issue. Please let me know if it
> w
Hello.
I've noticed that this patch is on CF and needs a reviewer so I decided
to take a look. Code looks good to me in general, it's well covered by
tests and passes `make check-world`.
However it would be nice to have a little more comments. In my opinion
every procedure have to have at least a
>
>> 3. Talking about saving some CPU cycles - if a clauseless full join can be
>> implemented only using merge join, probably that's the only path available
>> in
>> the list of paths for the given relation. Instead of building the same
>> path
>> anew, should we use the existing path like GetExis
On 2016/12/08 21:08, Etsuro Fujita wrote:
On 2016/12/07 20:23, Etsuro Fujita wrote:
My proposal here would be a bit different from what you proposed; right
before deparseSelectSql in deparseSelectStmtForRel, build the tlists for
relations present in the given jointree that will be deparsed as
su
On Tue, Dec 27, 2016 at 6:34 PM, Magnus Hagander wrote:
> On Tue, Dec 27, 2016 at 2:23 AM, Michael Paquier
> wrote:
>> Magnus, you have mentioned me as well that you had a couple of ideas
>> on the matter, feel free to jump in and let's mix our thoughts!
>
>
> Yeah, I've been wondering what the a
On 2016-12-27 14:09:05 +0900, Michael Paquier wrote:
> On Fri, Dec 23, 2016 at 3:02 AM, Andres Freund wrote:
> > Not quite IIRC: that doesn't deal with file size increase. All this would
> > be easier if hardlinks wouldn't exist IIUC. It's basically a question
> > whether dentry, inode or conte
On 2016/12/27 18:48, 高增琦 wrote:
> Hi ,
>
> I tried "COPY FROM" in the git version. It inserts rows to wrong partition.
>
> step to reproduce:
> create table t(a int, b int) partition by range(a);
> create table t_p1 partition of t for values from (1) to (100);
> create table t_p2 partition of t
On 2016/12/27 18:30, Rajkumar Raghuwanshi wrote:
> Hi Amit,
>
> I have pulled latest sources from git and tried to create multi-level
> partition, getting a server crash, below are steps to reproduce. please
> check if it is reproducible in your machine also.
>
[ ... ]
> postgres=# INSERT INTO
Hi ,
I tried "COPY FROM" in the git version. It inserts rows to wrong partition.
step to reproduce:
create table t(a int, b int) partition by range(a);
create table t_p1 partition of t for values from (1) to (100);
create table t_p2 partition of t for values from (100) to (200);
create table t_p
> On 27 December 2016 at 16:09, Aleksander Alekseev <
a.aleks...@postgrespro.ru> wrote:
> until it breaks existing extensions.
Hm...I already answered, that I managed to avoid compilation problems for
this particular extension
using the `genparser` command again:
> On Thu, Nov 17, 2016 at 10:56 P
On Tue, Dec 27, 2016 at 10:36 AM, Erik Rijkers wrote:
> On 2016-12-27 10:25, Magnus Hagander wrote:
>
>> On Sun, Dec 25, 2016 at 2:35 PM, Erik Rijkers wrote:
>>
>> Applied, thanks.
>>
>> Seems to me that in comments it's not worth chasing them down
>> individually,
>> but if you happen to fix on
On 2016-12-27 10:25, Magnus Hagander wrote:
On Sun, Dec 25, 2016 at 2:35 PM, Erik Rijkers wrote:
Applied, thanks.
Seems to me that in comments it's not worth chasing them down
individually,
but if you happen to fix one alongside another one like here, then it's
a
different story :)
Well,
On Tue, Dec 27, 2016 at 2:23 AM, Michael Paquier
wrote:
> Hi all,
>
> Since 56c7d8d4, pg_basebackup supports tar format when streaming WAL
> records. This has been done by introducing a new transparent routine
> layer to control the method used to fetch WAL walmethods.c: plain or
> tar.
>
> pg_re
Hi Amit,
I have pulled latest sources from git and tried to create multi-level
partition, getting a server crash, below are steps to reproduce. please
check if it is reproducible in your machine also.
postgres=# CREATE TABLE test_ml (a int, b int, c varchar) PARTITION BY
RANGE(a);
CREATE TABLE
p
On Sun, Dec 25, 2016 at 2:35 PM, Erik Rijkers wrote:
> On 2016-12-25 13:38, Erik Rijkers wrote:
>
>> 'the the' -> 'the'
>>
>> and
>>
>> 'ie' -> 'i.e.'
>>
>> Although (concening the latter change) the present counts are 'ie'
>> 428, and 'i.e.' 428.
>> so it might be debatable (but let's not)
>>
>>
On 2016-12-27 01:35:05 +, Greg Stark wrote:
> On Dec 26, 2016 10:35 PM, "Tom Lane" wrote:
>
>
> So it seems like the configure support we'd need is to detect
> whether clock_gettime is available (note on Linux there's also
> a library requirement, -lrt), and we would also need a way to
> pro
As I mentioned above [1] in my humble opinion this patch is not at all in a
"good shape" until it breaks existing extensions.
[1] http://postgr.es/m/20161115080324.GA5351%40e733.localdomain
On Mon, Dec 26, 2016 at 10:49:30PM +0700, Dmitry Dolgov wrote:
> > On 5 December 2016 at 12:03, Haribabu Ko
On Sat, Dec 24, 2016 at 1:18 AM, Alvaro Herrera
wrote:
> Alvaro Herrera wrote:
>
> > With your WARM and my indirect indexes, plus the additions for for-key
> > locks, plus identity columns, there is no longer a real expectation that
> > we can exit early from the function. In your patch, as well
On 2016/12/26 19:46, Amit Langote wrote:
> (Perhaps, the following should be its own new thread)
>
> I noticed that ExecProcessReturning() doesn't work properly after tuple
> routing (example shows how returning tableoid currently fails but I
> mention some other issues below):
>
> create table p
At Fri, 23 Dec 2016 11:02:11 +0900, Michael Paquier
wrote in
> On Fri, Dec 23, 2016 at 8:13 AM, Robert Haas wrote:
> > On Thu, Dec 22, 2016 at 2:34 PM, Andres Freund wrote:
> >> On 2016-12-22 08:32:56 -0800, Andres Freund wrote:
> >>> I plan to commit this later today. Hope I got the reviewer
On Tue, Dec 27, 2016 at 1:36 PM, Mithun Cy wrote:
Oops, patch number should be 08 re-attaching same after renaming.
--
Thanks and Regards
Mithun C Y
EnterpriseDB: http://www.enterprisedb.com
diff --git a/src/backend/access/hash/hashinsert.c b/src/backend/access/hash/hashinsert.c
index 46df589..c
On Thu, Dec 22, 2016 at 12:17 PM, Amit Kapila wrote:
> On Wed, Dec 21, 2016 at 9:26 PM, Robert Haas wrote:
>> On Tue, Dec 20, 2016 at 2:25 PM, Mithun Cy
>> wrote:
>>> -- I think if it is okay, I can document same for each member of
>>> HashMetaPageData whether to read from cached from meta pag
2016-12-27 8:54 GMT+01:00 Pavel Stehule :
> Hi
>
> I reread ideas described on page https://github.com/trustly/plpgsql2
>
> Some points are well and can be benefit for PlpgSQL.
>
> First I describe my initial position. I am strongly against introduction
> "new" language - plpgsql2 or new plpgsql,
89 matches
Mail list logo
