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 s
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 source.correct
On Tue, 6 Mar 2007, lissette wrote:
> 2007-02-02 16:41:03 [Thread-6]message(s) in mail box>
> 2007-02-02 16:41:13 [Thread-39 ]an ebxml message from mail box>
> 2007-02-02 16:41:13 [Thread-39 ]
>
> 2007-02-02 16:41:14 [Thread-39 ]outgoing message: [EMAIL PROTECTED]>
> 2007-
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
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 statemen
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]
2007-02-02 16:41:13 [Thread-39 ]
2007-02-02
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 tra
Hi Andreas,
Thanks for the info about COPY !!
On Mar 6, 1:23 pm, [EMAIL PROTECTED] (Andreas Kostyrka) wrote:
> * Richard Huxton <[EMAIL PROTECTED]> [070306 12:22]:> >>2. You can do a COPY
> from libpq - is it really not possible?
>
> > >Not really but i have been testing it and inserts are flyin
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 source.correct
Hey there :)
I'm re-writing a summarization process that used to be very 'back and
forth' intensive (i.e. very chatty between my summarization software and
the DB). I'm trying to reduce that by practically reducing all this back
and forth to a single SQL query, but in order to support certain
Carlos,
Now, yet another thing that you (Craig) seem to be missing: you're
simply putting the expense of all this time under the expenses column
in exchange for solving the particular problem...
More like I was trying to keep my response short ;-). I think we're all in
agreement on pretty mu
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
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 broadc
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.
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 financial
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: pgsql-performance@postgresql
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 mo
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 organization
Schwarz, Karl wrote:
I am having a performance problem with a query implemented within a
server side function. If I use an SQL client(EMS Postgres) and manually
generate the sql query I get about 100 times performance improvement
over using the function.
I've also tried using a prepared statemen
Schwarz, Karl wrote:
Is there something basic I am missing here with the use of a function. I
am no database expert, but my assumption was that a function would give
me better results than in-line sql.
Not necessarily. Usually it means the planner has less information to go on.
We'll need more
I am having a performance problem with a query implemented within a
server side function. If I use an SQL client(EMS Postgres) and manually
generate the sql query I get about 100 times performance improvement
over using the function.
I've also tried using a prepared statement from my application
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 que
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 W
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 ha
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/
trunk/database/ERD.pd
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 because Stonebreaker made an assumption about the fu
26 matches
Mail list logo
