> > I doubt everyone would like trading query speed for insert/update > > speed plus index size > > If he is scanning through the entire index, he could do a sequential > scan of the table, grab all the tid transaction status values, and use > those when viewing the index. No need to store/update the transaction > status in the index that way. Huh ? How ? It is how you do it now. Do you expect load several milion transaction statuses into memory, then scan index and lookup these values ? Missed I something ? devik
- [HACKERS] pgsql is 75 times faster with my new index scan devik
- Re: [HACKERS] pgsql is 75 times faster with my new i... Alfred Perlstein
- Re: [HACKERS] pgsql is 75 times faster with my new i... Hannu Krosing
- Re: [HACKERS] pgsql is 75 times faster with my n... Philip Warner
- Re: [HACKERS] pgsql is 75 times faster with ... devik
- [HACKERS] Deep Trouble Abe Asghar
- Re: [HACKERS] pgsql is 75 times faster with my n... Hiroshi Inoue
- Re: [HACKERS] pgsql is 75 times faster with my n... Bruce Momjian
- Re: [HACKERS] pgsql is 75 times faster with ... Devik
- Re: [HACKERS] pgsql is 75 times faster w... Bruce Momjian
- Re: [HACKERS] pgsql is 75 times fas... Hannu Krosing
- Re: [HACKERS] pgsql is 75 times... Devik
- Re: [HACKERS] pgsql is 75 times... Bruce Momjian
- RE: [HACKERS] pgsql is 75 times faster with my new i... Mikheev, Vadim
- RE: [HACKERS] pgsql is 75 times faster with my new i... Mikheev, Vadim
- RE: [HACKERS] pgsql is 75 times faster with my new i... Mikheev, Vadim