From: | Wei Weng <wweng(at)kencast(dot)com> |
---|---|
To: | Jan de Visser <jdevisser(at)digitalfairway(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Anything I can do to speed up this query? |
Date: | 2006-12-05 21:06:22 |
Message-ID: | 1165352782.8448.12.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am running this in the same machine as the database though.
Thanks
On Tue, 2006-12-05 at 16:02 -0500, Jan de Visser wrote:
> On Tuesday 05 December 2006 3:56 pm, Wei Weng wrote:
> > I have a table that has roughly 200,000 entries and many columns.
> >
> > The query is very simple:
> >
> > SELECT Field1, Field2, Field3... FieldN FROM TargetTable;
> >
> > TargetTable has an index that is Field1.
> >
> > The thing is on this machine with 1Gig Ram, the above query still takes
> > about 20 seconds to finish. And I need it to run faster, ideally around
> > 5 seconds.
>
> I suspect it's the time needed to ship the data over the wire. Don't forget
> you're asking for an awful lot of data...
>
> >
> > Wei
> >
>
> jan
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Moran | 2006-12-05 21:06:27 | Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 Now Available) |
Previous Message | Wei Weng | 2006-12-05 21:04:30 | Re: Anything I can do to speed up this query? |