Hello,
> well, I have a server with a database over 7GB, and : > > backup=> select count(*) from file; > count > ---------- > 19430605 > (1 row) > > backup=> explain analyze select * from file where id_file = 29000000; > NOTICE: QUERY PLAN: > > Index Scan using file_pkey on file (cost=0.00..3.18 rows=1 width=117) > (actual time=0.60..0.61 rows=1 loops=1) > Total runtime: 0.77 msec > > and it's an old poor : > hda: IBM-DTLA-307030, ATA DISK drive > > ps: the select count(*) took a long time, but I believe that was because > there was a batch running and feeding the db :) Thanks for the information. Though, as a newbie, I am not quite sure what all the above performance numbers actually mean. :) What sort of CPU/Memory configuration are you running this server on? Thanks again, David ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
