Mark Kirkwood wrote:
> This is a well-worn thread title - apologies, but these results seemed
> interesting, and hopefully useful in the quest to get better performance
> on Solaris:
>
> I was curious to see if the rather uninspiring pgbench performance
> obtained from a Sun 280R (see General:
On Thu, 11 Dec 2003, Alvaro Herrera Munoz wrote:
> On Thu, Dec 11, 2003 at 06:03:05PM -0400, Peter Eisentraut - PostgreSQL wrote:
>
> > Modified files:
> > src/bin/initdb : nls.mk
> > Added files:
> > src/bin/initdb/po: it.po
>
> Are you going to keep managing these things? I received you
Andrew Dunstan wrote:
> Nigel J. Andrews said:
> > On Thu, 11 Dec 2003, Alvaro Herrera wrote:
> >
> >> On Thu, Dec 11, 2003 at 06:36:05PM -0500, Bruce Momjian wrote:
> >> > Our dbcommands.c has for create database:
> >> >
> >> > snprintf(buf, sizeof(buf), "cp -r '%s' '%s'", src_loc,
> >> >
Nigel J. Andrews said:
> On Thu, 11 Dec 2003, Alvaro Herrera wrote:
>
>> On Thu, Dec 11, 2003 at 06:36:05PM -0500, Bruce Momjian wrote:
>> > Our dbcommands.c has for create database:
>> >
>> > snprintf(buf, sizeof(buf), "cp -r '%s' '%s'", src_loc,
>> > target_dir);
>> >
>> [...]
>> >
>> > I
Nigel J. Andrews wrote:
> On Thu, 11 Dec 2003, Alvaro Herrera wrote:
>
> > On Thu, Dec 11, 2003 at 06:36:05PM -0500, Bruce Momjian wrote:
> > > Our dbcommands.c has for create database:
> > >
> > > snprintf(buf, sizeof(buf), "cp -r '%s' '%s'", src_loc, target_dir);
> > >
> > [...]
> > >
> >
On Thu, 11 Dec 2003, Alvaro Herrera wrote:
> On Thu, Dec 11, 2003 at 06:36:05PM -0500, Bruce Momjian wrote:
> > Our dbcommands.c has for create database:
> >
> > snprintf(buf, sizeof(buf), "cp -r '%s' '%s'", src_loc, target_dir);
> >
> [...]
> >
> > I think we should switch to -R in our cod
On Fri, 12 Dec 2003 10:36 am, Bruce Momjian wrote:
> I think we should switch to -R in our code.
Both -r and -R are supported on Linux (fileutils 4.1), Tru64 v4.0 and Solaris
(at least as far back as 2.6) so no complaints here.
Regards, Philip.
---(end of broadcast)
Thanks for getting this out.
Tim
On Tue, 2003-12-09 at 16:27, [EMAIL PROTECTED] wrote:
> I just wanted to share that we're on the brink of having an automated
> test on our Scalable Test Platform (http://www.osdl.org/stp/) that
> features our DBT-2 workload, a fair use implementation of the TPC-
On Thu, Dec 11, 2003 at 06:36:05PM -0500, Bruce Momjian wrote:
> Our dbcommands.c has for create database:
>
> snprintf(buf, sizeof(buf), "cp -r '%s' '%s'", src_loc, target_dir);
>
[...]
>
> I think we should switch to -R in our code.
But you will have to write special code for Win32, won't
Andrew Dunstan wrote:
> Peter Eisentraut wrote:
> >Thomas Hallgren wrote:
> >>What are your thoughts and ideas?
> >
> >Instead of making up your own stuff, there's a whole SQL standard
> > that tells you how Java embedded in an SQL server should work. Of
> > course that doesn't tell you about impl
Peter Eisentraut wrote:
Thomas Hallgren wrote:
What are your thoughts and ideas?
Instead of making up your own stuff, there's a whole SQL standard that
tells you how Java embedded in an SQL server should work. Of course
that doesn't tell you about implementation details.
Where can
Our dbcommands.c has for create database:
snprintf(buf, sizeof(buf), "cp -r '%s' '%s'", src_loc, target_dir);
but my BSD/OS manual only documents 'cp -R' and mentions:
Historic versions of the cp utility had a -r option. This implementation
supports that option, however, its use i
On Thu, Dec 11, 2003 at 06:03:05PM -0400, Peter Eisentraut - PostgreSQL wrote:
> Modified files:
> src/bin/initdb : nls.mk
> Added files:
> src/bin/initdb/po: it.po
Are you going to keep managing these things? I received your email about a
CVS write account so I could handle them f
Thomas Hallgren wrote:
> What are your thoughts and ideas?
Instead of making up your own stuff, there's a whole SQL standard that
tells you how Java embedded in an SQL server should work. Of course
that doesn't tell you about implementation details.
---(end of broadcas
Tom Lane wrote:
> libpq++ got heaved overboard largely
> because the autoconf burden for it was too high,
That's news to me. Certainly the overhead doesn't grow smaller by
splitting stuff up in smaller pieces.
---(end of broadcast)---
TIP 4: Don'
My 2 cents...
The C++ language is a horrible language from an OO perspective. Operator
overloading, copy-constructors, templates, etc. can produce quite horrendous
and inefficient results if used incorrectly. Having said that I must defend
it some too.
Using C++, you get inheritance, data-hid
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> How is "prod" getting into that command line? I suspect it's coming
>> from an environment variable like PROFILE or CFLAGS ...
> Is there a case for making Makefile/shell variables and defines we use
> have less generic names?
Havi
Tom Lane wrote:
"Dave Page" <[EMAIL PROTECTED]> writes:
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declarations prod -I../../src/include -D_GNU_SOURCE
-I/usr/include -c -o path.o path.c
gcc: cannot specify -o with -c or -S and multiple compilations
How is "prod" get
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 11 December 2003 15:31
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] 7.4 build problem on Linux Vserver
>
> "Dave Page" <[EMAIL PROTECTED]> writes:
> > gcc -O2 -fno-strict-aliasing -Wall -Wmissi
On Thu, Dec 11, 2003 at 04:14:43PM +0100, Manfred Koizar wrote:
> On Sat, 6 Dec 2003 10:43:18 -0500 (EST), Bruce Momjian
> <[EMAIL PROTECTED]> wrote:
> >Where are we on nested transactions. Is it something we can get for 7.5?
>
> I honestly don't know. I've been working on other things lately an
On Thursday 11 December 2003 14:36, Nagib Abi Fadel wrote:
> HI,
> let's say we have the following table :
>
> # CREATE TABLE tempo (col1 varchar(3) not null);
> CREATE TABLE
>
> # insert INTO tempo VALUES ('');
> INSERT 11420541 1
I don't have much to add to Doug's reply, but you may want to look
"Dave Page" <[EMAIL PROTECTED]> writes:
> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
> -Wmissing-declarations prod -I../../src/include -D_GNU_SOURCE
> -I/usr/include -c -o path.o path.c
> gcc: cannot specify -o with -c or -S and multiple compilations
How is "prod" getting into that c
On Thu, 2003-12-11 at 22:36, Nagib Abi Fadel wrote:
> HI,
> let's say we have the following table :
>
> # CREATE TABLE tempo (col1 varchar(3) not null);
> CREATE TABLE
>
> # insert INTO tempo VALUES ('');
> INSERT 11420541 1
>
> the insert command works.
>
> The issue is that since the col
On Sat, 6 Dec 2003 10:43:18 -0500 (EST), Bruce Momjian
<[EMAIL PROTECTED]> wrote:
>Where are we on nested transactions. Is it something we can get for 7.5?
I honestly don't know. I've been working on other things lately and
have not heard from Alvaro for some time.
Servus
Manfred
"Nagib Abi Fadel" <[EMAIL PROTECTED]> writes:
>The issue is that since the column col1 is defined as character with
>not null attribute,
>
>shouldn't we deny such inserts (i mean inserting empty fields)???
NULL and the empty string '' are *completely* different things. If
you want to
From: Nagib Abi Fadel
[mailto:[EMAIL PROTECTED] Sent: 11 December 2003
14:37To: generalpost; developPostSubject: [HACKERS]
Should we consider empty fields as NULL values when dealing with string
columns ?
HI,
let's say we have the following table :
# CREATE TA
HI,
let's say we have the following
table :
# CREATE TABLE tempo (col1 varchar(3) not
null);CREATE TABLE
# insert INTO tempo VALUES ('');INSERT 11420541
1
the insert command works.
The issue is that since the column col1 is
defined as character with not null attribute,
shouldn't we de
Shridhar Daithankar <[EMAIL PROTECTED]> writes:
> Jokes and facts aside, I can't help it to think how better it would
> have been, if postgresql was in C++. We could easily plug multiple
> implementations of underlying subsystems without mucking much in base
> code..
That's easy to do in any lang
Andrew Dunstan wrote:
Not to mention it would kill PostgreSQL's current speedy performance!
Maybe, maybe not. Modern JVMs have much better performance
characteristics than was once the case. Also, some of the things that
Java buys you (memory management, threading, for example) might actually
Hi all,
I get the following build error when attempting to build 7.4 in a Linux
Vserver (like a FreeBSD jail) built on Slackware 9.1 with the 2.4.22
kernel:
make -C doc all
make[1]: Entering directory `/usr/local/src/postgresql-7.4/doc'
gzip -d -c man.tar.gz | /bin/tar xf -
for file in man1/*.1;
In article <[EMAIL PROTECTED]> you wrote:
>
> You also need to quote values containing the separator.
Roight! Thanks for the heads-up :) And now, version 2.
Cheers,
D
CREATE OR REPLACE FUNCTION csv(anyarray) RETURNS TEXT AS
'DECLARE
in_array ALIAS FOR $1;
temp_string TEXT;
quoted_
31 matches
Mail list logo
