swap storm created by 8.2.3

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: swap storm created by 8.2.3
Date: 2007-05-22 17:17:41
Message-ID: f2v8jk$2a8c$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm running:

PostgreSQL 8.2.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
3.4.6 20060404 (Red Hat 3.4.6-3)

My memory settings are:

work_mem = 64MB
shared_buffers = 128MB
temp_buffers = 32MB

I ran a query that was "SELECT field, count(*) INTO TEMP temptable" and
it grew to be 10gig (as reported by top) and brought the whole machine
to its knees. How do I keep this from happening again?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sudhir 2007-05-22 17:20:33 Re: Lock table, Select for update and Serialization error
Previous Message Robert Fitzpatrick 2007-05-22 17:15:56 Re: Permance issues with migrated db