Re: select slow? - Mailing list pgsql-performance

From Paul Thomas
Subject Re: select slow?
Date
Msg-id 20040331182701.A17746@bacon
Whole thread Raw
In response to Re: select slow?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On 31/03/2004 16:40 Tom Lane wrote:
> "Jaime Casanova" <el_vigia_ec@hotmail.com> writes:
> > There are no indexes yet, and the table is just 6 rows long so even if
> > indexes exists the planner will do a seq scan. that's my whole point
> 63m for
> > seq scan in 6 rows table is too much.
>
> That was 63 milliseconds, according to your original post, which seems
> perfectly reasonable to me seeing that it's not a super-duper server.
>
> The problem sounds to be either on the client side or somewhere in your
> network.  I don't know anything about VB, but you might want to look
> through the client-side operations to see what could be eating up the 13
> seconds.


Given that the client and server are on different machines, I'm wondering
the bulk of the 13 seconds is due a network mis-configuration or a very
slow DNS server...

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business             |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: select slow?
Next
From: Gaetano Mendola
Date:
Subject: linux and anotime mount option