Re: Load a database into memory
Guillaume Lémery <glemery@comclick.com>
From: Guillaume Le'mery <glemery@comclick.com>
To: Denis Perchine <dyp@perchine.com>, pgsql-general <pgsql-general@postgresql.org>
Date: 2001-01-26T09:18:54Z
Lists: pgsql-general
>> Maybe I should create an index on (num_editeur, num_site, num_emplacement) >> ? > > > Yes. Try to. This is the best choice. Here it comes : VACUUM VERBOSE ANALYZE accord_editeur; NOTICE: --Relation accord_editeur-- NOTICE: Pages 7096: Changed 0, reaped 6790, Empty 0, New 0; Tup 447032: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 23768, MinLen 124, MaxLen 124; Re-using: Free/Avail. Space 721776/0; EndEmpty/Avail. Pages 0/0. CPU 0.39s/1.67u sec. NOTICE: Index ae_tracking_idx: Pages 2300; Tuples 447032: Deleted 0. CPU 0.07s/0.90u sec. VACUUM EXPLAIN : NOTICE: QUERY PLAN: Nested Loop (cost=0.00..228.27 rows=1 width=56) -> Index Scan using parametre_tracking_idx on parametre par (cost=0.00..2.02 rows=1 width=8) -> Index Scan using ae_tracking_idx on accord_editeur ae (cost=0.00..225.50 rows=60 width=48) EXPLAIN So, no change for the cost... Only for the number of pages... So, if I can't more optimize my index, what else should I try ? It uses too much CPU for me...