Search Postgresql Archives

Re: Select slow over network

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



am  Fri, dem 17.11.2006, um 17:22:47 -0200 mailte Leodinei Bielak folgendes:
> Hello. I'm using PostgreSQL 8.1.4 with WinXP Sp2.
> The acess over network 100mbit is too slow.
> My query take 100 times more.

How long is a long time?


> The use of CPU and network is low,  less than  1%.
> Searching in the web I found other with the same problem, but no reply to
> resolve this problem.
> The query is a simple "SELECT * FROM table".

A dump query, sorry.


> the EXPLAIN of the query:
>     Seq Scan on cliente_geral  (cost=0.00..344.95 rows=6795 width=587)

Can you give as the output from 'EXPLAIN ANALYSE', so we can see not
only the estimate cost? How long is the real result? Perhaps, you have
wrong statistics, perhaps. And: without any WHERE - Conditions, every
SELECT-Query ends in a 'Seq Scan', and this will be slow. What do you
expected?


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux