Re: Patch to return last tid

"Arturo =?ISO-8859-1?Q?Jos=E8?= Montes Sinning" <mitosys(at)colomsat(dot)net(dot)co> writes:
> I am talking about select <select-list> from <table> where oid=<oid>
> When the table has thousands records this query is executed by Postgres
> as sequential scan.

Create an index on OID, if you want to use it to find rows quickly...

> The other problems come from insert. We are paying
> an extra cost when insert a row because oid sequence computation.

I've never seen any evidence that generating an OID is a significant
part of the time needed to do an INSERT (and yes, I've done profiling
of such things).

regards, tom lane