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: Pine.GSO.4.10.10102181411540.6140-100000@sappho.ics.forth.gr (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-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


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-2014 The PostgreSQL Global Development Group