Forget abount IN. Its horribly slow.
try :
select w.appid,
w.rate,
w.is_subscribed,
sum(w.hits) AS Hits,
sum(w.sius) AS IUs,
sum(w.total_amnt) AS Total,
sum(w.hits) * w.rate AS ByHits,
sum(w.sius) * w.rate AS BYIUS
from bill_rpt_work w
where
afaik, this should be completely neglectable.
starting a transaction implies write access. if there is none, You do not need
to think about transactions, because there are none.
postgres needs to schedule the writing transactions with the reading ones,
anyway.
But I am not that performance
Mmmm, good question.
MVCC blocks reading processes when data is modified. using autocommit implies
that each modification statement is an atomic operation.
on a massive readonly table, where no data is altered, MVCC shouldn't have any
effect (but this is only an assumption) basing on
Title: INSERTs becoming slower and slower
Hi,
I am breaking up huge texts (between 25K and 250K words) into single words using PgPlsql.
For this I am using a temp table in the first step :
LOOP
vLeft := vRight;
vTmp := vLeft;
LOOP
vChr := SUBSTRING ( pText FROM
snip
FOR r_record IN SELECT count(cid) AS hits,src, bid, tid,NULL::int8 as
min_time,NULL::int8 as max_time FROM archive_event WHERE inst=\'3\' AND
(utctime BETWEEN \'111492\' AND \'1131512399\') GROUP BY src, bid, tid LOOP
SELECT INTO one_record MIN(utctime) as
I guess, You should check, if a blob field and large object access is suitable
for you - no escaping etc, just raw binary large objects.
AFAIK, PQExecParams is not the right solution for You. Refer the Large object
section:
28.3.5. Writing Data to a Large Object
The function
int
what about firing a
DELETE FROM qc_session S
WHERE EXISTS (SELECT *
FROM item_qc_doer i
WHERE i.item_id = s.item_id);
and
DELETE FROM item_qc_doer S
WHERE EXISTS (SELECT *
FROM item_qc_doer i
Nachricht-
Von: Richard Huxton [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 13. Oktober 2005 12:22
An: Nörder-Tuitje, Marcus
Cc: pgsql-performance@postgresql.org
Betreff: Re: [PERFORM] Optimizer misconfigured ?
Nörder-Tuitje wrote:
Hello,
I have a strange effect on upcoming structure