pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alexaki Sofia <alexaki@ics.forth.gr>
To: pgsql-sql@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: improve  performance
Date: Mon, 15 Jan 2001 15:07:56 +0200 (EET)
Message-ID: <Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr> (raw)

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
 




view thread (5+ messages)  latest in thread

Message-ID: <Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr>
Permalink:  ../Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr/
Also on:    postgresql.org/message-id/Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: alexaki@ics.forth.gr, pgsql-interfaces@postgresql.org
  Subject: Re: improve  performance
  In-Reply-To: <Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr>
  References: <Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox