| From: | Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr> | 
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org | 
| Cc: | pgsql-interfaces(at)postgresql(dot)org | 
| Subject: | improve performance | 
| Date: | 2001-01-15 13:07:56 | 
| Message-ID: | Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-interfaces pgsql-sql | 
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
 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-15 15:27:59 | Re: [SQL] improve performance | 
| Previous Message | Dave Page | 2001-01-15 10:05:15 | pgAdmin v7.0.5 Released | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Momo Mordacz | 2001-01-15 13:32:35 | www page - need a dbase? interested ? | 
| Previous Message | 571 | 2001-01-15 09:05:48 | I want to know the Query in order to insert the sound file into t he database |