Skip site navigation (1) Skip section navigation (2)

Re: [pgsql-performance] Large databases, performance

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: shridhar_daithankar(at)persistent(dot)co(dot)in,pgsql-hackers(at)postgresql(dot)org,pgsql-general <pgsql-general(at)postgresql(dot)org>,pgsql-performance(at)postgresql(dot)org
Subject: Re: [pgsql-performance] Large databases, performance
Date: 2002-10-09 18:09:03
Message-ID: hnf8quog5p54tf4tu0i12v00bc6bc9h0f2@4ax.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-performancepgsql-sql
On Wed, 09 Oct 2002 09:32:50 -0400, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
wrote:
>Coupla quick comments on these:

My first attempt on user types; thanks for the tips.

>These functions are dangerous as written, because they will crash on
>null inputs.  I'd suggest marking them strict in the function
>declarations.

I was not aware of this, just wondered why bpchar routines didn't
crash :-)  Fixed.

>Some attention to volatility declarations (isCachable
>or isImmutable) would be a good idea too.
>Also, it'd be faster and more portable to write the functions with
>version-1 calling conventions.

Done, too.  In the meantime I've found out why it crashed with 7.3:
INSERT INTO pg_opclass  is now obsolete, have to use  CREATE OPERATOR
CLASS ...

Servus
 Manfred

In response to

pgsql-performance by date

Next:From: Rich ScottDate: 2002-10-09 19:32:19
Subject:
Previous:From: Stephan SzaboDate: 2002-10-09 17:31:12
Subject: Re: [SQL] problem with the Index

pgsql-hackers by date

Next:From: Rod TaylorDate: 2002-10-09 18:13:26
Subject: Re: [GENERAL] Point in Time Recovery WAS: Hot Backup
Previous:From: Justin CliftDate: 2002-10-09 18:04:34
Subject: Re: [GENERAL] Point in Time Recovery WAS: Hot Backup

pgsql-sql by date

Next:From: Laurette CisnerosDate: 2002-10-09 23:16:23
Subject: Re: foreign key problem
Previous:From: Stephan SzaboDate: 2002-10-09 17:31:12
Subject: Re: [SQL] problem with the Index

pgsql-general by date

Next:From: Herbie LiechtiDate: 2002-10-09 18:16:31
Subject: Re: odbc with debian woody/postgres
Previous:From: Bruce MomjianDate: 2002-10-09 17:37:33
Subject: Re: MD5 Function?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group