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 === ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
