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 less clock speed, de-dups the
table
-Original Message-
From: Kevin Bartz [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 10:37 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [GENERAL] Out of swap space memory
Thanks for your reply, Mike! Theoretically, I should need only six of the
columns, but as a means of verifying
-
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 your query here say?
I had an issue[1] with 7.4.1 where
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
--
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
: Friday, August 06, 2004 8:41 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [GENERAL] Out of swap space memory
Well, all I'm doing right now is using psql from the command line. A bit
unintelligent, I know, but I want to make sure things will work
appropriately before I dive into the world of query editors