Hello.
The attached ugly patch does it. We seem should put NO_LOCALE=1
on the 'make check' command line for the encodings not compatible
with the environmental locale, although it looks work.
+REGRESS_LC0 = $(subst .sql,,$(shell cd sql; ls plperl_lc_$(shell echo
snip.
Hrm, that's quite
Andres Freund Sent: Thursday, June 21, 2012 5:11 PM
4.)
Log enough information in the walstream to make decoding possible using
only
the walstream.
What I understood is that enough information is catalog data. Is that right
or something else?
Advantages:
* Decoding can optionally be done
On 21 June 2012 12:41, Andres Freund and...@2ndquadrant.com wrote:
2.)
Keep the decoding site up2date by replicating the catalog via normal HS
recovery
mechanisms.
Advantages:
* most of the technology is already there
* minimal overhead (space, performance)
* no danger of out of sync
Hello.
Renaming ret to quoted and str to ret as the patch attached might
make it easily readable.
I think I'm going to refrain from this because it will be more painful
to backpatch.
I've felt hesitation to do so, too.
The new patch is indeed avoid leaks although which does not lasts
On Thu, 2012-06-14 at 02:56 +0400, Alexander Korotkov wrote:
Hackers,
attached patch implements quad-tree on ranges. Some performance
results in comparison with current GiST indexing.
Index creation is slightly slower. Probably, it need some
investigation. Search queries on SP-GiST use
On Friday, June 22, 2012 12:23:57 AM Peter Geoghegan wrote:
On 20 June 2012 14:38, Andres Freund and...@2ndquadrant.com wrote:
It incurs a rather high performance overhead due to added memory
allocations and added pointer indirections. Thats fine for most of the
current users of the List
On Friday, June 22, 2012 02:04:02 AM Tom Lane wrote:
Peter Geoghegan pe...@2ndquadrant.com writes:
All of the less popular compilers we support we support precisely
because they pretend to be GCC, with the sole exception, as always, of
the Microsoft product, in this case MSVC.
This is
Based on the discussion and suggestions in this mail chain, following features
can be implemented:
1. To compute the value of max LSN in data pages based on user input whether he
wants it for an individual file,
a particular directory or whole database.
2a. To search the available WAL files
Hi,
On Friday, June 22, 2012 08:48:41 AM Simon Riggs wrote:
On 21 June 2012 12:41, Andres Freund and...@2ndquadrant.com wrote:
2.)
Keep the decoding site up2date by replicating the catalog via normal HS
recovery
mechanisms.
Advantages:
* most of the technology is already there
*
On Jun22, 2012, at 06:32 , D'Arcy Cain wrote:
So I have my type working now but I had to create a new C function
that take the opposite argument order. Seems redundant but I could
not see a better way.
There isn't. Postgres itself contains a huge number of such functions,
e.g. for every *lt()
Leon Smith leon.p.sm...@gmail.com writes:
It's not clear to me that this is even a solvable problem without modifying
the schema to include both a taken and a finished processing state,
and then letting elements be re-delievered after a period of time.
You maybe should have a look at PGQ from
On Wed, Jun 20, 2012 at 9:23 AM, Ryan Kelly rpkell...@gmail.com wrote:
I had trouble finding what operators arrays supported or which ones
had index support or even determining that arrays could be indexed from
the documentation from the array data type. So, patch.
Yeah, I agree that the
On Thu, Jun 21, 2012 at 3:44 AM, Tatsuo Ishii is...@postgresql.org wrote:
On Wed, Jun 20, 2012 at 4:04 AM, Tatsuo Ishii is...@postgresql.org wrote:
Currently pgbench -i prints following message every 10k tuples created.
fprintf(stderr, %d tuples done.\n, j);
I think
On Thu, Jun 21, 2012 at 10:25 AM, Simon Riggs si...@2ndquadrant.com wrote:
On 21 June 2012 15:00, Tom Lane t...@sss.pgh.pa.us wrote:
Simon Riggs si...@2ndquadrant.com writes:
On 21 June 2012 08:30, Peter Eisentraut pete...@gmx.net wrote:
Nonetheless, it would be a good idea to prune the TODO
On Thursday, June 21, 2012 05:40:08 PM Andres Freund wrote:
On Thursday, June 21, 2012 03:56:54 PM Florian Pflug wrote:
On Jun21, 2012, at 13:41 , Andres Freund wrote:
3b)
Ensure that enough information in the catalog remains by fudging the
xmin horizon. Then reassemble an appropriate
On 22 June 2012 14:15, Robert Haas robertmh...@gmail.com wrote:
Rather, we all like to believe
that our own ideas are awesome. This is frequently true, but not so
frequently as we like to believe.
Hmm, for me, awesome has nothing to do with it. I strive to produce
useful features that
On Wed, Jun 20, 2012 at 12:24 PM, John Lumby johnlu...@hotmail.com wrote:
An INSERT which has a RETURNING clause and which is to be rewritten based
on
a rule will be accepted if the rule is an unconditional DO INSTEAD.
In general I believe unconditional means no WHERE clause, but
On Sat, Feb 4, 2012 at 8:18 PM, Noah Misch n...@leadboat.com wrote:
On Sat, Feb 04, 2012 at 03:41:27PM -0800, Jeff Davis wrote:
On Sat, 2012-01-28 at 13:18 -0500, Tom Lane wrote:
Yeah. Personally I would be sad if initdb got noticeably slower, and
I've never seen or heard of a failure that
I am not convinced that it's a good idea to wake up every walsender
every time we do XLogInsert(). XLogInsert() is a super-hot code path,
and adding more overhead there doesn't seem warranted. We need to
replicate commit, commit prepared, etc. quickly, by why do we need to
worry about a
On Tue, Jun 19, 2012 at 5:41 AM, Etsuro Fujita
fujita.ets...@lab.ntt.co.jp wrote:
I'm confused by this remark, because surely the query planner does it this
way only if there's no LIMIT. When there is a LIMIT, we choose based on
the startup cost plus the estimated fraction of the total cost we
Andres Freund and...@2ndquadrant.com writes:
On Friday, June 22, 2012 12:23:57 AM Peter Geoghegan wrote:
Why are you using the stdlib's assert.h? Why have you used the
NDEBUG macro rather than USE_ASSERT_CHECKING? This might make sense if
the header was intended to live in port, but it isn't,
On Friday, June 22, 2012 04:09:59 PM Robert Haas wrote:
I am not convinced that it's a good idea to wake up every walsender
every time we do XLogInsert(). XLogInsert() is a super-hot code path,
and adding more overhead there doesn't seem warranted. We need to
replicate commit, commit
On Friday, June 22, 2012 04:18:35 PM Tom Lane wrote:
Andres Freund and...@2ndquadrant.com writes:
On Friday, June 22, 2012 12:23:57 AM Peter Geoghegan wrote:
Why are you using the stdlib's assert.h? Why have you used the
NDEBUG macro rather than USE_ASSERT_CHECKING? This might make sense if
On Fri, Jun 22, 2012 at 10:19 AM, Andres Freund and...@2ndquadrant.com wrote:
On Friday, June 22, 2012 04:09:59 PM Robert Haas wrote:
I am not convinced that it's a good idea to wake up every walsender
every time we do XLogInsert(). XLogInsert() is a super-hot code path,
and adding more
Andres Freund and...@2ndquadrant.com writes:
Oh, I and Peter weren't talking about the pg_list.h stuff, it was about my
'embedded list' implementation which started this subthread. The
pg_list.h/list.c stuff isn't problematic as far as I have seen in profiles;
its checks are pretty simple
On Friday, June 22, 2012 04:34:33 PM Robert Haas wrote:
On Fri, Jun 22, 2012 at 10:19 AM, Andres Freund and...@2ndquadrant.com
wrote:
On Friday, June 22, 2012 04:09:59 PM Robert Haas wrote:
I am not convinced that it's a good idea to wake up every walsender
every time we do XLogInsert().
On Friday, June 22, 2012 04:41:20 PM Tom Lane wrote:
Andres Freund and...@2ndquadrant.com writes:
Oh, I and Peter weren't talking about the pg_list.h stuff, it was about
my 'embedded list' implementation which started this subthread. The
pg_list.h/list.c stuff isn't problematic as far as I
Kyotaro HORIGUCHI horiguchi.kyot...@lab.ntt.co.jp writes:
+REGRESS_LC0 = $(subst .sql,,$(shell cd sql; ls plperl_lc_$(shell echo
Hrm, that's quite cute. I dunno if there is a more cannon way of doing
the above-- but it seems to work. I'm not sure this regression test is
worth it. I'm thinking
Andres Freund and...@2ndquadrant.com writes:
On Friday, June 22, 2012 04:41:20 PM Tom Lane wrote:
Well, so does list.c, so I'd expect the performance risks to be similar.
I don't think list.c does so:
Huh, OK. I seem to remember that the original version actually chased
down the whole list
On Fri, Jun 22, 2012 at 10:45 AM, Andres Freund and...@2ndquadrant.com wrote:
the likelihood of that as you know.
Hmm, well, I guess. I'm still not sure I really understand what
benefit we're getting out of this. If we lose a few WAL records for
an uncommitted transaction, who cares? That
On 12-06-22 07:11 AM, Florian Pflug wrote:
On Jun22, 2012, at 06:32 , D'Arcy Cain wrote:
So I have my type working now but I had to create a new C function
that take the opposite argument order. Seems redundant but I could
not see a better way.
There isn't. Postgres itself contains a huge
On Fri, Jun 22, 2012 at 5:25 AM, Amit Kapila amit.kap...@huawei.com wrote:
Based on the discussion and suggestions in this mail chain, following
features can be implemented:
1. To compute the value of max LSN in data pages based on user input whether
he wants it for an individual file,
a
D'Arcy Cain da...@druid.net writes:
... The issue here is that the operator is SC but
the args are different types.
Well, that's a weird way of defining self-commutating, but ...
It would be nice if there was a way
to automatically generate code that reverses arguments. Maybe such
a thing
On 06/22/2012 09:45 AM, Simon Riggs wrote:
On 22 June 2012 14:15, Robert Haasrobertmh...@gmail.com wrote:
Rather, we all like to believe
that our own ideas are awesome. This is frequently true, but not so
frequently as we like to believe.
Hmm, for me, awesome has nothing to do with it. I
On Wed, Jun 20, 2012 at 4:36 PM, Dimitri Fontaine
dimi...@2ndquadrant.fr wrote:
Robert Haas robertmh...@gmail.com writes:
1. I still think we ought to get rid of the notion of BEFORE or AFTER
(i.e. pg_event_trigger.evttype) and just make that detail part of the
event name (e.g.
On 12-06-22 11:36 AM, Tom Lane wrote:
D'Arcy Cainda...@druid.net writes:
The thing is that either of those approaches is hugely more expensive
than just providing a second C function. It costs probably thousands
of cycles to inline that SQL function, each time it's used in a query.
I assumed
On Friday, June 22, 2012 04:59:45 PM Robert Haas wrote:
On Fri, Jun 22, 2012 at 10:45 AM, Andres Freund and...@2ndquadrant.com
wrote:
the likelihood of that as you know.
Hmm, well, I guess. I'm still not sure I really understand what
benefit we're getting out of this. If we lose a
On 20-06-2012 17:40, Marko Kreen wrote:
On Wed, Jun 20, 2012 at 10:05 PM, Florian Pflug f...@phlo.org wrote:
I'm starting to think that relying on SSL/TLS for compression of
unencrypted connections might not be such a good idea after all. We'd
be using the protocol in a way it quite clearly
It has now happened at least twice that builds on spponbill started to
fail after it failed during ECPGcheck:
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=spoonbilldt=2012-06-19%2023%3A00%3A04
the first failure was:
Stefan Kaltenbrunner ste...@kaltenbrunner.cc writes:
It has now happened at least twice that builds on spponbill started to
fail after it failed during ECPGcheck:
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=spoonbilldt=2012-06-19%2023%3A00%3A04
the first failure was:
On 06/22/2012 02:34 PM, Tom Lane wrote:
Stefan Kaltenbrunnerste...@kaltenbrunner.cc writes:
It has now happened at least twice that builds on spponbill started to
fail after it failed during ECPGcheck:
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=spoonbilldt=2012-06-19%2023%3A00%3A04
On Fri, Jun 22, 2012 at 2:16 PM, Stefan Kaltenbrunner
ste...@kaltenbrunner.cc wrote:
sending a manual kill -15 to either of them does not seem to make them
exit either...
I did some further investiagations with robert on IM but I don't think
he has any further ideas other than that I have a
On Friday, June 22, 2012 08:51:55 PM Robert Haas wrote:
On Fri, Jun 22, 2012 at 2:16 PM, Stefan Kaltenbrunner
ste...@kaltenbrunner.cc wrote:
sending a manual kill -15 to either of them does not seem to make them
exit either...
I did some further investiagations with robert on IM but I
On 06/22/2012 08:34 PM, Tom Lane wrote:
Stefan Kaltenbrunner ste...@kaltenbrunner.cc writes:
It has now happened at least twice that builds on spponbill started to
fail after it failed during ECPGcheck:
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=spoonbilldt=2012-06-19%2023%3A00%3A04
On Friday, June 22, 2012 03:22:03 PM Andres Freund wrote:
On Thursday, June 21, 2012 05:40:08 PM Andres Freund wrote:
On Thursday, June 21, 2012 03:56:54 PM Florian Pflug wrote:
On Jun21, 2012, at 13:41 , Andres Freund wrote:
3b)
Ensure that enough information in the catalog remains
Stefan Kaltenbrunner ste...@kaltenbrunner.cc writes:
On 06/22/2012 08:34 PM, Tom Lane wrote:
Still, panther is NetBSD so there may be some general BSD flavor to
whatever's going on here.
yeah the threading reference was mostly because all backtraces contain
references to threading libs and
Andres Freund and...@2ndquadrant.com writes:
On Friday, June 22, 2012 08:51:55 PM Robert Haas wrote:
I remarked to Stefan that the symptoms seem consistent with the idea
that the children have signals blocked. But I don't know how that
could happen.
You cannot block sigkill.
sigterm is at
Robert Haas robertmh...@gmail.com writes:
It's not before/after anymore, but rather addon/replace if you will. I
kept the INSTEAD OF keyword for the replace semantics, that you've been
asking me to keep IIRC, with security policy plugins as a use case.
Now we can of course keep those
Robert Haas robertmh...@gmail.com writes:
73%? I think it's got about 15% overlap.
83.7% of stats are wrong. This one included.
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
--
Sent via pgsql-hackers mailing list
On 06/22/2012 09:39 PM, Tom Lane wrote:
Andres Freund and...@2ndquadrant.com writes:
On Friday, June 22, 2012 08:51:55 PM Robert Haas wrote:
I remarked to Stefan that the symptoms seem consistent with the idea
that the children have signals blocked. But I don't know how that
could happen.
I wrote:
I believe the right fix for both of these issues is to add knowledge of
the section concept to the topological sort logic, so that an ordering
that puts POST_DATA before DATA or PRE_DATA after DATA is considered to
be a dependency-ordering violation. One way to do that is to add
Stefan Kaltenbrunner ste...@kaltenbrunner.cc writes:
On 06/22/2012 09:39 PM, Tom Lane wrote:
(Hey Stefan, is there a way on BSD to check a process's signals-blocked
state from outside? If so, next time this happens you should try to
determine the children's signal state.)
with help from
On 06/22/2012 11:02 PM, Tom Lane wrote:
Stefan Kaltenbrunner ste...@kaltenbrunner.cc writes:
On 06/22/2012 09:39 PM, Tom Lane wrote:
(Hey Stefan, is there a way on BSD to check a process's signals-blocked
state from outside? If so, next time this happens you should try to
determine the
Stefan Kaltenbrunner ste...@kaltenbrunner.cc writes:
PID PENDING CAUGHT IGNORED BLOCKED COMMAND
12480 20004004 34084005 c942b002 fffefeff postgres: writer process
9841 20004004 34084007 c942b000 fffefeff postgres: wal writer process
this seems to be SIGUSR1,SIGTERM and SIGQUIT
OK, I
oh, and just for comparison's sake, what do the postmaster's signal
masks look like?
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Fri, Jun 22, 2012 at 2:57 PM, Andres Freund and...@2ndquadrant.com wrote:
On Friday, June 22, 2012 08:51:55 PM Robert Haas wrote:
On Fri, Jun 22, 2012 at 2:16 PM, Stefan Kaltenbrunner
ste...@kaltenbrunner.cc wrote:
sending a manual kill -15 to either of them does not seem to make them
On Fri, Jun 22, 2012 at 12:28 PM, D'Arcy Cain da...@druid.net wrote:
I doubt that an auto reverse the arguments facility would be very
much cheaper. You could maybe argue that the aggregated maintenance
and space costs of all the commutator-pair functions are enough to
justify having some
The biggest problem with pgfincore from my point of view is that it
only works under Linux, whereas I use a MacOS X machine for my
development, and there is also Windows to think about. Even if that
were fixed, though, I feel we ought to have something in the core
distribution. This patch
http://pgolub.wordpress.com/2012/06/22/backward-compatibility-never-heard-of-it
If we had stable system views for all database objects (stable as in we
just append to them), then refactoring our system tables wouldn't break
things for our users. Just sayin'.
(and don't tell me about
On Fri, Jun 22, 2012 at 10:04:23AM -0400, Robert Haas wrote:
On Sat, Feb 4, 2012 at 8:18 PM, Noah Misch n...@leadboat.com wrote:
If we add fsync calls to the initdb process, they should cover the entire
data
directory tree. ?This patch syncs files that initdb.c writes, but we ought
to
On Fri, Jun 22, 2012 at 9:30 PM, Josh Berkus j...@agliodbs.com wrote:
http://pgolub.wordpress.com/2012/06/22/backward-compatibility-never-heard-of-it
If we had stable system views for all database objects (stable as in we
just append to them), then refactoring our system tables wouldn't break
On 12-06-22 07:09 PM, Robert Haas wrote:
I think DirectionFunctionCall2 is what you want.
Can you elaborate? I could not find a single hit in Google or the
documentation search on the PG site and it does not appear anywhere
in the source distribution.
--
D'Arcy J.M. Cain da...@druid.net
D'Arcy Cain da...@druid.net writes:
On 12-06-22 07:09 PM, Robert Haas wrote:
I think DirectionFunctionCall2 is what you want.
Can you elaborate? I could not find a single hit in Google or the
documentation search on the PG site and it does not appear anywhere
in the source distribution.
He
On Fri, Jun 22, 2012 at 9:05 PM, Robert Haas robertmh...@gmail.com wrote:
On Fri, Jun 22, 2012 at 9:30 PM, Josh Berkus j...@agliodbs.com wrote:
http://pgolub.wordpress.com/2012/06/22/backward-compatibility-never-heard-of-it
If we had stable system views for all database objects (stable as in
64 matches
Mail list logo
