see
http://stackoverflow.com/questions/26237463/bad-optimization-planning-on-postgres-window-based-queries-partition-by-group
for details
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Bad-optimization-planning-on-Postgres-window-based-queries-partition-by-group-by-100
application break at any point
3. I decided to work with out OIDS because
1. It has a limit of -2147483648 to +2147483647
2 Due to this limitation I would not like to drop recreate my
database because it is a bit difficult/dirty process
All links and suggestion pertaining to OIDS are most welcome my
Hello Neil Conway,
We are doing some test on our applications and will let know the
community if without OIDS we could gain
more speed .
2. Though I have not written any code in my any of the pgsql functions
which depend on OIDS
1. Will without OIDS the functions behave
Merlin,
> Good, I'll give it a shot and see what I come up with...thx.
>
Do share your experience with us.
--
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
http://saihertz.com
---(end o
Dear all,
Have anyone compiled PostgreSQL with kernel 2.6.x
if YES
1. Was their any performance gains
Else
1. Is it possible
2. What problems would keeping us away from compiling on kernel 2.6
--
Best Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt