Re: Performance - Mailing list pgsql-general

From Diego Schvartzman
Subject Re: Performance
Date
Msg-id 00d601bfc111$b475ff60$e80a0a0a@redfed8
Whole thread Raw
In response to Re: Performance  (Charles Tassell <ctassell@isn.net>)
Responses Re: Performance  (Lincoln Yeoh <lylyeoh@mecomb.com>)
List pgsql-general
Hi !
I destroyed my db and created again, 'vacuum' it and seems to be everything
ok.
Now I'm getting this (wich is much better than before). Thanks all !

explain select * from d_cue where clave = '9400001';
NOTICE:  QUERY PLAN:

Index Scan using d_cue_clave on d_cue  (cost=0.00..1.69 rows=1 width=544)



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL cleartext passwords
Next
From: Peter Eisentraut
Date:
Subject: Re: initdb and "exit_nicely"...