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