Fragmenting tables in postgres

Поиск
Список
Период
Сортировка
От karthikg@yahoo.com (Karthik Guruswamy)
Тема Fragmenting tables in postgres
Дата
Msg-id 5cfe8c88.0109261656.1a432724@posting.google.com
обсуждение
Ответы Re: Fragmenting tables in postgres
Список pgsql-hackers
Hi,
Anyone tried fragmenting tables into multiple sub tables 
transparently through Postgres rewrite rules ? I'm having 
a table with 200,000 rows with varchar columns and noticed 
that updates,inserts take a lot longer time compared to a 
few rows in the same table. I have a lot of memory in my 
machine like 2Gig and 600,000 buffers. 

I really appreciate any pointers.

Karthik Guruswamy


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