Re: Newbie Question: FAQ for database optimization?

am 20.12.2005, um 22:21:54 +0100 mailte Alexander Scholz folgendes:
> Hi,
>
> is there a newbie's FAQ / book / link for "howto optimize databases with
> PostgreSQL"?

07:12 < rtfm_please> For information about tuning
07:12 < rtfm_please> see http://www.powerpostgresql.com
07:12 < rtfm_please> or http://www.powerpostgresql.com/PerfList
07:12 < rtfm_please> or http://www.varlena.com/varlena/GeneralBits/116.php

>
> 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(*)"

bad & ugly

> What action and/or reading can you recommend? (We quickly need some 'wow'
> effects to keep the customer happy <sigh>).

Create suitable indexes.

07:14 < akretschmer> ??index
07:14 < rtfm_please> For information about index
07:14 < rtfm_please> see http://www.postgresql.org/docs/current/static/indexes-expressional.html
07:14 < rtfm_please> or http://www.postgresql.org/docs/current/static/indexes-partial.html
07:14 < rtfm_please> or http://www.postgresql.org/docs/current/static/indexes.html

Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===