On Tuesday, May 15, 2012 08:29:11 AM Віталій Тимчишин wrote:
2012/5/13 Robert Klemme shortcut...@googlemail.com
On Sun, May 13, 2012 at 10:12 AM, Віталій Тимчишин tiv...@gmail.com
wrote:
2012/5/11 Robert Klemme shortcut...@googlemail.com
On the contrary: what would be the
Hi,
On Tue, May 15, 2012 at 12:57 PM, Andres Freund and...@anarazel.de 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)
On Sun, May 13, 2012 at 9:01 AM, Craig James cja...@emolecules.com 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
2012/5/11 Robert Klemme shortcut...@googlemail.com
On Fri, May 11, 2012 at 12:50 PM, Vidhya Bondre meetvbon...@gmail.com
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
On Sun, May 13, 2012 at 10:12 AM, Віталій Тимчишин tiv...@gmail.com wrote:
2012/5/11 Robert Klemme shortcut...@googlemail.com
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 -
On Sun, May 13, 2012 at 1:12 AM, Віталій Тимчишин tiv...@gmail.com wrote:
2012/5/11 Robert Klemme shortcut...@googlemail.com
On Fri, May 11, 2012 at 12:50 PM, Vidhya Bondre meetvbon...@gmail.com
wrote:
Is there any max limit set on sequences that can be created on the
database
? Also
Hi All,
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.
Regards
Vidhya
On Fri, May 11, 2012 at 12:50 PM, Vidhya Bondre meetvbon...@gmail.com 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