Re: slow INSERTS :(( - Mailing list pgsql-general

Varun Kacholia <varunk@cse.iitb.ac.in> writes:
> I have migrated from MySql to PostgreSQL and i find that inserts are
> extremly slow.

See the standard tips at
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/populate.html

>  Isnt the following query supported in postgresql (it is surely useful and
>  supported in MySQL )
>  CREATE INDEX t_index ON (NAME(20) , ID);

I can't see any particular value in that myself, but Postgres supports
a generic approach to weird indexing requirements: functional indexes.
See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/indexes-functional.html

            regards, tom lane