RE: Performance on inserts
От | Franck Martin |
---|---|
Тема | RE: Performance on inserts |
Дата | |
Msg-id | F12ECEA0435AD211B5280008C7ACBC857FEEAF@BIGIRON обсуждение исходный текст |
Ответ на | Performance on inserts (Jules Bean <jules@jellybean.co.uk>) |
Список | 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 по дате отправления: