Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id A1F842E004F for ; Wed, 9 Apr 2008 06:58:40 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 15116-04 for ; Wed, 9 Apr 2008 06:58:34 -0300 (ADT) X-Greylist: delayed 00:06:40.823566 by SQLgrey-1.7.5 Received: from web33505.mail.mud.yahoo.com (web33505.mail.mud.yahoo.com [68.142.206.154]) by developer.postgresql.org (Postfix) with SMTP id 7F0EC2E002C for ; Wed, 9 Apr 2008 06:58:33 -0300 (ADT) Received: (qmail 91174 invoked by uid 60001); 9 Apr 2008 09:51:50 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=rocketmail.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=wVrmF6Vj1RE0zjrVBuR9nucWCUYbuhDC5Gn4ncmE+Q1ZQSv4utAXS6XAv29IrfqPTMF0D6WXx8XTYYMxc2EXXkdfJHfvVwhSlv3hspBMiGllbSOa3uoB9trTApa5U4c+mMhA2tnvM1a4r0xqa4dufIENldW4osuz/rgTfu+tGjg=; X-YMail-OSG: g05pffIVM1nDOETXtEmRSOkJvbq_3zV4eut_NkJWoXR_st5pYhw._.mHwZXE05QqcQ-- Received: from [88.149.180.151] by web33505.mail.mud.yahoo.com via HTTP; Wed, 09 Apr 2008 02:51:50 PDT Date: Wed, 9 Apr 2008 02:51:50 -0700 (PDT) From: "Luigi N. Puleio" Subject: EXPLAIN detail To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <862313.90586.qm@web33505.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/98 X-Sequence-Number: 29591 Hello everyone!! I have a table with 17 columns and it has almost 530000 records and doing just a SELECT * FROM table with the EXPLAIN ANALYZE I get: Seq Scan on table (cost=0.00...19452.95 rows=529395 width=170) (actual time=0.155...2194.294 rows=529395 loops=1) total runtime=3679.039 ms and this table has a PK... Do you think is too much time for a simple select?... I guess it's a bit slow to get all those records...but since I'm a newbie with PostgreSQL, what I can check to optimize? Thanks to all! Ciao, Luigi __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com