[PERFORM] performance of SELECT * much faster than SELECT with large offset

2014-10-02 Thread Marc Slemko
I ran into this oddity lately that goes against everything I thought I understood and was wondering if anyone had any insight. Version/env details at the end. The root of it is these query times: marcs=# select * from ccrimes offset 514 limit 1; [...data omitted...] (1 row) Time: 650.280 ms

Re: [PERFORM] Does PostgreSQL run with Oracle?

2004-10-15 Thread Marc Slemko
On Fri, 15 Oct 2004 11:54:44 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > My basic question to the community is "is PostgreSQL approximately as fast > as Oracle?" > > I don't want benchmarks, they're BS. I want a gut feel from this community > because I know many of you are in mixed shop