Horton

Re: Large databases, performance

Manfred Koizar <mkoi-pg@aon.at>

View thread
From: Manfred Koizar <mkoi-pg@aon.at>
To: shridhar_daithankar@persistent.co.in
Cc: pgsql-hackers@postgresql.org, pgsql-general <pgsql-general@postgresql.org>, pgsql-performance@postgresql.org
Date: 2002-10-09T08:00:03Z
Lists: pgsql-hackers, pgsql-performance

Attachments

On Mon, 07 Oct 2002 15:07:29 +0530, "Shridhar Daithankar"
<shridhar_daithankar@persistent.co.in> wrote:
>Only worry is database size. Postgresql is 111GB v/s 87 GB for mysql.

Shridhar,

here is an implementation of a set of user types: char3, char4,
char10.  Put the attached files into a new directory contrib/fixchar,
make, make install, and run fixchar.sql through psql.  Then create
your table as
	CREATE TABLE tbl (
	type		int,
	esn		char10,
	min		char10,
	datetime	timestamp,
	opc0		char3,
	...
	rest		char4,
	field0		int,
	field1		char4,
	...
	)

This should save 76 bytes per heap tuple and 12 bytes per index tuple,
giving a database size of ~ 76 GB.  I'd be very interested how this
affects performance.

Code has been tested for v7.2, it crashes on v7.3 beta 1.  If this is
a problem, let me know.

Servus
 Manfred