Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfacespgsql-sql

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
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
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

pgsql-interfaces by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group