On Sat, February 9, 2013 06:24, Peter Eisentraut wrote:
psql: Improve expanded print output in tuples-only mode
When there are zero result rows, in expanded mode, (No rows) is
printed. So far, there was no way to turn this off. Now, when
tuples-only mode is turned on, nothing is printed in
Hello
In Czech discussion group was reported performance regression of CTE
query. I wrote a test, when I can show it.
Execution on 9.2, 9.3 is about 9 sec, on 8.4, 9.1 is about 30ms with
default work_mem ='1MB'
optimal plan (8.4)
QUERY PLAN
I might be confused here, but I think the point is that if you pass
true as the third argument to set_config, the setting lasts only for
the duration of the current transaction, like SET LOCAL. Which I
think solves your problem.
Yes, but at the end of transaction it is reset to the value it
On 8 February 2013 10:23, Magnus Hagander mag...@hagander.net wrote:
to solve two problems:
1. maximize the efficiency of existing reviewer time
2. make tooling not be an obstacle to getting new reviewers
I think you are missing a fundamental part in this - which is 0.
don't negatively
Hi!
On Mon, Dec 17, 2012 at 2:42 PM, Jeff Davis pg...@j-davis.com wrote:
I have attached a patch with some significant edits.
* In your patch, there was still an inconsistency between the comment
for bounds_adjacent and the code. I refactored it to ensure it always
takes the upper bound as
2013/1/31 Pavel Stehule pavel.steh...@gmail.com:
I am sending rewritten code
Nice. I think this will be very useful, and it looks like it now
supports everything that printf() does for %s format specifiers, and
it's good that %I and %L behave the same. Also the code is looking
cleaner.
It
On Sun, Jun 24, 2012 at 1:36 PM, Cédric Villemain ced...@2ndquadrant.comwrote:
Le samedi 23 juin 2012 02:47:15, Josh Berkus a écrit :
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
Recently I have started getting these confirmations for every email I send
to the mailing lists. I think it's related to the fact that I recently
switched to using a new email address.
How can I turn these notifications off?
-- Forwarded message --
From:
It's in your personal majordomo settings. I don't think it's related
to that at all, but it's a flag you set on your subscription, so
perhaps you set it by mistake.
You shold be able to set it from https://mail.postgresql.org. The
setting you're looking for is ackpost, and you'll want to turn it
On 9 February 2013 15:24, Magnus Hagander mag...@hagander.net wrote:
It's in your personal majordomo settings. I don't think it's related
to that at all, but it's a flag you set on your subscription, so
perhaps you set it by mistake.
Then I must have set it by mistake too, when I recently
On Sat, Feb 9, 2013 at 4:31 PM, Peter Geoghegan
peter.geoghega...@gmail.com wrote:
On 9 February 2013 15:24, Magnus Hagander mag...@hagander.net wrote:
It's in your personal majordomo settings. I don't think it's related
to that at all, but it's a flag you set on your subscription, so
perhaps
I tried the lists page and disabled the 'selfcopy' since the 'ackpot' was
kinda hidden under the mailing list names. I have updated the settings
again to disable ackpost, and enable the selfcopy. This email will be test
if that worked.
BTW, I hope I understand what selfcopy is: send a copy to
of XXX
comments. I'll add it to the next commitfest.
Regards,
Mark
add_spigettypmod-20130209.diff
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Josh Hansen josh.han...@zonarsystems.com writes:
We've been seeing these same messages flying by our logs for years:
2012-12-13 22:28:07 GMT LOG: picksplit method for column 2 of index
xxx_idx doesn't support secondary split
I see from the linked message that Tom Lane made the
On Sun, Jan 13, 2013 at 07:01:07PM -0500, Noah Misch wrote:
On Sun, Jan 13, 2013 at 05:46:12PM -0500, Tom Lane wrote:
Marko Kreen mark...@gmail.com writes:
On Fri, Dec 21, 2012 at 10:27 PM, Noah Misch n...@leadboat.com wrote:
How about instead calling RAND_cleanup() after each backend
2013/2/9 Dean Rasheed dean.a.rash...@gmail.com:
2013/1/31 Pavel Stehule pavel.steh...@gmail.com:
I am sending rewritten code
Nice. I think this will be very useful, and it looks like it now
supports everything that printf() does for %s format specifiers, and
it's good that %I and %L behave
This is not entirely unrelated to the discussions about allowing
broader use of automatic casting server-side. It seems to me that
on one side of the argument is the idea that strict typing reduces
bugs and doesn't lead to problems with ambiguity, especially as
things change; and on the
On Tue, Feb 5, 2013 at 2:31 PM, Tomas Vondra t...@fuzzy.cz wrote:
We do not already have this. There is no relevant spec. I can't see
how this could need pg_dump support (but what about pg_upgrade?)
pg_dump - no
pg_upgrage - IMHO it should create the pg_stat directory. I don't think
it
On 09-02-2013 13:45, Gurjeet Singh wrote:
BTW, I hope I understand what selfcopy is: send a copy to yourself. Why would
that be turned on by default?
If you want to reply to yourself...
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria,
I've spent the afternoon reading and documenting gistsplit.c, and
finally feel like I understand what's going on in there, particularly
with respect to the secondary-split logic of log-spam infamy. I'll be
committing the results of that in a bit, but meanwhile: what I now
realize is that the
Magnus Hagander escribió:
On Sat, Feb 9, 2013 at 4:31 PM, Peter Geoghegan
peter.geoghega...@gmail.com wrote:
On 9 February 2013 15:24, Magnus Hagander mag...@hagander.net wrote:
It's in your personal majordomo settings. I don't think it's related
to that at all, but it's a flag you set on
On Saturday, February 09, 2013 9:03 AM Tom Lane wrote:
Amit kapila amit.kap...@huawei.com writes:
if (!is_projection_capable_plan(result_plan)
compare_tlist_exprs(sub_tlist, result_plan-targetlist) )
Sorry, the check I suggested in last mail should be as below:
if
Folks,
Per suggestions and lots of help from Andrew Gierth, please find
attached a patch to clean up the call sites for FuncCall nodes, which
I'd like to expand centrally rather than in each of the 37 (or 38, but
I only redid 37) places where it's called. The remaining one is in
23 matches
Mail list logo