Bruce Momjian <[EMAIL PROTECTED]> writes:
> I was just testing the threaded ecpg, and ran some performance tests.
> Without using threads, I am seeing 100,000 inserts of a single word into
> a simple table take 12 seconds:
> CREATE TABLE test_thread(message TEXT);
> giving me 8333 inserts per
ignore
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Well for me it's the difference between this:
australia=# \d affiliates_transactions
View "public.affiliates_transactions"
Column| Type | Modifiers
--+--+---
affiliate_id | integer |
date | t
Sean Chittenden <[EMAIL PROTECTED]> writes:
> Hrm, after an hour of searching and reading, I think one of the better
> papers on the subject can be found here:
> http://www.cs.ust.hk/faculty/dimitris/PAPERS/TKDE-NNmodels.pdf
Interesting paper, but I don't see the connection to index order
correlat
In src/port, we have in threads.c:
/*
* Wrapper around getpwuid() or getpwuid_r() to mimic POSIX getpwuid_r()
* behaviour, if it is not available.
*/
int
pqGetpwuid(uid_t uid, struct passwd * resultbuf, char *buffer,
size_t buflen, struct passwd ** result)
{
#if defined(USE_THREA
Hi,
I've just tried the cvs on uw 7.13. It fails on compiling hba.c:
UX:acomp: ERROR: "hba.c", line 651: undefined symbol: AI_NUMERICHOST
UX:acomp: ERROR: "hba.c", line 1237: undefined symbol: AI_NUMERICHOST
gmake[3]: *** [hba.o] Error 1
gmake[2]: *** [libpq-recursive] Error 2
gmake[1]: *** [all]
Hi all,
I had these during the compilation:
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../src/include -c -o execScan.o execScan.c
execScan.c: In function `tlist_matches_tupdesc':
execScan.c:199: warning: unused variable `att_tup'
In file included from preproc.y:6278:
pg
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> It might be a bit risky getting pg_dump to use it though?
I definitely don't want pg_dump using the pretty-print stuff ;-).
I'm neutral on whether to use it in psql's \d commands.
regards, tom lane
Bruce Momjian writes:
> First get your own platforms enabled for the existing thread flag, and
> we can revisit this when most/all our platforms are supported. We want
> to avoid confusion of having things work for some platforms and not
> others with no way to communicate that to the users.
Yes
--On Thursday, August 07, 2003 10:46:47 -0400 Tom Lane <[EMAIL PROTECTED]>
wrote:
[EMAIL PROTECTED] writes:
I've just tried the cvs on uw 7.13. It fails on compiling hba.c:
UX:acomp: ERROR: "hba.c", line 651: undefined symbol: AI_NUMERICHOST
UX:acomp: ERROR: "hba.c", line 1237: undefined symbol
I've filed a bug with the folks I know that work on the compilers.
workaround for now is to --enable-debug.
LER
--On Thursday, August 07, 2003 19:50:21 -0400 Bruce Momjian
<[EMAIL PROTECTED]> wrote:
The SCO compilers are notoriously buggy for the past 10-15 years.
Hi Tom,
I have NI_NUMERICHOST defined in netdb.h
I too can provide an account on my machine(s) if you need a few
On Thu, 7 Aug 2003, Tom Lane wrote:
> Date: Thu, 07 Aug 2003 10:46:47 -0400
> From: Tom Lane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>
>
On Thu, Aug 07, 2003 at 04:09:33PM -0400, Tom Lane wrote:
I think the check is only a warning though; and the only thing that
> actually fails to build is ecpg's preproc.y. It's possible his current
> copy of parser/gram.c was built with an older bison before he hit the
> hard failure, and then h
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Strange. I know we check for bison >= 1.875, and you have that, and so
> do I, but I don't see those regression failures. Is it possible you
> have old bison output files from an older bison release?
I think the check is only a warning though; and the
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Dann Corbit wrote:
>> Perhaps a portable BSD licensed threading library could be included for
>> platforms that do not have a safe thread interface.
> That seems pretty heavy.
It seems highly unlikely that you could band-aid threading over a libc
that w
Bruce Momjian wrote:
I was just testing the threaded ecpg, and ran some performance tests.
Without using threads, I am seeing 100,000 inserts of a single word into
a simple table take 12 seconds:
CREATE TABLE test_thread(message TEXT);
giving me 8333 inserts per second. That seems very high.
I
In theory, the news2mail gateway is back in place ...
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
On Thu, Aug 07, 2003 at 13:11:32 -0500,
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> I just (with the last half hour) grabbed a fresh copy of 7.4 from CVS
> and got an error when building contrib/array:
>
> gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I.
> -I../../src/includ
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I.
> -I../../src/include -c array_iterator.c -o array_iterator.o
> array_iterator.c:30: utils/fmgroids.h: No such file or directory
> make: *** [array_iterator.o] Error 1
This suggests
On Wed, 2003-08-06 at 04:39, Andreas wrote:
> At 17:55 05.08.2003, Josh Berkus wrote:
> >I also don't think that outside of your particular
> >case that there's much demand for it;
>
> I would like to believe that there is a need for efficient unit-testing
> (unit-tests can be seen as a kind of
When I run the regression tests against current sources, I get
failures because bison-generated error messages use "parse
error", not "syntax error". I vaguely recall running into
this issue before I left for the summer -- did we resolve
it?
[EMAIL PROTECTED] neil]$ uname -a
FreeBSD arch.wavefire.
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 06, 2003 4:29 PM
> To: Peter Eisentraut
> Cc: Lee Kindness; Larry Rosenman; PostgreSQL Development
> Subject: Re: [HACKERS] Thread-safe configuration option appears to
>
>
> Peter Eisentraut wr
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> I've noticed an inconsistency in calls to gettimeofday(): sometimes it
> is passed a struct tz (which is ignored) as the second argument, and
> sometimes NULL as the second argument. My understanding is that the
> second argument is basically useless
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > It just seemed complex to figure out which operators needed parens and
> > which didn't.
>
> The fact that the first attempt was wrong doesn't improve my faith in
> that code one bit ;-). I don't want pg_dump invoking it, even as an
I was just testing the threaded ecpg, and ran some performance tests.
Without using threads, I am seeing 100,000 inserts of a single word into
a simple table take 12 seconds:
CREATE TABLE test_thread(message TEXT);
giving me 8333 inserts per second. That seems very high.
I remember tes
Hi guys (tom),
Just reminding people that there was a question regarding my changes to
psql's \d command. I'm not sure if everyone wanted all the identifier
names double quoted or not...
And are people happy with the layout in general? Also, I think it'd be
nice if my recent patch to use the ne
No, win32 was delayed for 7.5.
---
Jinqiang Han wrote:
> hi, Tom and Momjian
>
> I wonder if 7.4 will have win32 porting£¿
> I checkout source from cvs. I only find win32 makefile for client.
>
>
>
>
>
OK, I moved them both to the object section, next to each other.
---
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Why is this not together with the mention that dollar signs are *not*
cc -O -K inline -g -I../../../../src/include -I/usr/local/include -c -o
printtup.o printtup.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:acomp: ERROR: "printtup.c", line 94: undefined struct/union member:
_shutdown
UX:acomp: WARNING: "printtup.c", line 94: impr
Hi there,
I have a RedHat 7.3 machine that can build the 7.3.4 RPMs if required -
it only contains RPMs from the vanilla CD or from updates.redhat.com.
I've just done a test build and everything seems OK except that the C
compiler is passed the -mcpu=i686 flag - I'm guessing I need to somehow
chan
> "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> >
gcc -pipe -O -Wall -Wmissing-prototypes -Wmissing-declarations -Wno-error -I
> >
./../include -I. -I../../../../src/include -DMAJOR_VERSION=3 -DMINOR_VERSIO
> >
N=0 -DPATCHLEVEL=0 -DINCLUDE_PATH=\"/home/chriskl/local/include\" -c -o
> >
--On Tuesday, August 05, 2003 16:27:55 -0400 Tom Lane <[EMAIL PROTECTED]>
wrote:
Josh Berkus <[EMAIL PROTECTED]> writes:
From my perspective, we could really use a "delimiter" between the
"fields" of log output which is unlikely to appear within those fields
instead of parsing by character coun
Yes, I see those regularly too, and are related to bison issues.
---
Christopher Kings-Lynne wrote:
> It all built and passes regressions for me on freebsd/alpha, I got this
> though:
>
> gcc -pipe -O -Wall -Wmissing-protot
33 matches
Mail list logo
