Hi,
Current pg_standby is dangerous because the presence of the trigger
file causes recovery to end whether or not the next WAL file is available.
So, some *available* transactions may be lost at failover. Such danger
will become high if the standby server has not caught up with the primary.
On Wed, Mar 25, 2009 at 7:29 AM, Fujii Masao masao.fu...@gmail.com wrote:
Attached patch fixes the above problem by adding a new trigger option
to pg_standby; the presence of this new trigger file causes recovery to
end after replaying all the available WAL files.
Shouldn't it be the default?
Hi,
nobody answered on the regular mailing list, hope someone can answer here
Thank you
Original Message
Subject:[GENERAL] Matching dimensions in arrays
Date: Mon, 9 Mar 2009 01:14:57 -0700 (PDT)
From: Scara Maccai m_li...@yahoo.it
To: pgsql-general
Hi,
Thanks for the comment.
On Wed, Mar 25, 2009 at 3:50 PM, Guillaume Smet
guillaume.s...@gmail.com wrote:
On Wed, Mar 25, 2009 at 7:29 AM, Fujii Masao masao.fu...@gmail.com wrote:
Attached patch fixes the above problem by adding a new trigger option
to pg_standby; the presence of this new
On Wed, Mar 25, 2009 at 9:44 AM, Fujii Masao masao.fu...@gmail.com wrote:
Yeah, I agree... but there may be scripts for warm-standby based on
the existing default behavior. So, I didn't make a new trigger the default.
I don't use pg_standby personnaly but I admit I'm quite surprised by
the
Hi.
Now, we can check the running query string by pg_stat_activity.current_query.
If we can also check previous query_string of idle-in-transaction,
it is useful for analysis of long transaction problem.
Long-transaction is a trouble, because it prevents defragmentation of HOT and
VACUUM.
And
Hi,
On Wed, Mar 25, 2009 at 5:55 PM, Guillaume Smet
guillaume.s...@gmail.com wrote:
On Wed, Mar 25, 2009 at 9:44 AM, Fujii Masao masao.fu...@gmail.com wrote:
Yeah, I agree... but there may be scripts for warm-standby based on
the existing default behavior. So, I didn't make a new trigger the
Joshua D. Drake wrote:
On Mon, 2009-03-23 at 16:21 -0400, Bruce Momjian wrote:
If a platform doesn't have posix_fadvise(), we don't allow
effective_io_concurrency to be set to anything but zero:
test= set effective_io_concurrency = 1;
ERROR: 1 is outside the valid range for
This sure is a desirable feature. I have seen quite a few instances, where
the app is in 'IDLE in Transaction' state, and we are left with the only
choice of killing such processes from OS. (Remember pg_cancel_backend() does
not work for sessions in IDLE or IDLE in transaction state)
Also, it
Tom Lane wrote:
It does look like -interfaces is dying: almost no traffic, and what
questions it does get are off-topic more often than not. Partly this
is because the -jdbc, -odbc, and -php lists suck away all the traffic
about those interfaces, leaving not much. So we could kill -interfaces
Robert Haas wrote:
I think the key to getting this done is
to keep the design as simple as possible and to avoid entanglements
with other features that may need to be designed independently and
first.
I think the key to getting this done is to define project purpose and
requirements before
[ I'm arbitrarily replying to Greg as his was the most verbose ]
On Tue, Mar 24, 2009 at 11:23:36PM -0400, Greg Smith wrote:
On Tue, 24 Mar 2009, Sam Mason wrote:
The conceptual idea is to have at most one outstanding flush for the
log going through the filesystem at any one time.
Quoting
I found an old patch on my disk to enable SSL over Unix-domain sockets.
Remember, about a year ago it was discussed that there might also be
man-in-the-middle or fake-server attacks using Unix-domain sockets,
because usually anyone can start a server in /tmp. After an extensive
discussion
On Wed, Mar 25, 2009 at 12:58:46AM -0700, Scara Maccai wrote:
I've altready asked this some months ago, but I've never seen any answers:
why do multidimensional arrays have to have matching extents for each
dimension?
Because the dimensions define the rectangular bounds of the array in
Dne 24.03.09 22:31, Robert Lor napsal(a):
I think the is-enabled test will address the issues you encountered. I
see a few alternative to fixing this:
1) Only use if (foo_ENABLED()) test for probes with expensive function
call/computation in arguments. This will keep the code clean, and we
Peter Eisentraut wrote:
I found an old patch on my disk to enable SSL over Unix-domain sockets.
Remember, about a year ago it was discussed that there might also be
man-in-the-middle or fake-server attacks using Unix-domain sockets,
because usually anyone can start a server in /tmp. After
Magnus Hagander wrote:
I imagine for example, we could invent an additional sslmode of the sort
prefer-but-not-if-local-socket, which could be the default.
That parameter is already pretty complex, not sure it's a great idea to
make it even more so :(
I think there is a firm difference
Peter Eisentraut wrote:
Magnus Hagander wrote:
I imagine for example, we could invent an additional sslmode of the sort
prefer-but-not-if-local-socket, which could be the default.
That parameter is already pretty complex, not sure it's a great idea to
make it even more so :(
I think there
Guillaume Smet guillaume.s...@gmail.com wrote:
On Wed, Mar 25, 2009 at 9:44 AM, Fujii Masao masao.fu...@gmail.com
wrote:
Yeah, I agree... but there may be scripts for warm-standby based on
the existing default behavior. So, I didn't make a new trigger the
default.
I don't use pg_standby
Peter Eisentraut pete...@gmx.net writes:
Joshua D. Drake wrote:
Do we want to give a more informative error message, like not supported
on this platform?
The trick will be to fit this into the GUC framework.
You could do it by enforcing the limit in an assign hook, but I'm
not convinced it's
Sam Mason s...@samason.me.uk writes:
You can see this
most easily by doing inserts into a system that's limited by a slow fsync,
like a single disk without write cache where you're bound by RPM speed.
Yes, I did a test like this and wasn't getting the scaling I was
expecting--hence my post.
Peter Eisentraut wrote:
Tom Lane wrote:
It does look like -interfaces is dying: almost no traffic, and what
questions it does get are off-topic more often than not. Partly this
is because the -jdbc, -odbc, and -php lists suck away all the traffic
about those interfaces, leaving not much. So
Greg Stark st...@enterprisedb.com writes:
What happens is that the first backend comes along, finds nobody else waiting
and does an fsync for its own work. While that fsync is happening the rest of
the crowd -- N-1 backends -- comes along and blocks waiting on the lock. The
first backend to
On Wed, Mar 25, 2009 at 2:59 PM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
I find it hard to imagine a use case for the existing default
behavior.
I thought a bit about it and I think it can be useful when your
priority is the availability of the service and you don't consider a
data
On Wed, Mar 25, 2009 at 02:38:45PM +, Greg Stark wrote:
Sam Mason s...@samason.me.uk writes:
Why does it top out so much though? It goes up nicely to around ten
clients (I tested with 8 and 12) and then tops out and levels off. The
log is chugging along at around 2MB/s which is well
[ back to this patch... ]
Teodor Sigaev teo...@sigaev.ru writes:
Looked at this a bit ... do you think it's really a good idea to remove
the strategy number argument of comparePartial? The argument given in
the docs for it is that it might be needed to determine when to end the
scan, and
I thought we had fixed this in 8.3:
cap=# create table t1 (t varchar(40));
CREATE TABLE
cap=# create table t2 (t varchar(40));
CREATE TABLE
cap=# create function t1trig() returns trigger language plpgsql as
$$ begin insert into t2 values(new.t); return null; end; $$;
CREATE
On Wed, Mar 25, 2009 at 06:08:43PM +0900, Tatsuhito Kasahara wrote:
So, I sometimes want to know what query (main cause) was done before
transaction which have been practiced for a long time.
Thoughts?
I would love to get it, but when I suggested it some time in the past
Tom shot it down as
BTW ... while I'm thinking about it: it seems to me to be a serious
error that the consistent() function isn't given nkeys so that it can
know the length of the arrays it's being handed. I suppose it's
possible for it to re-deduce nkeys by examining the query datum, but
that could be quite
Andrew Dunstan and...@dunslane.net writes:
I thought we had fixed this in 8.3:
I think that behavior is intentional: plancache.c can deal with the plan
changing internally, but it doesn't expect that its callers could
survive the plan's argument datatypes changing underneath them.
Peter Willis wrote:
I am aware of PostGIS and already use it. My question was regarding
the entry format of PostgreSQL polygon data. There is a void
in the PostgreSQL documentation regarding this.
Incidentally, PostGIS uses PostgreSQL polygon, point, and path
data types.
Errr... no it
On Wed, Mar 25, 2009 at 03:58:06PM +, Sam Mason wrote:
On Wed, Mar 25, 2009 at 02:38:45PM +, Greg Stark wrote:
Sam Mason s...@samason.me.uk writes:
Why does it top out so much though? It goes up nicely to around ten
clients (I tested with 8 and 12) and then tops out and levels
On Wed, Mar 25, 2009 at 5:48 PM, hubert depesz lubaczewski
dep...@depesz.com wrote:
I would love to get it, but when I suggested it some time in the past
Tom shot it down as bad idea.
http://archives.postgresql.org/message-id/20071016132131.ga4...@depesz.com
I agree with Tom here. I tracked a
Tom Lane wrote:
Andrew Dunstan and...@dunslane.net writes:
I thought we had fixed this in 8.3:
I think that behavior is intentional: plancache.c can deal with the plan
changing internally, but it doesn't expect that its callers could
survive the plan's argument datatypes changing
Our fine manual sayeth (in section 52.5)
When extractQuery returns zero keys, GIN will emit an error. Depending
on the operator, a void query might match all, some, or none of the
indexed values (for example, every array contains the empty array, but
does not overlap the empty array), and
On Wed, Mar 25, 2009 at 12:01:57PM -0500, Kenneth Marshall wrote:
On Wed, Mar 25, 2009 at 03:58:06PM +, Sam Mason wrote:
#!/bin/bash
nclients=$1
ittrs=$2
function gensql {
echo INSERT INTO bm (c,v) VALUES ('$1','0');
for (( i = 1; i $ittrs; i++ )); do
On 3/25/09 12:17 PM, Alvaro Herrera wrote:
Josh Berkus wrote:
On 3/25/09 8:11 AM, Alvaro Herrera wrote:
As for actually shutting it down in Majordomo, Marc is the man.
Might want to make an announcement on that list first.
Josh Berkus wrote:
On 3/25/09 8:11 AM, Alvaro Herrera wrote:
As for actually shutting it down in Majordomo, Marc is the man.
Might want to make an announcement on that list first.
http://archives.postgresql.org/pgsql-interfaces/2008-07/msg2.php
--
Alvaro Herrera
On Wed, Mar 25, 2009 at 05:56:02PM +, Sam Mason wrote:
On Wed, Mar 25, 2009 at 12:01:57PM -0500, Kenneth Marshall wrote:
On Wed, Mar 25, 2009 at 03:58:06PM +, Sam Mason wrote:
#!/bin/bash
nclients=$1
ittrs=$2
function gensql {
echo INSERT INTO bm (c,v)
All,
Due to budget constraints, Google needed to cut 50 projects from the
Summer of Code this year. We were one of the projects cut (although we
can re-apply next year).
However, that doesn't mean we won't be working with students this year.
1) Portland State University has generously
On 3/25/09 8:11 AM, Alvaro Herrera wrote:
Peter Eisentraut wrote:
Tom Lane wrote:
It does look like -interfaces is dying: almost no traffic, and what
questions it does get are off-topic more often than not. Partly this
is because the -jdbc, -odbc, and -php lists suck away all the traffic
Josh Berkus wrote:
On 3/25/09 12:17 PM, Alvaro Herrera wrote:
http://archives.postgresql.org/pgsql-interfaces/2008-07/msg2.php
That was 6 months ago. I doubt anyone remembers it. Make another
announcement, so that when people get the unsubscribed announcement,
they're not
Alvaro Herrera alvhe...@commandprompt.com writes:
Josh Berkus wrote:
That was 6 months ago. I doubt anyone remembers it. Make another
announcement, so that when people get the unsubscribed announcement,
they're not confused.
Done.
BTW, what was the reason we didn't pull the trigger
Tom == Tom Lane t...@sss.pgh.pa.us writes:
Tom BTW ... while I'm thinking about it: it seems to me to be a
Tom serious error that the consistent() function isn't given nkeys
Tom so that it can know the length of the arrays it's being handed.
Tom I suppose it's possible for it to re-deduce
Andrew Gierth and...@tao11.riddles.org.uk writes:
Tom == Tom Lane t...@sss.pgh.pa.us writes:
Tom BTW ... while I'm thinking about it: it seems to me to be a
Tom serious error that the consistent() function isn't given nkeys
Tom so that it can know the length of the arrays it's being handed.
Hi,
I hope I found the right list for this request. I am aware that timestamp
with[out] time zone data types have -infinity and infinity key values; see
http://www.postgresql.org/docs/current/interactive/datatype-datetime.html
However, there is no equivalent for date types, and expressions
Michael Toews escreveu:
This feature request is for PG to support -infinity and infinity for date
types.
This was done for 8.4. Look at TODO [1].
[1] http://wiki.postgresql.org/wiki/Todo
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via pgsql-hackers mailing list
Teodor Sigaev teo...@sigaev.ru writes:
[ btree_gin 0.12 ]
Committed with some editorializations. There are still a few loose
ends:
* the question about zero-key queries that I mentioned before
* After this new look at the code I think that matchPartialInPendingList
is completely broken.
And you thought it'd never happen ...
We still have a few loose ends before we can go beta, but we're getting
there.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On Wed, Mar 25, 2009 at 7:50 PM, Tom Lane t...@sss.pgh.pa.us wrote:
And you thought it'd never happen ...
We still have a few loose ends before we can go beta, but we're getting
there.
Awesome!
...Robert
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
2009/3/24 Tom Lane t...@postgresql.org:
catversion bumped because of change in GIN's pg_am entry, and because
the format of GIN indexes changed on-disk (there's a metapage now,
and possibly a pending list).
Will this break
Hi,
On Thu, Mar 26, 2009 at 12:48 AM, Guillaume Smet
guillaume.s...@gmail.com wrote:
On Wed, Mar 25, 2009 at 2:59 PM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
I find it hard to imagine a use case for the existing default
behavior.
I thought a bit about it and I think it can be
On Mar 25, 2009, at 2:39 PM, Josh Berkus wrote:
Note that since the Internships are not required to be project code,
we can also take student projects to contribute to our WWW
infrastructure and other areas the project needs some work.
God, could someone do the module thing? :-
I'd be
David E. Wheeler wrote:
On Mar 24, 2009, at 9:41 AM, Bruce Momjian wrote:
So far taking the CVS logs and making a list of only the items we want
for the release notes took one day; researching and rewording the
items
so they are ready for the release notes took five days; grouping
Peter Eisentraut wrote:
I found an old patch on my disk to enable SSL over Unix-domain sockets.
Remember, about a year ago it was discussed that there might also be
man-in-the-middle or fake-server attacks using Unix-domain sockets,
because usually anyone can start a server in /tmp. After
Hi,
Set the maximum number of times to retry the copy or link command
maxretries option of pg_standby is documented as above, but actually
indicates the maximum number of times to *try* the copy or link command.
So, if -r 0 is specified, pg_standby always fails.
Attached is the patch which
OK, I am all wet. I now understand why the editing is the
time-consuming part of this job. On the plus side it is probably
possible to parallelize it to some degree by splitting the list into N
pieces after the remove insignificant items step.
With respect to this item:
Disable appending of the
Robert Haas robertmh...@gmail.com writes:
OK, I am all wet. I now understand why the editing is the
time-consuming part of this job. On the plus side it is probably
possible to parallelize it to some degree by splitting the list into N
pieces after the remove insignificant items step.
The
All,
In any case, the release notes aren't normally a bottleneck. I still
think that Bruce had his priorities out of whack in not cleaning up
his open-items list before doing this. If he had done so, nobody
would have noticed how long the notes took.
Yes, although Bruce *has* asked for help
Josh Berkus j...@agliodbs.com writes:
Yes, although Bruce *has* asked for help in cleaning up the open-items list.
I spent several hours on that on Saturday, and more or less got the bird
in response... the way Bruce has that page set up, only he can do any
actual item removal, the rest of us
Please clarify what you want done on the majordomo side ... I saw one
comment about unsub'ng everyone ... for archive purposes, this makes
sense, I just want to make sure before I blow them all away (and I will
unsubscribe them without having a blast of emails go out to them)
I will
61 matches
Mail list logo