Try to execute your query (in psql) with prefixing by EXPLAIN ANALYZE and
send us the result
db=# EXPLAIN ANALYZE UPDATE s_apotik SET stock = 100 WHERE obat_id='A';
regards
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tino Wildenhain
Sent: mardi 6 dé
Can you tell us more about the structure of your
tables,
witch sort of index did you set on witch fields
?
Did you really need to get ALL records at
once, instead you may be could use paging
(cursor or SELECT LIMIT OFFSET ) ?
And did you well
configure your .conf ?
Regards
Alban
M
You seem to not have index on botnumber, but in
your query bot number is the clause.
I don't explain you why the same query is so
long.
but have your try procedure with a loop structure
(witch create cursor) ?
you could try
CREATE OR
REPLACE FUNCTION sp_test_Alban1 ( )
returns in
Nobody got a plane to came from europe :-) ???
As a poor frenchie I will not come ...
Have a good time
Alban
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Aaron Mulder
Sent: mercredi 20 octobre 2004 15:11
To: [EMAIL PROTECTED]
Subject: Re: [PERFORM]
This topic probably available in 8.x will be very usefull for people just
using postgresql as a "normal" Database user.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: jeudi 21 octobre 2004 23:53
To: Thomas F.O'Connell
Cc: PgSQL - Performanc
Did you test with ILIKE instead of lower LIKE lower ?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of sdfasdfas
sdfasdfs
Sent: mercredi 24 novembre 2004 18:37
To: [EMAIL PROTECTED]
Subject: [PERFORM] "Group By " index usage
I have a table with this in
