The thing is that in the text file there is a column that is something like
xyz_12 and in the table i just need the integer part of it that's what the
query is used for. The problem though is not really in the select part, because
running the select part on 8 million lines takes about 3
The analyze is from the exact query and i dropped the indexes before the insert
as well without imrpvement. The target table is as well completely empty and
the insert is supposed to write, in this case, more or less 8 million lines in
the table. There is a rule though, because i have
On 19/07/2006, at 6:32 PM, Christian Rengstl wrote:
The analyze is from the exact query and i dropped the indexes
before the insert as well without imrpvement. The target table is
as well completely empty and the insert is supposed to write, in
this case, more or less 8 million lines in
Well, i'll try that, but honestly i don't think it's the rule as the rule is
really simple: it's just one simple integer comparison...
Q [EMAIL PROTECTED] wrote on 07/19/06 11:54 am:
On 19/07/2006, at 6:32 PM, Christian Rengstl wrote:
The analyze is from the exact query and i dropped the
hi,
can anydody tell me what steps nee to configure postgres for java application.plz give me link frm where i got driver for it.-- Deepak PalSoftware DeveloperWicenet ltd.Pune(M.H
)
On Tue, Jul 18, 2006 at 08:03:51PM -0400, Eric Faulhaber wrote:
It's not a defect ... or at least, it doesn't make sense to change it
unless you are willing to go through the entire system to make it able
to store null bytes in text. We've looked at that in the past and
always concluded
Obviously it had something to do with the rule, because now everything finished
within 20 minutes. the problem is just that i don't really want to give up the
inheritance design. is there a way to maintain the inheritance that doesn't
cause this huge performance problem?
Q [EMAIL PROTECTED]
On 19/07/2006, at 8:49 PM, Christian Rengstl wrote:
Obviously it had something to do with the rule, because now
everything finished within 20 minutes. the problem is just that i
don't really want to give up the inheritance design. is there a way
to maintain the inheritance that doesn't
this is really newb of me but i can't manage to make a script to create
users.
cur.execute(CREATE USER %s WITH PASSWORD %s IN GROUP %s
,(StaffUserName,NewPassword,StaffGroup))
produces this error
ERROR: syntax error at or near 'bob.smith' at character 13
is it because i need to double
So here's the master table including the rules:
entry_no int8 NOT NULL DEFAULT nextval('public.master_seq'::regclass),
pid varchar(15) NOT NULL,
val_1 varchar(1),
val_2 varchar(1),
chr int2 NOT NULL,
aendat timestamp DEFAULT now(),
aennam varchar(8),
CONSTRAINT PK_ENTRY PRIMARY KEY
On Jul 19 10:02, Timothy Smith wrote:
cur.execute(CREATE USER %s WITH PASSWORD %s IN GROUP %s
,(StaffUserName,NewPassword,StaffGroup))
produces this error
ERROR: syntax error at or near 'bob.smith' at character 13
IIRC, per Python DB-API PEP, the DB adapter you use try to escape and
On Jul 19 10:40, Timothy Smith wrote:
Volkan YAZICI wrote:
On Jul 19 10:02, Timothy Smith wrote:
cur.execute(CREATE USER %s WITH PASSWORD %s IN GROUP %s
,(StaffUserName,NewPassword,StaffGroup))
produces this error
ERROR: syntax error at or near 'bob.smith' at character 13
Hello List,
Sorry to send an other e-mail on this subject but it is become a little
bit vague for me.
Imagine you have a database on which a lot of transactions are done
daily : the tables will contain a lot of dead tuples and the B-tree
index too.
If I do a VACUUM on this database, will
On Wed, Jul 19, 2006 at 03:03:43PM +0200, DANTE Alexandra wrote:
Imagine you have a database on which a lot of transactions are done
daily : the tables will contain a lot of dead tuples and the B-tree
index too.
If I do a VACUUM on this database, will the B-tree index be scanned,
space
Volkan YAZICI wrote:
On Jul 19 10:40, Timothy Smith wrote:
Volkan YAZICI wrote:
On Jul 19 10:02, Timothy Smith wrote:
cur.execute(CREATE USER %s WITH PASSWORD %s IN GROUP %s
,(StaffUserName,NewPassword,StaffGroup))
produces this error
ERROR: syntax error at or near
Thank you Martijn for your answer !
I use the 8.1.3 release of PostgreSQL.
Will it be sensible to launch an ANALYZE after the VACUUM to update
statistics ?
Regards,
Alexandra
Martijn van Oosterhout wrote:
On Wed, Jul 19, 2006 at 03:03:43PM +0200, DANTE Alexandra wrote:
Imagine you have
On Wed, Jul 19, 2006 at 03:23:08PM +0200, DANTE Alexandra wrote:
Thank you Martijn for your answer !
I use the 8.1.3 release of PostgreSQL.
You'll be fine...
Will it be sensible to launch an ANALYZE after the VACUUM to update
statistics ?
Or do both at the same time (VACUUM ANALYZE).
Have
On 19/07/2006, at 10:03 PM, Christian Rengstl wrote:
So here's the master table including the rules:
entry_no int8 NOT NULL DEFAULT nextval('public.master_seq'::regclass),
pid varchar(15) NOT NULL,
val_1 varchar(1),
val_2 varchar(1),
chr int2 NOT NULL,
aendat timestamp DEFAULT now(),
Yesterday I sent two messages to pgsql-general@postgresql.org, and
neither one posted, as far as I can tell.
Please explain the gin index - 7/18/06 10:44 AM EDT
number of distinct values in tsearch2 gist index - 7/18/06 1:24 PM EDT
This has also happened to me on numerous previous occasions.
Martijn van Oosterhout kleptog@svana.org writes:
Looking at the code it doesn't appear that there are too many places
that are problematic.
Really?
The killer problem is that all datatype I/O goes through C strings.
Fixing this therefore would require breaking every user-defined
datatype on
# [EMAIL PROTECTED] / 2006-07-19 09:50:05 -0400:
Yesterday I sent two messages to pgsql-general@postgresql.org, and
neither one posted, as far as I can tell.
Please explain the gin index - 7/18/06 10:44 AM EDT
number of distinct values in tsearch2 gist index - 7/18/06 1:24 PM EDT
On 7/19/06, Roman Neuhauser [EMAIL PROTECTED] wrote:
Both are in my pgsql-general maildir, message ids:
[EMAIL PROTECTED] [EMAIL PROTECTED]
I find those as well.
regards,
Robin
---(end of broadcast)---
TIP 3: Have you checked our
Kevin Murphy [EMAIL PROTECTED] writes:
Yesterday I sent two messages to pgsql-general@postgresql.org, and
neither one posted, as far as I can tell.
Why do you think that?
http://archives.postgresql.org/pgsql-general/2006-07/msg00660.php
well i started by creating a table with the data i needed, instead of
working on the big tablethat helped a whole lot.
thanks.
On 7/18/06, Michael Fuhr [EMAIL PROTECTED] wrote:
On Tue, Jul 18, 2006 at 08:11:40AM -0500, Rhys Stewart wrote:
i created a function and it takes a long time to
Hi,
I'm diving more into depth of the features outside the typical table
stuff, which I usually need.
I wrote a trigger that fires a function written in PL/Python, both works
fine so far.
But as I browsed my database via pgAdmin3 I recognized that there is
also 'Procedures' under 'public'
I have a junction table that is recording
relationships between two records in another table. Is there a way that
I can create a constraint so that the values are not repeated in any order?
I want to make sure that rows such as 2 and 4 in the example below cannot
happen. This is a very small
I have a junction table that is recording relationships between two
records in another table. Is there a way that I can create a constraint so
that the values are not repeated in any order? I want to make sure that
rows such as 2 and 4 in the example below cannot happen. This is a very
deepak pal wrote:
hi,
can anydody tell me what steps nee to configure postgres for java
application.plz give me link frm where i got driver for it.
--
Deepak Pal
Software Developer
Wicenet ltd.
Pune(M.H )
Deepak,
JDBC drivers and docs are provided separately. See:
Hi Richard and list,
Thanks for the reply. On the constraint
what I am trying to create is a constraint that would not let me create
a row with fkey1 = 4 and fkey2 = 10 if I already had a row that had fkey1
= 10 and fkey2 = 4. The constraint needs to check the combination
of values in any order.
Hi all
Trying to create a function I get the following:
codex=# CREATE FUNCTION bitvg (integer,integer) RETURNS integer AS
'/home/database/pgdata/cobis/bitvg/bitvg.so', 'bitvg' LANGUAGE 'C';
ERROR: could not load library
/home/database/pgdata/cobis/bitvg/bitvg.so:
Cornelia Boenigk wrote:
The file does exist in the path /home/database/pgdata/cobis/bitvg/:
-rwxr-xr-x 1 root root 133 Jul 19 13:13 bitvg.c
-rwxr-xr-x 1 root root 782 Jul 19 13:13 bitvg.o
-rwxr-xr-x 1 root root 3198 Jul 19 13:13 bitvg.so
What do I miss?
Does the postgres user have
On Wed, 19 Jul 2006 [EMAIL PROTECTED] wrote:
I have a junction table that is recording relationships between two
records in another table. Is there a way that I can create a constraint so
that the values are not repeated in any order?
I think the following does what you need, though my
On Wed, 2006-07-19 at 09:01 -0700, [EMAIL PROTECTED] wrote:
I have a junction table that is recording relationships between two
records in another table. Is there a way that I can create a
constraint so that the values are not repeated in any order? I want to
make sure that rows such as 2 and
Title: Message
PostgreSQL is a database engine. You use it
froma Java application just like you would any other DBMS. The JDBC
driver for it can be found here: http://jdbc.postgresql.org/
--Guy Rouillier
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Cornelia Boenigk [EMAIL PROTECTED] writes:
in english: /home/database/pgdata/cobis/bitvg/bitvg.so: cannot open
shared object: file not found
The file does exist in the path /home/database/pgdata/cobis/bitvg/:
The file not found might be coming from the dynamic loader trying to
load some
On 7/19/06, Anastasios Hatzis [EMAIL PROTECTED] wrote:
Hi,
I'm diving more into depth of the features outside the typical table
stuff, which I usually need.
I wrote a trigger that fires a function written in PL/Python, both works
fine so far.
But as I browsed my database via pgAdmin3 I
Hi Joe
Try:
su postgres
cd /home/database/pgdata/cobis/bitvg
Succeeds, ls -la shows all files in that directory and can open them
with less.
Regards
Conni
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Tom Lane wrote:
Kevin Murphy [EMAIL PROTECTED] writes:
Yesterday I sent two messages to pgsql-general@postgresql.org, and
neither one posted, as far as I can tell.
Perhaps your own incoming spam filtering is dropping the messages?
Hmm, I checked the spam filter folder, to no avail.
Olá senhores, boa tarde.
Estou com o seguinte problema...cadastrei em lote alguns dados nas
tabelas do meu bd, só que as seqüências não foram atualizadas,
todas elas se encontram com valor atual igual a 1, gerando erros quando
eu vou cadastrar alguma informação.
Primeiro gostaria de saber se
Hello,
I have created a DB1 with several tables. Now i need to create another DB2 with a linked table from DB1. So if there is a table_X in DB1, is there a way to import that table_X into DB2 so that any changes made to table_X in DB1 will also apply to DB2?
table_X has references to other
Hi
Is it possible to merge the postgre.msi into a visual studio 2005 setup msi.
I am hoping to combine both rather then have to seperate files.
Thanks in advance for any advise
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Merlin Moncure wrote:
there are differences. PostgreSQL only really supports functions and
on the lists they are used interchangably. on the -hacker list about
a year back there was a good discussion about implementing true SP and
why they would be needed.
mainly, SP are not externally
I have created a DB1 with several tables. Now i need to create another DB2 with
a linked table
from DB1. So if there is a table_X in DB1, is there a way to import that
table_X into DB2 so that
any changes made to table_X in DB1 will also apply to DB2?
table_X has references to other tables in
Hi Tom
You should try ldd or local equivalent on bitvg.so to check
whether all its dependencies can be found.
output:
ldd /home/database/pgdata/cobis/bitvg/bitvg.so
statically linked
Regards
Conni
---(end of broadcast)---
TIP 9: In
19 Jul 2006 10:59:10 -0700, Léo Matos [EMAIL PROTECTED]:
Olá senhores, boa tarde.
Estou com o seguinte problema...cadastrei em lote alguns dados nas
tabelas do meu bd, só que as seqüências não foram atualizadas,
todas elas se encontram com valor atual igual a 1, gerando erros quando
eu vou
On Wed, Jul 19, 2006 at 10:03:34AM -0400, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
Looking at the code it doesn't appear that there are too many places
that are problematic.
Really?
The killer problem is that all datatype I/O goes through C strings.
Fixing this
Cornelia Boenigk wrote:
Hi Joe
Try:
su postgres
cd /home/database/pgdata/cobis/bitvg
Succeeds, ls -la shows all files in that directory and can open them
with less.
Kind of odd, particularly given your reply to Tom's question in a nearby
post. Could it be an SELinux issue?
Joe
Martijn van Oosterhout kleptog@svana.org writes:
The fact is that if you're using binary format paramaters and output
you can put embedded nulls into strings and get them back out.
Not any more ;-)
By changing a
few strcmps to memcmps you can get sane behaviour for sorting a several
other
Joe Conway [EMAIL PROTECTED] writes:
Could it be an SELinux issue?
I'd really expect the strerror result to be something about 'permission
denied' rather than 'file not found', if that were the problem...
regards, tom lane
---(end of
Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
The fact is that if you're using binary format paramaters and output
you can put embedded nulls into strings and get them back out.
Not any more ;-)
OK, but now that this feature has been removed in 8.1.4, how is this
Hi Tom, Joe
After compiling the C-source files
# gcc -fpic -c bitvg.c
# gcc -shared -o bitvg.so bitvg.o
the pg_restore created the function.
It is Suse 9.x and PG 8.1.4
Thanks
Conni
---(end of broadcast)---
TIP 2: Don't 'kill -9' the
On Wed, Jul 19, 2006 at 05:13:04PM -0400, Tom Lane wrote:
Given the lack of memcoll, that proposal isn't going to fly ...
at least not until we replace all the locale support code with something
else (that hopefully will be null-clean).
Yeah, ICU would give us that, but it won't magically fix
On Wed, Jul 19, 2006 at 05:24:53PM -0400, Eric Faulhaber wrote:
OK, but now that this feature has been removed in 8.1.4, how is this
supposed to be handled, given that we don't control what string data
we're handed? How does psql deal with it?
Well, bytea handles null like it always has.
Martijn van Oosterhout wrote:
On Wed, Jul 19, 2006 at 05:24:53PM -0400, Eric Faulhaber wrote:
OK, but now that this feature has been removed in 8.1.4, how is this
supposed to be handled, given that we don't control what string data
we're handed? How does psql deal with it?
Well, bytea
On Wed, 2006-07-19 at 09:01 -0700, [EMAIL PROTECTED]
wrote:
I have a junction table that is recording relationships between
two
records in another table. Is there a way that I can create a
constraint so that the values are not repeated in any order?
I want to
make sure that rows such as
I saw the same behavior with Functions and Procedures. At first, I could not tell what made one go into the Function folder and one go into the Procedure one.The one thing that clearly distinguishes a Procedure (to be placed into the Procedures folder in PgAdminIII) is if you include an OUT
I wrote:
Reece Hart [EMAIL PROTECTED] writes:
After a system crash, postgresql 8.1.4 restarted but reported that I
have an apparent wraparound:
2006-07-13 14:03:40 PDT [10092] LOG: could not truncate directory
pg_multixact/offsets: apparent wraparound
2006-07-13 14:03:40 PDT [10092] LOG:
On 7/19/06, Pratik Shukla [EMAIL PROTECTED] wrote:
I have created a DB1 with several tables. Now i need to create another DB2
with a linked table from DB1. So if there is a table_X in DB1, is there a
way to import that table_X into DB2 so that any changes made to table_X in
DB1 will also apply
i am using postgresql 8.0.0
my disk is 100% full
i have a database called x
i do the following
psql x
delete from table;
nothing happens
i try to see the top output
i see the following
1768 sdc
25 0 41860 32m 30m R 99.7 0.8 11:29.35
postmasteri also saw this appearing
2525 root 16 0
59 matches
Mail list logo