Alvaro Herrera alvhe...@commandprompt.com writes:
Jakub Ouhrabka wrote:
Was autovacuum requesting to write this 20MB file 650x per minute?
Yes, exactly.
Ideally, autovacuum would only request a new copy of the file if the one
it got was considerably out of date. Obviously a tenth of a
Tom Lane wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
Jakub Ouhrabka wrote:
Was autovacuum requesting to write this 20MB file 650x per minute?
Yes, exactly.
Ideally, autovacuum would only request a new copy of the file if the one
it got was considerably out of date.
Matthias Brantner wrote:
I know this has been discussed several times and it seems the
conclusin was it's impossible if we would like to use existing XQuery
external modules (some are by license reasons and some are by
techinical reasons).
So it seems the only way to support XQuery is,
t...@sss.pgh.pa.us (Tom Lane) writes:
Merlin Moncure mmonc...@gmail.com writes:
On Tue, Feb 16, 2010 at 10:38 AM, Tom Lane t...@sss.pgh.pa.us wrote:
2. Add an extra lock to serialize writers to the queue, so that messages
are guaranteed to be added to the queue in commit order. As long as
Martijn van Oosterhout klep...@svana.org writes:
On Tue, Feb 16, 2010 at 09:11:24AM -0800, David E. Wheeler wrote:
An extra source of puzzlement is that the oid of the 'unknown' type is
705 not 0, and the unknown type isn't discussed in the docs (as far as I
could see).
Yes, I noticed that,
All,
In my 12 years on the PostgreSQL project, this is the 2nd time, ever,
I've heard a question about OpenVMS support. The previous time was in 2003.
Maybe there's an untapped community out there, but personally I think
we'd find more users on z/OS than on OpenVMS.
--Josh Berkus
--
Sent via
Josh Berkus j...@agliodbs.com writes:
In my 12 years on the PostgreSQL project, this is the 2nd time, ever,
I've heard a question about OpenVMS support. The previous time was in 2003.
Well, a search of our archives for OpenVMS finds a few more, but it
still looks like about one request a year.
Jan Urbański wrote:
Arie Bikker wrote:
Hi all,
I've combined the review suggestions of Jan Urbański, Scott Bailey, and
others.
This was a lot harder, then I had foreseen; and I took my time to do it
the right way (hope you agree!).
Hi,
I see the patch has been marked as Returned with
Alvaro Herrera alvhe...@commandprompt.com writes:
Maybe check at backend startup whether the limit is valid, and call
SetTransactionIdLimit if not?
Actually, the intent was that that would get called during startup,
but it seems I forgot to actually plug that in :-(. Loose wires now
reattached
On Tue, Feb 16, 2010 at 8:17 PM, Bruce Momjian br...@momjian.us wrote:
Incidentally, can you have two active anonymous portals at the same time?
No, the first one is deleted when the second is created, i.e., our docs
have:
An unnamed prepared statement lasts only until the next Parse
On Tue, Feb 16, 2010 at 1:02 PM, David Fetter wrote:
You clearly know vastly more than I do about this, and should lead this
effort :)
I have been working on OpenVMS on and off for a few years, but I am
sure a lot of people are more qualified than I am :)
I guess I will create a page in the
On Nov 10, 2009, at 9:54 AM, Bruce Momjian wrote:
FYI, Heikki has fixed this bug and the fix will appear in Postgres 8.5.
Heikki Oops, you're right. The check is indeed confusing julian day
Heikki numbers, with epoch at 23th of Nov 4714 BC, with
Heikki postgres-reckoning day numbers, with
aduns...@postgresql.org (Andrew Dunstan) writes:
Clean up package namespace use and use of Safe in plperl.
According to buildfarm member kite, there is more than one spelling of
the Perl warning message that was (randomly?) chosen for the test added
here. I doubt it's worth maintaining a
On Wed, Feb 17, 2010 at 12:12 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
Maybe check at backend startup whether the limit is valid, and call
SetTransactionIdLimit if not?
Actually, the intent was that that would get called during startup,
but it
Andrew Dunstan and...@dunslane.net wrote:
With the following settings
custom_variable_classes = 'auto_explain'
auto_explain.log_min_duration = 0
auto_explain.log_format = 'xml'
auto_explain.log_analyze = on
auto_explain.log_verbose = on
shared_preload_libraries =
Simon Riggs si...@2ndquadrant.com writes:
* Don't really like pg_listening() as a name. Perhaps pg_listening_to()
or pg_listening_on() or pg_listening_for() or pg_listening_channels() or
pg_listen_channels()
BTW, I used pg_listening_channels() for that.
* I think it's confusing that
Tom Lane wrote:
aduns...@postgresql.org (Andrew Dunstan) writes:
Clean up package namespace use and use of Safe in plperl.
According to buildfarm member kite, there is more than one spelling of
the Perl warning message that was (randomly?) chosen for the test added
here. I doubt
On Wed, Feb 17, 2010 at 6:28 AM, Magnus Hagander mag...@hagander.net wrote:
If you send me your amazon id, I can get you premissions on my private
image. I plan to clean it up and make it public, just haven't gotten
around to it yet...
Thanks for your concern! I'll send the ID when I complete
Andrew Dunstan and...@dunslane.net writes:
I am getting regression failures on the rowtypes, transactions and
arrays tests. Diff file is attached. I'm going to look into it, but if
anyone has a good idea what's going on please speak up ASAP.
Hmm. Didn't decipher the transactions-test
On Wed, Feb 17, 2010 at 06:55, Fujii Masao masao.fu...@gmail.com wrote:
On Wed, Feb 17, 2010 at 6:28 AM, Magnus Hagander mag...@hagander.net wrote:
If you send me your amazon id, I can get you premissions on my private
image. I plan to clean it up and make it public, just haven't gotten
around
Andrew Dunstan and...@dunslane.net writes:
I am getting regression failures on the rowtypes, transactions and
arrays tests. Diff file is attached. I'm going to look into it, but if
anyone has a good idea what's going on please speak up ASAP.
And as for the transactions-test failures, a stack
Andrew Dunstan wrote:
Matthias Brantner wrote:
I know this has been discussed several times and it seems the
conclusin was it's impossible if we would like to use existing XQuery
external modules (some are by license reasons and some are by
techinical reasons).
So it seems the only way to
Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp writes:
Thank you for the bug report. Auto_explan tries to explain the query
even if it is failed, but schema objects that are created in the same
transaction might not be available. cache lookup failed erros can be
avoided if auto_explain skips
Magnus Hagander mag...@hagander.net writes:
On Wed, Feb 17, 2010 at 06:55, Fujii Masao masao.fu...@gmail.com wrote:
2. Straightforwardly observe the alignment rule. Since the received WAL
data might start at the middle of WAL block, walreceiver needs to keep
the last half-written WAL block
Scott Bailey arta...@comcast.net writes:
If it were possible to drop the xerces dependency from Zorba and use
libxml2 for parsing, that would be a strong case for it. The other big
dependency for Zorba was ICU for converting character sets. I'm not
familiar with that part of Postgres. But
Robert Haas robertmh...@gmail.com writes:
* Fix large object support in pg_dump. I think this is just waiting
for a second opinion on whether the approach is correct. I've been
meaning to look at it, but haven't gotten enough round tuits; maybe
someone else would like to take a look? This
On Wed, Feb 17, 2010 at 3:03 PM, Magnus Hagander mag...@hagander.net wrote:
In that case, O_DIRECT would be counterproductive, no? It maps to
FILE_FLAG_NOI_BUFFERING, which makes sure it doesn't go into the
cache. So the read in the startup proc is actually guaranteed to
reuqire a physical
On Wed, Feb 17, 2010 at 3:27 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Magnus Hagander mag...@hagander.net writes:
On Wed, Feb 17, 2010 at 06:55, Fujii Masao masao.fu...@gmail.com wrote:
2. Straightforwardly observe the alignment rule. Since the received WAL
data might start at the middle of
Well, maybe you can answer the questions I had last time I looked at it,
namely:
XQuery is a whole other question. Adding another library dependency is
something we try to avoid. Zorba http://www.zorba-xquery.com/ might work,
but it appears to have its own impressive list of dependencies
I've been playing around with Zorba and xQilla today. I couldn't actually get
Zorba to build on my system. It looks like the two share a common (or
similar) C API though.
Yes, Zorba and XQilla both implement the XQC API. It was developed by
the Zorba and XQilla teams in a joint effort. The
well, my current opinion is that we should spend some nonzero amount
of thought into figuring out what to do.
I'd suggest to do it like this:
Do autovac_refresh_stats() once per autovacuum_naptime/2 and share the
result among all autovacuum workers.
This would guarantee that autovacuum is
This would guarantee that autovacuum is fired no later than
autovacuum_naptime after the condition for the run became true.
Of course, this unfortunately not true... The guarantee is 1,5x
autovacuum_naptime. But I'd be happy with it but I agree that's not what
I'd as a user expect from this
On Tue, Feb 16, 2010 at 10:28:00PM +0100, Michael Meskes wrote:
I was trying to stress the *beta* status. Maybe someone into NetBSD might be
interested in reporting this as a bug. At least it behaves different to all
other archs we have.
Hmm, it seems the patch didn't work. Back to the
101 - 133 of 133 matches
Mail list logo