Thanks you very much Craig for clearing these facts and sorry for mail sent only to you by mistake.
-- Thanks & Regards, Amit Bondwal On Fri, Jul 17, 2015 at 6:19 PM, Craig Ringer <cr...@2ndquadrant.com> wrote: > On 17 July 2015 at 19:37, Amit Bondwal <bondwal.a...@gmail.com> wrote: > > Thank you very much all of you for quick response and clearing my mind. > > Please reply to the mailing list, not just to me directly. > > > One more question, can I run a databse of postgres 9.4 on postgres-XL > > cluster? > > postgres-XL is based on PostgreSQL 9.2, so no. > > Postgres-XL doesn't "run on" PostgreSQL. It's a modified (forked) > version of PostgreSQL. > > > Or you can advise me any better solution. > > Not without knowing a lot more about what you're trying to do, what > your requirements are, etc. > > > As per my knowledge partitioning > > of a table have some limits in nos. and I can't extend more storage in a > > server upto a limit. > > Yes, that's true, but those limits are quite large, and you may be > trying to solve a problem you don't and won't have. > > This may well be premature optimisation. I can't know without a lot more > info. > > Rather than starting with the solution (horizontal partitioning, > sharding) try starting with the problem and requirements, then looking > for solutions from there. > > -- > Craig Ringer http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services >
