От: Praveen Raja
Тема: very large table
Дата: ,
Msg-id: 022801c565c4$6b1ac8c0$541510ac@sek.se
(см: обсуждение, исходный текст)
Ответы: Re: very large table  (Tom Lane)
Re: very large table  (Simon Riggs)
Список: pgsql-performance



I’m trying to move an existing solution from MySQL to PostgreSQL. As it is now the solution has 4 tables where data in inserted by an application. At regular intervals (10min) data from these tables is consolidated and moved to another table for reporting purposes. There exist many instances of these reporting tables and in total they are expected to hold about 500 million rows. There are about 200 of these reporting tables at the moment with data split among them. When a request comes in all these tables are searched. While moving to PostgreSQL is it a good idea to move from using multiple tables to one table for so many rows?

В списке pgsql-performance по дате сообщения:

От: Tom Lane
Сообщение: Re: slow queries, possibly disk io
От: Josh Close
Сообщение: Re: slow queries, possibly disk io