[PERFORM] Bad optimization/planning on Postgres window-based queries (partition by(, group by?)) - 1000x speedup

2014-10-07 Thread and
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

[PERFORM] Tables Without OIDS and its effect

2003-12-12 Thread Sai Hertz And Control Systems
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

Re: [PERFORM] Tables Without OIDS and its effect

2003-12-13 Thread Sai Hertz And Control Systems
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

Re: [PERFORM] postgresql amd-64

2004-11-05 Thread Vishal Kashyap @ [Sai Hertz And Control Systems]
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

[PERFORM] PostgreSQL and Kernel 2.6.x

2004-06-01 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
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