On Wed, 13 Aug 2003, ingrid martinez wrote:
Floes table looks like this
Table flows
Column| Type | Modifiers
--+--+---
flidload | bigint | not null
PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 9:32 AM
Subject: Re: [PERFORM] How can I Improve performance in Solaris?
On Wed, Aug 13, 2003 at 09:03:31AM -0500, ingrid martinez wrote:
I want to know, how can I improve the performance of postgres, I
have a java class thar inserts
More than likely you are suffering from an affliction known as type
mismatch. This is listed as tip 9 here on the performance list (funny, it
was sent at the bottom of your reply :-)
What happens is that when you do:
select * from some_table where id=123;
where id is a bigint the query
On Wed, Aug 13, 2003 at 10:17:45AM -0500, ingrid martinez wrote:
The query that execute is only inserts, I use a batch of 300 and then do
commit.
insert into FLOWS values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Are there any foreign keys, c?
and
postgresql.conf looks like this
[ . .
the primary key is flidload
- Original Message -
From: scott.marlowe [EMAIL PROTECTED]
To: ingrid martinez [EMAIL PROTECTED]
Cc: Andrew Sullivan [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 11:47 AM
Subject: Re: [PERFORM] How can I Improve performance