Re: Problematic Index Scan - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Problematic Index Scan
Date
Msg-id 20020725085136.Q48685-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Problematic Index Scan  (Tourtounis Sotiris <tourtoun@csd.uoc.gr>)
List pgsql-general
On Thu, 25 Jul 2002, Tourtounis Sotiris wrote:

> I have a table with 3 attributes(int8, int8, int respectively) and I load
> to it a batch file of 150000 tuples, which each of them contains a series
> of java long, long and integer parameters respectively too. The first

Are you running vacuum analyze after doing the load (and if you're doing
any significant update/insert/delete occasionally thereafter?)



pgsql-general by date:

Previous
From: Tourtounis Sotiris
Date:
Subject: B-trees (Indexes) storage space
Next
From: Stephan Szabo
Date:
Subject: Re: select distinct error ?