Projecting currentdb to more users

Поиск
Список
Период
Сортировка
От Yves Vindevogel
Тема Projecting currentdb to more users
Дата
Msg-id c6b1db0eb27fc3d0a67651c9c449c4a0@implements.be
обсуждение исходный текст
Ответы Re: Projecting currentdb to more users  (Matthew Nuzum <mattnuzum@gmail.com>)
Список pgsql-performance
Hi,


We have a couple of database that are identical (one for each
customer).

They are all relatively small, ranging from 100k records to 1m records.

There's only one main table with some smaller tables, a lot of indexes
and some functions.


I would like to make an estimation of the performance, the diskspace
and other related things,

when we have database of for instance 10 million records or 100
million records.


Is there any math to be done on that ?


Met vriendelijke groeten,

Bien à vous,

Kind regards,


<bold>Yves Vindevogel</bold>

<bold>Implements</bold>

<smaller>

</smaller>Hi,

We have a couple of database that are identical (one for each customer).
They are all relatively small, ranging from 100k records to 1m records.
There's only one main table with some smaller tables, a lot of indexes
and some functions.

I would like to make an estimation of the performance, the diskspace
and other related things,
when we have database of for instance 10 million records or 100 million
records.

Is there any math to be done on that ?

Met vriendelijke groeten,
Bien à vous,
Kind regards,

Yves Vindevogel
Implements

<smaller>


Mail: yves.vindevogel@implements.be  - Mobile: +32 (478) 80 82 91


Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76


Web: http://www.implements.be

<italic><x-tad-smaller>

First they ignore you.  Then they laugh at you.  Then they fight you.
Then you win.

Mahatma Ghandi.</x-tad-smaller></italic></smaller>


Mail: yves.vindevogel@implements.be  - Mobile: +32 (478) 80 82 91

Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76

Web: http://www.implements.be

First they ignore you.  Then they laugh at you.  Then they fight you.
Then you win.
Mahatma Ghandi.

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: join and query planner
Следующее
От: Ian Westmacott
Дата:
Сообщение: Re: cost-based vacuum