speed up creation of a table

From: Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr>
To: pgsql-interfaces(at)postgresql(dot)org
Cc: pgsql-sql(at)postgresql(dot)org
Subject: speed up creation of a table
Date: 2001-02-18 12:52:50
Message-ID: Pine.GSO.4.10.10102181411540.6140-100000@sappho.ics.forth.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-sql

Hello,

I have two questions concerning space and time required to
load huge volume of data in the DBMS.
To note I use JDBC interface to load the schema and data in the postgresql

In order to create the tables contained in my database
I use the command stmt.executeUpdate("CREATE TABLE t1 .... inherits
(t2));
is there any way to speed up the creation of a table in postgresql????

My application creates a lot of tables in which at the beginning are
stored
few records. I woule like to reduce the size DBMS allocates (8K) every
time needs more space? Can this be achieved without reducing BLCKSZ
parameter since I suspect that reducing BLCKSZ will reduce querying
performance. Is that so??

Is it possible to reduce DBMS size e.g. to 4K during loading and
set it back to 8K when querying?

Thank you in advance
Sofia Alexaki

Browse pgsql-interfaces by date

  From Date Subject
Next Message Cedar Cox 2001-02-18 15:03:23 passing values to a function
Previous Message Katsuyuki Tanaka 2001-02-18 04:27:47 IPC Shared Memory

Browse pgsql-sql by date

  From Date Subject
Next Message S Bey 2001-02-18 17:14:32 Trouble with CREATE FUNCTION
Previous Message John Taves 2001-02-18 07:39:07 Can a function return a record set?