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.
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
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
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 2001-01-15 15:27:59|
|Subject: Re: [SQL] improve performance |
|Previous:||From: Dave Page||Date: 2001-01-15 10:05:15|
|Subject: pgAdmin v7.0.5 Released|
pgsql-sql by date
|Next:||From: Momo Mordacz||Date: 2001-01-15 13:32:35|
|Subject: www page - need a dbase? interested ?|
|Previous:||From: 571||Date: 2001-01-15 09:05:48|
|Subject: I want to know the Query in order to insert the sound file into the database|