X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 524D38B9EF3 for ; Tue, 8 Feb 2005 17:51:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38371-09 for ; Tue, 8 Feb 2005 17:51:24 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.197]) by svr1.postgresql.org (Postfix) with ESMTP id 8F51D8B9F0E for ; Tue, 8 Feb 2005 17:51:23 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id f1so955911rne for ; Tue, 08 Feb 2005 09:51:23 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=iMe89k/iyfF4S1T3EJ9jrhNHK05jdtnTvYESIQZLAQAUXFnL8VouzQjD7sx6avBheSAURsgbW28mEBFpIK5XUzD8mfe8bleLiWW++PUmOt+UOqG4jZa1N22S5kIeyFmuj0s0rjlxP6nFB3nXPGX21SVAmuF7PHUQmdJkL+x9vRA= Received: by 10.38.6.72 with SMTP id 72mr70559rnf; Tue, 08 Feb 2005 09:51:22 -0800 (PST) Received: by 10.38.72.74 with HTTP; Tue, 8 Feb 2005 09:51:22 -0800 (PST) Message-ID: <5f447e3505020809517851420b@mail.gmail.com> Date: Tue, 8 Feb 2005 11:51:22 -0600 From: Shashi Gireddy Reply-To: Shashi Gireddy To: pgsql-admin@postgresql.org Subject: too slow Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200502/67 X-Sequence-Number: 16235 I recently migrated from MySql, The database size in mysql was 1.4GB (It is a static database). It generated a dump file (.sql) of size 8GB), It took 2days to import the whole thing into postgres. After all the response from postgres is a disaster. It took 40sec's to run a select count(logrecno) from sf10001; which generated a value 197569. And It took for ever time to display the table. How to optimize the database so that I can expect faster access to data. each table has 70 colsX197569 rows (static data), like that I have 40 tables, Everything static. system configuration: p4 2.8ghz 512mb ram os: xp postgres version: 8.0 thanks a million in advance, shashi. -- Shashi Kiran Reddy. Gireddy, Graduate Assistant, CBER, University of Alabama. http://www.cs.ua.edu/shashi Home: 205-752-5137 Cell: 205-657-1438