On Jun 14 12:53, Böszörményi Zoltán wrote:
> # explain analyze select * from mxstrpartsbg where szam =
> round(80*random())::integer;
AFAIK, you can use sth like that:
SELECT * FROM mxstrpartsbg
WHERE szam = (SELECT round(80*random())::integer OFFSET 0);
This will prevent calculation o
Hi,
Am I wrong or AGE() always gets directed to a sequential scan?
# BEGIN;
] SET enable_seqscan TO off;
] EXPLAIN ANALYZE
] SELECT count(1)
] FROM incomingmessageslog
] WHERE AGE(time) < '1 year';
] ROLLBACK;
BEGIN
SET
Hi,
Below command has been running since ~700 minutes in one of our
PostgreSQL servers.
DELETE FROM mugpsreglog
WHERE NOT EXISTS (SELECT 1
FROM mueventlog
WHERE mueventlog.eventlogid =
mugpsreglog.eventlogid);
Seq Scan on mugps
On Thu, 07 Aug 2008, Richard Huxton <[EMAIL PROTECTED]> writes:
> Volkan YAZICI wrote:
>> DELETE FROM mugpsreglog
>> WHERE NOT EXISTS (SELECT 1
>> FROM mueventlog
>>WHERE mueventlog.eventl
