[PERFORM] Vacuum problems with 9.1

Hi, We have been using the current version of postgres i.e. 9.1.4 with streaming replication on. While vacuuming we noticed that certain dead rows are not getting removed and following debug information is printed: "DETAIL: 12560 dead row versions cannot be removed yet." As per suggestion, we ma

[PERFORM] Error message in wal_log for Streaming replication

Hi All, We have been trying to implement the streaming replication on one of our test servers. We have set archive_xlogs to on. But on the standby server, when we start the database we get error the following errors: LOG: shutting down LOG: database system is shut down LOG: database system was

[PERFORM] Clean up of archived Xlogs in postgres-9.

Hi, Can any one of you suggest how the archived Xlogs can be cleaned in postgres-9. We want to use streaming replication and have set the "wal_level" to "hot_standby" and "archive_mode" to "on". Regards, Nimesh.

[PERFORM] Using unnest function on multi-dimensional array.

Hi, Can anybody highlight how to use unnest function from postgres 8.4 on multi-dimensional array? Below is the sample table structure: Table "public.multi_array_test" Column | Type | Modifiers -+--+--- id | integer | user_id | bigint[] | Sample data: 1

[PERFORM] Postgres connection status as BIND

Hi, When we do a ps U postgres command, we find some connection in BIND status: 10088 ?Ss 0:00 postgres: chk production xxx.xx.x.xx(48672) BIND 10090 ?Ss 0:00 postgres: chk production xxx.xx.x.xx(48674) BIND We are connecting to the database using pgpool for load balanci

Re: [PERFORM] Prepared statement does not exist

at 5:07 PM, Glyn Astill wrote: > > > > > --- On Thu, 19/3/09, Nimesh Satam wrote: > > > > We are receving the following error in the postgres > > database logs: > > > > 2009-03-19 02:14:20 PDT [2547]: [79-1] LOG: duration: > > 0.039 ms stateme

[PERFORM] Prepared statement does not exist

Hi, I am not sure if sending this to the right place. I did try to get the answer from pgpool mailing list but no luck . Would appreciate if someone can help here. We are receving the following error in the postgres database logs: 2009-03-19 02:14:20 PDT [2547]: [79-1] LOG: duration: 0.039 ms

[PERFORM] Sl_log_1 and sl_log_2 not getting truncated.

Hi, We have recently installed slony and tsrted replication on one of our test machines. When we start inserting data in to the replicated database, the replication is taking properly. Over a period of time the lag increases between the two database. Looking further we found that, sl_log_1 and sl

[PERFORM] insert and Update slow after implementing slony.

Hi, We are trying to implement slony as a replication tool for one of our database. The Insert and updates have increased by approximately double making some of our important script slow. The database in concern is a warehouse and we have added additional primary key to support slony by using def

[PERFORM] Out of memory for Select query.

All, While running a Select query we get the below error: ERROR: out of memory DETAIL: Failed on request of size 192. Postgres Conf details: shared_buffers = 256000 work_mem =15 max_stack_depth = 16384 max_fsm_pages = 40 version: 8.1.3 We are using 8gb of Primary memory for the server

Re: [PERFORM] Append Cost in query planners

, Heikki Linnakangas <[EMAIL PROTECTED]> wrote: > > Nimesh Satam wrote: > > Heikki, > > > > > > Thanks for your reply. Will try to do the changes and rivert back. I had > one > > more requirement for partitioning. > > > > I wanted to inherit

Re: [PERFORM] Append Cost in query planners

(cost=520.63..520.63 rows=28363 width=23) -> Seq Scan on rs (cost=0.00..520.63 rows=28363 width=23) -> Hash (cost=435.63..435.63 rows=24063 width=24) -> Seq Scan on radv (cost=0.00..435.63 rows=24063 width=24) (41 rows) Can you

[PERFORM] Append Cost in query planners

All, We are trying to implement partition on one tables on date basis. the overall cost and timming and cost of the query is increasing on the Append of the child table output. As shown below: *-> Append (cost=0.00..112217.92 rows=2752906 width=52) (actual time= 2454.207..20712.021 rows=2752905

Re: [PERFORM] pg_statistic doesnt contain details for specific table

, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Mon, Jun 11, 2007 at 02:28:32PM +0530, Nimesh Satam wrote: > We have already used analyze command on the table. > We have also ran the vacuum analyze command. > > But they are not helping. Is there any data in the table? What doe

Re: [PERFORM] pg_statistic doesnt contain details for specific table

Heikki, Thank you for replying. We have already used analyze command on the table. We have also ran the vacuum analyze command. But they are not helping. Thanks, Nimesh. On 6/11/07, Heikki Linnakangas <[EMAIL PROTECTED]> wrote: Nimesh Satam wrote: > While monitioring we not

[PERFORM] pg_statistic doesnt contain details for specific table

Hi, While monitioring we noticed that there are no details in the pg_statistics for a particular table. Can you let us know what might be the reason? Also what steps can be taken care for adding the statistics? Note: The queries which are running on this table are taken longer time then al the

[PERFORM] Warm - standby system.

Hi, I tried to create a standby system as per the steps mentioned in the following article http://archives.postgresql.org/sydpug/2006-10/msg1.php. Can anybody let me know the steps which are supposed to be followed to make the standby machine for read access? and how it should be one. Al

[PERFORM] Table not getting vaccumed.

Hi,     I am trying to vaccum one of the table using the following command:   VACUUM FULL ANALYZE VERBOSE table_name;       But for some reason the table vaccuming is not going ahead. Can you guys let me know what the problem is.   Regards, Nimesh.

Re: [PERFORM] [PATCHES] Template0 age is increasing speedily.

number is increasing pretty fast for template0.   Please let me know if this a problem.       Regards, Nimesh.   On 9/7/06, Chris Mair <[EMAIL PROTECTED]> wrote: On Thu, 2006-09-07 at 16:01 +0530, Nimesh Satam wrote:> I noticed that the age of  template0 is increasing very rapidly..Can >

[PERFORM] Template0 age is increasing speedily.

Hi!..   I noticed that the age of  template0 is increasing very rapidly..Can you please let me know how we can control this and what causes such problems.   We also noticed that the database slow downs heavily at a particular time..Can you suggest any tools which will help in diagnosing the ro