| From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
|---|---|
| To: | shridhar_daithankar(at)persistent(dot)co(dot)in |
| Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Large databases, performance |
| Date: | 2002-10-09 08:00:03 |
| Message-ID: | a2n7qu0qen2ne1chalomdgt5n1etgb4uk3@4ax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-performance pgsql-sql |
On Mon, 07 Oct 2002 15:07:29 +0530, "Shridhar Daithankar"
<shridhar_daithankar(at)persistent(dot)co(dot)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
| Attachment | Content-Type | Size |
|---|---|---|
| fixcharNN.sql.in | text/plain | 3.4 KB |
| Makefile | text/plain | 490 bytes |
| fixcharNN.c.in | text/plain | 1.4 KB |
| README.fixchar | text/plain | 2.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2002-10-09 08:07:13 | Re: Large databases, performance |
| Previous Message | Erwan DUROSELLE | 2002-10-09 07:30:37 | Rép. : Re: How to find out about index |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2002-10-09 08:07:13 | Re: Large databases, performance |
| Previous Message | Bruce Momjian | 2002-10-09 05:35:47 | Re: inline newNode() |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2002-10-09 08:07:13 | Re: Large databases, performance |
| Previous Message | Josh Berkus | 2002-10-09 05:22:37 | Re: What does this tell me? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2002-10-09 08:07:13 | Re: Large databases, performance |
| Previous Message | Josh Berkus | 2002-10-09 04:49:18 | Re: Temporary tables and indexes |