From: | Manuel Duran Aguete <mdaguete(at)alsernet(dot)es> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Perfomance Problems |
Date: | 2001-11-07 00:41:20 |
Message-ID: | 1005093710.10200.48.camel@dt1010.quantum.int |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
Sorry , but by error I'd sent this message to postgresql-admin
I'm building an app (A) that inserts about 30.000 - 40.000
records in a
table per day. Another app (B) get this records and process it, an then
the records are deleted. The A app gets 50 records each time, this SQL
statement takes 10-15 seconds. I make a vaccum and the time is now about
5-10 seconds, bu it's to slow. It enqueue records, about 10-20 in each.
The B app takes less than a second in process each message.
The statement is
SELECT * FROM table_a
WHERE number = 123
AND msg_orig = 'A'
ORDER by id;
The table is:
id serial primary key,
data varchar(260),
number varchar(12)
time_a timestamp,
time_b timestamp,
msg_orig varchar(3)
Indexes:
Number,msg_orig, id, time_b
Please, Help, What I'm doing bad?
I'm using 7.1.2 in Solaris.
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-11-07 01:08:48 | Re: self outer join |
Previous Message | Peter Eisentraut | 2001-11-06 22:51:05 | Re: Probably simple answer |