Re: [NOVICE] Hardware needed for 15,000,000 record DB?
От | |
---|---|
Тема | Re: [NOVICE] Hardware needed for 15,000,000 record DB? |
Дата | |
Msg-id | 027001c1e9d1$25af59d0$0a00000a@windowsbox обсуждение исходный текст |
Ответ на | Re: [NOVICE] Hardware needed for 15,000,000 record DB? (Mathieu Arnold <mat@mat.cc>) |
Ответы |
Re: [NOVICE] Hardware needed for 15,000,000 record DB?
|
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: