Re: Performance Question

On Wed, Nov 12, 2008 at 8:57 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> - - <themanatuf(at)yahoo(dot)com> writes:
>> One of my tables has 660,000 records and doing a SELECT * from that table (without any joins or sorts) takes 72 seconds. Ordering the table based on 3 columns almost doubles that time to an average of 123 seconds. To me, those numbers are crazy slow and I don't understand why the queries are taking so long. The tables are UTF-8 encode and contain a mix of languages (English, Spanish, etc). I'm running the query from pgadmin3 on a remote host. The server has nothing else running on it except the database.
>
> pgadmin has got its own performance issues with large select results.

They were fixed a couple of years ago. We're essentially at the mercy
of libpq now.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com