Re: [PERFORM] Maximum number of sequences that can be created

2012-05-25 Thread Craig James
On Fri, May 25, 2012 at 4:58 AM, Greg Spiegelberg wrote: > On Sun, May 13, 2012 at 10:01 AM, Craig James wrote: > >> >> On Sun, May 13, 2012 at 1:12 AM, Віталій Тимчишин wrote: >> >>> >>> The sequences AFAIK are accounted as relations. Large list of relations >>> may slowdown different system util

Re: [PERFORM] Maximum number of sequences that can be created

2012-05-25 Thread Greg Spiegelberg
On Sun, May 13, 2012 at 10:01 AM, Craig James wrote: > > On Sun, May 13, 2012 at 1:12 AM, Віталій Тимчишин wrote: > >> >> The sequences AFAIK are accounted as relations. Large list of relations >> may slowdown different system utilities like vacuuming (or may not, depends >> on queries and indexe

Re: [PERFORM] Maximum number of sequences that can be created

2012-05-15 Thread Robert Klemme
Hi, On Tue, May 15, 2012 at 12:57 PM, Andres Freund wrote: > I would rather suggest going with a suming table if you need to do something > like that: > > sequence_id | value > 1 | 3434334 > 1 | 1 > 1 | -1 > 1 | 1 > 1 | 1 > ... > > You then can get the current value with SELECT SUM(value) WHERE

Re: [PERFORM] Maximum number of sequences that can be created

2012-05-15 Thread Andres Freund
On Tuesday, May 15, 2012 08:29:11 AM Віталій Тимчишин wrote: > 2012/5/13 Robert Klemme > > > On Sun, May 13, 2012 at 10:12 AM, Віталій Тимчишин > > > > wrote: > > > 2012/5/11 Robert Klemme > > > > > >> On the contrary: what would be the /advantage/ of being able to create > > >> millions of s

Re: [PERFORM] Maximum number of sequences that can be created

2012-05-14 Thread Віталій Тимчишин
2012/5/13 Robert Klemme > On Sun, May 13, 2012 at 10:12 AM, Віталій Тимчишин > wrote: > > 2012/5/11 Robert Klemme > > >> On the contrary: what would be the /advantage/ of being able to create > >> millions of sequences? What's the use case? > > > > We are using sequences as statistics counters

Re: [PERFORM] Maximum number of sequences that can be created

2012-05-14 Thread Jeff Janes
On Sun, May 13, 2012 at 9:01 AM, Craig James wrote: > > In my experience (PG 8.4.x), the system can handle in the neighborhood of > 100,000 relations pretty well.  Somewhere over 1,000,000 relations, the > system becomes unusable.  It's not that it stops working -- day-to-day > operations such as

Re: [PERFORM] Maximum number of sequences that can be created

2012-05-13 Thread Craig James
On Sun, May 13, 2012 at 1:12 AM, Віталій Тимчишин wrote: > > > 2012/5/11 Robert Klemme > >> On Fri, May 11, 2012 at 12:50 PM, Vidhya Bondre >> wrote: >> > Is there any max limit set on sequences that can be created on the >> database >> > ? Also would like to know if we create millions of seque

Re: [PERFORM] Maximum number of sequences that can be created

2012-05-13 Thread Robert Klemme
On Sun, May 13, 2012 at 10:12 AM, Віталій Тимчишин wrote: > 2012/5/11 Robert Klemme >> On the contrary: what would be the /advantage/ of being able to create >> millions of sequences?  What's the use case? > > We are using sequences as statistics counters - they produce almost no > performance i

Re: [PERFORM] Maximum number of sequences that can be created

2012-05-13 Thread Віталій Тимчишин
2012/5/11 Robert Klemme > On Fri, May 11, 2012 at 12:50 PM, Vidhya Bondre > wrote: > > Is there any max limit set on sequences that can be created on the > database > > ? Also would like to know if we create millions of sequences in a single > db > > what is the downside of it. > The sequences

Re: [PERFORM] Maximum number of sequences that can be created

2012-05-11 Thread Robert Klemme
On Fri, May 11, 2012 at 12:50 PM, Vidhya Bondre wrote: > Is there any max limit set on sequences that can be created on the database > ? Also would like to know if we create millions of sequences in a single db > what is the downside of it. On the contrary: what would be the /advantage/ of being