Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group