Received: from relay1.dnt.ro (IDENT:root@ns.dnt.ro [193.226.100.1])
	by hub.org (8.9.2/8.9.1) with ESMTP id JAA92066
	for <pgsql-sql@hub.org>; Thu, 4 Feb 1999 09:55:47 -0500 (EST)
	(envelope-from vang@ppp-21.dnt.ro)
Received: from ppp-21.dnt.ro (ppp-40.dnt.ro [193.231.125.40])
	by relay1.dnt.ro (8.8.5/8.8.8+antispam) with ESMTP id QAA09177;
	Thu, 4 Feb 1999 16:53:30 +0200
Received: (from vang@localhost) by ppp-21.dnt.ro (8.8.7/8.8.5) id QAA17359;
	Thu, 4 Feb 1999 16:57:18 -0500
Message-ID: <19990204165718.E16437@zeus.advatech.ro>
Date: Thu, 4 Feb 1999 16:57:18 -0500
From: Viorel Anghel <vang@altavista.net>
To: pgsql-sql@hub.org
Cc: tim@dmcity.net
Subject: Re: [SQL] Performance Question
Reply-To: vang@altavista.net
Mail-Followup-To: pgsql-sql@hub.org, tim@dmcity.net
References: <00c601be4fe5$a0796d10$0b8c5aa5@timnt.weather.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Mailer: Mutt 0.91.1i
In-Reply-To: <00c601be4fe5$a0796d10$0b8c5aa5@timnt.weather.net>;
	from Tim Perdue on Wed, Feb 03, 1999 at 08:25:25PM -0600
X-Organization: AdvaTech SRL

On Wed, Feb 03, 1999 at 08:25:25PM -0600, Tim Perdue wrote:
> Please email directly to tim@dmcity.net.
hmm, and CC to list, we also want to know ;-)

[snip]

> am I going to get killed with a performance hit?? It's running OK now, with
> the table at 20MB, but I have 100MB more worth of letters to drop into the
> table.....  8-)

1. What does mean "OK now"? Just for my curiosity, on which machine and
which is the average time for such a query?

2. Why don't you test with the rest of 100MB and tell us what is happening?

-- 
        ___
       <o-o>    Viorel ANGHEL <vang@altavista.net>
       [`-']    
       -"-"-