On mån, 2011-09-05 at 16:53 -0400, Bruce Momjian wrote:
hubert depesz lubaczewski wrote:
Good. Is it possible to compile with debug symbols, -g? Odd you are
crashing in libc.
this had debug:
./configure \
--prefix=/opt/pgsql-9.0.5a-int \
--enable-debug \
On lör, 2011-09-03 at 19:18 -0400, Bruce Momjian wrote:
FYI, here are all the C files with over 6k lines:
- 45133 ./interfaces/ecpg/preproc/preproc.c
- 33651 ./backend/parser/gram.c
- 17551 ./backend/parser/scan.c
14209 ./bin/pg_dump/pg_dump.c
10590 ./backend/access/transam/xlog.c
On 2011-09-06 04:55, Robert Haas wrote:
On Mon, Sep 5, 2011 at 10:52 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Robert Haas's message of lun sep 05 23:27:16 -0300 2011:
On Mon, Sep 5, 2011 at 9:14 AM, Yeb Havingayebhavi...@gmail.com wrote:
I didn't see my name as one
Hi,
I am interested in this thread because I may be able to borrow a big
IBM machine and might be able to do some tests on it if it somewhat
contributes enhancing PostgreSQL. Is there anything I can do for this?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
On Mon, Sep 5, 2011 at 21:01, Tom Lane t...@sss.pgh.pa.us wrote:
What we have to start with is WHERE b = 0::smallint, which the planner
is able to prove implies the index predicate WHERE b = 0::integer,
so both indexes are considered. But the check for predicate redundancy
in
On 05.09.2011 21:55, Bruce Momjian wrote:
Heikki Linnakangas wrote:
On 11.03.2011 19:41, Tom Lane wrote:
Heikki Linnakangasheikki.linnakan...@enterprisedb.com writes:
On 11.03.2011 17:59, Tom Lane wrote:
But that will be fixed during WAL replay.
Not under the circumstances that started
On Mon, Sep 05, 2011 at 05:26:00PM -0400, Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
Odd it is dying in the memory freeing at executor close --- not in the
ltree code.
Doesn't seem odd. The glibc complaint previously shown already
indicates this is a memory stomp problem.
Hi,
Worked a bit to get the ltree problem down to smallest possible, repeatable,
situation.
Initial setup:
1. PostgreSQL 8.3.11, configured with:
./configure\
--prefix=/opt/pgsql-8.3.11-int \
--disable-rpath\
--without-perl
On Tue, Sep 6, 2011 at 12:41 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Pity we can't use git notes.
Well, I guess there's no law that says we can't. Should I give it a try?
I don't see why not :-) (But my guess is that you're going to need to
publish some pull and push
On Tue, Sep 6, 2011 at 6:21 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Nope.
On a closer look, this isn't only a problem for page deletion. Page
splitting also barfs if it can't find the parent of a page. As the code
stands, a missing downlink is not harmless, but
Hi,
Unlogged tables seems to me to follow a similar goal. Obviously GiST
indexes are not supported there.
Do you know the technical reason?
Do you see some synergy in your work on fast GiST index building and
unlogged tables?
Yours, Stefan
2011/9/6 Alexander Korotkov aekorot...@gmail.com:
On 06.09.2011 16:40, Robert Haas wrote:
On Tue, Sep 6, 2011 at 6:21 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
The way it would work is that on page split the right page is flagged with
MISSING_DOWNLINK flag. When the downlink is inserted into the parent, the
flag is
On 09/06/2011 09:35 AM, Robert Haas wrote:
[git notes is more than cumbersome ]
As much as I'd like to have something like this, I'm inclined to think
that it will take a whole lot more time to get this facility working
than it's really worth. Unless someone has a strong opinion the other
On Tue, Sep 6, 2011 at 4:33 AM, Tatsuo Ishii is...@postgresql.org wrote:
I am interested in this thread because I may be able to borrow a big
IBM machine and might be able to do some tests on it if it somewhat
contributes enhancing PostgreSQL. Is there anything I can do for this?
That would be
On Tue, Sep 6, 2011 at 9:45 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Do you really need to hold the page locks for all that time, or could
you cheat? Like... release the locks on the split pages but then go
back and reacquire them to clear the flag...
Hmm, there's
Hi,
Is there a plan to wrap up 9.2 Alpha 1 before the next commitfest?
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
Hi!
Unlogged tables seems to me to follow a similar goal. Obviously GiST
indexes are not supported there.
Do you know the technical reason?
GiST using serial numbers of operations for concurrency. In current
implementation xlog record ids are used in capacity of that numbers. In
unlogged
Bruce Momjian wrote:
Piyush Newe wrote:
Hi,
I was randomly testing some date related stuff on PG observed that the
outputs were wrong.
e.g.
postgres=# SELECT TO_DATE('01-jan-2010', 'DD-MON-YY');
to_date
3910-01-01 - Look at this
(1 row)
Robert Haas wrote:
On Tue, Sep 6, 2011 at 9:45 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Do you really need to hold the page locks for all that time, or could
you cheat? ?Like... release the locks on the split pages but then go
back and reacquire them to clear the
Peter Eisentraut wrote:
On l?r, 2011-09-03 at 19:18 -0400, Bruce Momjian wrote:
FYI, here are all the C files with over 6k lines:
- 45133 ./interfaces/ecpg/preproc/preproc.c
- 33651 ./backend/parser/gram.c
- 17551 ./backend/parser/scan.c
14209 ./bin/pg_dump/pg_dump.c
10590
Devrim G?ND?Z wrote:
Is there a plan to wrap up 9.2 Alpha 1 before the next commitfest?
We talked about it on core and no one seems interested in doing the
packaging. :-(
--
Bruce Momjian br...@momjian.ushttp://momjian.us
EnterpriseDB
That would be great. What I've been using as a test case is pgbench
-S -c $NUM_CPU_CORES -j $NUM_CPU_CORES with scale factor 100 and
shared_buffers=8GB.
I think what you'd want to compare is the performance of unpatched
master, vs. the performance with this line added to s_lock.h for your
On Tue, 2011-09-06 at 10:06 -0400, Bruce Momjian wrote:
Devrim GNDZ wrote:
Is there a plan to wrap up 9.2 Alpha 1 before the next commitfest?
We talked about it on core and no one seems interested in doing the
packaging. :-(
Oh, what if noone will be interested in packaging until the
On Tue, Sep 6, 2011 at 10:03 AM, Bruce Momjian br...@momjian.us wrote:
Robert Haas wrote:
On Tue, Sep 6, 2011 at 9:45 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Do you really need to hold the page locks for all that time, or could
you cheat? ?Like... release the locks
David Fetter da...@fetter.org writes:
On Mon, Sep 05, 2011 at 10:07:29PM -0300, Alvaro Herrera wrote:
What would be the point?
Removing the legacy char type, per original post. :)
Removing it is the wrong solution.
The idea of renaming it to char1 might be an appropriate balance of pain
Marti Raudsepp ma...@juffo.org writes:
On Mon, Sep 5, 2011 at 21:01, Tom Lane t...@sss.pgh.pa.us wrote:
What we have to start with is WHERE b = 0::smallint, which the planner
is able to prove implies the index predicate WHERE b = 0::integer,
so both indexes are considered. Â But the check for
Here is the latest spgist patch, which has all planned features as well as
all overhead, introduced by concurrency and recovery, so performance
measurement should be realistic now.
Oleg
On Mon, 5 Sep 2011, Oleg Bartunov wrote:
I attached wrong patch in previous message, sorry ! Here is a
2011/9/6 Bruce Momjian br...@momjian.us:
Devrim GÜNDÜZ wrote:
Is there a plan to wrap up 9.2 Alpha 1 before the next commitfest?
We talked about it on core and no one seems interested in doing the
packaging. :-(
Well I don't particularly mind pushing a tag and bundling it, but I
guess the
Robert Haas wrote:
2011/9/6 Bruce Momjian br...@momjian.us:
Devrim G?ND?Z wrote:
Is there a plan to wrap up 9.2 Alpha 1 before the next commitfest?
We talked about it on core and no one seems interested in doing the
packaging. ?:-(
Well I don't particularly mind pushing a tag and
Uh, have we addressed this? I don't think so.
---
Heikki Linnakangas wrote:
On 02.04.2011 20:48, Tom Lane wrote:
Heikki Linnakangasheikki.linnakan...@enterprisedb.com writes:
We sometimes transform IN-clauses to a
Nope, this hasn't been addressed. FWIW, I put it on the todo list when I
stopped working on it.
On 06.09.2011 20:48, Bruce Momjian wrote:
Uh, have we addressed this? I don't think so.
---
Heikki Linnakangas wrote:
On
Heikki Linnakangas wrote:
Nope, this hasn't been addressed. FWIW, I put it on the todo list when I
stopped working on it.
Oh, I see it now. Thanks.
---
On 06.09.2011 20:48, Bruce Momjian wrote:
Uh, have we
Bruce Momjian br...@momjian.us writes:
Uh, have we addressed this? I don't think so.
No. IIRC, I didn't like Heikki's proposed patch, so it's on my head
to come up with something better.
regards, tom lane
--
Sent via pgsql-hackers mailing list
Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
Uh, have we addressed this? I don't think so.
No. IIRC, I didn't like Heikki's proposed patch, so it's on my head
to come up with something better.
You can blame me for getting it into the parser. It used to be in
gram.y!
--
On 06.09.2011 20:53, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjianbr...@momjian.us writes:
Uh, have we addressed this? I don't think so.
No. IIRC, I didn't like Heikki's proposed patch, so it's on my head
to come up with something better.
You can blame me for getting it into the
Heikki Linnakangas wrote:
On 06.09.2011 20:53, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjianbr...@momjian.us writes:
Uh, have we addressed this? I don't think so.
No. IIRC, I didn't like Heikki's proposed patch, so it's on my head
to come up with something better.
You can
On 09/06/2011 07:34 PM, Oleg Bartunov wrote:
Here is the latest spgist patch, which has all planned features as
well as
all overhead, introduced by concurrency and recovery, so performance
measurement should be realistic now.
Oleg
Sorry for not getting the might-be-obvious here, but will
Here's version 2 of the patch, mainly to silence compiler warnings
about missing case statements from a switch over SubLinkType enum.
Also expanded commit message a little and changed whitespace to be
more consistent with nearby code.
Regards,
Marti
From 9f987efacfe2cd2af82722775127605e690df976
On Tue, Sep 6, 2011 at 10:21 PM, Andreas Joseph Krogh
andr...@officenet.nowrote:
Sorry for not getting the might-be-obvious here, but will this patch
bring indexed substring-search to PG? So queries conceptually equal to
this will be possible to index: WHERE som_col @@
Yes, it has always been a time vs. value question. I am not sure how I
feel on the matter but I am away too often to help anyway.
I think the alphas have been extremely valuable for testing. And with
some of the stuff going into CF1 and CF2 for 9.2, we really need some
early testing.
Or, to
[ Sorry for letting this slip through the cracks ... I think I got
distracted by collation bugs :-( ]
Noah Misch n...@leadboat.com writes:
On Sat, Mar 12, 2011 at 12:44:29PM -0500, Tom Lane wrote:
Noah Misch n...@leadboat.com writes:
A suitably-instrumented run of make installcheck-world
Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
If you have the timezone configured to a non-default value in
postgresql.conf, and you comment it out and reload, it says:
LOG: parameter TimeZone removed from configuration file, reset to default
...but at least when I tested
Excerpts from Ants Aasma's message of mar sep 06 12:40:04 -0300 2011:
On Mon, Sep 5, 2011 at 4:55 PM, Greg Stark st...@mit.edu wrote:
What I wouldn't mind seeing is a graph of all includes and what they
include. This might help figure out what layering violations there are
like the one that
Bruce Momjian br...@momjian.us writes:
Was this dealt with?
Yes, as much as I think is reasonable anyway. See
commit e05b866447899211a0c2df31bf0671faac4fc3e5.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to
On Tue, Sep 6, 2011 at 19:51, Tom Lane t...@sss.pgh.pa.us wrote:
Marti Raudsepp ma...@juffo.org writes:
So it seems the more fundamental issue is that b=0 and b='0'
conditions are normalized differently when b is smallint.
That's not a fundamental issue, if by that you mean that it's a bug to
On Tue, Sep 6, 2011 at 3:05 PM, Bruce Momjian br...@momjian.us wrote:
Peter Eisentraut wrote:
On l?r, 2011-09-03 at 19:18 -0400, Bruce Momjian wrote:
FYI, here are all the C files with over 6k lines:
- 45133 ./interfaces/ecpg/preproc/preproc.c
- 33651 ./backend/parser/gram.c
- 17551
On Tue, Sep 6, 2011 at 3:56 PM, Simon Riggs si...@2ndquadrant.com wrote:
The only way I would entertain thoughts of major refactoring would be
if comprehensive tests were contributed, so we could verify everything
still works afterwards.
That sounds like a really good idea. Mind you, I don't
Robert Haas robertmh...@gmail.com writes:
On Mon, Sep 5, 2011 at 1:56 PM, Andy Colson a...@squeakycode.net wrote:
This patch:
https://commitfest.postgresql.org/action/patch_view?id=605
Seems to have been after thoughts, and back burner stuff, and forgotten
about...
Has it already been
On Tue, Sep 6, 2011 at 3:48 AM, Robert Haas robertmh...@gmail.com wrote:
On Mon, Sep 5, 2011 at 2:02 PM, Andy Colson a...@squeakycode.net wrote:
Taking into account Noah's and Greg's Displaying accumulated autovacuum
cost patch is also sending to logs, do we all now agree that this is proper
On Tue, Sep 6, 2011 at 9:12 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Mon, Sep 5, 2011 at 1:56 PM, Andy Colson a...@squeakycode.net wrote:
This patch:
https://commitfest.postgresql.org/action/patch_view?id=605
Seems to have been after thoughts, and
On Fri, Sep 2, 2011 at 1:19 PM, Magnus Hagander mag...@hagander.net wrote:
From what I can tell, everytime I start a postmaster on HEAD (at least
when i've set wal_level=archive, and max_wal_senders 0), I get the
message:
LOG: terminating all walsender processes to force cascaded standby(s)
On Tue, Sep 6, 2011 at 3:31 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Bruce Momjian br...@momjian.us writes:
Was this dealt with?
Yes, as much as I think is reasonable anyway. See
commit e05b866447899211a0c2df31bf0671faac4fc3e5.
I am (and, I think, Alvaro is also) of the opinion that the
On Mon, Sep 5, 2011 at 11:38 AM, Magnus Hagander mag...@hagander.net wrote:
On Sun, Sep 4, 2011 at 19:02, Simon Riggs si...@2ndquadrant.com wrote:
On Fri, Sep 2, 2011 at 6:52 PM, Magnus Hagander mag...@hagander.net wrote:
Attached patch implements a low watermark wal location in the
walsender
hubert depesz lubaczewski dep...@depesz.com writes:
Worked a bit to get the ltree problem down to smallest possible, repeatable,
situation.
I looked at this again and verified that indeed, commit
8eee65c996048848c20f6637c1d12b319a4ce244 introduced an incompatible
change into the on-disk format
Robert Haas robertmh...@gmail.com writes:
On Tue, Sep 6, 2011 at 12:41 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Pity we can't use git notes.
I spent some time looking at this this morning, and my reaction is
yaggh!!
Yeah, we had this same discussion six weeks ago.
Dimitri Fontaine dimi...@2ndquadrant.fr wrote:
Kevin Grittner kevin.gritt...@wicourts.gov writes:
(1) We're talking about a new /bin executable to do this which
could be referenced in an archive_command string or run from a
script called by archive_command, right?
That, or an internal
Dimitri Fontaine dimi...@2ndquadrant.fr wrote:
I think the solution to that problem is to provide a default
archive command that just does the very simple thing, namely
moving the WAL file to some place given as parameter. Some
*local* mount point.
I think we've been mostly in agreement,
Robert Haas robertmh...@gmail.com writes:
On Tue, Sep 6, 2011 at 3:31 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Bruce Momjian br...@momjian.us writes:
Was this dealt with?
Yes, as much as I think is reasonable anyway. See
commit e05b866447899211a0c2df31bf0671faac4fc3e5.
I am (and, I think,
Hi list,
This patch adds the backend's current running query to the backend
crash message.
The crashing query is often a good starting point in debugging the
cause, and much more easily accessible than core dumps.
Example output:
LOG: server process (PID 31451) was terminated by signal 9:
On Tue, Sep 6, 2011 at 4:40 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Tue, Sep 6, 2011 at 12:41 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Pity we can't use git notes.
I spent some time looking at this this morning, and my reaction is
On Tue, Sep 6, 2011 at 4:52 PM, Marti Raudsepp ma...@juffo.org wrote:
This patch adds the backend's current running query to the backend
crash message.
The crashing query is often a good starting point in debugging the
cause, and much more easily accessible than core dumps.
Example output:
I wrote:
Robert Haas robertmh...@gmail.com writes:
I am (and, I think, Alvaro is also) of the opinion that the behavior
here is still not really right.
I don't see a practical way to do better unless we can find a less
horridly inefficient way of implementing identify_system_timezone().
Martijn van Oosterhout wrote:
-- Start of PGP signed section.
On Fri, Apr 08, 2011 at 02:10:56PM -0400, Tom Lane wrote:
Muhammad Usama m.us...@gmail.com writes:
While using the vacuumlo utility I encountered a redundant carriage
return(\r') character in the output. It is required in any
There was a discussion months ago about helping people document the
pgpass columns, so I added a documentation sentence suggestion the use
of a comment. Patch attached and applied to 9.1 and head.
--
Bruce Momjian br...@momjian.ushttp://momjian.us
EnterpriseDB
Marti Raudsepp ma...@juffo.org writes:
This patch adds the backend's current running query to the backend
crash message.
Sorry, this patch is entirely unacceptable. We cannot have the
postmaster's functioning depending on the contents of shared memory
still being valid ... most especially not
On Tue, Sep 6, 2011 at 5:16 PM, Tom Lane t...@sss.pgh.pa.us wrote:
I wrote:
Robert Haas robertmh...@gmail.com writes:
I am (and, I think, Alvaro is also) of the opinion that the behavior
here is still not really right.
I don't see a practical way to do better unless we can find a less
On tis, 2011-09-06 at 17:33 -0400, Bruce Momjian wrote:
+(You can add a reminder comment to the file by copying the line above and
+preceeding it with literal#/.)
Fix spelling please.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
On Tue, Sep 6, 2011 at 5:34 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Marti Raudsepp ma...@juffo.org writes:
This patch adds the backend's current running query to the backend
crash message.
Sorry, this patch is entirely unacceptable. We cannot have the
postmaster's functioning depending on
On Wed, Sep 7, 2011 at 00:34, Tom Lane t...@sss.pgh.pa.us wrote:
No, I don't think your attempts to validate the data are
adequate, nor do I believe they can be made adequate.
Can you think of any concrete situations that would fail the current validation?
As far as I can tell, the only
Robert Haas robertmh...@gmail.com writes:
On Tue, Sep 6, 2011 at 5:34 PM, Tom Lane t...@sss.pgh.pa.us wrote:
And I doubt
that the goal is worth taking risks for.
I am unable to count the number of times that I have had a customer
come to me and say well, the backend crashed. And I go look
Robert Haas robertmh...@gmail.com wrote:
Tom Lane t...@sss.pgh.pa.us wrote:
Marti Raudsepp ma...@juffo.org writes:
This patch adds the backend's current running query to the
backend crash message.
Sorry, this patch is entirely unacceptable. We cannot have the
postmaster's functioning
On Tue, Sep 6, 2011 at 6:05 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Tue, Sep 6, 2011 at 5:34 PM, Tom Lane t...@sss.pgh.pa.us wrote:
And I doubt
that the goal is worth taking risks for.
I am unable to count the number of times that I have had a
On 6 September 2011 21:07, Robert Haas robertmh...@gmail.com wrote:
On Tue, Sep 6, 2011 at 3:56 PM, Simon Riggs si...@2ndquadrant.com wrote:
The only way I would entertain thoughts of major refactoring would be
if comprehensive tests were contributed, so we could verify everything
still works
On 07/09/11 01:13, Peter Geoghegan wrote:
On 6 September 2011 08:29, Peter Eisentraut pete...@gmx.net wrote:
I was thinking about splitting up plpython.c, but it's not even on that
list. ;-)
IIRC the obesity of that file is something that Jan Urbański intends
to fix, or is at least
Peter Eisentraut wrote:
On tis, 2011-09-06 at 17:33 -0400, Bruce Momjian wrote:
+(You can add a reminder comment to the file by copying the line above
and
+preceeding it with literal#/.)
Fix spelling please.
Fixed, thanks.
--
Bruce Momjian br...@momjian.us
Hi Pavel,
I can get:
ERROR: permission denied to set parameter plpgsql.prepare_plans
with this script:
set plpgsql.prepare_plans to on_start;
create or replace function test1(a integer) returns integer as $$
begin
return a+1;
end;
$$ language plpgsql;
If test1() exists, then this script
On 7 September 2011 00:13, Peter Geoghegan pe...@2ndquadrant.com wrote:
* Within TUs, we unshadow a previously shadowed variable, so we link
to a global variable rather than one local to the original/other new
file. Unlikely to be a problem. Here's what I get when I compile
xlog.c in the usual
Peter Geoghegan wrote:
On 7 September 2011 00:13, Peter Geoghegan pe...@2ndquadrant.com wrote:
* Within TUs, we unshadow a previously shadowed variable, so we link
to a global variable rather than one local to the original/other new
file. Unlikely to be a problem. Here's what I get when I
On 7 September 2011 01:18, Bruce Momjian br...@momjian.us wrote:
I am confused how moving a function from one C file to another could
cause breakage?
I'm really concerned about silent breakage, however unlikely - that is
also Simon and Robert's concern, and rightly so. If it's possible in
Tom Lane wrote:
hubert depesz lubaczewski dep...@depesz.com writes:
Worked a bit to get the ltree problem down to smallest possible,
repeatable, situation.
I looked at this again and verified that indeed, commit
8eee65c996048848c20f6637c1d12b319a4ce244 introduced an incompatible
change
Tom Lane wrote:
Bernd Helmle maili...@oopsware.de writes:
--On 10. April 2011 13:53:52 -0400 Tom Lane t...@sss.pgh.pa.us wrote:
The core team has therefore decided to wrap back-branch
update releases this Thursday for release Monday 4/18.
Hmm, I would like to see the patch for
On Wed, Sep 7, 2011 at 5:22 AM, Simon Riggs si...@2ndquadrant.com wrote:
Fujii - the original goal here was to avoid having a unexplained
disconnection in the logs. The only way to do this cleanly is to have
a disconnection reason passed to the walsender, rather than just a
blind signal. Looks
On Sat, Sep 3, 2011 at 5:10 AM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
(2) It should copy, not move, with protection against overwriting
an existing file.
I agree that basically archive_command should not overwrite an existing file.
But if the size of existing file is less than
On 08/22/2011 01:22 AM, Pavan Deolasee wrote:
Hi All,
Here is a revised patch based on our earlier discussion. I implemented
Robert's idea of tracking the vacuum generation number in the line
pointer itself. For LP_DEAD line pointers, the lp_off/lp_len is unused
(and always set to 0 for heap
On Tue, Sep 06, 2011 at 03:00:42PM -0400, Tom Lane wrote:
Noah Misch n...@leadboat.com writes:
On Sat, Mar 12, 2011 at 12:44:29PM -0500, Tom Lane wrote:
I wonder whether we should instead fix this by copying the correct tuple
length.
Seems like a step in the wrong direction. We only
On Tue, Sep 6, 2011 at 3:02 AM, Andy Colson a...@squeakycode.net wrote:
Several people thought a view or some-non-log option would be better.
+1
Tomas
replied but I need to go back in time to post diagnose a problem, and I
saw no replies to that.
You can go back in time if you periodically
Hi Alexey, I was taking a quick look at this patch, and have a question for ya.
I have a default config from initdb, there is a new setting at the end but its
commented out.
root@storm: /db/pg92
# /etc/rc.d/postgresql start
Starting PostgreSQL:
root@storm: /db/pg92
# more serverlog
LOG:
87 matches
Mail list logo