Philip Warner <[EMAIL PROTECTED]> writes:
> Don't suppose you could post the original data?
Sure.
regards, tom lane
commit_delay = 0
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client
At 00:41 25/02/01 -0500, Tom Lane wrote:
>
>Comments anyone?
>
Don't suppose you could post the original data?
Philip Warner| __---_
Albatross Consulting Pty. Ltd. |/ - \
(A.B.N. 75 008 659
Attached are graphs from more thorough runs of pgbench with a commit
delay that occurs only when at least N other backends are running active
transactions.
My initial try at this proved to be too noisy to tell much. The noise
seems to be coming from WAL checkpoints that occur during a run and
pu
Roberto Mello <[EMAIL PROTECTED]> writes:
> I think I finished the HOWTO that I've been writing far a couple days.
> The HTML version is at http://www.brasileiro.net/roberto/howto. The
> document expalins the basic differences from Oracle's PL/SQL to
> PoltgreSQL's PL/pgSQL and how to port a
[ redirected to pgsql-hackers instead of -patches ]
Matthew Kirkwood <[EMAIL PROTECTED]> writes:
> On Sat, 24 Feb 2001, Bruce Momjian wrote:
>> I am confused why mmap() is better than writing to a real file.
> It isn't, except that it allows to initialise the logfile in
> one syscall, without fi
On Sat, Feb 24, 2001 at 01:07:17AM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] (Nathan Myers) writes:
> > I see, I had it backwards: N=0 corresponds to "always delay", and
> > N=infinity (~0) is "never delay", or what you call zero delay. N=1 is
> > not interesting. N=M/2 or N=sqrt(M) or N=log(
Hi,
I think I finished the HOWTO that I've been writing far a couple days.
The HTML version is at http://www.brasileiro.net/roberto/howto. The
document expalins the basic differences from Oracle's PL/SQL to
PoltgreSQL's PL/pgSQL and how to port applications to Postgres. It comes
w
"Timothy H. Keitt" <[EMAIL PROTECTED]> writes:
> Basically, I need to update rows by offset from the beginning of the
> table.
I think you'd better rethink your data design. Tuple order in a table
is not a defined concept according to SQL. Even if we allowed queries
such as you've described, t
Adam Haberlach <[EMAIL PROTECTED]> writes:
> ... one of the engineers has been writing some queries that
> cast a text field to an int and take advantage of the
> fact that we used to turn text fields with no digits into 0,
> much as C's atoi function works.
> The new behavior is to throw a
I see this (subselect) is available in >=7.1.
Tim
Timothy H. Keitt wrote:
> Hi,
>
> It appears that limit and offset do not work in a subselect such as:
>
> update my_table set my_col = new_val where oid = (select oid from
> my_table offset row_number limit 1);
>
> Basically, I need to
Hi,
It appears that limit and offset do not work in a subselect such as:
update my_table set my_col = new_val where oid = (select oid from
my_table offset row_number limit 1);
Basically, I need to update rows by offset from the beginning of the
table. Even nicer would be
upd
I've just upgraded to the beta4 in order to fix an RI
deadlock we seemed to be having with 7.0.3 -- and it seems
that one of the engineers has been writing some queries that
cast a text field to an int and take advantage of the
fact that we used to turn text fields with no digits into 0,
m
At 13:05 23/02/01 -0500, Jeff Duffy wrote:
>On Fri, 23 Feb 2001, Andy Engdahl wrote:
>
> > I seem to be having some problems w/ the psql jdbc driver. I'm able to
> load the driver, but as soon as I try to connect w/ the database. here's
> my code:
> >
> > import java.sql.*;
> >
> > public class
Hi Teodorescu,
I have made patches which enable pgaccess to input Japanese characters
in the table editing window. As you might know, to input Japanese
characters, we first type in "hiragana" then convert it to "kanji". To
make this proccess transparent to tcl application programs, libraries
are
Tom Lane wrote:
>
> With current sources:
>
> DEBUG: copy: line 629980, XLogWrite: new log file created - try to increase
>WAL_FILES
> DEBUG: copy: line 694890, XLogWrite: new log file created - try to increase
>WAL_FILES
> FATAL 2: copy: line 759383, ZeroFill(logfile 0 seg 13) failed: No sp
15 matches
Mail list logo
