Re: [PERFORM] Configuration tips for very large database

On 02/13/2015 12:19 AM, Claudio Freire wrote: I have a table with ~800M rows, wide ones, that runs reporting queries quite efficiently (usually seconds). Of course, the queries don't traverse the whole table. That wouldn't be efficient. That's probably the key there, don't make you database proc

Re: [PERFORM] Reverse Key Index

Thanks for the immediate reply. I understand the use case is quite limited. On the other hand, I see potential when it comes to applications which use PostgreSQL. There, programmers would have to change a lot of code to tweak existing (and more importantly working) queries to hash/reverse an

Re: [PERFORM] Reverse Key Index

"Sven R. Kunze" writes: > does PostgreSQL support the concept of reverse key indexing as described > here? I couldn't find any documentation on this yet. > http://www.toadworld.com/platforms/oracle/w/wiki/11075.reverse-key-index-from-the-concept-to-internals.aspx There's nothing built-in for th

[PERFORM] Reverse Key Index

Hi, does PostgreSQL support the concept of reverse key indexing as described here? I couldn't find any documentation on this yet. http://www.toadworld.com/platforms/oracle/w/wiki/11075.reverse-key-index-from-the-concept-to-internals.aspx Regards, -- Sven R. Kunze TBZ-PARIV GmbH, Bernsdorfer