Known Bottlenecks

From: Vikul Khosla <vkhosla(at)gridsolv(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Known Bottlenecks
Date: 2009-10-19 13:43:06
Message-ID: 212577.97807.qm@web306.biz.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jeff, Robert, I am still working on the "low cardinality" info you requested. Please bear with me.

In the meantime, have the following question:

Are there known "scenarios" where certain types of SQL queries perform worse in PG
than they do in ORacle ?

For example, I have observed some discussion where MAX (In Oracle) was replaced with ORDER/DESC/LIMIT
in PG.

I realize this is a loaded question, but it would be great if any of you would share some observed
generalities in this context.

Thanks
VK

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-10-19 13:46:58 Re: Known Bottlenecks
Previous Message Joe Uhl 2009-10-19 10:58:15 Re: Performance with sorting and LIMIT on partitioned table