Re: [GENERAL] Many thousands of partitions

2013-10-09 Thread Grzegorz Tańczyk
Hello, Thanks for sharing your experiences with the problem. W dniu 2013-10-09 00:47, "Gabriel E. Sánchez Martínez" pisze: Partioning seems to be a good idea if a single table would be too big to fit in your server's file cache, and also for management, since you can drop partitions of old dat

Re: [GENERAL] Many thousands of partitions

2013-10-08 Thread Gabriel E. Sánchez Martínez
On 10/08/2013 11:23 AM, Grzegorz Tańczyk wrote: Hello, I have question regarding one of caveats from docs: http://www.postgresql.org/docs/8.3/static/ddl-partitioning.html "Partitioning using these techniques will work well with up to perhaps a hundred partitions; don't try to use many thousan

Re: [GENERAL] Many thousands of partitions

2013-10-08 Thread bricklen
On Tue, Oct 8, 2013 at 8:23 AM, Grzegorz Tańczyk wrote: > Hello, > > I have question regarding one of caveats from docs: > http://www.postgresql.org/docs/8.3/static/ddl-partitioning.html > > If you are using Postgresql 8.3 then you should consider upgrading to 9.3 instead. > "Partitioning using

[GENERAL] Many thousands of partitions

2013-10-08 Thread Grzegorz Tańczyk
Hello, I have question regarding one of caveats from docs: http://www.postgresql.org/docs/8.3/static/ddl-partitioning.html "Partitioning using these techniques will work well with up to perhaps a hundred partitions; don't try to use many thousands of partitions." What's the alternative? Neste