[GENERAL] Trigger to update table info

Hello friends, I have a table with the following structure Create table postablestatus ( tablename varchar(30) NOT NULL, updatetime timestamp, reccount int, size int, CONSTRAINT postablestatus_pkey PRIMARY KEY(tablenam

[GENERAL] Postgres 9.3 beta log

Hello and namaste, I have installed the latest version an running tests on it. Since i analyze logs , i have found three new entries in log for each insert statement which isn't present in postgres 9.0 log --- 2013-08-10 11:59:27.031 IST,"postgres","aeppos",2780,"192.168.10.19:50935",5205dd5b.

[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

I have installed postgres server 9.3 on windows 7 network for the first time. The systems are connected on wifi network. Server in installed and working normal. configured pghba with host all all0.0.0.0/0md5 hostall all ::1/128

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

Hello and greetings, I need help in understanding the purpose of the following columns produced by PG stats collector in version 9.1 >From pg_stat_database - blks_read, blks_hit, _tup_returned, tup_fetched Reported In pg_stat_user_tables -

[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

the cyclic change idea is really marvellous , thank you but we store each round, because we need player actions for further analysis about game trends returnstrikeHP is a random number in range, that is calculated when a player strikes back. although as you write, we can calculate the diffe

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

we are all aware of the popular trend of MMO games. where players face each other live. My area of concern, is storage of player moves and game results. Using Csharp and PostgreSql The game client is browser based ASP.NET and calls Csharp functions for all database related processing To und

[GENERAL] Game Server Lags

we are all aware of the popular trend of MMO games. where players face each other live. My questions are focussed on reducing load on Game database or Sql queries a) How to control the surge of records into the GameProgress table. so that players get response quicker. The Server starts to lag

[GENERAL] PG Log MultiLine Records

we have been working on a CSV Log parser application in csharp. we recently discovered that certain log entries or records can span across multiple lines. in the sense, that the same activity has more detail in subsequent lines. For ex, a select,insert query has A query entry A Duration en

Re: [GENERAL] application for postgres Log

thanx Laurenz, But Our CSV Log contains lot of statements like the following THREE lines. They appear exactly one after the other. And they number in thousands for a Session (more than ten thousand) 2011-11-11 12:41:31.484 IST,"agent1","pem",524,"localhost:2141",4ebccaa2.20c,754,"idle"

Re: [GENERAL] application for postgres Log

Frost, Stopping by Woods on a Snowy Evening) > Subject: RE: [GENERAL] application for postgres Log > Date: Fri, 14 Sep 2012 13:16:33 +0200 > From: laurenz.a...@wien.gv.at > To: arvin...@hotmail.com; pgsql-general@postgresql.org > > Arvind Singh wrote: > > I have e

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

Hello and namaste I am in a project that uses PostGresSql v9.0. We are developing an application in CSharp to parse the PG server activity log installed on Windows 2003/XP or higher. Our application will : Scan the Log for a given search text and Post rows found Produce statistics related t

[GENERAL] More PG Log

x27;, '_uuid', 'xml', '_xml', 'interval', '_interval', 'date', '_date', 'time', '_time', 'timetz', '_timetz', 'timestamp', '_timestamp', 'abstime', '_abst

[GENERAL] PG Log

I have queries regarding columns in Postgres CSV Log. Following is a sample Logline 2012-03-28 19:25:47.968 IST,"postgres","stock_apals",2388,"localhost:1898",4f731863.954,6,"SET",2012-03-28 19:25:47 IST,2/0,0,LOG,0,

[GENERAL] pgcon 2012

Dear sir, we are recent users of Postgres and wish to be more aware and soak up the activities around the DB. we used to develop more on MySql , SQl Server combo Now we are using PG 9.0.5 , NPGSQL + Visual CSharp , Java Is http://www.pgcon.org/2012/?2nd a valid and certified Postgres Even

Re: [GENERAL] Parsing PG log usings CSV format

gt; Subject: RE: [GENERAL] Help in Parsing PG log usings CSV format > Date: Thu, 22 Mar 2012 16:47:11 +0100 > From: laurenz.a...@wien.gv.at > To: arvin...@hotmail.com; pgsql-general@postgresql.org > > Arvind Singh wrote: > > Help needed in parsing PostgreSQL CSV Log > >

[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