[PERFORM] Maximum number of sequences that can be created

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

Re: [PERFORM] Vacuum problem due to temp tables

Robert, select ctid,xmin,xmax,* from pg_index gives 2074 records. Regards Vidhya On Wed, Mar 2, 2011 at 9:14 PM, Robert Haas wrote: > On Mon, Feb 28, 2011 at 12:08 AM, Bhakti Ghatkar > wrote: > > Tom, > > The query which you gave returns me 0 rows. > > select ctid,xmin,xmax,* from pg_index

Re: [PERFORM] Out of shared memory in postgres 8.4.2 and locks

On Tue, Mar 9, 2010 at 6:04 PM, Merlin Moncure wrote: > On Tue, Mar 9, 2010 at 4:38 AM, Vidhya Bondre > wrote: > > Hi All, > > > > We have installed postgres 8.4.2 on production. > > > > We have a parition table structure for one of the table. > > >

[PERFORM] Out of shared memory in postgres 8.4.2 and locks

Hi All, We have installed postgres 8.4.2 on production. We have a parition table structure for one of the table. when i am drop the master table we get the following error. drop table table_name cascade; WARNING: out of shared memory ERROR: out of shared memory HINT: You might need to increa

[PERFORM] slow query

Hi all, I need a very urgent help from you all in below case. I have a query SELECT amp.campaign_id, dam.allocation_map_id,amp.optimize_type, amp.optimize_by_days, amp.rate, amp.action_id,amp.actions_delta, amp.vearned_today, amp.creative_id, amp.channel_code,SUM(CASE dam.sqldatewhen 20070