Received: from ext1.ics.forth.gr (mailgate.ics.forth.gr [139.91.1.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0FD8ap69011; Mon, 15 Jan 2001 08:08:37 -0500 (EST) (envelope-from alexaki@ics.forth.gr) Received: from ismene.ics.forth.gr (mailhost.ics.forth.gr [139.91.157.51]) by ext1.ics.forth.gr (8.9.3/ICS-FORTH/V8.2.5-GATE) with ESMTP id PAA04917; Mon, 15 Jan 2001 15:08:33 +0200 (EET) Received: from athena.ics.forth.gr (athena.ics.forth.gr [139.91.183.30]) by ismene.ics.forth.gr (8.8.8/ICS-FORTH/V3) with ESMTP id PAA13733; Mon, 15 Jan 2001 15:06:46 +0200 (EET) Posted-Date: Mon, 15 Jan 2001 15:06:46 +0200 (EET) Organization: Received: from localhost (alexaki@localhost) by athena.ics.forth.gr (8.9.3/ICS-FORTH/V8.2.2C-INTNULL) with ESMTP id PAA24704; Mon, 15 Jan 2001 15:07:56 +0200 (EET) X-Authentication-Warning: athena.ics.forth.gr: alexaki owned process doing -bs Date: Mon, 15 Jan 2001 15:07:56 +0200 (EET) From: Alexaki Sofia To: pgsql-sql@postgresql.org cc: pgsql-interfaces@postgresql.org Subject: improve performance Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200101/142 X-Sequence-Number: 756 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