Re: Work table

On 10/27/2013 02:48 PM, Robert James wrote:
> On 10/27/13, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:

>>> Is there another problem here? Perhaps something to do with
>>> triggerring autovacuum?
>>
>> Is there a FK relationship involved?
>>
>> Could we see the schema for another_table?
>
>
> 1. No FK
> 2. I removed the indexes from the table
> TRUNCATE takes only 40 ms, but the INSERT still takes 10s!

So how many records are we talking about?

Also complete this sentence :)

INSERT INTO
another_table SELECT ...

In other words what is the SELECT statement for the INSERT?

Also, you mentioned the above was in a function. What is the function
body and how is it being called?

> 3. ALTER TABLE another_table SET (autovacuum_enabled = true,
> toast.autovacuum_enabled = true); didn't seem to make a difference
>
> 4. Here's the schema:
>
>
> CREATE TABLE another_table
> (
> id serial NOT NULL,
> eventtime timestamp without time zone NOT NULL,
> reporter character varying NOT NULL,
> loc character varying NOT NULL,
> city character varying NOT NULL,
> stanza character varying,
> purdue character varying,
> CONSTRAINT segment_pkey PRIMARY KEY (id)
> )
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com