Re: [GENERAL] swap storm created by 8.2.3

2007-05-28 Thread Tom Lane
Joseph S <[EMAIL PROTECTED]> writes: > I set the ulimit for data to 4194304k: I've noticed that ulimit -d doesn't seem to do what you might expect on Linuxen. Try -m and/or -v. regards, tom lane ---(end of broadcast)--- TIP

Re: [GENERAL] swap storm created by 8.2.3

2007-05-27 Thread Joseph S
I set the ulimit for data to 4194304k: core file size (blocks, -c) 0 data seg size (kbytes, -d) 4194304 file size (blocks, -f) unlimited pending signals (-i) 1024 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimite

Re: [GENERAL] swap storm created by 8.2.3

2007-05-25 Thread Tom Lane
Richard Huxton <[EMAIL PROTECTED]> writes: > Let's see if that hash-join is really the culprit. Can you run EXPLAIN > and then EXPLAIN ANALYSE on the query, but first issue: > SET enable_hashjoin=off; > If that make little difference, try the same with enable_hashagg. It seems like it must be the

Re: [GENERAL] swap storm created by 8.2.3

2007-05-25 Thread Richard Huxton
Joseph Shraibman wrote: Richard Huxton wrote: Joseph Shraibman wrote: I ran a query that was "SELECT field, count(*) INTO TEMP temptable" and it grew to be 10gig (as reported by top) What was the real query? First I selected 90634 rows (3 ints) into the first temp table, then I did "sele

Re: [GENERAL] swap storm created by 8.2.3

2007-05-25 Thread Joseph Shraibman
Richard Huxton wrote: Joseph Shraibman wrote: I ran a query that was "SELECT field, count(*) INTO TEMP temptable" and it grew to be 10gig (as reported by top) What was the real query? First I selected 90634 rows (3 ints) into the first temp table, then I did "select intfield1, count(intfi

Re: [GENERAL] swap storm created by 8.2.3

2007-05-25 Thread Richard Huxton
Joseph Shraibman wrote: I ran a query that was "SELECT field, count(*) INTO TEMP temptable" and it grew to be 10gig (as reported by top) What was the real query? First I selected 90634 rows (3 ints) into the first temp table, then I did "select intfield1, count(intfield2) FROM realtable rt W

Re: [GENERAL] swap storm created by 8.2.3

2007-05-25 Thread Joseph Shraibman
Richard Huxton wrote: Joseph Shraibman wrote: 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, cou

Re: [GENERAL] swap storm created by 8.2.3

2007-05-22 Thread Richard Huxton
Joseph Shraibman wrote: 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

Re: [GENERAL] swap storm created by 8.2.3

2007-05-22 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/22/07 12:17, Joseph Shraibman wrote: > 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_

[GENERAL] swap storm created by 8.2.3

2007-05-22 Thread Joseph Shraibman
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 10gi