Re: Memory consumption problem

Franck Routier <franck.routier@axege.com> writes:
> I have a problem with a simple request :

> insert into mytable
> select a.id, a.desc, 'mystring'
> from mytable a;

> Mytable has about 1,7 million tuples, it has a few indexes.

Tell us about triggers or foreign keys involving that table?

            regards, tom lane