Re: PGSQL with high number of database rows?

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: PGSQL with high number of database rows?
Дата
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB201FF8302@EXADV1.host.magwien.gv.at
обсуждение исходный текст
Ответ на PGSQL with high number of database rows?  (Tim Perrett <hello@timperrett.com>)
Список pgsql-general
> I am possibly looking to use PSGSQL in a project I am working on for a
very
> large client. The upshot of this is the throughput of data will be
pretty
> massive, around 20,000 new rows in one of the tables per day.
> We also have tokeep this data online for a set period so after 5 or 6
weeks
> it could have nearly a million rows.
>
> Are there any implications with possibly doing this? will PG
> handle it?

What do you mean, massive? A mere 1000000 rows?
I don't think that a small database like this will be a worry.
Try to avoid unnecessary table scans by using indexes!

Yours,
Laurenz Albe

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

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: PGSQL with high number of database rows?
Следующее
От: Thorsten Kraus
Дата:
Сообщение: Re: Webappication and PostgreSQL login roles