On 16.07.2012 22:01, Robert Haas wrote:
On Sat, Jul 14, 2012 at 7:54 PM, Josh Berkusj...@agliodbs.com wrote:
So, here's the core issue with degraded mode. I'm not mentioning this
to block any patch anyone has, but rather out of a desire to see someone
address this core problem with some
On Mon, Jul 16, 2012 at 10:58 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
BTW, one little detail that I don't think has been mentioned in this thread
before: Even though the master currently knows whether a standby is
connected or not, and you could write a patch to act
On Mon, Jul 16, 2012 at 5:29 PM, Jeff Davis pg...@j-davis.com wrote:
On Tue, 2012-07-10 at 11:50 -0400, Bruce Momjian wrote:
I don't think we can assume that because pg_upgrade was run on the
master and standby that they are binary identical, can we? Technically
the user file are identical,
Hello,
I suppose that testing for the two cases and additional
one case which runs pg_do_encoding_conversion(), say latin1,
would be enough to confirm that encoding/decoding is properly
done, since the concrete conversion scheme is not significant
this case.
So I recommend that we
Am 17.07.12 05:21, schrieb Tom Lane:
Samuel Vogel s...@muel-vogel.de writes:
I'm currently on a university research project if performance could be
increased by substituting different inter-node search algorithms instead
of the currently used binary search.
Hm, what have you got in mind
On 16 July 2012 01:16, Tom Lane t...@sss.pgh.pa.us wrote:
We are now at the end of the originally scheduled one-month window for
the June commitfest. While the numbers look fairly bad:
Needs Review: 17, Waiting on Author: 10, Ready for Committer: 3, Committed:
29, Returned with Feedback:
On 28 June 2012 13:16, David E. Wheeler da...@justatheory.com wrote:
Very interesting design document for SQLite 4:
http://www.sqlite.org/src4/doc/trunk/www/design.wiki
I'm particularly intrigued by covering indexes. For example:
CREATE INDEX cover1 ON table1(a,b) COVERING(c,d);
On Jul 17, 2012, at 5:18 PM, Simon Riggs wrote:
Now that we have index-only scans in 9.2, I'm wondering if it would make
sense to add covering index support, too, where additional, unindexed
columns are stored alongside indexed columns.
Just to be clear, the ability to have covered
On 17 July 2012 16:21, David E. Wheeler da...@justatheory.com wrote:
On Jul 17, 2012, at 5:18 PM, Simon Riggs wrote:
Now that we have index-only scans in 9.2, I'm wondering if it would make
sense to add covering index support, too, where additional, unindexed
columns are stored alongside
On Jul 17, 2012, at 5:32 PM, Simon Riggs wrote:
CREATE INDEX ON foo (a, b, c, d);
allows
SELECT c, d FROM foo WHERE a = ? AND b = ?
to use an index only scan.
The phrase unindexed seems misleading since the data is clearly in
the index from the description on the URL you gave. And
On 17 July 2012 16:54, David E. Wheeler da...@justatheory.com wrote:
On Jul 17, 2012, at 5:32 PM, Simon Riggs wrote:
CREATE INDEX ON foo (a, b, c, d);
allows
SELECT c, d FROM foo WHERE a = ? AND b = ?
to use an index only scan.
The phrase unindexed seems misleading since the data is
On Tue, Jul 17, 2012 at 6:08 PM, Simon Riggs si...@2ndquadrant.com wrote:
On 17 July 2012 16:54, David E. Wheeler da...@justatheory.com wrote:
Yeah, but that index is unnecessarily big if one will never use c or d
in the search. The nice thing about covering indexes as described for
SQLite 4
-Original Message-
From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-
ow...@postgresql.org] On Behalf Of David E. Wheeler
Sent: Tuesday, July 17, 2012 11:55 AM
To: Simon Riggs
Cc: Pg Hackers
Subject: Re: [HACKERS] Covering Indexes
On Jul 17, 2012, at 5:32 PM, Simon
On 17 July 2012 17:41, David Johnston pol...@yahoo.com wrote:
Concretely, I would presume that the contents of a covering index could then
look like the following (a,b,c,d):
(2,1,2,A)
(2,1,5,A) -- the 5 is out of natural order but exists in the covering
part
(2,1,3,A)
Whereas PostgreSQL
On 07/17/2012 12:41 PM, David Johnston wrote:
So the question that needs to be asked is what kind of performance increase
can be had during DML (insert/update) statements and whether those gains are
worth pursuing. Since these other engines appear to allow both cases you
should be able to get
David E. Wheeler da...@justatheory.com
ca+u5nmjz33zsvqpzk-auoindxkq6elip1hgq53byodlpwfd...@mail.gmail.com writes:
On Jul 17, 2012, at 5:32 PM, Simon Riggs wrote:
The phrase unindexed seems misleading since the data is clearly in
the index from the description on the URL you gave. And since the
Robert Haas robertmh...@gmail.com writes:
On Mon, Jul 16, 2012 at 9:58 PM, Tom Lane t...@sss.pgh.pa.us wrote:
BTW, I wonder whether the code that checks for relfilenode conflict
when selecting a pg_class or relfilenode OID tries both file naming
conventions? If not, should we make it do so?
Samuel Vogel s...@muel-vogel.de writes:
Am 17.07.12 05:21, schrieb Tom Lane:
Samuel Vogel s...@muel-vogel.de writes:
I'm currently on a university research project if performance could be
increased by substituting different inter-node search algorithms instead
of the currently used binary
Excerpts from Andrew Dunstan's message of dom jul 15 16:42:22 -0400 2012:
I'm looking into that. But given that the default is to set
max_prepared_transactions to 0, shouldn't we just remove that test from the
normal installcheck schedule?
We could provide an alternative schedule that does
On Fri, Jul 13, 2012 at 1:15 AM, Magnus Hagander mag...@hagander.net wrote:
On Thu, Jul 12, 2012 at 6:07 PM, Fujii Masao masao.fu...@gmail.com wrote:
On Thu, Jul 12, 2012 at 8:39 PM, Magnus Hagander mag...@hagander.net wrote:
On Tue, Jul 10, 2012 at 7:03 PM, Fujii Masao masao.fu...@gmail.com
I wrote:
I had thought that we might get a performance boost here by saving fsync
queue traffic, but I see that md.c was already not calling
register_dirty_segment for temp rels, so there's no joy there.
Actually, wait a second. We were smart enough to not send fsync
requests in the first
Excerpts from Kyotaro HORIGUCHI's message of mar jul 17 05:01:10 -0400 2012:
I think that's probably too much engineering for something that doesn't
really warrant it. A real solution to this problem could be to create
yet another new test file containing just this function definition and
On ons, 2012-05-09 at 14:44 -0400, Alvaro Herrera wrote:
Excerpts from Peter Eisentraut's message of mié may 09 13:54:53 -0400 2012:
Split contrib documentation into extensions and programs
Create separate appendixes for contrib extensions and other server
plugins on the one hand, and
On Tue, 2012-07-17 at 01:02 -0700, Daniel Farina wrote:
Could pg_upgrade emit WAL segment(s) to provide continuity of a
timeline? So something like:
By segments did you mean records?
* Take down the writable primary for pg_upgrade
* Some WAL is emitted and possibly archived
* The old
On Tue, Jul 17, 2012 at 01:56:19PM -0400, Alvaro Herrera wrote:
Excerpts from Andrew Dunstan's message of dom jul 15 16:42:22 -0400 2012:
I'm looking into that. But given that the default is to set
max_prepared_transactions to 0, shouldn't we just remove that test from the
normal
There is a new release of the PostgreSQL buildfarm client available at
https://github.com/downloads/PGBuildFarm/client-code/build-farm-4_7.tgz
Most of the changes in the release are minor bug fixes. Enhancements
include:
* extra_config can now have a DEFAULT key, and these entries are
On Mon, Jul 16, 2012 at 05:29:26PM -0700, Jeff Davis wrote:
On Tue, 2012-07-10 at 11:50 -0400, Bruce Momjian wrote:
I don't think we can assume that because pg_upgrade was run on the
master and standby that they are binary identical, can we? Technically
the user file are identical, but the
Robert Haas robertmh...@gmail.com writes:
On Mon, Jul 16, 2012 at 3:18 PM, Tom Lane t...@sss.pgh.pa.us wrote:
BTW, while we are on the subject: hasn't this split completely broken
the statistics about backend-initiated writes?
Yes, it seems to have done just that.
So I went to fix this in
On 17 July 2012 23:56, Tom Lane t...@sss.pgh.pa.us wrote:
This implies that nobody has done pull-the-plug testing on either HEAD
or 9.2 since the checkpointer split went in (2011-11-01), because even
a modicum of such testing would surely have shown that we're failing to
fsync a significant
On Tue, Jul 17, 2012 at 11:55 AM, Jeff Davis pg...@j-davis.com wrote:
On Tue, 2012-07-17 at 01:02 -0700, Daniel Farina wrote:
Could pg_upgrade emit WAL segment(s) to provide continuity of a
timeline? So something like:
By segments did you mean records?
Yes. It would be nicer not to have to
On 07/18/2012 06:56 AM, Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
On Mon, Jul 16, 2012 at 3:18 PM, Tom Lane t...@sss.pgh.pa.us wrote:
BTW, while we are on the subject: hasn't this split completely broken
the statistics about backend-initiated writes?
Yes, it seems to have done
Craig Ringer ring...@ringerc.id.au writes:
On 07/18/2012 06:56 AM, Tom Lane wrote:
This implies that nobody has done pull-the-plug testing on either HEAD
or 9.2 since the checkpointer split went in (2011-11-01)
That makes me wonder if on top of the buildfarm, extending some
buildfarm
Hi all,
I reviewed the source code, and saw the following calling path:
StartupXLOG() StartupDatabase() RmgrTable[rmid].rm_cleanup()
btree_xlog_cleanup() _bt_insert_parent _bt_insertonpg() XLogInsert()
As we can see, during xlog replaying, XLog may be emitted. So whether there
xu2002261 xu2002...@163.com writes:
Hi all,
I reviewed the source code, and saw the following calling path:
StartupXLOG() StartupDatabase() RmgrTable[rmid].rm_cleanup()
btree_xlog_cleanup() _bt_insert_parent _bt_insertonpg() XLogInsert()
As we can see, during xlog
Thanks a lot.
oops, indeed, the clean up stage is not in the XLog replay, So there is no
problem.
2012-07-18
xu2002261
发件人: Tom Lane
发送时间: 2012-07-18 10:05:26
收件人: xu2002261
抄送: pgsql-hackers
主题: Re: [HACKERS] During Xlog replaying, is there maybe emitted xlog?
xu2002261
On 07/16/2012 02:39 PM, Robert Haas wrote:
Unfortunately, there are lots of important operations (like bulk
loading, SELECT * FROM bigtable, and VACUUM notverybigtable) that
inevitably end up writing out their own dirty buffers. And even when
the background writer does write something, it's not
On 07/17/2012 06:56 PM, Tom Lane wrote:
So I went to fix this in the obvious way (attached), but while testing
it I found that the number of buffers_backend events reported during
a regression test run barely changed; which surprised the heck out of
me, so I dug deeper. The cause turns out to
On Tue, Jul 17, 2012 at 04:49:39PM -0700, Daniel Farina wrote:
On Tue, Jul 17, 2012 at 11:55 AM, Jeff Davis pg...@j-davis.com wrote:
On Tue, 2012-07-17 at 01:02 -0700, Daniel Farina wrote:
Could pg_upgrade emit WAL segment(s) to provide continuity of a
timeline? So something like:
By
On 07/18/2012 12:00 PM, Greg Smith wrote:
The second justification for the split was that it seems easier to get
a low power result from, which I believe was the angle Peter Geoghegan
was working when this popped up originally. The checkpointer has to
run sometimes, but only at a 50% duty
On 07/18/2012 08:31 AM, Tom Lane wrote:
Not sure if we need a whole farm, but certainly having at least one
machine testing this sort of stuff on a regular basis would make me feel
a lot better.
OK. That's something I can actually be useful for.
My current qemu/kvm test harness control code
Greg Smith g...@2ndquadrant.com writes:
On 07/17/2012 06:56 PM, Tom Lane wrote:
Furthermore, I would say that any performance testing done since then,
if it wasn't looking at purely read-only scenarios, isn't worth the
electrons it's written on. In particular, any performance gain that
41 matches
Mail list logo