Thank you for comments.
I understand your points.
For only to read a current transaction-id, I know we just have to use
txid_current_snapshot and that is a best way, but I feel a little bit
hassle to explain columns of txid_current_snapshot for my supporting customers..
(Xmin is and Xmax
Robert,
Thank you for your response.
* Robert Haas (robertmh...@gmail.com) wrote:
On Tue, May 26, 2015 at 8:10 PM, Stephen Frost sfr...@snowman.net wrote:
I certainly welcome review from others and if there is not another
committer-level formal review before we get close on 9.5 (say, end of
Dean,
* Dean Rasheed (dean.a.rash...@gmail.com) wrote:
On 27 May 2015 at 02:42, Stephen Frost sfr...@snowman.net wrote:
Now, looking at the code, I'm actually failing to see a case where we
use the RowSecurityPolicy-policy_name.. Perhaps *that's* what we
should be looking to remove?
If
On Tue, May 26, 2015 at 08:10:04PM -0400, Stephen Frost wrote:
* Noah Misch (n...@leadboat.com) wrote:
+ /*
+ * Don't audit substatements. All the substatements we care about
should
+ * be covered by the event triggers.
+ */
+ if (context = PROCESS_UTILITY_QUERY
From: Andreas Joseph Krogh andr...@visena.com
To: pgsql-hackers@postgresql.org
Sent: Wednesday, 27 May 2015, 13:55
Subject: Re: [HACKERS] Triggers on transaction?
På onsdag 27. mai 2015 kl. 12:42:29, skrev Marko Tiikkaja ma...@joh.to:
On 5/27/15 12:39 PM, Jordan Gigov wrote:
I found myself
Simon Riggs wrote:
What I think should happen is that the command tag should vary according to
whether an INSERT or an UPDATE was performed, so we get a visible
difference without any new tags.
The problem with doing that is that the same command might have updated
some tuples and inserted
On 22 May 2015 at 00:28, Alvaro Herrera alvhe...@2ndquadrant.com wrote:
On the other hand, this was noticed because Alvaro just argued that it
*should* have a new command tag. Alvaro, where do you see the advantage?
Well, I was just skimming nearby code and noticed that CreateCommandTag
On Tue, May 26, 2015 at 04:32:42PM -0300, Alvaro Herrera wrote:
Robert Haas wrote:
But every time we pgindent, especially with slightly different
settings, we cause tools like 'git blame' to return less useful
answers. And that sucks.
I've wondered a few times whether there's a way to
On Mon, May 18, 2015 at 10:21 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Uriy Zhuravlev u.zhurav...@postgrespro.ru writes:
I have attached a patch that extends ALTER OPERATOR to support COMMUTATOR,
NEGATOR, RESTRICT and JOIN.
There are fairly significant reasons why we have not done this, based
On Wed, May 27, 2015 at 11:35 AM, Ted Toth txt...@gmail.com wrote:
I'm trying to use a newer version than is available from RH in our
custom distro but am having problems install both x86_64 and i686 rpms
because file conflicts. We have some i686 packages that use libgdal
which pulls in libpq
On Tue, May 26, 2015 at 2:46 AM, Nivedita Kulkarni
nkulka...@genius-minds.com wrote:
We have newbie to Postgresql.
Hi,
You've reached the pgsql-hackers mailing list, which is for discussion
of current development issues, problems and bugs, and proposed new
features. Questions about how to use
On Tue, May 26, 2015 at 2:50 AM, Shulgin, Oleksandr
oleksandr.shul...@zalando.de wrote:
Is it reasonable to add this patch to CommitFest now?
It's always reasonable to add a patch to the CommitFest if you would
like for it to be reviewed and avoid having it get forgotten about.
There seems to be
On 05/27/2015 02:37 PM, Robert Haas wrote:
On Tue, May 26, 2015 at 2:50 AM, Shulgin, Oleksandr
oleksandr.shul...@zalando.de wrote:
Is it reasonable to add this patch to CommitFest now?
It's always reasonable to add a patch to the CommitFest if you would
like for it to be reviewed and avoid
Andres Freund and...@anarazel.de writes:
But really, the typedef list is the minor part what annoys me about
pgindent. That it completely butchers so many constructs (e.g. function
pointer typedefs, inline asm as extreme examples) is much worse.
These are all things we might try to fix (where
Hello, my partner and me are working with the goal of improve the GEQO's
performance, we tried with Ant Colony Optimization, but it does not
improve, actually we are trying with a new variant of Genetic Algorithm,
specifically Micro-GA. This algorithm finds a better solution than GEQO
in less
http://yum.postgresql.org/9.4/redhat/rhel-6.5-x86_64/
On Wed, May 27, 2015 at 1:31 PM, Robert Haas robertmh...@gmail.com wrote:
On Wed, May 27, 2015 at 11:35 AM, Ted Toth txt...@gmail.com wrote:
I'm trying to use a newer version than is available from RH in our
custom distro but am having
On Wed, May 27, 2015 at 7:00 PM, Dan Langille d...@langille.org wrote:
Have you been to PGCon before? Do you remember the hacker lounge? Do you
remember going there to work on stuff? Do you recall anything about it?
I remember I've tried to visit it in 2012 or 2013. That time I found empty
On 05/27/2015 11:53 AM, Bruce Momjian wrote:
On Wed, May 27, 2015 at 02:31:07AM +0200, Andres Freund wrote:
But really, the typedef list is the minor part what annoys me about
pgindent. That it completely butchers so many constructs (e.g. function
pointer typedefs, inline asm as extreme
commit 4c5e060049a3714dd27b7f4732fe922090edea69
Author: Bruce Momjian br...@momjian.us
Date: Sat May 16 00:40:18 2015 -0400
pg_upgrade: force timeline 1 in the new cluster
Previously, this prevented promoted standby servers from being upgraded
because of a missing WAL history
On Wed, May 27, 2015 at 02:31:07AM +0200, Andres Freund wrote:
But really, the typedef list is the minor part what annoys me about
pgindent. That it completely butchers so many constructs (e.g. function
pointer typedefs, inline asm as extreme examples) is much worse. It's
also neigh on
Have you been to PGCon before? Do you remember the hacker lounge? Do you
remember going there to work on stuff? Do you recall anything about it?
—
Dan Langille
http://langille.org/
signature.asc
Description: Message signed with OpenPGP using GPGMail
I'm trying to use a newer version than is available from RH in our
custom distro but am having problems install both x86_64 and i686 rpms
because file conflicts. We have some i686 packages that use libgdal
which pulls in libpq which ends up in the same location in both the
x86_64 and i686
* Noah Misch (n...@leadboat.com) wrote:
The test case demonstrated a hole in GRANT auditing, and your diagnosis is
incorrect. GRANT statements aren't subject to event triggers. Selecting DDL
too, with pg_audit.log=all, does not audit the GRANT substatement.
GRANT statements are subject to
On 27 May 2015 at 15:06, Alvaro Herrera alvhe...@2ndquadrant.com wrote:
Simon Riggs wrote:
What I think should happen is that the command tag should vary according
to
whether an INSERT or an UPDATE was performed, so we get a visible
difference without any new tags.
The problem with
Simon Riggs si...@2ndquadrant.com writes:
Can't you just use deferred triggers?
That seems like the real $64 question.
I'm not clear exactly when such a trigger should run. If the trigger issues
more SQL, which also has triggers... do we run the PreCommit trigger twice?
Or just accept that
On Mon, May 25, 2015 at 04:37:11PM -0400, Tom Lane wrote:
Davin M. Potts da...@discontinuity.net writes:
At Alvaro's suggestion, I'm forwarding my questions (see email thread
further below) to this list.
In short, building of PL/Python has been disabled on OpenBSD since 2005.
The errors
On Wed, May 27, 2015 at 9:24 AM, Stephen Frost sfr...@snowman.net wrote:
I agree that the documentation needs improvement. I don't agree with
your assessment that the code quality is well below the level we
normally expect, as committed. That's clearly a difficult thing to
judge, hence my
On Wed, May 27, 2015 at 05:40:09PM +0200, Christoph Berg wrote:
commit 4c5e060049a3714dd27b7f4732fe922090edea69
Author: Bruce Momjian br...@momjian.us
Date: Sat May 16 00:40:18 2015 -0400
pg_upgrade: force timeline 1 in the new cluster
Previously, this prevented promoted
On Mon, May 25, 2015 at 04:35:11PM -0300, Alvaro Herrera wrote:
Davin M. Potts wrote:
At Alvaro's suggestion, I'm forwarding my questions (see email thread
further below) to this list.
In short, building of PL/Python has been disabled on OpenBSD since 2005.
The errors seen at the time
When we create table, some column use foreign key references.
Now PostgreSQL don't create index for the FK, and there is no problem.
But when some body need the index to speed up the query within these APP,
they need to add the index manual one-by-one when has many tables.
If we can add syntax for
On Tue, May 26, 2015 at 7:03 PM, digoal zhou digoal.z...@gmail.com wrote:
When we create table, some column use foreign key references.
Now PostgreSQL don't create index for the FK, and there is no problem.
But when some body need the index to speed up the query within these APP,
they need to
On 05/27/2015 09:40 AM, Glyn Astill wrote:
From: Andreas Joseph Krogh andr...@visena.com
To: pgsql-hackers@postgresql.org
Sent: Wednesday, 27 May 2015, 13:55
Subject: Re: [HACKERS] Triggers on transaction?
På onsdag 27. mai 2015 kl. 12:42:29, skrev Marko Tiikkaja ma...@joh.to:
On 5/27/15
On Mon, May 25, 2015 at 04:26:02PM -0400, Andrew Dunstan wrote:
On 05/25/2015 03:35 PM, Andrew Dunstan wrote:
On 05/25/2015 12:38 PM, Davin M. Potts wrote:
At Alvaro's suggestion, I'm forwarding my questions (see email thread
further below) to this list.
In short, building of PL/Python
On Wed, May 27, 2015 at 3:25 PM, Ted Toth txt...@gmail.com wrote:
On Wed, May 27, 2015 at 1:31 PM, Robert Haas robertmh...@gmail.com wrote:
On Wed, May 27, 2015 at 11:35 AM, Ted Toth txt...@gmail.com wrote:
I'm trying to use a newer version than is available from RH in our
custom distro but am
Re: Bruce Momjian 2015-05-27 20150527174244.gb31...@momjian.us
In fact, I'm wondering if pg_upgrade shouldn't rather *increase* the
timeline to make sure the archive_command doesn't clobber any files
from the old cluster when reused in the new cluster?
https://bugs.debian.org/786993
I'm playing with a static analyzer and it's giving out some real error
analyzing postgresql code base like the following one
src/backend/access/transam/commit_ts.c
return *ts != 0 // line 321
but a few line up (line 315) ts is checked for null, so either is not
needed to check for null or *ts
On Mon, May 25, 2015 at 10:05 PM, Andres Freund and...@anarazel.de wrote:
Hm. So we have a *occasional* stack size exceeded failure and an
occasional spinlock error in test_shm_mq. I'm inclined to think that
this is a shm_mq problem, and not a more general locking problem - it
seems likely,
On 5/26/15 8:31 PM, Andres Freund wrote:
I actually think both are relatively easy to figure out without a
typedef list. There's harder cases though, e.g. (char *) foo in an
expression is already more complicated.
Well, if you know of a way to fix this, let's see it. Others have been
trying
On 05/27/2015 05:19 PM, Peter Eisentraut wrote:
And even if we got to the point where all commits should be perfectly
pgindented, it wouldn't work, because under the current workflow the
updated typedef list isn't available until after the commit (on an
unpredictable schedule). (This problem
Jeff Janes jeff.ja...@gmail.com writes:
As it is currently, it is not clear what purpose nonempty_pages serves.
It's to allow an early exit at vacuumlazy.c:271 in case there is no chance
of deleting a useful number of pages.
regards, tom lane
--
Sent via pgsql-hackers
On 5/27/15 2:55 PM, Tom Lane wrote:
These are all things we might try to fix (where fix could include
replace it with another tool) if the back-patching pain created by even
minor changes of the formatting rules weren't so great. But at this point
I despair of getting to consensus on a way to
Robert Haas robertmh...@gmail.com writes:
Tom, do you want to review this patch and figure out how to solve the
underlying problem? If not, I will take care of it. But I will be
unhappy if I put time and effort into this and then you insist on
changing everything afterwards, again.
[ sorry
Robert,
* Robert Haas (robertmh...@gmail.com) wrote:
I note that there are already 11 followup commits fixing bugs in
pg_audit, including 7 in the first 24 hours. It's usually not a good
thing when you can get the regression tests for a piece of
platform-independent code to pass in less than
On 2015-05-27 16:55:45 -0400, Peter Eisentraut wrote:
On 5/26/15 8:31 PM, Andres Freund wrote:
I actually think both are relatively easy to figure out without a
typedef list. There's harder cases though, e.g. (char *) foo in an
expression is already more complicated.
Well, if you know of
boix b...@uclv.cu writes:
Hello, my partner and me are working with the goal of improve the GEQO's
performance, we tried with Ant Colony Optimization, but it does not
improve, actually we are trying with a new variant of Genetic Algorithm,
specifically Micro-GA. This algorithm finds a
At 2015-05-27 11:46:39 +0530, a...@2ndquadrant.com wrote:
I'm trying a couple of approaches to that (e.g. using readdir directly
instead of ReadDir), but other suggestions are welcome.
Here's what that looks like, but not yet fully tested.
-- Abhijit
diff --git
On 5/27/15 5:08 PM, Andres Freund wrote:
I don't think I need to. clang-format has apparently done pretty much
what I described:
Well, that appears to work reasonably well in practice, which is all we
can hope for. Unfortunately, clang-format makes a bit of a mess of some
of our code, so it
Noah,
* Noah Misch (n...@leadboat.com) wrote:
On Wed, May 27, 2015 at 04:36:53PM -0400, Stephen Frost wrote:
This list includes all issues that I've
identified from the commits done to master, comments made by the
numerous individuals who have taken time to look at the patch and
comment,
JD,
* Joshua D. Drake (j...@commandprompt.com) wrote:
On 05/27/2015 06:11 PM, Stephen Frost wrote:
Thank you for your honest comments and your concern.
I sincerely hope you're able to be involved in developing auditing for
PostgreSQL in the future, as it is a key requirement in any secure
Stephen Frost sfr...@snowman.net writes:
* Joshua D. Drake (j...@commandprompt.com) wrote:
It seems to me that perhaps the solution is then to pull pg_audit
into user space and instead work on a general solution (an API?
custom backend?) that provides what is needed.
I am planning on working
2015-05-28 3:30 GMT+02:00 Joshua D. Drake j...@commandprompt.com:
On 05/27/2015 06:11 PM, Stephen Frost wrote:
Thank you for your honest comments and your concern.
I sincerely hope you're able to be involved in developing auditing for
PostgreSQL in the future, as it is a key requirement
On Thu, May 28, 2015 at 6:07 AM, Gaetano Mendola mend...@gmail.com wrote:
I'm playing with a static analyzer and it's giving out some real error
analyzing postgresql code base like the following one
src/backend/access/transam/commit_ts.c
return *ts != 0 // line 321
but a few line up
On Wed, May 27, 2015 at 6:55 PM, Andres Freund and...@anarazel.de wrote:
On 2015-05-27 15:39:14 -0400, Robert Haas wrote:
On Mon, May 25, 2015 at 10:05 PM, Andres Freund and...@anarazel.de wrote:
Hm. So we have a *occasional* stack size exceeded failure and an
occasional spinlock error in
Abhijit Menon-Sen a...@2ndquadrant.com writes:
At 2015-05-27 20:22:18 -0400, t...@sss.pgh.pa.us wrote:
I doubt that that (not using AllocateDir) [â¦]
(Disregarding per your followup.)
What I think is a reasonable compromise is to treat AllocateDir
failure as nonfatal, but to continue using
On Wed, May 27, 2015 at 5:13 PM, Naoya Anzai nao-an...@xc.jp.nec.com wrote:
Perhaps we could make the documentation
clearer about those things though, changing the description of this
function to get current transaction ID, and assign a new one if one
is not assigned yet:
On 05/27/2015 06:38 PM, Stephen Frost wrote:
While I certainly appreciate the support, I don't believe auditing will
be able to work as an extension over the long term and if the community
is unwilling or unable to accept steps in that direction through contrib
modules or even changes to core
Robert Haas wrote:
On Wed, May 27, 2015 at 6:21 PM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
Steve Kehlet wrote:
I have a database that was upgraded from 9.4.1 to 9.4.2 (no pg_upgrade, we
just dropped new binaries in place) but it wouldn't start up. I found this
in the logs:
On Wed, May 27, 2015 at 10:14 PM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
Well I'm not very clear on what's the problematic case. The scenario I
actually saw this first reported was a pg_basebackup taken on a very
large database, so the master could have truncated multixact and the
2015-05-28 1:41 GMT+08:00 David G. Johnston david.g.johns...@gmail.com:
On Tue, May 26, 2015 at 7:03 PM, digoal zhou digoal.z...@gmail.com
wrote:
When we create table, some column use foreign key references.
Now PostgreSQL don't create index for the FK, and there is no problem.
But when
On Thu, Apr 30, 2015 at 8:07 PM, Sawada Masahiko sawada.m...@gmail.com wrote:
On Fri, Apr 24, 2015 at 11:21 AM, Sawada Masahiko sawada.m...@gmail.com
wrote:
On Fri, Apr 24, 2015 at 1:31 AM, Jim Nasby jim.na...@bluetreble.com wrote:
On 4/23/15 11:06 AM, Petr Jelinek wrote:
On 23/04/15 17:45,
On Wed, May 27, 2015 at 11:08 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Wed, May 27, 2015 at 11:00 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Assuming that we can get a fix for the fsync-failure-during-restart
problem committed by the end of the week,
Robert Haas robertmh...@gmail.com writes:
On Wed, May 27, 2015 at 11:00 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Assuming that we can get a fix for the fsync-failure-during-restart
problem committed by the end of the week, there will be a new set of
back-branch minor releases next week. Usual
Abhijit Menon-Sen a...@2ndquadrant.com writes:
At 2015-05-27 11:46:39 +0530, a...@2ndquadrant.com wrote:
I'm trying a couple of approaches to that (e.g. using readdir directly
instead of ReadDir), but other suggestions are welcome.
Here's what that looks like, but not yet fully tested.
I
I wrote:
Abhijit Menon-Sen a...@2ndquadrant.com writes:
At 2015-05-27 11:46:39 +0530, a...@2ndquadrant.com wrote:
I'm trying a couple of approaches to that (e.g. using readdir directly
instead of ReadDir), but other suggestions are welcome.
Here's what that looks like, but not yet fully
On Wednesday, May 27, 2015, digoal zhou digoal.z...@gmail.com wrote:
2015-05-28 1:41 GMT+08:00 David G. Johnston david.g.johns...@gmail.com
javascript:_e(%7B%7D,'cvml','david.g.johns...@gmail.com');:
On Tue, May 26, 2015 at 7:03 PM, digoal zhou digoal.z...@gmail.com
On Wed, May 27, 2015 at 04:36:53PM -0400, Stephen Frost wrote:
This list includes all issues that I've
identified from the commits done to master, comments made by the
numerous individuals who have taken time to look at the patch and
comment, and those found by the ongoing work of David and I
On Wed, May 27, 2015 at 6:21 PM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
Steve Kehlet wrote:
I have a database that was upgraded from 9.4.1 to 9.4.2 (no pg_upgrade, we
just dropped new binaries in place) but it wouldn't start up. I found this
in the logs:
waiting for server to
Assuming that we can get a fix for the fsync-failure-during-restart
problem committed by the end of the week, there will be a new set of
back-branch minor releases next week. Usual schedule, wrap Monday
for public announcement Thursday.
regards, tom lane
--
Sent via
Tom,
Many thanks for your comments and for jumping into this discussion.
* Tom Lane (t...@sss.pgh.pa.us) wrote:
Stephen Frost sfr...@snowman.net writes:
* Joshua D. Drake (j...@commandprompt.com) wrote:
It seems to me that perhaps the solution is then to pull pg_audit
into user space and
Steve Kehlet wrote:
On Wed, May 27, 2015 at 3:21 PM Alvaro Herrera alvhe...@2ndquadrant.com
wrote:
I think a patch like this should be able to fix it ... not tested yet.
Thanks Alvaro. I got a compile error, so looked for other uses of
SimpleLruDoesPhysicalPageExist and added
At 2015-05-27 20:22:18 -0400, t...@sss.pgh.pa.us wrote:
I doubt that that (not using AllocateDir) […]
(Disregarding per your followup.)
What I think is a reasonable compromise is to treat AllocateDir
failure as nonfatal, but to continue using ReadDir etc which means
that any post-open
On Wed, May 27, 2015 at 11:00 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Assuming that we can get a fix for the fsync-failure-during-restart
problem committed by the end of the week, there will be a new set of
back-branch minor releases next week. Usual schedule, wrap Monday
for public
At 2015-05-27 23:41:29 -0400, t...@sss.pgh.pa.us wrote:
What about turning ReadDir into a wrapper around a ReadDirExtended
function that adds an elevel argument?
Sounds reasonable, doing.
-- Abhijit
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to
JD,
* Joshua D. Drake (j...@commandprompt.com) wrote:
On 05/27/2015 06:38 PM, Stephen Frost wrote:
While I certainly appreciate the support, I don't believe auditing will
be able to work as an extension over the long term and if the community
is unwilling or unable to accept steps in that
On 05/27/2015 07:02 PM, Stephen Frost wrote:
JD,
As it is currently an extension, it does not need to be in core. If
this extension reaches a point where it needs to be in core to
achieve some level of integration not currently provided then we can
evaluate that problem. Currently, that is
On 05/27/2015 06:11 PM, Stephen Frost wrote:
Thank you for your honest comments and your concern.
I sincerely hope you're able to be involved in developing auditing for
PostgreSQL in the future, as it is a key requirement in any secure
environment.
Guys,
I think we are overlooking the
On Wed, May 27, 2015 at 3:21 PM Alvaro Herrera alvhe...@2ndquadrant.com
wrote:
I think a patch like this should be able to fix it ... not tested yet.
Thanks Alvaro. I got a compile error, so looked for other uses of
SimpleLruDoesPhysicalPageExist and added MultiXactOffsetCtl, does this look
On 2015-05-27 15:39:14 -0400, Robert Haas wrote:
On Mon, May 25, 2015 at 10:05 PM, Andres Freund and...@anarazel.de wrote:
Hm. So we have a *occasional* stack size exceeded failure and an
occasional spinlock error in test_shm_mq. I'm inclined to think that
this is a shm_mq problem, and not
Folks,
The time may have come again to discuss $Subject. As I recall, the
state of the spec back in 2007, when this was last discussed, was so
abysmal that we simply abandoned the effort.
It appears, at least to me, that SQL:2011 has polished this up in ways
that could be helpful, especially
On Wed, May 27, 2015 at 10:06:03PM +0200, Christoph Berg wrote:
Re: Bruce Momjian 2015-05-27 20150527174244.gb31...@momjian.us
In fact, I'm wondering if pg_upgrade shouldn't rather *increase* the
timeline to make sure the archive_command doesn't clobber any files
from the old cluster
Steve Kehlet wrote:
I have a database that was upgraded from 9.4.1 to 9.4.2 (no pg_upgrade, we
just dropped new binaries in place) but it wouldn't start up. I found this
in the logs:
waiting for server to start2015-05-27 13:13:00 PDT [27341]: [1-1] LOG:
database system was shut down at
81 matches
Mail list logo