From: | Alexander Scholz <alexander(dot)scholz1(at)freenet(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Newbie Question: FAQ for database optimization? |
Date: | 2005-12-20 21:21:54 |
Message-ID: | do9sl9$1tbi$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
is there a newbie's FAQ / book / link for "howto optimize databases with
PostgreSQL"?
Background: Customer has the Windows* (sorry <g>) Postgres 8.1.0
standard installation "out of the box". A table has 2.5 mio records. No
indizes defined, primary key (sequence) does exist. In pgAdmin "select
count(*)" takes over 30 seconds, an "update" affecting 70'000 records
takes minutes... I am sure PostgreSQL could do better, we "just" need to
tune the database. (I hope so at least!)
What action and/or reading can you recommend? (We quickly need some
'wow' effects to keep the customer happy <sigh>).
Thanx,
Alexander.
*) sorry, I don't have server's hardware spec. available right now, but
the MSSQL2005 instance on it does the same things in a few seconds... ;-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-12-20 21:49:14 | Re: Syntax Error Inserting From STDIN? |
Previous Message | Hunter's Lists | 2005-12-20 20:40:13 | Re: Syntax Error Inserting From STDIN? |