On Fri, Sep 12, 2014 at 11:55 AM, Amit Kapila amit.kapil...@gmail.com
wrote:
On Thu, Sep 11, 2014 at 4:31 PM, Andres Freund and...@2ndquadrant.com
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
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
On Fri, Sep 12, 2014 at 11:09 PM, Gregory Smith gregsmithpg...@gmail.com
wrote:
This looks like it's squashed one of the very fundamental buffer
scaling issues though; well done Amit.
Thanks.
I'll go back to my notes and try to recreate the pathological cases
that plagued both the 8.3 BGW
On 14/09/14 19:00, Amit Kapila wrote:
On Fri, Sep 12, 2014 at 11:09 PM, Gregory Smith
gregsmithpg...@gmail.com mailto:gregsmithpg...@gmail.com wrote:
This looks like it's squashed one of the very fundamental buffer
scaling issues though; well done Amit.
Thanks.
I'll go back to my notes
On Sunday, September 14, 2014, Mark Kirkwood mark.kirkw...@catalyst.net.nz
wrote:
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
Hello Peter,
I've committed the $(missing) use separately,
That was simple and is a definite improvement.
Tiny detail: the new DBTOEPUB macro definition in src/Makefile.global.in
lacks another tab to be nicely aligned with the other definitions.
and rebased this patch on top of that.
On 14/09/14 19:25, Atri Sharma wrote:
On Sunday, September 14, 2014, Mark Kirkwood
mark.kirkw...@catalyst.net.nz mailto:mark.kirkw...@catalyst.net.nz
wrote:
On 14/09/14 05:36, Rohit Goyal wrote:
Hi All,
I want to work on the code of intermediate dataset of select and
Hi Mark,
On Sun, Sep 14, 2014 at 8:57 AM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz wrote:
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
On Sun, Sep 14, 2014 at 1:30 PM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz wrote:
On 14/09/14 19:25, Atri Sharma wrote:
On Sunday, September 14, 2014, Mark Kirkwood
mark.kirkw...@catalyst.net.nz mailto:mark.kirkw...@catalyst.net.nz
wrote:
On 14/09/14 05:36, Rohit Goyal wrote:
On Sun, Sep 14, 2014 at 1:30 PM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz wrote:
On 14/09/14 19:25, Atri Sharma wrote:
On Sunday, September 14, 2014, Mark Kirkwood
mark.kirkw...@catalyst.net.nz mailto:mark.kirkw...@catalyst.net.nz
wrote:
On 14/09/14 05:36, Rohit Goyal wrote:
On 14/09/14 20:24, Atri Sharma wrote:
On Sun, Sep 14, 2014 at 1:30 PM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz mailto:mark.kirkw...@catalyst.net.nz
wrote:
On 14/09/14 19:25, Atri Sharma wrote:
On Sunday, September 14, 2014, Mark Kirkwood
On 14/09/14 20:11, Rohit Goyal wrote:
Hi Mark,
On Sun, Sep 14, 2014 at 8:57 AM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz mailto:mark.kirkw...@catalyst.net.nz
wrote:
Currently in Postgres, these intermediate versions all exist -
however a given session can only see one of them.
FYI, got an initial implementation of
http://wiki.postgresql.org/wiki/HTTP_API done in Java (intended to run as a
servlet) at https://github.com/bjornharrtell/jdbc-http-server. Feedback is
welcome :)
Regards,
Björn
2014-09-03 1:19 GMT+02:00 Álvaro Hernández Tortosa a...@nosys.es:
On 02/09/14
Hi Mark Atri, :)
Thanks for reply. But, I think i confused you. I am talking about access
using indexes. So, I assume that B+ tree store key-value pair where rohit
is the key and all the versions are its value.
Another way to think is I have a secondary index on emp. name and there are
4 rohit
On 14/09/14 21:18, Rohit Goyal wrote:
Hi Mark Atri, :)
Thanks for reply. But, I think i confused you. I am talking about access
using indexes. So, I assume that B+ tree store key-value pair where
rohit is the key and all the versions are its value.
Another way to think is I have a secondary
On Thu, Sep 11, 2014 at 03:42:14PM +1000, Andrew McNamara wrote:
Anyone from down under care to remark about the actual usage of old
and new abbreviations?
About bloody time!
AEST/AEDT/etc are the official abbreviations and are commonly used.
They have been increasingly used over the last
On 09/13/2014 11:28 PM, Peter Geoghegan wrote:
Anyway, attached rough test program implements what you outline. This
is for 30,000 32 byte strings (where just the final two bytes differ).
On my laptop, output looks like this (edited to only show median
duration in each case):
Got to be careful
On 9/1/14 7:51 AM, Kyotaro HORIGUCHI wrote:
The attached patch simply changes the context for local_... to
PGC_USERSET and edits the doc.
I had this ready to commit, but then
Invent PGC_SU_BACKEND and mark log_connections/log_disconnections
that way.
was committed in the meantime.
Does
On 2014-09-13 20:27:51 -0500, k...@rice.edu wrote:
What we are looking for here is uniqueness thus better error detection. Not
avalanche effect, nor cryptographically secure, nor bit distribution.
As far as I'm aware CRC32C is unbeaten collision wise and time proven.
I couldn't find
On 9/12/14 3:13 PM, Andreas 'ads' Scherbaum wrote:
Of course a general rule how to link to WP would be nice ...
I think Wikipedia links should be avoided altogether. We can assume
that readers are technically proficient to look up general technical
concepts on their own using a reference system
Peter Eisentraut pete...@gmx.net writes:
On 9/1/14 7:51 AM, Kyotaro HORIGUCHI wrote:
The attached patch simply changes the context for local_... to
PGC_USERSET and edits the doc.
I had this ready to commit, but then
Invent PGC_SU_BACKEND and mark log_connections/log_disconnections
that
Martijn van Oosterhout klep...@svana.org writes:
On Thu, Sep 11, 2014 at 03:42:14PM +1000, Andrew McNamara wrote:
Quite likely this change will break stuff, but my feeling is more people
will be cheering than screaming.
Indeed, this has been a pain in the ass for a long long time.
It's good
On Sun, Sep 14, 2014 at 05:21:10PM +0200, Andres Freund wrote:
On 2014-09-13 20:27:51 -0500, k...@rice.edu wrote:
Also, while I understand that CRC has a very venerable history and
is well studied for transmission type errors, I have been unable to find
any research on its applicability
I added the point to polygon distance operator patch to the open
CommitFest as ready for committer and added myself as reviewer to
both of the patches.
I think that for most use cases just some operators require further sorting
and some of them not. But it could appear one day that some index
2014-09-09 7:54 GMT+02:00 Craig Ringer cr...@2ndquadrant.com:
On 09/05/2014 05:21 PM, Pavel Stehule wrote:
*shrug* Doing it in SQL would probably break more stuff. I'm trying to
contain the damage. And arguably, this is mostly only useful in
PL/PgSQL.
I've wanted assertions in SQL
On 09/14/2014 02:25 PM, Pavel Stehule wrote:
a) Isn't possible handle a assertion exception anywhere .. it enforce
ROLLBACK in 100%
b) Assertions should be disabled globally .. I am not sure, it it is a
good idea, but I can understand so some tests based on queries to data
can be performance
On Sun, Sep 14, 2014 at 10:09 PM, Emre Hasegeli e...@hasegeli.com wrote:
I added the point to polygon distance operator patch to the open
CommitFest as ready for committer and added myself as reviewer to
both of the patches.
Thanks.
Cost estimation of GiST is a big problem anyway. It
On Sun, Sep 14, 2014 at 7:37 AM, Heikki Linnakangas
hlinnakan...@vmware.com wrote:
Got to be careful to not let the compiler optimize away microbenchmarks like
this. At least with my version of gcc, the strcoll calls get optimized away,
as do the memcmp calls, if you don't use the result for
On 12 September 2014 18:19, Simon Riggs si...@2ndquadrant.com wrote:
On 12 September 2014 15:30, Tom Lane t...@sss.pgh.pa.us wrote:
After a little bit I remembered there was already a function for this.
So specifically, I'd suggest using ExecRelationIsTargetRelation()
to decide whether to
On 12 September 2014 03:56, Alvaro Herrera alvhe...@2ndquadrant.com wrote:
Thomas Munro wrote:
But to reach the case you mentioned, it would need to get past that
(xmax is not a valid transaction) but then the tuple would need to be
locked by another session before heap_lock_tuple is called a
On 18/11/13 11:50, Heikki Linnakangas wrote:
I don't think the sequence AM should be in control of 'cached'. The
caching is done outside the AM. And log_cnt probably should be passed to
the _alloc function directly as an argument, ie. the server code asks
the AM to allocate N new values in one
Em 14/09/2014 12:21, Andres Freund and...@2ndquadrant.com escreveu:
On 2014-09-13 20:27:51 -0500, k...@rice.edu wrote:
What we are looking for here is uniqueness thus better error
detection. Not
avalanche effect, nor cryptographically secure, nor bit distribution.
As far as I'm aware
El 08/09/14 13:02, Alvaro Herrera escribió:
Here's version 18. I have renamed it: These are now BRIN indexes.
I have fixed numerous race conditions and deadlocks. In particular I
fixed this problem you noted:
Heikki Linnakangas wrote:
Another race condition:
If a new tuple is inserted
On Sat, Sep 13, 2014 at 4:25 AM, Fabien COELHO coe...@cri.ensmp.fr wrote:
[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
Header comments within execTuples.c state:
* - ExecutePlan() calls ExecSelect(), which passes the result slot
* to printtup(), which uses slot_getallattrs() to extract the
* individual Datums for printing.
This isn't true, though - the function ExecSelect() no longer exists.
This is because
Peter Geoghegan p...@heroku.com writes:
Header comments within execTuples.c state:
* - ExecutePlan() calls ExecSelect(), which passes the result slot
* to printtup(), which uses slot_getallattrs() to extract the
* individual Datums for printing.
This isn't true, though - the function
On Sun, Sep 14, 2014 at 9:05 PM, Tom Lane t...@sss.pgh.pa.us wrote:
More generally, though, it seems like the header comments in execTuples.c
are not the best place to document global behavior ...
Yeah, my thoughts exactly.
--
Peter Geoghegan
--
Sent via pgsql-hackers mailing list
On 09/14/2014 09:27 AM, k...@rice.edu wrote:
Thank you for running this sample benchmark. It definitely shows that the
hardware version of the CRC is very fast, unfortunately it is really only
available on x64 Intel/AMD processors which leaves all the rest lacking.
We're talking about
On Tue, Sep 02, 2014 at 12:25:39AM -0400, Tom Lane wrote:
Noah Misch n...@leadboat.com writes:
Buildfarm member orangutan has failed chronically on both of the branches
for
which it still reports, HEAD and REL9_1_STABLE, for over two years. The
postmaster appears to jam during
39 matches
Mail list logo
