Re: [GENERAL] Out of swap space & memory

2004-08-09 Thread Tom Lane
"Kevin Bartz" <[EMAIL PROTECTED]> writes: > Hi Lincoln! Thanks for your reply. On the problematic SELECT INTO, EXPLAIN > says: > test=# > QUERY PLAN > -- > HashAggregate (cos

Re: [GENERAL] Out of swap space & memory

2004-08-09 Thread Alvaro Herrera
On Mon, Aug 09, 2004 at 11:33:04AM -0700, Kevin Bartz wrote: > Hi Lincoln! Thanks for your reply. On the problematic SELECT INTO, EXPLAIN > says: > > test=# > QUERY PLAN > -- >

Re: [GENERAL] Out of swap space & memory

2004-08-09 Thread Kevin Bartz
r all your help. Kevin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lincoln Yeoh Sent: Friday, August 06, 2004 9:25 PM To: Kevin Bartz; 'Manfred Koizar'; [EMAIL PROTECTED] Subject: Re: [GENERAL] Out of swap space & memory What does EXPLAIN s

Re: [GENERAL] Out of swap space & memory

2004-08-09 Thread Kevin Bartz
ehalf Of Jeff Sent: Saturday, August 07, 2004 4:31 AM To: Kevin Bartz Cc: [EMAIL PROTECTED]; 'Manfred Koizar' Subject: Re: [GENERAL] Out of swap space & memory On Aug 6, 2004, at 10:32 PM, Kevin Bartz wrote: > > -- de-dup the table > MS SQL Server, with as much RAM and l

Re: [GENERAL] Out of swap space & memory

2004-08-08 Thread Pierre-Frédéric Caillaud
catalog_type varchar(100), pushed int, delivered int, clicks int, opened int, month varchar(100), type1 int, type2 int, type3 int, type4 int, type5 int); You could use the TEXT type (see postgresql doc). ---(end of broadcast)--- TIP 6: Have you