Re: what is the maximum number of rows in a table in postgresql 8.1

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: what is the maximum number of rows in a table in postgresql 8.1
Дата
Msg-id 20080325120101.GC6756@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: what is the maximum number of rows in a table in postgresql 8.1  ("sathiya psql" <sathiya.psql@gmail.com>)
Ответы Re: what is the maximum number of rows in a table in postgresql 8.1
Список pgsql-performance
Дерево обсуждения 
sathiya psql escribió:

> I have 1 GB RAM with Pentium Celeron.
> 50 lakh records and postgres performance is not good....
>
> It takes 30 sec for simple queries....

Shows us the explain analyze.  There is no problem with a large number
of records, as long as you're not expecting to process all of them all
the time.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: postgresql is slow with larger table even it is in RAM
Следующее
От: "sathiya psql"
Дата:
Сообщение: Re: what is the maximum number of rows in a table in postgresql 8.1