Greg Stark <gsst...@mit.edu> [2009-08-21 18:55]: [...] > Is this, perchance, new hardware? Did you test the memory in it?
It's a "virtual private server"; the hosting provider is swearing everything's fine. I can't vouch for it myself, obviously. > Do you have other records that have "disappeared"? I haven't found any (yet). So far, verified with: create function exec(text) returns void language plpgsql as $f$ begin execute $1; end; $f$; select exec( 'select log_id, id from ( select distinct ''' || relname || ''', case first_value(trigger_mode) over w when ''DELETE'' then null else id end as log_id, first_value(last_modified) over w as lm from log.' || relname || ' window w as (partition by id order by id desc,trigger_id desc ) )x left join public.' || relname || ' on id=log_id where ( id is null or last_modified <> x.lm ) and log_id is not null' ) from pg_stat_user_tables where schemaname = 'log'; (Looks at the log.* table, finds the largest last_modified of the non-deleted rows, joins the public.* table on id, compares last_modified). -- Radosław Zieliński <ra...@pld-linux.org>
pgp6hTaWhV9cz.pgp
Description: PGP signature
