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 = 2900;
> NOTICE: QUERY PLAN:
>
> Index Scan using file_pkey on file (cost=0.00.
Hello, :-)
Can someone help me spec out the hardware needed for a simple web-based
database app?
Basically, that application needs to lookup a single row by its primary key.
This would be fairly straightforward, except that the table needs to contain
up to 15 million records. Each row will con
