Re: [NOVICE] Hardware needed for 15,000,000 record DB?

From: <pdg(at)stratos(dot)net>
To: "Mathieu Arnold" <mat(at)mat(dot)cc>, <pgsql-novice(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [NOVICE] Hardware needed for 15,000,000 record DB?
Date: 2002-04-22 07:41:42
Message-ID: 027001c1e9d1$25af59d0$0a00000a@windowsbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-novice

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mathieu Arnold 2002-04-22 07:58:15 Re: [NOVICE] Hardware needed for 15,000,000 record DB?
Previous Message Mathieu Arnold 2002-04-22 06:29:57 Re: [NOVICE] Hardware needed for 15,000,000 record DB?

Browse pgsql-novice by date

  From Date Subject
Next Message Mathieu Arnold 2002-04-22 07:58:15 Re: [NOVICE] Hardware needed for 15,000,000 record DB?
Previous Message paul butler 2002-04-22 07:30:31 triggers