I'm using the current CVS (4.0.8-dev)- It's spectacular. Lower memory
usage, more descriptive debug, better control over it. Tons more options,
smaller code, much much faster.
Can you trust it- sure. It isn't a release candidate. It is the
current development version. As they find proble
Tom Lane wrote:
>
> Neil Padgett <[EMAIL PROTECTED]> writes:
> > Well. Currently the runs are the typical pg_bench runs.
>
> With what parameters? If you don't initialize the pg_bench database
> with "scale" proportional to the number of clients you intend to use,
> then you'll naturally get hu
Haller,
The way I have handled this in the past is to attempt the following
insert, followed by an update if the insert doesn't insert any rows:
insert into foo (fooPK, foo2)
select 'valuePK', 'value2'
where not exists
(select 'x' from foo
where fooPK = 'valuePK')
if number of rows inse
On Mié 26 Sep 2001 22:51, Mike Rogers wrote:
> There is a problem in PHP-4.0.6. Please use PHP4.0.7 or 4.0.8 and the
> problem will be solved. This can be obtained from CVS
Sorry, but 4.0.6 is the last version out (there may be some RC of 4.0.7), but
how can we get those, and how much can we t
On Wed, 26 Sep 2001 19:23:26 -0700, you wrote:
>Itried everywhere can't get JDBC to update.
The right place for this question is the
[EMAIL PROTECTED] mailing list.
I think you have a better chance of getting help when you post a
brief description of the problem, instead of the full history
[EMAIL PROTECTED] (Karthik Guruswamy) writes:
> Anyone tried fragmenting tables into multiple sub tables
> transparently through Postgres rewrite rules ? I'm having
> a table with 200,000 rows with varchar columns and noticed
> that updates,inserts take a lot longer time compared to a
> few ro
I'm considering moving s_lock.c from backend/storage/buffer, where it
seems to make no sense, into backend/storage/lmgr which seems like a
more logical place for it. However, the only way to do it that I know
of is to "cvs remove" in the one directory and then "cvs add" a new copy
in the other.
Hi,
Anyone tried fragmenting tables into multiple sub tables
transparently through Postgres rewrite rules ? I'm having
a table with 200,000 rows with varchar columns and noticed
that updates,inserts take a lot longer time compared to a
few rows in the same table. I have a lot of memory in my
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 24 September 2001 20:11
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-hackers] Alter project: client or server side?
< snipped long discussion about object dependencies and gotchas with regard
to dropping/r
Hi,
please run below recursion function in
7.1.3
---
drop function listTest(int4);create function
listTest(int4)returns textas 'declare mtype alias for
$1; begin if mtype=0 then return
''0''; else return
mtype||listTest(mtype-1);
I just tried to get PostgreSQL from CVS , but it rejected the password
'postgresql' for user 'anoncvs':
$ export CVSROOT=:pserver:[EMAIL PROTECTED]:/home/projects/pgsql/cvsroot
$ cvs login
(Logging in to [EMAIL PROTECTED])
CVS password:
cvs login: authorization failed: server
Hello friends,
int4eq (xid, int4) seems to be needed for proper support of MS Access2K:
CREATE FUNCTION "int4eq" (xid, int4)
RETURNS bool
AS 'int4eq'
LANGUAGE 'internal'
Is int4eq function included in PostgreSQL 7.2?
Regards,
Jean-Michel POURE
---(end of broadcast)
Hello--
I'm looking for anecdotes describing debugging experiences with
database systems. In particular, I want to hear about how you've
solved particularly difficult bugs that were a real headache in a real
system. The bugs could have occurred in any aspect of a database:
problems with the user
I tried to subscribe to a few more lists (docs, patches, and committers) and
got this for them all:
subscribe
Illegal command!
No valid commands processed.
Geoff
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
ht
> -Original Message-
> From: Hiroshi Inoue [mailto:[EMAIL PROTECTED]]
> Sent: 24 September 2001 06:26
> To: Jean-Michel POURE
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
> Tatsuo Ishii
> Subject: Re: [ODBC] UTF-8 support
>
>
> Jean-Michel POURE wrote:
> >
> > 3) Is there a way to qu
Itried everywhere can't get JDBC to update. I can't build 7.13 J2EE
JDBC, I get build errors.
The driver I have bellow, I can't get to update using bellow code
Suggestions please?
Vic
Original Message
Subject: Re: JDBC update wont, plz help.
Date: Wed, 26 Sep 2001 10:
> The sticky thing is dropping a column. There are two options, and
> postgresql developers just can't make up their mind :P)
>
> a) keep old column data in database (wasted space, but fast)
> b) immediately 'compress' table, removing old data (slow, needs a
lot of
> space for compression)
>
> Opt
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> I did some benchmarking with/without multibyte support using current.
> (1) regression test
> (2) pgbench
pgbench unfortunately seems quite irrelevant to this issue, since it
performs no textual operations whatsoever. It'd be interesting to
modify pgben
"D. Hageman" wrote:
> On 26 Sep 2001, Ian Lance Taylor wrote:
> >
> > > Save for the fact that the kernel can switch between threads faster then
> > > it can switch processes considering threads share the same address space,
> > > stack, code, etc. If need be sharing the data between threads is
> [EMAIL PROTECTED] wrote:
> >
> > Greetings.
> > I don´t know if this is the right place to ask this, sorry if this don't
> > belong here.
> > I begun this week working in a new firm. They use linux and PostgreSQL as
> > the database for the Intranet site and for the management of CV's and
> > Kn
> > With multibyte support(first column is the concurrent user, second is
> > the TPS):
> ...
> > 32 95.947363
> > 64 92.718780
> > 128 61.725883
> >
> > Witout multibyte support:
> ...
> > 32 92.283645
> > 64 86.936559
> > 128 87.584099
>
> Do you have any theory why multibyte passes non-mb at
Thanks a lot. Now that I've read your message,
I wonder why I was asking something trivial.
Christoph
> > In a C application I want to run several
> > insert commands within a chained transaction
> > (for faster execution).
> > >From time to time there will be an insert command
> > causing an
>
Tatsuo Ishii wrote:
>
> I did some benchmarking with/without multibyte support using current.
...
> (2) pgbench
>
> With multibyte support(first column is the concurrent user, second is
> the TPS):
...
> 32 95.947363
> 64 92.718780
> 128 61.725883
>
> Witout multibyte support:
...
> 32 92.28
Haller Christoph wrote:
> My first message:
> In a C application I want to run several
> insert commands within a chained transaction
> (for faster execution).
> >From time to time there will be an insert command
> causing an
> ERROR: Cannot insert a duplicate key into a unique index
>
> As a re
Michael Meskes wrote:
> On Thu, Sep 27, 2001 at 12:08:29AM -0400, Tom Lane wrote:
> > I looked around, and am worried about the behavior of PGLC_current()
> > in src/backend/utils/adt/pg_locale.c. It doesn't change locale but
> > does retrieve several successive setlocale() results. Does that w
> It's nice.
:-)
> Can you try it for old 7.1? I should like see some improvement between
> release:-)
Not sure if it's meaningfull since new regression test cases might be
added for current?
--
Tatsuo Ishii
---(end of broadcast)---
TIP 3: if p
Hi all,
Sorry for bothering you with my stuff for the second time
but I haven't got any answer within two days and the problem
appears fundamental, at least to me.
I have a C application running to deal with meteorological data
like temperature, precipitation, wind speed, wind direction, ...
On Thu, Sep 27, 2001 at 02:22:07PM +0900, Tatsuo Ishii wrote:
> I did some benchmarking with/without multibyte support using current.
>
> (1) regression test
>
> With multibyte support:
> 9.52user 3.38system 0:59.27elapsed 21%CPU (0avgtext+0avgdata 0maxresident)k
>
> Without multibyte support:
On Thu, Sep 27, 2001 at 09:26:12AM +0200, Christof Petig wrote:
> Tom Lane wrote:
>
> > >> Well at least on glibc-2.2 it seems that setlocale retuns a pointer to
> > >> malloced memory, and frees this pointer on subsequent calls to
> > >> setlocale.
> > >> So I would kindly ask you to take a seco
Tom Lane wrote:
> >> Well at least on glibc-2.2 it seems that setlocale retuns a pointer to
> >> malloced memory, and frees this pointer on subsequent calls to
> >> setlocale.
> >> So I would kindly ask you to take a second look at every invokation of
> >> setlocale.
>
> I looked around, and am w
30 matches
Mail list logo
