RE: Performance on inserts - Mailing list pgsql-hackers

From Franck Martin
Subject RE: Performance on inserts
Date
Msg-id F12ECEA0435AD211B5280008C7ACBC857FEEAF@BIGIRON
Whole thread Raw
In response to Performance on inserts  (Jules Bean <jules@jellybean.co.uk>)
List pgsql-hackers
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,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Performance on inserts
Next
From: Tom Lane
Date:
Subject: Re: Performance on inserts