Table partition for very large table

Поиск
Список
Период
Сортировка
I have table with more than 4 millions records and when I do select
query it gives me "out of memory" error.
Does postgres has feature like table partition to handle table with
very large records.
Just wondering what do you guys do to deal with very large table?


Thanks!

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Can't pg_dumpall, claims database exists twice
Следующее
От: "Janning Vygen"
Дата:
Сообщение: Re: pg_xlog disk full error, i need help