hash vs. sql lookup map speeds

This is a discussion on hash vs. sql lookup map speeds within the mailing.postfix.users forums, part of the Mail Servers and Related category; Hi, I've read several times that postfix-"native" index files are a lot faster than SQL lookups. ...


Go Back   Usenet Forums > Mail Servers and Related > mailing.postfix.users

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 05-30-2005
Sven Riedel
 
Posts: n/a
Default hash vs. sql lookup map speeds

Hi,

I've read several times that postfix-"native" index files are
a lot faster than SQL lookups. While I no problems believing
that statement for maps up to a certain number of entries (below
several thousand, say), I am a little curious if there is a
certain number of entries where the lookup speed is faster
in SQL than in the index files.

As a concrete scenario: Say you're using postfix as a=20
mail gateway to a set of domains that have tens of thousands
of valid email addresses. Would it still make sense to=20
keep these in postfix hash-tables or would MySQL/Postgres make
more sense then?

(As a disclaimer: I have no idea how postfix accesses/caches/re-reads
the index files).

Regs,
Sven
Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 07:53 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0