Re: Maximum number of sequences that can be created

From: Robert Klemme <shortcutter(at)googlemail(dot)com>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Maximum number of sequences that can be created
Date: 2012-05-11 10:56:30
Message-ID: CAM9pMnMvNFhBkLj1gm93tkoOx6R3WB7jvU51pq-AdfjpN6Xd2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, May 11, 2012 at 12:50 PM, Vidhya Bondre <meetvbondre(at)gmail(dot)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 /advantage/ of being able to create
millions of sequences? What's the use case?

Cheers

robert

--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message MauMau 2012-05-11 13:19:21 Re: Could synchronous streaming replication really degrade the performance of the primary?
Previous Message Vidhya Bondre 2012-05-11 10:50:25 Maximum number of sequences that can be created