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: | Raw Message | Whole Thread | 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 |