[about logging...]
Here is an attempt at updating the log features, including the aggregate
and sampling stuff, with skipped transactions under throttling.
I moved the logging stuff into a function which is called when a
transaction is skipped or finished.
From a log file format perspect
Attached is an updated version of the patch.
Ok.
I notice that you decided against adding tags around function and type
names.
It's really not about the IEEE changing something, but about someone
changing the Wikipedia page. The way I linked it makes sure it always
displays the same versi
On Tue, Aug 19, 2014 at 2:02 PM, David Rowley wrote:
> Here's a few notes from reading over the code:
>
> * pathkeys.c
>
> EquivalenceMember *member = (EquivalenceMember *)
> lfirst(list_head(key->pk_eclass->ec_members));
>
> You can use linitial() instead of lfirst(list_head()). The same thin
Fabien COELHO-3 wrote
>> Of course a general rule how to link to WP would be nice ...
>
> I'm afraid that the current implicit rule is more or less "no links", at
> least there are very few of them but in the glossary, and when I submitted
> docs with them they were removed before committing.
I
Of course a general rule how to link to WP would be nice ...
I'm afraid that the current implicit rule is more or less "no links", at
least there are very few of them but in the glossary, and when I submitted
docs with them they were removed before committing.
Ideally if external links were
On Tue, Aug 26, 2014 at 1:42 AM, Fabrízio de Royes Mello <
fabriziome...@gmail.com> wrote:
>
>
> On Fri, Aug 22, 2014 at 5:23 PM, Alvaro Herrera
wrote:
> >
> > Fabrízio de Royes Mello wrote:
> > > On Fri, Aug 22, 2014 at 4:45 PM, Alvaro Herrera <
alvhe...@2ndquadrant.com>
> > > wrote:
> >
> > > >
On Fri, Sep 12, 2014 at 11:48:03PM -0400, Tom Lane wrote:
> Bruce Momjian writes:
> > Is everyone OK with me renaming some variables, structures, and macros?
> > It will make back-patching harder, but will allow us to properly maintain
> > that file.
>
> The back-patching problem could be addres
On 2014-09-13 08:52:33 +0300, Ants Aasma wrote:
> On Sat, Sep 13, 2014 at 6:59 AM, Arthur Silva wrote:
> > That's not entirely true. CRC-32C beats pretty much everything with the same
> > length quality-wise and has both hardware implementations and highly
> > optimized software versions.
>
> For
Andres Freund writes:
> On 2014-09-13 08:52:33 +0300, Ants Aasma wrote:
>> On Sat, Sep 13, 2014 at 6:59 AM, Arthur Silva wrote:
>>> That's not entirely true. CRC-32C beats pretty much everything with the same
>>> length quality-wise and has both hardware implementations and highly
>>> optimized s
Hi All,
I want to work on the code of intermediate dataset of select and update
query.
For example.
Rohit's salary has been updated 4 times, so it has 4 different version of
salary.
I want to select salary of person named Rohit. Now suppose , in
intermediate result, I found 4 different version
On Sat, Sep 13, 2014 at 11:06 PM, Rohit Goyal wrote:
>
> Hi All,
>
> I want to work on the code of intermediate dataset of select and update
> query.
>
> For example.
>
> Rohit's salary has been updated 4 times, so it has 4 different version of
> salary.
>
> I want to select salary of person nam
Atri Sharma wrote
> On Sat, Sep 13, 2014 at 11:06 PM, Rohit Goyal <
> rhtgyl.87@
> > wrote:
>
>>
>> Hi All,
>>
>> I want to work on the code of intermediate dataset of select and update
>> query.
>>
>> For example.
>>
>> Rohit's salary has been updated 4 times, so it has 4 different version of
>
On Sat, Sep 13, 2014 at 11:52 PM, David G Johnston <
david.g.johns...@gmail.com> wrote:
> Atri Sharma wrote
> > On Sat, Sep 13, 2014 at 11:06 PM, Rohit Goyal <
>
>
>
> Or rather even if you want to be able to reference the older versions of
> that record there is nothing in PostgreSQL to facilitat
On Sat, Sep 13, 2014 at 12:55:33PM -0400, Tom Lane wrote:
> Andres Freund writes:
> > On 2014-09-13 08:52:33 +0300, Ants Aasma wrote:
> >> On Sat, Sep 13, 2014 at 6:59 AM, Arthur Silva wrote:
> >>> That's not entirely true. CRC-32C beats pretty much everything with the
> >>> same
> >>> length qu
On Fri, Sep 12, 2014 at 11:38 AM, Robert Haas wrote:
> Based on discussion thus far it seems that there's a possibility that
> the trade-off may be different for short strings vs. long strings. If
> the string is small enough to fit in the L1 CPU cache, then it may be
> that memcmp() followed by
On 14/09/14 06:35, Atri Sharma wrote:
On Sat, Sep 13, 2014 at 11:52 PM, David G Johnston
mailto:david.g.johns...@gmail.com>> wrote:
Atri Sharma wrote
> On Sat, Sep 13, 2014 at 11:06 PM, Rohit Goyal <
Or rather even if you want to be able to reference the older
versions of
Zhaomo,
* Zhaomo Yang (zhy...@cs.ucsd.edu) wrote:
> > Have you considered just using a regular, but unlogged, table? That
> > would also avoid any risk that the application manages to drop or shadow
> > the temp table somehow with a "fake" table that changes who is currently
> > authenticated, an
On Fri, Sep 12, 2014 at 6:40 AM, Alexander Korotkov
wrote:
> It's likely that "JB_ROOT_COUNT(val) < JB_ROOT_COUNT(tmpl)" should be
> checked only for objects, not arrays. Also, should JsonbDeepContains does
> same fast check when it deals with nested objects?
Attached patch implements something s
On 8/21/14 4:28 PM, Fabien COELHO wrote:
> I'm fine with "$(missing)" or whatever else that provides a clear message.
I've committed the $(missing) use separately, and rebased this patch on
top of that.
>From cb2787b2473186239eb23e7320654513df8e8fb7 Mon Sep 17 00:00:00 2001
From: Peter Eisentraut
Amit Kapila writes:
> Yes, it was failing only on windows. Today when I further tried to
> look into the issue, I found that if I rebuild plpgsql, it didn't occurred.
> So the conclusion is that it occurred due to build mismatch, however I
> am not sure why a rebuild of plpgsql is required for th
On Sat, Sep 13, 2014 at 09:50:55PM -0300, Arthur Silva wrote:
> On Sat, Sep 13, 2014 at 1:55 PM, Tom Lane wrote:
>
> > Andres Freund writes:
> > > On 2014-09-13 08:52:33 +0300, Ants Aasma wrote:
> > >> On Sat, Sep 13, 2014 at 6:59 AM, Arthur Silva
> > wrote:
> > >>> That's not entirely true. CR
On Sat, Sep 13, 2014 at 10:27 PM, k...@rice.edu wrote:
> On Sat, Sep 13, 2014 at 09:50:55PM -0300, Arthur Silva wrote:
> > On Sat, Sep 13, 2014 at 1:55 PM, Tom Lane wrote:
> >
> > > Andres Freund writes:
> > > > On 2014-09-13 08:52:33 +0300, Ants Aasma wrote:
> > > >> On Sat, Sep 13, 2014 at 6:
On Sat, Sep 13, 2014 at 10:27 PM, k...@rice.edu wrote:
>> Here're the results running the test program on my i5-4200M
>>
>> crc sb8: 90444623
>> elapsed: 0.513688s
>> speed: 1.485220 GB/s
>>
>> crc hw: 90444623
>> elapsed: 0.048327s
>> speed: 15.786877 GB/s
>>
>> xxhash: 7f4a8d5
>> elapsed: 0.1821
On Fri, Sep 12, 2014 at 2:19 PM, Alexander Korotkov
wrote:
> Actually, higher cardinality skip columns is better. Sorting of smaller
> groups is faster than sorting larger groups of same size. Also, with smaller
> groups you achieve limit more accurate (in average), i.e. sort smaller
> amount of t
Some quick comments on partial-sort-basic-2.patch:
> *** a/src/include/utils/tuplesort.h
> --- b/src/include/utils/tuplesort.h
> ***
> *** 24,29
> --- 24,30
> #include "executor/tuptable.h"
> #include "fmgr.h"
> #include "utils/relcache.h"
> + #include "utils/sortsuppor
On Fri, Sep 12, 2014 at 11:55 AM, Amit Kapila
wrote:
> On Thu, Sep 11, 2014 at 4:31 PM, Andres Freund
wrote:
> > On 2014-09-10 12:17:34 +0530, Amit Kapila wrote:
> > > +++ b/src/backend/postmaster/bgreclaimer.c
> >
> > A fair number of comments in that file refer to bgwriter...
>
> Will fix.
Fix
On 14/09/14 05:36, Rohit Goyal wrote:
Hi All,
I want to work on the code of intermediate dataset of select and update
query.
For example.
Rohit's salary has been updated 4 times, so it has 4 different version
of salary.
I want to select salary of person named Rohit. Now suppose , in
intermed
27 matches
Mail list logo
