От: Jim C. Nasby
Тема: Re: PGSQL Capacity
Дата: ,
Msg-id: 20050510214024.GO31103@decibel.org
(см: обсуждение, исходный текст)
Ответ на: Re: PGSQL Capacity  ("Steinar H. Gunderson")
Список: pgsql-performance

Скрыть дерево обсуждения

PGSQL Capacity  (, )
 Re: PGSQL Capacity  (John A Meinel, )
 Re: PGSQL Capacity  ("Dave Held", )
 Re: PGSQL Capacity  ("Steinar H. Gunderson", )
  Re: PGSQL Capacity  ("Jim C. Nasby", )
 Re: PGSQL Capacity  (Chris Browne, )

http://stats.distributed.net has a table that's 130M rows.
http://stats.distributed.net/participant/phistory.php?project_id=8&id=39622
is a page that hits that table, and as you can see it's quite fast. This
is on a dual opteron with 4G of memory.

Unless you're looking for sub millisecond response times, 50k rows is
nothing.

On Mon, May 09, 2005 at 09:32:18PM +0200, Steinar H. Gunderson wrote:
> On Mon, May 09, 2005 at 09:22:40PM +0200,  wrote:
> > How can i know a capacity of a pg database ?
> > How many records my table can have ?
> > I saw in a message that someone have 50 000 records it's possible in a table ?
> > (My table have 8 string field (length 32 car)).
> > Thanks for your response.
>
> You can have several million records in a table easily -- I've done 10
> million personally, but you can find people doing that many records a _day_.
> Hitting 1 billion records should probably not be impossible either -- it all
> depends on your hardware, and perhaps more importantly, what kind of queries
> you're running against it. 50000 is absolutely no problem at all.
>
> /* Steinar */
> --
> Homepage: http://www.sesse.net/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

--
Jim C. Nasby, Database Consultant               
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"


В списке pgsql-performance по дате сообщения:

От: "Joshua D. Drake"
Дата:
Сообщение: Re: Partitioning / Clustering
От: Bruno Wolff III
Дата:
Сообщение: Re: Partitioning / Clustering