Re: Newbie Question: FAQ for database optimization? - Mailing list pgsql-general

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    ===