PostgreSQL :: table !!

1.txt

--- 1. View CacheMemoryContext ---
SELECT pg_size_pretty(total_bytes)
FROM pg_get_backend_memory_contexts()
WHERE name = 'CacheMemoryContext';

ผลการทำงาน
1024 kB

--- 2. Select from all tables in database
DO
$$DECLARE
   i integer;
BEGIN
   FOR i IN 1..1000 LOOP
     EXECUTE
        format(
           'TABLE %I',
           'tab_' || i
        );
     IF i % 10 = 0 THEN
        COMMIT;
     END IF;
   END LOOP;
END;$$;

--- 3. View CacheMemoryContext Again !! ---
SELECT pg_size_pretty(total_bytes)
FROM pg_get_backend_memory_contexts()
WHERE name = 'CacheMemoryContext';


ผลการทำงาน
16 MB