Problem With Postgres

Поиск
Список
Период
Сортировка
От Hitesh Kumar Gulati
Тема Problem With Postgres
Дата
Msg-id 36549AEE.18B@plasma.ernet.in
обсуждение исходный текст
Список pgsql-hackers
Please tell me ,
1.               Actually I have to store 2048 to 27584 short integers
into the one
field of  each record. The number of data is not fixed. Presently I am
storing them in a file and then importing that file into the database
and at the time of retrieval I am exporting that file from database. The
page size of postgres is 8K Bytes. So it is not better according to the
memory consumption.               The second option is array but the record or tuple size
in
postgres is limited to 8K. It is not sufficient to store 27584 data of
type short integers. So please tell me how can I store this much number
of data in a single record.
--              What are other suitable types for me. Please tell me.

2.Can we change page size of database.  
--                 Hitesh kumar Gulati                 E-mail-:hkg@plasma.ernet.in                Ph. (079)-2864023 (O)
              Engineer - SC                Institute For Plasma Research                Near Indira Bridge
 Bhat Gandhinagar(GUJARAT)
 


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

Предыдущее
От: Oleg Broytmann
Дата:
Сообщение: Re: [HACKERS] More on 6.4 on DEC Alpha + Digital Unix 4.0d + DEC C compiler
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] More on 6.4 on DEC Alpha + Digital Unix 4.0d + DEC C compiler