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 по дате отправления: