Re: [GENERAL] memory problem with refresh materialized view

2016-02-12 Thread Albe Laurenz
Enrico Pirozzi wrote: > I have a new postgresql 9.5.0 installation on a new virtual server debian 8.3 > x64 with 4gb RAM, I have > compiled postgresql from source. > > When I import a dump with materialized views I see that postgres process > takes about all 4 Gb and then > I have this error >

Re: [GENERAL] Memory Problem

2008-07-03 Thread Volkan YAZICI
Hi, On Wed, 02 Jul 2008, Tom Lane <[EMAIL PROTECTED]> writes: > Are there any foreign keys referencing this table? If so, you're > probably running out of memory for the list of pending trigger events > (to verify that the FK constraint isn't violated by the delete). > > Allowing the triggers to

Re: [GENERAL] Memory Problem

2008-07-02 Thread Tom Lane
Volkan YAZICI <[EMAIL PROTECTED]> writes: > We have an IBM System x3850 machine running on RHEL 4.5 Cluster Suite > with high-availability enabled. During a huge delete process, PostgreSQL > (8.3.1) exhausts available memory and receives an OOM kill. Are there any foreign keys referencing this tab