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 f1ICtSx29493; Sun, 18 Feb 2001 07:55:28 -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 OAA09292; Sun, 18 Feb 2001 14:55:26 +0200 (EET) Received: from sappho.ics.forth.gr (sappho-lane.ics.forth.gr [139.91.157.50]) by ismene.ics.forth.gr (8.8.8/ICS-FORTH/V3) with ESMTP id OAA08691; Sun, 18 Feb 2001 14:52:59 +0200 (EET) Posted-Date: Sun, 18 Feb 2001 14:52:59 +0200 (EET) Organization: Received: from localhost (alexaki@localhost) by sappho.ics.forth.gr (8.9.3/ICS-FORTH/V8.2.2C-INTNULL) with ESMTP id OAA06295; Sun, 18 Feb 2001 14:52:50 +0200 (EET) X-Authentication-Warning: sappho.ics.forth.gr: alexaki owned process doing -bs Date: Sun, 18 Feb 2001 14:52:50 +0200 (EET) From: Alexaki Sofia To: pgsql-interfaces@postgresql.org cc: pgsql-sql@postgresql.org Subject: speed up creation of a table Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200102/117 X-Sequence-Number: 1074 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