[Sqlgrey-users] Indexes

[Michel B. <mi...@bo...>]

I tried to figure out what kind of indexes could be useful in SQLgrey, an=
d I=20
found one that my PostgreSQL seems to like on from_awl:

=ABfrom_awl_sender_domain_host_ip=BB btree (sender_domain, host_ip)

For each time a new entry is to be added in from_awl, SQLgrey will look f=
or=20
the count(*) of addresses with the same domain and IP, to determine wheth=
er=20
this couple should be moved to domain_awl.

Without this index, PostgreSQL has to read the whole table sequentially, =
and=20
the from_awl is a tables that grows big...

Cheers.

--=20
Michel Bouissou <mi...@bo...> OpenPGP ID 0xDDE8AC6E