Hi performers,
after following this list for a while, I try to configure a database
server with a limited budget.
Planned are 2 databases
- archiveopteryx - http://www.archiveopteryx.org/sql-schema.html
- ERDB - https://www.chaos1.de/svn-public/repos/network-tools/ERDB/
I would just like to note here that this is an example of inefficient
strategy.
We could all agree (up to a certain economical point) that Alex saved the
most expensive one thousand dollars of his life.
I don't know the financial status nor the size of your organization, but I'm
sure that you
On 3/8/07, Magnus Hagander [EMAIL PROTECTED] wrote:
On Thu, Mar 08, 2007 at 06:24:35AM -, James Mansion wrote:
In the long run, we are going to have to seriously rethink pg's use
of WAL as the way we implement MVCC as it becomes more and more of a
performance bottleneck.
We have WAL
Hi Tom, thanks for the great job getting to the core of this
problem... I would say I'm not sure I want randomize the rows (not
really even sure how to do it without truncating the table and re-
adding the records in a random order). I think for the moment I
will either a) re-write the
Rodrigo Madera wrote:
I would just like to note here that this is an example of inefficient
strategy.
We could all agree (up to a certain economical point) that Alex saved
the most expensive one thousand dollars of his life.
I don't know the financial status nor the size of your
At 09:11 AM 3/8/2007, Merlin Moncure wrote:
On 3/8/07, Magnus Hagander [EMAIL PROTECTED] wrote:
On Thu, Mar 08, 2007 at 06:24:35AM -, James Mansion wrote:
In the long run, we are going to have to seriously rethink pg's use
of WAL as the way we implement MVCC as it becomes more and more
Thanks. I was not looking for help with the query just wanted to know
that I didn't overlook some basic
configuration setting.
Karl
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 08, 2007 12:50 PM
To: Schwarz, Karl
Cc:
At 01:34 PM 3/8/2007, Craig A. James wrote:
Rodrigo Madera wrote:
I would just like to note here that this is an example of
inefficient strategy.
We could all agree (up to a certain economical point) that Alex
saved the most expensive one thousand dollars of his life.
I don't know the
I would just like to note here that this is an example of inefficient
strategy.
[ ... ]
Alex may have made the correct, rational choice, given the state of
accounting at most corporations. Corporate accounting practices and
the budgetary process give different weights to cash and labor.
Ron wrote:
Speak Their Language (tm) [ ... ] Do The Right Thing (tm)
[...] Not Listening to Reason (tm),
[...]
fiscal or managerial irresponsibility.)
And *here*, of all the instances, you don't put a (TM) sign ??
Tsk-tsk-tsk
:-)
Carlos
--
---(end of
On 3/8/07, Ron [EMAIL PROTECTED] wrote:
Exactly, and WAL services other purposes than minimizing the penalty
from writing to high latency media. WAL underlies PITR for example.
Never argued with any of this.
Near-zero latency media is coming, eventually...and I don't think the
issue is
Hi Richard,
No, as said above transactions are made of 10 inserts...
Hmm - I read that as just meaning inserted 10 rows. You might find
that smaller batches provide peak performance.
Ahh ok ;-) sorry for my bad english... (yeah, i have been testing
several transaction size
Hello!!
I have perfectly installed ebmail and Hermes 2 whith JDK
1.4.2 ,postgreSQL
8.1 and Tomacat 5.0.28 and all good works.
I send messages whith ebmail and it`s writing in Postgresql but I
have
some mistakes:
2007-02-02 16:41:03 [Thread-6] INFO cecid.ebms.spa Found 1
message(s) in mail
Hi and thanks for your quick answer :-)
Here is my problem. With some heavy insert into a simple BD (one
table, no indexes) i can't get better perf than 8000 inserts/sec. I'm
testing it using a simple C software which use libpq and which use:
- Insert prepared statement (to avoid too
Hi Richard,
Here is my problem. With some heavy insert into a simple BD (one
table, no indexes) i can't get better perf than 8000 inserts/sec. I'm
testing it using a simple C software which use libpq and which use:
- Insert prepared statement (to avoid too many request parsing on the
On Tue, 6 Mar 2007, lissette wrote:
2007-02-02 16:41:03 [Thread-6] INFO cecid.ebms.spa Found 1
message(s) in mail box
2007-02-02 16:41:13 [Thread-39 ] INFO cecid.ebms.spa Received
an ebxml message from mail box
2007-02-02 16:41:13 [Thread-39 ] ERROR cecid.ebms.spa
Unauthorized
Steve wrote:
IF strlen(source.corrected_procedure_code)
THEN:
summary.procedure_code=source.corrected_procedure_code
summary.wrong_procedure_code=source.procedure_code
ELSE:
summary.procedure_code=source.procedure_code
summary.wrong_procedure_code=NULL
Um, so you test if
Isn't it likely that a single stream (or perhaps one that can be partitioned
across spindles) will tend to be fastest, since it has a nice localised
stream that a) allows for compression of reasonable blocks and b) fits with
commit aggregation?
RAM capacity on servers is going up and up, but the
18 matches
Mail list logo
