Could you add to the TODO:

 support of binary data (eg varbinary type)

I think the above is not trivial, as I think the parser choques on \00 bytes
at several levels...

I had a check on the TODO and it seems that TOAST is not planned anymore for
7.1. Is it true?

Franck Martin
Database Development Officer
SOPAC South Pacific Applied Geoscience Commission
Fiji
E-mail: franck@sopac.org <mailto:franck@sopac.org> 
Web site: http://www.sopac.org/ <http://www.sopac.org/> 

This e-mail is intended for its recipients only. Do not forward this
e-mail without approval. The views expressed in this e-mail may not be
neccessarily the views of SOPAC.



-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Sent: Monday, October 16, 2000 9:45 AM
To: Jules Bean
Cc: Tom Lane; Alfred Perlstein; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Performance on inserts



Added to TODO:

* Prevent index lookups (or index entries using partial index) on most
  common values; instead use sequential scan 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 16 Oct 2000 11:09:15 +1200
Franck Martin <Franck@sopac.org>
RE: Performance on inserts
[ Charset ISO-8859-1 unsupported, converting... ]
> Could you add to the TODO:
> 
>  support of binary data (eg varbinary type)
> 
> I think the above is not trivial, as I think the parser choques on \00 bytes
> at several levels...

bytea type works for inserting null:  'a\\000b'.

> 
> I had a check on the TODO and it seems that TOAST is not planned anymore for
> 7.1. Is it true?

It is in 7.1.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Sun, 15 Oct 2000 19:24:36 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Performance on inserts