improve performance
От | Alexaki Sofia |
---|---|
Тема | improve performance |
Дата | |
Msg-id | Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr обсуждение исходный текст |
Ответы |
Re: [SQL] improve performance
Re: improve performance |
Список | pgsql-interfaces |
Hello, A) I am going to load a huge amount of data in the DBMS using JDBC and I want to reduce as much as possible the required loading time. Initially I loaded all data in one transaction. Subsequently, I increased the number of buffers and disabled fsync() (-o -F) and I loaded the data again but the performance was almost unchanged. Does it make sense?? How can I improve performance? To note that no indexes are created on the tables and that I load both "insert into" and "create table" statements. ------------------------------ B) I want to reduce the space (8 Kb) allocated by DBMS when more space is required to load the data in a table. I reduced the parameter BLCKSZ but the space allocated remains the same, that is 8 KB. How can the allocated space be reduced? If the space was reduced would loading time and query time increase? Thank you in advance for your help Sofia Alexaki
В списке pgsql-interfaces по дате отправления: