Now I'm trying to tackle the covert-channel problem that Korotkov
pointed out at upthread.
The attached patch works almost well. It prevents to print number of
rows being filtered
if the target plan node is under sub-query with security-barrier
attribute; because row-
level security feature is
Oleg,
Unfortunately the archives seem to miss attached files. I love to see
the attached files because they are logo images. Any idea?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
Tatsuo,
I have emails even from 1995 !
On Fri, Sep 20, 2013 at 5:14 PM, Andres Freund and...@2ndquadrant.com wrote:
Hi,
On 2013-09-19 11:44:34 -0400, Robert Haas wrote:
On Wed, Sep 18, 2013 at 1:42 PM, Andres Freund and...@2ndquadrant.com
wrote:
--- /dev/null
+++ b/src/backend/storage/ipc/dsm.c
+#define
Dear Noah,
Thanks for your answers and remarks,
[...]
I'll split some part of the patch where there is no coupling, but I do
not want to submit conflicting patches.
Those benefits aren't compelling enough to counterbalance the risk of
gettimeofday() overhead affecting results. (Other
Hi,
I don't have time to answer the other emails today (elections,
climbing), but maybe you could clarify the below?
On 2013-09-21 17:07:11 -0700, Peter Geoghegan wrote:
On Sun, Sep 15, 2013 at 8:23 AM, Andres Freund and...@2ndquadrant.com wrote:
I'll find it very difficult to accept any
It is also printed without --rate. There is a if above because there is
one report with lag (under --rate), and one without.
The code I quoted is for the final report in printResults(), and that only
shows latency mean/stddev when using --rate. The progress reporting in
threadRun() does have
On 09/20/2013 01:59 PM, Fabien COELHO wrote:
Here is a review of the pg_sleep(INTERVAL) patch version 1:
Thank you for looking at it.
- the new function is *not* tested anywhere!
I would suggest simply to replace some pg_sleep(int) instances
by corresponding pg_sleep(interval)
Hello,
There is no pg_sleep(text) function and the cast is unknown-double
precision.
My mistake.
As I understand it, pg_sleep('12') currently works and would not anymore
once your patch is applied. That is the concern raised by Robert Haas.
ISTM that providing pg_sleep(TEXT) cleanly
On Fri, Sep 20, 2013 at 10:33 PM, Samrat Revagade
revagade.sam...@gmail.com wrote:
On Fri, Sep 20, 2013 at 3:40 PM, Sameer Thakur samthaku...@gmail.com
wrote:
Attached patch combines documentation patch and source-code patch.
I have had a stab at reviewing the documentation. Have a
Split 1 of the initial submission.
pgbench: minor update of documentation help message.
Use NUM in help message for homogeneity with other options. The target
*start* time of the transaction is set by the stochastic process which is
doing the throttling (--rate), not the end time.
--
Split 2 of the initial submission
pgbench: reduce and compensate throttling underestimation bias.
This is a consequence of relying on an integer random generator,
which allow to ensure that delays inserted stay reasonably in
range of the target average delay.
The bias was about 0.5% with 1000
Split 3 of the initial submission, which actually deal with data measured
and reported on stderr under various options.
This version currently takes into account many comments by Noah Mish. In
particular, the default no report behavior under benchmarking is not
changed, although I really
On Sun, Sep 22, 2013 at 01:17:52PM +0530, Amit Kapila wrote:
On Fri, Sep 20, 2013 at 5:14 PM, Andres Freund and...@2ndquadrant.com wrote:
On 2013-09-19 11:44:34 -0400, Robert Haas wrote:
On Wed, Sep 18, 2013 at 1:42 PM, Andres Freund and...@2ndquadrant.com
wrote:
+ /* Create or
Fabien,
As long as you're hacking pgbench output, what about offering a JSON
option instead of the text output? I'm working on automating pgbench
performance testing, and having the output in a proper delimited format
would be really helpful.
--
Josh Berkus
PostgreSQL Experts Inc.
Hi
fix a small memory leak in guc-file.l ParseConfigFile
AbsoluteConfigLocation() return a strdup string but it's never free or
referenced outside ParseConfigFile
Courtesy Valgrind and Noah Misch MEMPOOL work.
Regards
Didier
memory_leak_in_parse_config_file.patch
Description: Binary data
--
Hi,
I've reviewed the v6 of the numeric optimize patch
(http://www.postgresql.org/message-id/CAFj8pRDQhG7Pqmf8XqXY0PnHfakkPQLPHnoRLJ_=ekfsboa...@mail.gmail.com),
as Pavel did some hacking on the patch and asked me to do the review.
The patch seems fine to me, the following comments are mostly
On Sun, Sep 22, 2013 at 2:10 AM, Andres Freund and...@2ndquadrant.com wrote:
I can't follow here. Why does e.g. the promise tuple approach bloat more
than the subxact example?
The protocol is roughly:
1) Insert index pointer containing an xid to be waiting upon instead of
the target tid
On 2013-09-22 12:54:57 -0700, Peter Geoghegan wrote:
On Sun, Sep 22, 2013 at 2:10 AM, Andres Freund and...@2ndquadrant.com wrote:
I can't follow here. Why does e.g. the promise tuple approach bloat more
than the subxact example?
The protocol is roughly:
1) Insert index pointer containing
Tatsuo,
you could ask Marc about archives. Probably he has original mbox files.
Oleg
On Sun, Sep 22, 2013 at 11:18 AM, Tatsuo Ishii is...@postgresql.org wrote:
Oleg,
Unfortunately the archives seem to miss attached files. I love to see
the attached files because they are logo images. Any
PostgreSQL has a very powerful possibilities for storing any kind of
encoding. So maybe it makes sense to add the ENCODING as another column
property, the same way a COLLATION was added?
Some other people in this community suggested that. ANd the SQL standard
suggests the same --
On 09/20/2013 12:55 PM, Heikki Linnakangas wrote:
Hi,
Prompted by Andres Freund's comments on my Freezing without Write I/O
patch, I realized that there's there's an existing bug in the way
predicate locking handles freezing (or rather, it doesn't handle it).
When a tuple is
On Sun, Sep 22, 2013 at 1:39 PM, Andres Freund and...@2ndquadrant.com wrote:
I still fail to see how that's relevant. For every index there's two
things that can happen:
a) there's a conflicting tuple. In that case we can fail at that
point/convert to an update. No Bloat.
Well, yes - if the
Hello, hackers.
Here is the patch that introduces kNN search for cubes with euclidean, taxicab
and chebyshev distances.
Following distance operators introduced:
# taxicab distance
- euclidean distance
= chebyshev distance
For example:
SELECT * FROM objects ORDER BY objects.coord -
2013/9/22 Jaime Casanova ja...@2ndquadrant.com
El 21/09/2013 17:16, Jaime Casanova ja...@2ndquadrant.com escribió:
On Fri, Sep 20, 2013 at 5:17 AM, Marko Tiikkaja ma...@joh.to wrote:
On 9/20/13 12:09 PM, Amit Khandekar wrote:
On 16 September 2013 03:43, Marko Tiikkaja ma...@joh.to
On Mon, Sep 23, 2013 at 12:34 AM, Noah Misch n...@leadboat.com wrote:
On Sun, Sep 22, 2013 at 01:17:52PM +0530, Amit Kapila wrote:
On Fri, Sep 20, 2013 at 5:14 PM, Andres Freund and...@2ndquadrant.com
wrote:
On 2013-09-19 11:44:34 -0400, Robert Haas wrote:
On Wed, Sep 18, 2013 at 1:42 PM,
On Fri, Sep 20, 2013 at 9:48 AM, Amit Kapila amit.kapil...@gmail.com wrote:
On Thu, Sep 19, 2013 at 2:48 PM, Andres Freund and...@2ndquadrant.com wrote:
On 2013-09-18 11:02:50 +0200, Andres Freund wrote:
On 2013-09-18 11:55:24 +0530, Amit Kapila wrote:
I think that ship has long since
Hello Josh,
As long as you're hacking pgbench output, what about offering a JSON
option instead of the text output? I'm working on automating pgbench
performance testing, and having the output in a proper delimited format
would be really helpful.
I'm more a grep | cut | ... person, but I do
27 matches
Mail list logo