[GENERAL] Trigger to update table info

dated or deleted in item_master PLEASE NOTE : a new record must be created if the item_master is not present in postablestatus thanks in advance arvind

[GENERAL] Postgres 9.3 beta log

master (loginid,fullname,empid,passwd) values ( 'login88193', 'fullname88193', 'empid88193', 'passwd88193')",,,"" --- as you can see it is for a single record "login88193" it places PARSER STATISTICS PARSE ANALYSIS STATISTICS REWRITER STATISTICS I know it appers because i have enabled log_parser_* options in log But what i request to know is the meaning of these statistics and how usefull is can be for a server load evaluation thanking you greetings from india arvind

[GENERAL] new instance of postgres on windows

Hello and greetings, I want to install postgresql for use as the backend to a Windows application. This seems to be no problem if postgresql is NOT already installed on the system. which is not in this case. postgresql is already installed and unless the command line par

[GENERAL] error postgresql remote access windows 7

checklist will Help. regards arvind

Re: [GENERAL] PG Stats Collector

Collector From: michael.paqu...@gmail.com To: arvin...@hotmail.com CC: pgsql-general@postgresql.org For such things documentation is your best friend. Please see inline. On Sun, May 12, 2013 at 4:30 PM, Arvind Singh wrote: I need help in understanding the purpose of the following columns

[GENERAL] PG Stats Collector

les - idx_tup_fetch, n_tup_hot_upd, n_live_tup, n_dead_tup thank you, arvind

[GENERAL] postgresql-9.1.2 - Linux

seen this before ? Does storing the DATA on a NAS is a problem ? Any suggestions pointers much appreciated. Thanks! Arvind

[GENERAL] Update latest column in master table from transaction table

hello, i have two tables customer_master > cname > lastreceiptdate > lastreceiptamt accounts > cname > date > amount i need help in constructing a single update query. where the customer_master table is updated with the latest receipt date and receipt amount for a single customer code (cnam

Re: [GENERAL] Improve MMO Game Performance

difference between rows, but that may increase the number of selects. yours truly arvind > Date: Fri, 19 Oct 2012 13:54:02 +0200 > From: f...@meisterderspiele.de > To: arvin...@hotmail.com > Subject: Re: Improve MMO Game Performance > > Hello Arvind, > > i worked on M

Re: [GENERAL] Improve MMO Game Performance

t; > Albe Laurenz wrote: > > Arvind Singh wrote: > > > Are there any particular settings or methods available to improve Just > > insert_table operations > > > > The obvious ones: > > - Wrap several of them in a transaction. > > - Increase checkpo

Re: [GENERAL] Improve MMO Game Performance

ct: Re: [GENERAL] Improve MMO Game Performance > From: scott.marl...@gmail.com > To: arvin...@hotmail.com > CC: pgsql-general@postgresql.org; laurenz.a...@wien.gv.at > > On Sat, Oct 13, 2012 at 5:52 AM, Arvind Singh wrote: > > we are all aware of the popular trend of MMO gam

[GENERAL] Improve MMO Game Performance

around same number for spells or special items a total of 96 per tourament or 48000 record inserts per hour (500 players/hour) Are there any particular settings or methods available to improve Just insert_table operations thanks arvind

[GENERAL] Game Server Lags

kup tournament status in Table thanks arvind

[GENERAL] PG Log MultiLine Records

examples or :: is there a link or page explaining type of Log entries :: Number of log statements a logentry type occupy. :: or other finer details that we may overlook it will be helpfull as we wish to release this application for all pg users at no price. thanks arvind

Re: [GENERAL] application for postgres Log

uot;QUERY STATISTICS","! system usage stats: ! 0.00 elapsed 0.00 user 0.00 system sec ! [0.25 user 0.156250 sys total]","INSERT INTO pemdata.settings (""name"", ""setting"", ""unit"", ""server_

Re: [GENERAL] application for postgres Log

uploaded that Part of Log at http://dl.dropbox.com/u/71964910/pg_log_with_lot_of_session.zip arvind -- The woods are lovely, dark, and deep, But I have promises to keep, And miles to go before I sleep, And miles to go before I sleep. (Robert

Re: [GENERAL] application for postgres Log

log structure mentioned in documentation arvind > Subject: RE: [GENERAL] application for postgres Log > Date: Mon, 10 Sep 2012 09:31:29 +0200 > From: laurenz.a...@wien.gv.at > To: arvin...@hotmail.com; pgsql-general@postgresql.org > > Arvind Singh wrote: > > I a

[GENERAL] application for postgres Log

. thanks arvind

[GENERAL] More PG Log

x27;inet', '_inet', 'money', '_money', 'point', '_point', 'lseg', '_lseg', 'path', '_path', 'box', '_box', 'circle', '_circle', 'polygon', '_polygon', 'uuid&#

[GENERAL] PG Log

stats: ! 0.047000 elapsed 0.00 user 0.00 system sec ! [0.078125 user 0.031250 sys total]", ---- What do the number mean, it seems to appear only with a Logline for SQL statements thank you arvind

[GENERAL] pgcon 2012

thanking you yours truly arvind

Re: [GENERAL] Parsing PG log usings CSV format

ast column as of yet is unknown because at all occurances it is a empty > quoted column ? > the column numbers dont match with the generated log Is this is a different Log format , can you guide us to a page where the column specifications can be matched. Yrs truly arvind pal singh &

[GENERAL] Help in Parsing PG log usings CSV format

Help needed in parsing PostgreSQL CSV Log Hello friends, I am working an a section of application which needs to Parse CSV Logs generated by PostgreSql server. - The Logs are stored C:\Program Files\PostgreSQL\9.0\data\pg_log - The Server version in 9.0.4 - The application is developed in C Sharp

[GENERAL] question related to pg_stat_database

Hello pg_users, we have just migrated an application from mysql to postgresql we use csharp+npgsql to develo application I need to monitor Postgresql statistics at regular intervals. I came across pg_stat_database and especially the columns tulip_fetched and tup_returned. Is there anyt

[GENERAL] Locale problem

6,000.00'::money; ERROR: invalid input syntax for type money: "Rs.6,000.00" I want to know whether it is possible in postgres 8.3 and if yes where i went wrong? Thanks in advance, Arvind S "Many of lifes failure are people who did not realize how close they were to success when they gave up." -Thomas Edison

[GENERAL] Postgres physical directory structure meaning

e data from the base folder as sql queries, but many table content are missing. Pls tell what kind of data will be present in each folder, if possible sent the doc link. Arvind S

Re: [GENERAL] Postgres Host

most of the site provided there r not have postgres,.. i think its better to clear up the links in that page... As Craig told i am also interested in cloud.. have to check it up.. On Tue, Jan 26, 2010 at 6:51 PM, Thom Brown wrote: > 2010/1/26 S Arvind > > Hi Everyone, >> m

[GENERAL] Postgres Host

Hi Everyone, me and my friend wants a central db to do our development as we are in different location. Do any one know postgres service provider who is doing service which can help us? Arvind S

Re: [GENERAL] Session based transaction!!

Web application have single DB only.. On Fri, Dec 25, 2009 at 7:03 PM, Bill Moran wrote: > S Arvind wrote: > > > > Hi Everyone, > > > > In a web application running in Tomcat and Postgres 8.3 as DB, i need to > > know whether my given task is feasible

[GENERAL] Session based transaction!!

across request but it must be done across the session. By not destroying the connection and using it for all the work done by that session. when session destroy we can rollback the entire transaction Is there any other way to achieve the requirements in postgres. Thanks in advance.. Arvind S

Re: [GENERAL] About logging

ok thanks Magnus from saving my time in googling -Arvind S "Many of lifes failure are people who did not realize how close they were to success when they gave up." -Thomas Edison On Fri, Sep 25, 2009 at 12:39 AM, Magnus Hagander wrote: > On Thu, Sep 24, 2009 at 21:06, wro

[GENERAL] Data folder in differnet filesystem

advance Arvind S "Many of lifes failure are people who did not realize how close they were to success when they gave up." -Thomas Edison

[GENERAL] Table replication

Hi Members, Is there any way to sync a single table across the DBs. We need a single table alone to be equal in all DBs in the single postgres. Presenly we are doing this with the help of Update, insert, delete trigger. Is there any other best way for that. Arvind S

[GENERAL] ResultSet is FORWARD_ONLY.

org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.first(DelegatingResultSet.java:326) This statment worked in postgres 8.1 jdbc 3 driver but now its not.. Pleas help is solving this... -Arvind S

Re: [GENERAL] max execution time of query

Thanks Chris & kretschmer. But one small doubt in it,, What happens to update or insert query? - Arvind S * "Many of lifes failure are people who did not realize how close they were to success when they gave up." -Thomas Edison * On Fri, Jun 5, 2009 at 11:59 AM, Chris wrote: &g

[GENERAL] max execution time of query

exception on this event. Is it possible? -Arvind S * "Many of lifes failure are people who did not realize how close they were to success when they gave up." -Thomas Edison*

[GENERAL] Upgrading from postgres 8.1 to 8.3

Our 600GB data was currently loaded in postgres 8.1 , we want to upgrade from postgres 8.1 to 8.3 . Can we able to point the data directly or should we have to do any porting work for transfering data from 8.1 to 8.3. Arvind S * "Many of lifes failure are people who did not realize how

[GENERAL] From 8.1 to 8.3

Our company wants to move from 8,1 to 8.3 latest. In irc they told me to check realse notes for issues while upgrading. But there are lots of release notesss. Can anyone tell some most noticable change or place-of-error while upgrading? Arvind S * "Many of lifes failure are people who di

[GENERAL] Reg: Logging log_min_duration_statement

I set log_min_duration_statement to 1 and restart the postgres. But when i check the tail to log i am getting all queries. please tell is it bug ? i have log_statement = all . is there any relation between this and min_duaration? Arvind S * "Many of lifes failure are people who di

[GENERAL] Oracle Varray to Postgres conversion problem

Regards,Arvind Purohit==The Journey Of Thousand Miles Can Be Started With One Step In Right Direction.==