On Wed, Jan 20, 2010 at 1:05 AM, Tom Lane t...@sss.pgh.pa.us wrote:
I guess Joachim is trying to provide a similar guarantee for the new
implementation, but I'm not clear on why it would require locking.
The new implementation is broadcast and ISTM it shouldn't require the
modifying
On Tue, Jan 19, 2010 at 4:41 PM, Simon Riggs si...@2ndquadrant.com wrote:
It would be useful to have the ps display differentiate between multiple
walsenders, and in this case have it indicate cascading also.
Since a normal walsender and a cascading one will not be running
at the same time, I
On Tue, Jan 19, 2010 at 16:59, Robert Haas robertmh...@gmail.com wrote:
On Tue, Jan 19, 2010 at 10:44 AM, Magnus Hagander mag...@hagander.net wrote:
On Mon, Jan 18, 2010 at 01:53, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
Magnus Hagander wrote:
the Git repository is missing parts of
On Wed, Jan 20, 2010 at 09:52, Magnus Hagander mag...@hagander.net wrote:
On Tue, Jan 19, 2010 at 16:59, Robert Haas robertmh...@gmail.com wrote:
On Tue, Jan 19, 2010 at 10:44 AM, Magnus Hagander mag...@hagander.net
wrote:
On Mon, Jan 18, 2010 at 01:53, Kevin Grittner
this is mostly true. I don't think any Oracle DBA will expect ALL_TABLES our
DBA_TABLES to be there.
however DESCRIBE and HELP would be the two that come to mind.
greg
On 20 Jan 2010 02:56, Greg Sabino Mullane g...@turnstep.com wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Why
Magnus Hagander wrote:
On Wed, Jan 20, 2010 at 09:52, Magnus Hagander mag...@hagander.net wrote:
On Tue, Jan 19, 2010 at 16:59, Robert Haas robertmh...@gmail.com wrote:
On Tue, Jan 19, 2010 at 10:44 AM, Magnus Hagander mag...@hagander.net
wrote:
On Mon, Jan 18, 2010 at 01:53, Kevin Grittner
Tom Lane írta:
Boszormenyi Zoltan z...@cybertec.at writes:
[ 5-pg85-locktimeout-14-ctxdiff.patch ]
I took a quick look at this. I am not qualified to review the Win32
implementation of PGSemaphoreTimedLock, but I am afraid that both of
the other ones are nonstarters on portability
On Wednesday 20 January 2010 06:30:28 Tom Lane wrote:
Andres Freund and...@anarazel.de writes:
Is there any supported platform with sizeof(sig_atomic_t) 4 - I would
doubt so?
Er ... what? I believe there are live platforms with sig_atomic_t = char.
If we're assuming more that's a
On Wed, 2010-01-20 at 06:14 +0100, Andres Freund wrote:
Full resolution patch attached for Startup process waits on buffer pins.
Startup process sets SIGALRM when waiting on a buffer pin. If woken by
alarm we send SIGUSR1 to all backends requesting that they check to see
if they are
On Wednesday 20 January 2010 06:30:28 Tom Lane wrote:
Andres Freund and...@anarazel.de writes:
Is there any supported platform with sizeof(sig_atomic_t) 4 - I would
doubt so?
Er ... what? I believe there are live platforms with sig_atomic_t = char.
If we're assuming more that's a
On Wednesday 20 January 2010 10:40:10 Simon Riggs wrote:
On Wed, 2010-01-20 at 06:14 +0100, Andres Freund wrote:
Full resolution patch attached for Startup process waits on buffer
pins.
Startup process sets SIGALRM when waiting on a buffer pin. If woken by
alarm we send SIGUSR1 to
On Wed, 2010-01-20 at 10:45 +0100, Andres Freund wrote:
LWLockAcquire
I'm using spinlocks, not lwlocks.
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On Tue, 19 Jan 2010, Tom Lane wrote:
iog...@free.fr writes:
I found a difference of behaviour between 8.3 and 8.4 on IS NULL with
multi-level arrays with NULL values.
8.3's behavior is just a bug ---
Ok, should I report through the -bugs ml for tracking purpose ? or
is it useless cause
On Wednesday 20 January 2010 10:52:24 Simon Riggs wrote:
On Wed, 2010-01-20 at 10:45 +0100, Andres Freund wrote:
LWLockAcquire
I'm using spinlocks, not lwlocks.
CancelDBBackends which is used in SendRecoveryConflictWithBufferPin which in
turn used by CheckStandbyTimeout triggered by SIGALRM
2010/1/19 Hitoshi Harada umi.tan...@gmail.com:
2010/1/19 Hitoshi Harada umi.tan...@gmail.com:
Yeah, that's my point, too. The planner has to distinguish four from
sort pathkeys and to teach the executor the simple information which
column should be used to determine frame. I was bit wrong
Tom Lane írta:
Greg Stark st...@mit.edu writes:
we already have statement timeout it seems the natural easy to implement
this is with more hairy logic to calculate the timeout until the next of the
three timeouts should fire and set sigalarm. I sympathize with whoever tries
to work that
New version of the patch, let me know if I can fix/change something else.
Leonardo
getsetbit.patch
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
On Wed, 2010-01-20 at 11:04 +0100, Andres Freund wrote:
On Wednesday 20 January 2010 10:52:24 Simon Riggs wrote:
On Wed, 2010-01-20 at 10:45 +0100, Andres Freund wrote:
LWLockAcquire
I'm using spinlocks, not lwlocks.
CancelDBBackends which is used in SendRecoveryConflictWithBufferPin
On Wednesday 20 January 2010 11:33:05 Simon Riggs wrote:
On Wed, 2010-01-20 at 11:04 +0100, Andres Freund wrote:
On Wednesday 20 January 2010 10:52:24 Simon Riggs wrote:
On Wed, 2010-01-20 at 10:45 +0100, Andres Freund wrote:
LWLockAcquire
I'm using spinlocks, not lwlocks.
On Wed, 2010-01-20 at 04:47 +0100, Andres Freund wrote:
On Saturday 16 January 2010 12:32:35 Simon Riggs wrote:
No. As mentioned upthread, this is not a bug.
Could you also mention in a little bit more detail why not?
When a cleanup record arrives without a latestRemovedXid we are forced
On Tue, Jan 19, 2010 at 5:01 PM, David Christensen da...@endpoint.com wrote:
On Jan 19, 2010, at 4:23 PM, Robert Haas wrote:
On Tue, Jan 19, 2010 at 5:14 PM, David E. Wheeler da...@kineticode.com
wrote:
Why would they want more? It's not MySQL, and they know that. If we give
them some very
Boszormenyi Zoltan írta:
Tom Lane írta:
Greg Stark st...@mit.edu writes:
we already have statement timeout it seems the natural easy to implement
this is with more hairy logic to calculate the timeout until the next of the
three timeouts should fire and set sigalarm. I
Leonardo F wrote:
New version of the patch, let me know if I can fix/change something
else.
All issues addressed, with one tiny nit-pick -- the get_bit and
set_bit methods are not part of the SQL standard. I took the liberty
of removing SQL-standard from the documentation of these functions
so
All issues addressed, with one tiny nit-pick -- the get_bit and
set_bit methods are not part of the SQL standard.
Damn! I completely forgot to mention that I had no idea if what I wrote
in the docs made any sense...
Well thank you for your thorough review.
--
Sent via pgsql-hackers
On Wednesday 20 January 2010 12:59:40 Simon Riggs wrote:
On Wed, 2010-01-20 at 04:47 +0100, Andres Freund wrote:
On Saturday 16 January 2010 12:32:35 Simon Riggs wrote:
No. As mentioned upthread, this is not a bug.
Could you also mention in a little bit more detail why not?
When a
On tis, 2010-01-19 at 11:43 -0800, Jeff Davis wrote:
I'll make an analogy to:
$ git difff
git: 'difff' is not a git-command. See 'git --help'.
Did you mean this?
diff
This is presumably spelling-based, which might be an interesting feature
(although probably useless for
On tis, 2010-01-19 at 16:00 -0600, David Christensen wrote:
Currently, a session will look like the following:
machack:machack:5485=# show tables;
See:
\d
or \? for general help with psql commands
machack:machack:5485=#
I think if you make show tables and the
I've been having a look at this, one master + one replica and also one
master + 2 replicas. I gotta say this is a nice piece of functionality
(particularly the multiple replicas).
I've been using the wiki page
(http://wiki.postgresql.org/wiki/Streaming_Replication) as a guide, and
I notice
Peter Eisentraut wrote:
On tis, 2010-01-19 at 16:00 -0600, David Christensen wrote:
Currently, a session will look like the following:
machack:machack:5485=# show tables;
See:
\d
or \? for general help with psql commands
machack:machack:5485=#
I
On Wed, 2010-01-20 at 14:13 +0100, Andres Freund wrote:
I do understand it correctly that in CancelVirtualTransaction
LW_SHARED is
taken only so that another transaction can finish during that time?
We're canceling one specific vxid, so no need to block other snapshots
from being taken.
Read
On ons, 2010-01-20 at 09:05 -0500, Bruce Momjian wrote:
I disagree. No one has complained that we are being a smartass by
reporting this for help in psql:
You are using psql, the command-line interface to PostgreSQL.
Type: \copyright for distribution terms
On Wed, Jan 20, 2010 at 9:05 AM, Bruce Momjian br...@momjian.us wrote:
Peter Eisentraut wrote:
On tis, 2010-01-19 at 16:00 -0600, David Christensen wrote:
Currently, a session will look like the following:
machack:machack:5485=# show tables;
See:
\d
or \?
On Wed, Jan 20, 2010 at 4:27 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Magnus Hagander wrote:
On Wed, Jan 20, 2010 at 09:52, Magnus Hagander mag...@hagander.net wrote:
On Tue, Jan 19, 2010 at 16:59, Robert Haas robertmh...@gmail.com wrote:
On Tue, Jan 19, 2010 at 10:44
On Wed, Jan 20, 2010 at 9:26 AM, Peter Eisentraut pete...@gmx.net wrote:
On ons, 2010-01-20 at 09:05 -0500, Bruce Momjian wrote:
I disagree. No one has complained that we are being a smartass by
reporting this for help in psql:
You are using psql, the command-line interface to
If that's the case then others timeouts should be failing on os x, no?
But i have never hear that
2010/1/20, Boszormenyi Zoltan z...@cybertec.at:
Boszormenyi Zoltan írta:
Tom Lane írta:
Greg Stark st...@mit.edu writes:
we already have statement timeout it seems the natural easy to
Robert Haas wrote:
I'm actually no big advocate of the \d commands. They're basically
magical queries that you can't easily see or edit - I've more than
once wished for a WHERE clause (\df WHERE Result data type =
'internal' or what have you.
You *can* easily see them, at least. Run
Hi,
I wrote:
Okay, after reading google it seems you're right that OS X lacks
sem_timedwait().
Jaime Casanova írta:
If that's the case then others timeouts should be failing on os x, no?
But i have never hear that
among others, I found this reference on the missing
sem_timedwait()
Robert Haas wrote:
On Wed, Jan 20, 2010 at 4:27 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Magnus Hagander wrote:
Actually, such a correction patch would be nice and short. Attached
for reference. Thoughts?
That seems better than rewinding the history all the way back
Robert Haas robertmh...@gmail.com writes:
If what the user wanted was to be using MySQL, he is out of luck
anyway.
That's not what we're talking about. We're talking about having a nice
client tool for those people having to do both MySQL and PostgreSQL
support, or new to PostgreSQL and comming
Dimitri Fontaine wrote:
Robert Haas robertmh...@gmail.com writes:
If what the user wanted was to be using MySQL, he is out of luck
anyway.
That's not what we're talking about. We're talking about having a nice
client tool for those people having to do both MySQL and PostgreSQL
support,
Dimitri Fontaine dfonta...@hi-media.com wrote:
I'll give my vote to Peter's idea that show tables; should better
act as if you typed \d.
I guess we don't need a tables GUC. Show all wouldn't include it?
Would we require a semicolon? Do we support \d-style globs?
Still seems kinda messy.
I would personally emulate \d and take the chance for showing a funny
warning, something like: hey, it's not MySql! or similar. I am sure
we will Finder something appropriate. :)
Inviato da iPhone
Il giorno 20/gen/2010, alle ore 16.30, Kevin Grittner kevin.gritt...@wicourts.gov
ha
Then your union operation is to just bitwise or the two bloomfilters.
Keep in mind that when performing this sort of union between two
comparably-sized sets, your false-positive rate will increase by about an order
of magnitude. You need to size your bloom filters accordingly, or perform the
2010/1/20 Boszormenyi Zoltan z...@cybertec.at:
Attached with the proposed modification to lift the portability concerns.
Fixed the missing check for get_rel_name() and one typo (transation)
Introduced checks for semtimedop() and sem_timedwait() in configure.in
and USE_LOCK_TIMEOUT in port.h
Robert Haas robertmh...@gmail.com writes:
2010/1/20 Boszormenyi Zoltan z...@cybertec.at:
Attached with the proposed modification to lift the portability concerns.
I think that it is a very bad idea to implement this feature in a way
that is not 100% portable.
Agreed, this is not acceptable.
Joachim Wieland j...@mcknight.de writes:
On Wed, Jan 20, 2010 at 1:05 AM, Tom Lane t...@sss.pgh.pa.us wrote:
I guess Joachim is trying to provide a similar guarantee for the new
implementation, but I'm not clear on why it would require locking.
It is rather about a listening backend seeing a
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes:
Magnus Hagander wrote:
Actually, such a correction patch would be nice and short. Attached
for reference. Thoughts?
That seems better than rewinding the history all the way back to August.
+1 ... I'm just an interested observer
Andres Freund and...@anarazel.de writes:
On Wednesday 20 January 2010 06:30:28 Tom Lane wrote:
Er ... what? I believe there are live platforms with sig_atomic_t = char.
If we're assuming more that's a must-fix.
The reason I have asked is that the code is doing things like:
[ grabbing a
On Wednesday 20 January 2010 17:30:04 Tom Lane wrote:
Andres Freund and...@anarazel.de writes:
On Wednesday 20 January 2010 06:30:28 Tom Lane wrote:
Er ... what? I believe there are live platforms with sig_atomic_t =
char. If we're assuming more that's a must-fix.
The reason I have
Dimitri Fontaine dfonta...@hi-media.com writes:
I'll give my vote to Peter's idea that show tables; should better act as
if you typed \d.
We have previously considered and rejected this type of approach, for
example in the pgsql-bugs discussion I referenced upthread.
I don't see what the gain
Andres Freund and...@anarazel.de writes:
I realize its way too late in the cycle for that, but why dont we start using
some library for easy cross platform atomic ops?
(1) there probably isn't one that does exactly what we want, works
everywhere, and has the right license;
(2) what actual gain
Tom Lane t...@sss.pgh.pa.us writes:
The proposed patch to just provide a helpful message
is only a dozen or two lines, which is about the right amount of effort
to expend in this direction IMHO.
For the record, agreed on the commands for which we have no obvious
equivalent :)
Regards,
--
Hi Tom, Hi Simon,
On Wednesday 20 January 2010 17:59:36 Tom Lane wrote:
Andres Freund and...@anarazel.de writes:
I realize its way too late in the cycle for that, but why dont we start
using some library for easy cross platform atomic ops?
(1) there probably isn't one that does exactly
I read the thread Our CLUSTER implementation is pessimal
http://archives.postgresql.org/pgsql-hackers/2008-08/msg01371.php .
I would like to try/integrate that patch as we use CLUSTER a lot on our
system.
I was going to try to add the proper cost_index/cost_sort calls to decide
which
Matt bsg...@gmail.com writes:
Attempting to build 8.5 alpha on Windows XP (MSVC 2005) with Python support.
Path to local interpreter added to config.pl (C:\Python), but message is
presented:
Could not determine python version from path at build.pl line 38
Do the build scripts attempt to
On Tue, Jan 19, 2010 at 10:04 PM, Greg Smith g...@2ndquadrant.com wrote:
Josh Berkus wrote:
Actually, the report which MonetDB has published I believe is illegal.
If they're not running it through the TPC, they can't claim it's a
TPCH result.
I just resisted getting into that but now
Andres Freund wrote:
On Wednesday 20 January 2010 17:59:36 Tom Lane wrote:
Andres Freund and...@anarazel.de writes:
I realize its way too late in the cycle for that, but why dont we start
using some library for easy cross platform atomic ops?
(1) there probably isn't one that does exactly
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes:
Streaming Replication introduces a few places with a polling pattern
like this (in pseudocode):
while()
{
/* Check if variable in shared has advanced beoynd X */
SpinLockAcquire()
localvar = sharedvar;
On Wed, 2010-01-20 at 20:00 +0200, Heikki Linnakangas wrote:
Hot standby also has a polling loop where it waits for a
transaction a transaction to die, though I'm not sure if that can be
fit into the same model
I prefer that in the context of HS because the Startup process is
waiting for
On Wed, 2010-01-20 at 17:40 +0100, Andres Freund wrote:
or similar things with LWLockAcquire in a signal handler
[ grows visibly pale ] *Please* tell me we are not trying to take
locks in a signal handler. What happens if it interrupts code that
is already holding that lock?
Yes
Tom Lane wrote:
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes:
Streaming Replication introduces a few places with a polling pattern
like this (in pseudocode):
while()
{
/* Check if variable in shared has advanced beoynd X */
SpinLockAcquire()
localvar = sharedvar;
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes:
My point is that we should replace such polling loops with something
non-polling, using wait/signal or semaphores or something. That gets
quite a bit more complex. You'd probably still have the loop, but
instead of pg_usleep()
On Wed, Jan 20, 2010 at 18:59, Tom Lane t...@sss.pgh.pa.us wrote:
Matt bsg...@gmail.com writes:
Attempting to build 8.5 alpha on Windows XP (MSVC 2005) with Python support.
Path to local interpreter added to config.pl (C:\Python), but message is
presented:
Could not determine python
Tom Lane wrote:
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes:
My point is that we should replace such polling loops with something
non-polling, using wait/signal or semaphores or something. That gets
quite a bit more complex. You'd probably still have the loop, but
instead of
Magnus Hagander mag...@hagander.net writes:
Or we'd welcome a patch for a smarter way to detect the version ;)
This particular code doesn't look like it really needs to know the
*version*. What it wants is the full pathname of the python.lib file
that goes with the python executable. Isn't
Dimitri Fontaine wrote:
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes:
1. Initial archive recovery. Standby fetches WAL files from archive
using restore_command. When a file is not found in archive, we start
walreceiver and switch to state 2
2. Retrying to restore from
On Wed, Jan 20, 2010 at 20:24, Tom Lane t...@sss.pgh.pa.us wrote:
Magnus Hagander mag...@hagander.net writes:
Or we'd welcome a patch for a smarter way to detect the version ;)
This particular code doesn't look like it really needs to know the
*version*. What it wants is the full pathname of
On Wed, Jan 20, 2010 at 09:22:49PM +0200, Heikki Linnakangas wrote:
Tom Lane wrote:
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes:
My point is that we should replace such polling loops with something
non-polling, using wait/signal or semaphores or something. That gets
David Fetter da...@fetter.org writes:
On Wed, Jan 20, 2010 at 09:22:49PM +0200, Heikki Linnakangas wrote:
My point is that we should replace such polling loops with something
non-polling, using wait/signal or semaphores or something.
Is this a TODO yet?
It hardly seems concrete enough for a
On Wed, Jan 20, 2010 at 5:14 PM, Tom Lane t...@sss.pgh.pa.us wrote:
In that case I think you've way overcomplicated matters. Just deliver
the notification. We don't really care if the listener gets additional
notifications; the only really bad case would be if it failed to get an
event that
Thanks Dimitri, I'd missed that thread. Ok, slave will need a suitable
restore_comand in addition to primary_conninfo in recovery.conf, and
then extended communication failures (or shutting down the slave for a
while!) will not break the streaming setup (FWIW I tried this just now).
Sure,
Joachim Wieland j...@mcknight.de writes:
Okay, what about unprocessed notifications in the queue and a backend
executing UNLISTEN: can we assume that it is not interested in
notifications anymore once it executes UNLISTEN and discard all of
them even though there might be notifications that
committed
On fre, 2010-01-15 at 13:37 +0100, Christoph Berg wrote:
There's not much I have to add, maybe the documentation could add a
pointer to what keywords are recognized:
| The file uses an INI file format where the section name is the
| service name and the parameters are connection
Josh Berkus wrote:
Thanks Dimitri, I'd missed that thread. Ok, slave will need a suitable
restore_comand in addition to primary_conninfo in recovery.conf, and
then extended communication failures (or shutting down the slave for a
while!) will not break the streaming setup (FWIW I tried this just
On Jan 20, 2010, at 12:27 PM, Magnus Hagander wrote:
Well, it needs the version to match it to the DLL name. For python
2.6, it needs python26.dll. But yes, there should probably be some way
to ask python itself about that - that would be the non-naive method.
But as long as python is
Mark Wong wrote:
What the TPC provides isn't really a usable kit. It could be
entertaining to see how their kit works.
The one for TPC-H seems to work for a lot of people; the best of the
intros I found for how to make it go was
http://bhairav.serc.iisc.ernet.in/doc/Installation/tpch.htm
It seems like Custom GUCs are still in need of some work, as shown in my
recent email. In particular, they are not transaction safe - if a
transaction attempts to do DefineCustomFooVariable() and that
transaction aborts, the placeholder setting that it used is already gone
by the time it
On Wed, 2010-01-20 at 15:54 -0500, Tom Lane wrote:
Joachim Wieland j...@mcknight.de writes:
Okay, what about unprocessed notifications in the queue and a backend
executing UNLISTEN: can we assume that it is not interested in
notifications anymore once it executes UNLISTEN and discard all of
Attached is a patch for the next milestone on the Serializable wiki
page: changing the table-level predicate locks to SIREAD locks
without worrying about lifespan. (Implementing correct lifespan is
next.)
The result of not worrying about it is that they aren't cleaned up
at all, even when the
On Wed, Jan 20, 2010 at 11:08 PM, Jeff Davis pg...@j-davis.com wrote:
Yes. That is the case with the existing implementation as well, no?
We don't consider sending notifies until transaction end, so anything
that commits during the xact in which you UNLISTEN will get dropped.
Only if the
Jeff Davis pg...@j-davis.com writes:
On Wed, 2010-01-20 at 15:54 -0500, Tom Lane wrote:
Yes. That is the case with the existing implementation as well, no?
We don't consider sending notifies until transaction end, so anything
that commits during the xact in which you UNLISTEN will get
I've been working on my demo, and I'm discovering that due to the
connection from the walsender and walreceiver, smart shutdown from
pg_ctl doesn't work if replication is active.
This seems worth fixing; if we don't fix it, we should at least document it.
Comments?
--Josh
--
Sent via
Mark Kirkwood mark.kirkw...@catalyst.net.nz writes:
Josh Berkus wrote:
Sure, but if the archived WAL segments are NOT needed, how are they
supposed to get deleted? It doesn't take long to run out of disk space
if they're not being rotated.
From what I am seeing at the moment (8.5 devel
Hello hackers,
I've recently hit the message WARNING: pgstat wait timeout with PG
8.4.2.
I saw some reports about that message in the -bugs mailing list
http://archives.postgresql.org/pgsql-bugs/2009-12/msg00175.php
http://archives.postgresql.org/pgsql-bugs/2009-07/msg00081.php
where the
On Wed, 2010-01-20 at 21:26 +0200, Heikki Linnakangas wrote:
So there's just two states:
1. Recovering from archive
2. Streaming
We start from 1, and switch state at error.
This gives nice behavior from a user point of view. Standby tries to
make progress using either the archive or
Tom Lane wrote:
Mark Kirkwood mark.kirkw...@catalyst.net.nz writes:
Josh Berkus wrote:
Sure, but if the archived WAL segments are NOT needed, how are they
supposed to get deleted? It doesn't take long to run out of disk space
if they're not being rotated.
From what I am
Mark Kirkwood wrote:
The likely typical use case for streaming replication makes a good
case and automated safe way of pruning these guys
Sorry, stupid typo: should read '...makes a good case for an automated
safe way of pruning these'
--
Sent via pgsql-hackers mailing list
On Thu, Jan 21, 2010 at 8:04 AM, Josh Berkus j...@agliodbs.com wrote:
I've been working on my demo, and I'm discovering that due to the
connection from the walsender and walreceiver, smart shutdown from
pg_ctl doesn't work if replication is active.
This seems worth fixing; if we don't fix it,
If it's standby, it's a previously-existing behavior that a smart
shutdown doesn't work immediately during recovery. After a recovery
has been completed, it would work. Of course, I agree that such a
behavior should be documented.
Well, as long as streaming rep is running, you can't do a
Huh? *Archived* segments aren't supposed to get deleted, at least not
by any automatic Postgres action. It would be up to the DBA how long
he wants to keep them around.
OK. The docs indicated that the segments needed to be kept around in
case the slave fell behind. If that's not the case
On Wed, Jan 20, 2010 at 8:44 PM, Josh Berkus j...@agliodbs.com wrote:
If it's standby, it's a previously-existing behavior that a smart
shutdown doesn't work immediately during recovery. After a recovery
has been completed, it would work. Of course, I agree that such a
behavior should be
Robert Haas robertmh...@gmail.com writes:
On Wed, Jan 20, 2010 at 8:44 PM, Josh Berkus j...@agliodbs.com wrote:
Well, as long as streaming rep is running, you can't do a smart shutdown
... smart shutdown seems to treat the walreciever as a client
connection. At the very least, this should be
On Wed, Jan 20, 2010 at 8:56 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Wed, Jan 20, 2010 at 8:44 PM, Josh Berkus j...@agliodbs.com wrote:
Well, as long as streaming rep is running, you can't do a smart shutdown
... smart shutdown seems to treat the
Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
On Wed, Jan 20, 2010 at 8:44 PM, Josh Berkus j...@agliodbs.com wrote:
Well, as long as streaming rep is running, you can't do a smart shutdown
... smart shutdown seems to treat the walreciever as a client
connection. At the
Boszormenyi Zoltan z...@cybertec.at wrote:
I only wanted to call ECPGprepare() in case it wasn't already prepared.
ECPGprepare() also checks for the statement being already prepared
with ecpg_find_prepared_statement() but in case it exists it
DEALLOCATEs the statement and PREPAREs again so
On Tue, 2010-01-19 at 19:24 -0500, Tom Lane wrote:
(I'm still
wondering if we couldn't do without the lock altogether though.)
Here's the problem as I see it:
If we insert the notifications into the queue before actually recording
the commit, there's a window in between where another backend
On Wed, Jan 20, 2010 at 6:20 PM, Sergey E. Koposov m...@sai.msu.ru wrote:
Hello hackers,
I've recently hit the message WARNING: pgstat wait timeout with PG 8.4.2.
i see the same yesterday when initdb a freshly compiled 8.5dev +
lock_timeout patch
i thought maybe it was related to that patch
On Jan 14, 2010, at 2:03 PM, Joshua D. Drake wrote:
What I would (as a non hacker) would look for is:
(1) Generalized benchmarks between plpython(core) and plpython3u
I know a lot of these are subjective, but it is still good to see if
there are any curves or points that bring the
On Wed, Jan 20, 2010 at 9:32 PM, Jaime Casanova
jcasa...@systemguards.com.ec wrote:
On Wed, Jan 20, 2010 at 6:20 PM, Sergey E. Koposov m...@sai.msu.ru wrote:
Hello hackers,
I've recently hit the message WARNING: pgstat wait timeout with PG 8.4.2.
i see the same yesterday when initdb a
On Thu, Jan 21, 2010 at 10:44 AM, Josh Berkus j...@agliodbs.com wrote:
If it's standby, it's a previously-existing behavior that a smart
shutdown doesn't work immediately during recovery. After a recovery
has been completed, it would work. Of course, I agree that such a
behavior should be
1 - 100 of 107 matches
Mail list logo