Re: Porting MSSQL to PGSQL (Was: [OT] MySQL is bad, but THIS bad?) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Porting MSSQL to PGSQL (Was: [OT] MySQL is bad, but THIS bad?)
Date
Msg-id 15889.1148339522@sss.pgh.pa.us
Whole thread Raw
In response to Re: Porting MSSQL to PGSQL (Was: [OT] MySQL is bad, but THIS bad?)  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Porting MSSQL to PGSQL (Was: [OT] MySQL is bad, but  (Andrew Dunstan <andrew@dunslane.net>)
Re: Porting MSSQL to PGSQL (Was: [OT] MySQL is bad, but THIS bad?)  (Thomas Hallgren <thomas@tada.se>)
List pgsql-hackers
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> If there was more information than the tuplestore could keep in memory,
> then a TIDstore might be faster, but only if it resulted in reading from
> the heap sequentially, or very near it.

That's easily arranged, use a bitmap indexing data structure.

I think we could probably even live with the structure becoming lossy
under memory pressure: AFAICS, all rows modified by a single query ought
to have the same XMIN/CMIN (or XMAX/CMAX for deleted rows), so it should
be possible to verify whether a particular row is one of the interesting
ones or not.

I think the hard part of this task is designing the API for access to
the rowsets from triggers.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: group by points
Next
From: Andrew Dunstan
Date:
Subject: Re: Porting MSSQL to PGSQL (Was: [OT] MySQL is bad, but