Table partition for very large table

Поиск
Список
Период
Сортировка
От Yudie Gunawan
Тема Table partition for very large table
Дата
Msg-id e460d0c0503280932cd9b3e3@mail.gmail.com
обсуждение исходный текст
Ответы Re: Table partition for very large table  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Table partition for very large table  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Table partition for very large table  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
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