Justin Clift writes:
Now that I know you are already addressing this, I'm not sure they need
to be on the techdocs site. I don't think we should have too much
duplication and therefore wasted effort.
Do you think it would be better to remove the startup scripts section
from the techdocs
Mike Mascari wrote:
If you start psql with the -E option you'll see it generates a query
similar to the following:
SELECT substring(d.adsrc for 128) FROM pg_attrdef d, pg_class c
WHERE c.relname = 'my_table' AND c.oid = d.adrelid NAD d.adnum = X
where my_table is the table in question
I have this little test application that compares
retreiving and inserting data using indexes and not using
indexes. I have tried this program on two different
machines. One is a PIII 533 256 meg memory and SCSI. The
other one is a dual 400 (something) 512 meg memory. The
thing is that the
Daniel ?erud [EMAIL PROTECTED] writes:
1 inserts takes 665 seconds on the PIII 533, while on
the dual 400 it takes about 13 seconds (*GULP!*).
Maybe postmaster running with -F on one system but not the other?
Or referential integrity checks defined on one table and
not the other?
Try to run a vacuum on the box with slow inserts (don't know if that
helps, though).
Run a /sbin/hdparm -t harddisk, to compare the speed of the harddisks.
HTH,
Poul L. Christiansen
Daniel ?erud wrote:
I have this little test application that compares
retreiving and inserting data using
On Mon, Apr 02, 2001 at 10:21:34AM -0400, Tom Lane wrote:
will trillich [EMAIL PROTECTED] writes:
i've tried
create function gpa(OPAQUE)
and psql tells me it successfully
CREATED
something, but
\df
shows no such function.
I believe \df suppresses opaque-argument
Hi.
here's my scenario: table employee has emp_id and employee
details. table salesorder has emp_id and sales details.
The following works fine: (get all employees who have sold
something)
SELECT emp_id FROM employee WHERE emp_id IN (SELECT emp_id FROM
salesorder);
However, getting employees
As someone else pointed out you can upgrade to 7.1. Or you can add your
own operators/functions.
I've included the C source and SQL create script. You'll need to do this
as the postgres superuser. And you'll probably need to edit the SQL
script and adjust the path of the .so file. The .c
Hi
To start with, I think your queries will be faster if you don't use IN,
but instead used regular joins or EXISTS whenever possible
On Mon, 2 Apr 2001, Kevin L wrote:
The following works fine: (get all employees who have sold
something)
SELECT emp_id FROM employee WHERE emp_id IN (SELECT
Kevin L writes:
However, getting employees who have NOT sold something always
returns zero rows:
SELECT emp_id FROM employee WHERE emp_id NOT IN (SELECT emp_id
FROM workorder);
Are there any NULL values in workorder.emp_id? If so, you need to exclude
them (... FROM workorder WHERE emp_id
Kevin L [EMAIL PROTECTED] writes:
However, getting employees who have NOT sold something always
returns zero rows:
SELECT emp_id FROM employee WHERE emp_id NOT IN (SELECT emp_id
FROM workorder);
Probably you have some NULL values in workorder. See past discussions
about why NOT IN and NULL
is there a way to reindex a sequence?
if so how and is it in the curent
docs?
Mike
Daniel ?erud wrote:
1 inserts takes 665 seconds on the PIII 533, while on
the dual 400 it takes about 13 seconds (*GULP!*). I have
done a clean reinstallation (dpkg --purge postgresql, apt-
get install postgresql) and tried it again. Same results.
Do you guys know what could be the
"mike" [EMAIL PROTECTED] writes:
is there a way to reindex a sequence?
Sequences don't have indexes, so they don't need reindexing.
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading through Usenet,
At 11:03 AM 4/2/2001 -0700, you wrote:
linking ./include/port to interfaces/odbc/port
mkdir: cannot create directory `interfaces/odbc': No such file or directory
ln: ./include/port: hard link not allowed for directory
configure: error: can not link interfaces/odbc/port to ./include/port
Ok, that
Thanks for the insight. The problem is that logging ax is basically a
convenience for the end user. (A is a user table) I must reference B
from C. If I also add an A reference to C, I want the A reference to
be automatically maintained at the database level. And this is where
things start
Soma Interesting [EMAIL PROTECTED] writes:
Judging by the mailing list archives, lots of people have ran into this,
but none received answers.
You must not have looked in the right threads.
If you're building interfaces/perl5 by hand (ie, not letting
src/interfaces/Makefile do it for you)
Hi guys -
This is today's CVS:
db= select 1::interval;
ERROR: Bad interval external representation '1'
And this is 7.0.3:
db= select 1::interval;
?column?
--
00:00:01
(1 row)
Am I missing something?
--
Alvaro Herrera (alvherre[@]atentus.com)
---(end of
The searchable archives seem to be unavailable today. Could somebody
please tell me how to display the constraints that have been defined
for a given table (or all tables).
Is it possible to dump the original SQL DDL for a database or table?
That is, not just the \d information but the
At 06:38 PM 4/2/2001 -0400, you wrote:
Soma Interesting [EMAIL PROTECTED] writes:
Judging by the mailing list archives, lots of people have ran into this,
but none received answers.
You must not have looked in the right threads.
If you're building interfaces/perl5 by hand (ie, not letting
Soma Interesting [EMAIL PROTECTED] writes:
ERROR: Load of file /usr/lib/pgsql/lib/plperl.so failed: libperl.so:
cannot open shared object file: No such file or directory.
Is libperl.so known to your dynamic linker? It has to be found via
LD_LIBRARY_PATH, /etc/ld.so.conf, or local
I would like to log cisco pix entries and then use that to report on
intrusion activities and monitor traffic patterns.
respectfully,
Joseph
-Original Message-
From: Ben [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 11:22 AM
To: Joseph
Cc: [EMAIL PROTECTED]
Subject: Re:
Thanks for the great anwsers.
I recieved good answers.
I had not even started thinking about the normalization part of it yet.
I am not sure I understand the implications of the piping it to the insert
routine.
That sure would sound like a simple effective method.
respectfully,
Joseph
I am not sure I understand the implications of the piping it to the
insert
routine.
It's a double-edged sword. Invoking it is as simple as adding a line to a
conf file, while developing it may turn out to be tricky. At least make
sure you examine output of ps ax to see how much
KuroiNeko [EMAIL PROTECTED] writes:
I am not sure I understand the implications of the piping it to the
insert
routine.
It's a double-edged sword. Invoking it is as simple as adding a line to a
conf file, while developing it may turn out to be tricky. At least make
sure
Also, if your pipe reader slows down too much, syslogd will start
blocking on the pipe
Indeed.
So I think it'd be much safer to
have a flat text logfile and have your program read from that
Or send the data to DB backend only when the logs are rotated. As long
as the logs are kept short,
From: "mike" [EMAIL PROTECTED]
is there a way to reindex a sequence?
if so how and is it in the curent docs?
Mike
Reindex a sequence? Not sure what you mean by that. You can set the value to
something else:
select setval('mysequence',12345);
If you mean compact the values used so there
27 matches
Mail list logo