Re: TB-sized databases

Поиск
Список
Период
Сортировка
От Pablo Alcaraz
Тема Re: TB-sized databases
Дата
Msg-id 474CA2FA.2020201@laotraesquina.com.ar
обсуждение исходный текст
Ответ на Re: TB-sized databases  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: TB-sized databases  (Matthew <matthew@flymine.org>)
Re: TB-sized databases  (Pablo Alcaraz <pabloa@laotraesquina.com.ar>)
Re: TB-sized databases  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-performance
Simon Riggs wrote:
> All of those responses have cooked up quite a few topics into one. Large
> databases might mean text warehouses, XML message stores, relational
> archives and fact-based business data warehouses.
>
> The main thing is that TB-sized databases are performance critical. So
> it all depends upon your workload really as to how well PostgreSQL, or
> another other RDBMS vendor can handle them.
>
>
> Anyway, my reason for replying to this thread is that I'm planning
> changes for PostgreSQL 8.4+ that will make allow us to get bigger and
> faster databases. If anybody has specific concerns then I'd like to hear
> them so I can consider those things in the planning stages
it would be nice to do something with selects so we can recover a rowset
on huge tables using a criteria with indexes without fall running a full
scan.

In my opinion, by definition, a huge database sooner or later will have
tables far bigger than RAM available (same for their indexes). I think
the queries need to be solved using indexes enough smart to be fast on disk.

Pablo

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: TB-sized databases
Следующее
От: cluster
Дата:
Сообщение: Re: Query only slow on first run