From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexaki Sofia <alexaki@ics.forth.gr>
Cc: pgsql-sql@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [SQL] improve performance
Date: Mon, 15 Jan 2001 10:27:59 -0500
Message-ID: <25588.979572479@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr>
References: <Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr>
Alexaki Sofia <alexaki@ics.forth.gr> writes:
> Initially I loaded all data in one transaction. Subsequently, I increased
> the number of buffers and disabled fsync() (-o -F) and I loaded the
> data again but the performance was almost unchanged. Does it make sense??
> How can I improve performance? To note that no indexes are created on the
> tables and that I load both "insert into" and "create table" statements.
If you can load the data with a COPY command, instead of individual
INSERTs, it'll go a lot faster. See also
http://www.postgresql.org/devel-corner/docs/postgres/populate.htm> I want to reduce the space (8 Kb) allocated by
> DBMS when more space is required to load the data in a table. I reduced
> the parameter BLCKSZ but the space allocated remains the same, that is 8
> KB.
> How can the allocated space be reduced? If the space was reduced
> would loading time and query time increase?
I've heard lots of people want to increase BLCKSZ, but you're the first
one who ever wanted to reduce it. You sure you want to do this? It's
going to make the maximum row length uncomfortably short.
Anyway, you probably forgot to do a full rebuild after changing config.h.
"make clean" before "make all" is the only way to be sure the
configuration change propagates to all the code. Don't forget you will
have to do an initdb, also, so back up your data with the old code first.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, alexaki@ics.forth.gr, pgsql-sql@postgresql.org
Subject: Re: [SQL] improve performance
In-Reply-To: <25588.979572479@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox