improve performance

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

Responses

Browse pgsql-interfaces by date

  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

Browse pgsql-sql by date

  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