From: Manfred Koizar <mkoi-pg@aon.at>
To: shridhar_daithankar@persistent.co.in
Cc: pgsql-hackers@postgresql.org, pgsql-general <pgsql-general@postgresql.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Large databases, performance
Date: Mon, 07 Oct 2002 17:22:41 +0200
Message-ID: <cl83quoi1kt2ebcsbajm18iekkporrj9f5@4ax.com> (raw)
In-Reply-To: <3DA1E50F.4394.107FF85D@localhost>
References: <3DA1A331.21316.F7E742B@localhost>
<69v2qu4n8fdt5do8dids2a9m98p0q8bu9r@4ax.com>
<3DA1E50F.4394.107FF85D@localhost>
On Mon, 07 Oct 2002 19:48:31 +0530, "Shridhar Daithankar"
<shridhar_daithankar@persistent.co.in> wrote:
>I say if it's a char field, there should be no indicator of length as it's not
>required. Just store those many characters straight ahead..
This is out of reach for a quick hack ...
>Sure. But the server machine is not available this week. Some other project is
>using it. So the results won't be out unless at least a week from now.
:-)
>This time results are correct. Postgresql loads data faster, indexes it faster
>and queries in almost same time.. Way to go..
Great! And now let's work on making selects faster, too.
Servus
Manfred
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-sql@postgresql.org
Cc: mkoi-pg@aon.at, shridhar_daithankar@persistent.co.in, pgsql-general@postgresql.org, pgsql-performance@postgresql.org
Subject: Re: Large databases, performance
In-Reply-To: <cl83quoi1kt2ebcsbajm18iekkporrj9f5@4ax.com>
* 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