Skip site navigation (1) Skip section navigation (2)

Re: not using indexes on large table

From: Vincenzo Romano <vincenzo(dot)romano(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: not using indexes on large table
Date: 2007-04-21 20:58:06
Message-ID: 200704212258.07094.vincenzo.romano@gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Saturday 21 April 2007 22:17:42 Jeroen Kleijer wrote:
> I've tried several things but doing a query like:
> select distinct volume from project_access_times

I'm new too but an "order by volume"  could help!

In any case maybe a different table design with a separate table for the
"distinct volumes" could help even more.

-- 
Vincenzo Romano
----
Maybe Computers will never become as intelligent as
Humans. For sure they won't ever become so stupid.

In response to

pgsql-performance by date

Next:From: Andreas KostyrkaDate: 2007-04-21 21:17:04
Subject: Re: not using indexes on large table
Previous:From: Jeroen KleijerDate: 2007-04-21 20:17:42
Subject: not using indexes on large table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group