in the future too.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Supportwww.2ndQuadrant.us
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
index dbf966b..f701b8f 100644
--- a/doc/src/sgml/monitoring.sgml
+++ b
.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Supportwww.2ndQuadrant.us
diff --git a/src/backend/postmaster/bgwriter.c b/src/backend/postmaster/bgwriter.c
index 43a149e..0ce8e2b 100644
--- a/src/backend/postmaster/bgwriter.c
+++ b/src
have checked when I ran into my problem (that other system stats views
were also working or not).
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Supportwww.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers
platform. The how
long does it take to find out the current time on every supported
PostgreSQL platform? question is one I'd like to have an answer to, but
it's hard to collect properly. All I know is that I don't have any
system where it's slow to properly test again here.
--
Greg Smith
sync, but then crossed
to other code that called it fsync, and made the external UI use that
name. No objections to sorting that out within my patch so it's consistent.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Supportwww
already have a
reviewer attached to them. Many of the remaining patches are pretty
approachable even if you're relatively new to reviewing PostgreSQL
code. See the usual for details:
http://wiki.postgresql.org/wiki/Reviewing_a_Patch
http://wiki.postgresql.org/wiki/RRReviewers
--
Greg Smith
at this until now because I
already had some patch development and review work to finish before the
CommitFest deadline we just crossed. Now I can go back to reviewing
other people's work.
P.S. There is no pgsql-patch list anymore; everything goes through the
hackers list now.
--
Greg Smith
-rrreviewers mailing list.
Whereas the pgsql-hackers list is the right destination for the actual
review itself.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
Tom Lane wrote:
I'm hoping that Greg Smith will take the lead on testing
this, since he seems to have spent the most time in the area so far.
It's not coincidence that the chapter of my book I convinced the
publisher to release as a sample is the one that covers this area; this
mess has
,
and what happens is completely dependent on filesystem.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Supportwww.2ndQuadrant.us
PostgreSQL 9.0 High Performance: http://www.2ndQuadrant.com/books
--
Sent via pgsql-hackers mailing list
trying to find time for, so I
can investigate this further myself.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
fix in it. I'll update the docs on the wiki
accordingly, once I've recovered from this morning's flight out West.
I forgot to credit Robert Noles here for rediscovering this bug on one
of our systems and bringing it to my attention.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com
to reason out what's going wrong myself yet. Wanted to
validate that Matt's report wasn't a unique one though, with a bit more
detail included about the state the system gets into, and one potential
fix (increasing wal_keep_segments) already tried without improvement.
--
Greg Smith
doubled in size.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
, and I haven't heard a good reason yet why those need
to coupled together.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Supportwww.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
described, except to say that I think
it's OK for complicated situations to give up and throw a serialization
error. I'm already collecting a list of pathological tests and will try
to add something based on your problem case, then see what we can do
with it later.
--
Greg Smith, 2ndQuadrant US g
at the right time to do the syntax and implementation
part first as well, that's the order it's ended up happening in. We're
only making the concurrency part a second priority right now in order to
break the development into managable chunks.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com
out looking for
them now that I have some basic testing that works for doing so.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Supportwww.2ndQuadrant.us
merge-test-v1.tar
Description: Unix tar archive
--
Sent via pgsql
and fine more unexpected
behavior edge cases and general bugs.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
at a decently large scale. The COPY used to populate the
giant accounts table takes advantage of the WAL bypass fast path if
available, and you can watch performance tank the minute one of the
options that disables it is turned on.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
details
that make for only a minor improvement until that's taken care of.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
about when
the right time to get into that whole giant subject is and who is going
to work on.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
://suckit.blog.hu/2009/09/29/postgresql_history and the tests
Jignesh did while at Sun
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
of it with a quick intro to add some context.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
Robert Haas wrote:
Greg, are you still working on a review of this patch?
Yes, just had more distractions while coming to speed up on this area
than I'd hoped. I'll get a second round of looking at this done by the
weekend.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore
instead.
That regex seems a bit too specific.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
to ship at all, and when you do the result is difficult to
support.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
if they are in or out of sync with one
another based on the conversation they have when they first connect to
one another, that suggests to me there needs to be improvements made in
the communications protocol they use to exchange messages.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore
is 11 months old at this point, which makes it still a bleeding edge
kernel in my book.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
was trying to make to you. And the fact
Oracle does this is why it's able to scale to high partition counts
better than PostgreSQL can.
You can read more about the work that was being done here at
http://wiki.postgresql.org/wiki/Table_partitioning
--
Greg Smith, 2ndQuadrant US g
to.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
providers! Not nearly good enough to avoid a correlated failure.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
about reaching as soon as feasible. And if takes massive cuts
in the flexibility or easy of configuration to get there quickly, so
long as it doesn't actually hamper the core operating set here I would
consider that a good trade.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
walkthrough of
setting up and using the program, showing what a passing result looks
like, and what a failing one looks like.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql
the standby. Default to -1 for forever. And if you hit
the timeout, mark the standby as degraded and force them to do a proper
resync when they disconnect. Once that's done, then they can re-enter
sync rep mode again, via the same process a new node would have done so.
--
Greg Smith, 2ndQuadrant US g
. And
complete faith that even trying will fail to deliver something for 9.1.
The scope creep that seems to be happening here in the name of this
will be hard to change so it must be right in the first version boggles
my mind.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
that something that
will undo that change is likely to appears to the user that suggests the
possibility is available.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
Author, PostgreSQL 9.0 High PerformancePre-ordering
, so
after I get back from that conference in November I'll see what I can do
about the docs too.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
Author, PostgreSQL 9.0 High PerformancePre-ordering at:
https
nothing useful from the perspective of the
database's expectations. And that's not true on Darwin unless you
specify F_FULLFSYNC, which doesn't happen by default in PostgreSQL. It
only does that when you switch wal_sync_method=fsync_writethrough
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com
of
the system than a single cluster of twice the size. The minute disks
start entering the picture though, you're likely to end up back to where
processor/memory affinity is the least of your concerns.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services
’, declared with
attribute warn_unused_result
common.c:251: warning: ignoring return value of ‘write’, declared with
attribute warn_unused_result
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
Author, PostgreSQL 9.0
? I thought I saw a
suggestion from you about that, but after looking through the history
here all I see are the diff patches you've been sending to the list.
That's fine, just trying to confirm where everything is at.
--
Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL
being on a different part of the disk if you didn't
control for that. Disks are almost twice as fast at their beginning
than their end nowadays.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql
in PostgreSQL.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
out how to get the rest of
this done, so it goes live somewhere during 9.1 development. Now that
the code has been released from the Noblis fortress, I can start
cleaning up some of the little details on it before then too (i.e. not
working for anything but 9.0 yet).
--
Greg Smith
Tom Lane wrote:
Greg Smith g...@2ndquadrant.com writes:
... The only clear case where this is
always a win is when the system it totally idle.
If you'll climb down off that horse for a moment: yeah, the idle case is
*exactly* what they're complaining about.
I wasn't on a horse here
to that. I'll take a look at some of the other
test cases I have here to see if they can help quantify its impact on
this aspect of BGW behavior.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers
Eventual design here presumed that this would reach the point where one
of the sources you might want to pull from to test performance of was a
different git branch than the main one. That's what I was planning to
do with it.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training
(last_autovacuum_start)
FROM pg_stat_user_tables to diagnose the sort of problems this patch
seems to aim at helping.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers
by then.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
of adding this one as an example for my next MySQL vs.
PostgreSQL paper update, it's a great example of the focus on
correctness differences between the two databases.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
. No arguments from me if
the decision is that's too much code to add for something so marginal.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
popular data-text serialization format out there not yet
supported. It's certainly beyond a format of the week at this point.
XML is like violence: if it doesn't solve your problem, you aren't
using enough of it. - Chris Maden
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training
useful improvement to this feature is
to get per-statement data into the latency log files if requested. If
this issue gets in the way there somehow, maybe it's worth squashing
then. I don't think it will though.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services
the fundamentals even nailed down yet.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
***
/home/postgres/pgwork/repo/git/postgresql/src/test/regress/expected/merge.out
2010-08-11 12:23:50.0 -0400
code is:
./configure --enable-depend --enable-cassert --enable-debug
Generally the only reason to build as a developer without asserts on is
to do performance testing. They will slow some portions of the code
down significantly.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training
. The patch hasn't had a committer assigned yet, so whoever wants
to claim it should mark the CF app.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
diff --git a/contrib/pgbench/pgbench.c b/contrib/pgbench
by probing to make this overhead smaller?
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
, and then you're back to solving the non-SSD problem
again. That's the problem with these things that keeps them from being
magic bullets; if you have a database large enough that you can't fit
the working set in RAM nowadays, you probably can't fit whole thing on
SSD either.
--
Greg Smith
are
the thing I've seen the most actual improvement on like this.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
you submit. Presuming
that's going to be the only version is optimistic for all but the
smallest of patches, and sometimes not even them...
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql
?
The tests you've put in there are the right general sort of things to
try out. The one example you gave does show an UPSERT being emulated by
MERGE, which is the #1 thing people are looking for initially.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g
about the best way to implement aggregates and the like are on the
pgsql-performance list. You'd be more likely to get detailed responses
if you asked this question there. That group loves to talk about how to
design things for other people.
--
Greg Smith 2ndQuadrant US Baltimore, MD
could start
looking out for them more as you continue to work on it.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
seen anyone analyze them via benchmarks. I'm sure you could get
help here (probably the performance list is a better spot though) with
getting your test case right if you wanted to try and nail that down.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g
if people want to see it. Can
always layer that on top later. I'll continue testing and try to get a
firmer opinion. Please take a look at the problem I pointed out and
produce a new patch when you get a chance that fixes that part, so at
least we don't get stuck on that detail.
--
Greg Smith
.html ; that mentions an earlier
paper by the author of the technique Markus is using, but this was from
before that one was written. It looks like Sun has a large portion of
the patent portfolio in this area, which is particularly troublesome now.
--
Greg Smith 2ndQuadrant US Baltimore, MD
. The right list for this discussion if you want to talk about it
more is pgsql-performance. This one is focused at things involving
PostgreSQL development, not questions related to using the database.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g
is a very bad idea; please
don't do that again.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
.
Style/functional suggestions appreciated.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
diff --git a/configure b/configure
index f6b891e..a5371ba 100755
--- a/configure
+++ b/configure
@@ -21624,7 +21624,8 @@ fi
becoming commit quality code. Far as I'm
concerned, a day spent working with the patch review checklist on
someone else's patch pays for itself tenfold when it comes time to
produce patches that others will be able to review.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training
for each student to start chewing on
during that period would usefully settle them into list interaction and
community development process much more gradually than starting that
with their code drops.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g
don't think people have enough scripts built
on this yet to make this break anything. We should backport to 8.4.
log_temp_files was introduced in 8.3, so we'll need to backpatch this
to 8.3, not just 8.4. Greg Smith tells me Simon has been busy with
other things, so I'm going to pick
a stab at that. I'm not exactly sure where the
integer parsing code in the server that would be appropriate is to break
out is at though.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers
releases.
This change is something worth mentioning in the release notes for 9.0 too.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
sorted out fully.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
of writing text out will annoy some
contributors here, that's not something you want to get into the habit
of on any of the mailing lists here.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql
as there's
documentation explaining the potential limitations. I'll write those if
necessary, but I think that some testing on known tricky platforms that
I don't have setup here is the best next step, so I'm looking for
feedback on that.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL
in this area, can't seem to find it at
the moment but I remember the results were not positive in any way.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers
Marc G. Fournier wrote:
Anyone volunteering ... ? Adding is simple enough ...
I can help with moderating announce, having now gotten used to doing the
similar chore for things submitted to the web site for a few months.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training
on the
database side.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
see value in here, to cut down
on other people running into what you did and being as confused by it.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers
. If you submit a new patch with a command line option to enable
this alternate logging format and add the result to
https://commitfest.postgresql.org/action/commitfest_view?id=6 , you can
put my name down as a reviewer and I'll take a deeper look at it as part
of that.
--
Greg Smith 2ndQuadrant
into that existing message with minimal overhead.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
operating
systems. Whereas a more generic preallocation improvement would help
everywhere.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
+
Startup Cost: 0.00 +
Total Cost: 726.00 +
Plan Rows: 19000 +
Plan Width: 268+
Filter: (customerid 1000)
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www
+
/explain
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
could end
up being a much richer source for historical analysis of how the system
got into the bad state than is available right now. Typically those can
have longer histories available than you'll find on a primary that's
recycling segments all the time.
--
Greg Smith 2ndQuadrant US
using simple SQL, rather than having to write a new Replication
Description Language or something so ambitious. This data about what's
been replicated to where looks an awful lot like a set of rows you can
operate on using features already in the database to me.
--
Greg Smith 2ndQuadrant US
was didn't
remember is to include some timestamp information to allow rules based
on that information too.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers
/browser/trunk/contrib/control
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
pool of people who feel comfortable working on this code.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
to that, too, and in reality it will probably
increase the amount of messages I read, because people will ask stuff
there that's already been covered on other lists, and vice-versa.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www
relative to total load times.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
, we should have the info needed to really nail this
down accurately. I can make my own proofreading pass of what Josh has
already been doing that also reflects the new data, and then we can
commit something that's good and well reviewed for 9.0 here.
--
Greg Smith 2ndQuadrant US Baltimore, MD
to PostgreSQL is
far more likely to come with a dose of argument and frustration rather
than reward, and this discussion is a perfect example of such.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql
the PostgreSQL community, but we do
need to deliver what our customers want too.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
/pgbench-intro.pdf on
pages 36,37.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
of HS is aimed at and suitable for.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
701 - 800 of 1566 matches
Mail list logo
