Re: PostgreSQL 8.0.6 crash

More info: the machine has 512M RAM and 512M swap
Work mem is set to:work_mem = 1024

This should't have crashed, should it?

> PostgreSQL promptly uses all available memory for the query and
> subsequently crashes.
>
> I'm sure it can be corrected with a setting, but should it crash?
>
> freedb=# create table ucode as select distinct ucode from cdtitles group
> by ucode having count(ucode)>1 ;
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
>
> (Table layout)
> freedb=# \d cdtitles
> Table "public.cdtitles"
> Column | Type | Modifiers
> -----------+-------------------+-----------------------------------
> cdid | integer | default nextval('seq_cdid'::text)
> cdcode | character varying |
> ucode | character varying |
> title | character varying |
> artist | character varying |
> genre | character varying |
> dgenre | character varying |
> year | integer |
> processed | character varying |
> submit | character varying |
> revision | integer |
> disclen | integer |
> tracks | integer |
> extkey | integer |
> offsets | integer[] |
> Indexes:
> "cdtitles_ucode" btree (ucode) CLUSTER
>
> (Size of table)
> freedb=# select count(*) from cdtitles ;
> count
> ---------
> 1927912
> (1 row)
>
> (Sample row)
> freedb=# select * from cdtitles where cdid = 100001 limit 1;
> cdid | cdcode | ucode | title |
> artist | genre | dgenre | year | processed
> | submit | revision | disclen | tracks | extkey |
> offsets
> --------+----------+-----------------------+--------------------------+------------+-------+--------+------+-------------------------------------------------+-----------------+----------+---------+--------+--------+-----------------------------------------------------------------------------------------------------------------------------------------------
> 100001 | 320e9e14 | 0ea0-14-3399-0006ad6a | Var Slutar V�arna
> (CD1) | Streaplers | rock | | 0 | cddbd v1.5PL3 Copyright (c)
> Steve Scherf et al. | dBpowerAMP V4.0 | 0 | | 19 |
> |
> {21,150,13920,31180,43664,59907,73163,86629,98447,113684,130205,141682,154920,166783,179028,192689,205161,222164,234649,249692,264340,3744,0}
> (1 row
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>