Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size - Mailing list pgsql-bugs

On 28.08.2013 02:28, Valentine Gogichashvili wrote:
> Running this sproc on the master:
>
> CREATE OR REPLACE FUNCTION public.f()
>   RETURNS integer
>   LANGUAGE plpgsql
> AS $function$
> begin
>
>    CREATE TEMP TABLE temp_table_to_test_replication AS
>      SELECT s.i as id from generate_series(1, 100) as s(i);
>    DROP TABLE temp_table_to_test_replication;
>    RETURN 1;
> end;
> $function$
>
> leads to writing of WAL files. Is it an expected behavior? Is it expected
> that WAL files are filled  when the only thing, that sproc is supposed to
> do is to create and drop a temporary table. Are these catalog changes?

Yep, creating/dropping temp tables are catalog changes, which are
WAL-logged.

- Heikki