Re: [GENERAL] Memory consumption for Query

from Outlook<http://aka.ms/weboutlook> From: Albe Laurenz Sent: Monday, April 24, 2017 12:54 PM To: 'dhaval jaiswal *EXTERN*'; PostgreSQL General Subject: RE: Memory consumption for Query dhaval jaiswal wrote: > How to check how much memory quer

[GENERAL] Memory consumption for Query

How to check how much memory query is consuming. Is there tool can check of query consuming memory for the execution or output. Let's say for following query how to calculate memory consumption. select * from test where id=1; Sent from Outlook

[GENERAL] Alternate way of xpath

I have the following situation. PostgreSQL is not configured with the option --with-libxml Having one text column where i am trying to run the following command which is failing as expected its not configure with libxml. However, is there any alternate way through which i can achieve this.

Re: [GENERAL] pg_class (system) table increasing size.

--- 346 (1 row) Sent from Outlook<http://aka.ms/weboutlook> From: pgsql-general-ow...@postgresql.org on behalf of dhaval jaiswal Sent: Monday, November 21, 2016 11:04 PM To: Kevin Grittner; Alvaro Herrera Cc: Adrian Klaver; David G. Johnston; pgsql-g

Re: [GENERAL] pg_class (system) table increasing size.

can look into. Due to business impact auto vacuum is off. Sent from Outlook<http://aka.ms/weboutlook> From: Kevin Grittner Sent: Friday, November 18, 2016 3:49 AM To: Alvaro Herrera Cc: dhaval jaiswal; Adrian Klaver; David G. Johnston; pgsql-g

Re: [GENERAL] pg_class (system) table increasing size.

| 0 autovacuum_count| 0 analyze_count | 0 autoanalyze_count | 0 Yes, the size of pg_class table is of 5 GB. However, the existing row is only 2380 only. It's got fragmented. From: Adrian Klaver Sent: Thursday, November 17, 2016 8:29 PM To: dhaval

Re: [GENERAL] pg_class (system) table increasing size.

quires maintenance as well for the pg_class. It seems its affecting performance. From: David G. Johnston Sent: Thursday, November 17, 2016 8:13 AM To: dhaval jaiswal Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_class (system) table increasing size.

[GENERAL] pg_class (system) table increasing size.

PostgreSQL 9.4.0 Why pg_class table is getting bigger in size. How to stop increasing it. Does it affect the performance.

Re: [GENERAL] archive_cleanup_command recovery.conf Standby server error

Try to give the full path of pg_archivecleanup.exe e.g: archive_cleanup_command = '/usr/local/pgsql/bin/pg_archivecleanup %r' > Date: Wed, 29 Feb 2012 04:40:17 -0800 > From: chinna...@gmail.com > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] archive_cleanup_command recovery.conf S

Re: [GENERAL] Error while importing CSV file

Is this ERROR thrown for all the rows ? Try the following. select max(length(column_name)) from table_name; It seems that some value is bigger than the define size. > Date: Sun, 5 Feb 2012 21:14:40 -0800 > From: w_war...@hotmail.com > To: pgsql-general@postgresql.org > Subject: Re: [GENERA

[GENERAL] streaming replication vacuum

Might be discussed but not clear for the below query. In async. streaming replication do I need to run VACUUM & ANALYZE on both master & slave. Bec, while querying on master getting below result, but slave's system table is not updated. select last_vacuum, last_autovacuum, last_analyze, l

[GENERAL]

Might be discussed but not clear for the below query. In async. streaming replication do I need to run VACUUM & ANALYZE on both master & slave as to it is bit to bit replication. Bec, while querying on master getting below result, but slave's system table is not updated. select last_vacuum

Re: [GENERAL] how to use savepoint and rollback in function

create table mock (id int); begin; truncate table mock; insert into mock values (1),(2); savepoint A; insert into mock values (3),(4); savepoint B; rollback to savepoint A; end; Following link may help you. http://www.postgresql.org/docs/current/static/sql-rollback-to.html Date: Wed

[GENERAL] >>relation with OID 1211822032 does not exist

Hi All, We are getting following error on intermittent basis when we write data into database. We are on postgreSQL 8.0.2, with slony I. We used to stop the replication, taking back-up from the primary, restore it on secondary server and again start the replication again. We used to do above ac

Re: [GENERAL] Postgresql On Windows

>> postgres=# \i C:/dj1.sql; >> If there are space.  --   postgres=# \i  'C:/Program Files/PostgreSQL/8.3/bin/dj.sql';      Thanks & Regards Dhaval Jaiswal www.enterprisedb.com   From:

Re: [GENERAL] Determining PUBLIC's permissions

>> select a.relname, a.relowner, b.oid, b.rolname from pg_class a, pg_roles b >> where relname like '' and a.relowner=b.oid and relkind = 'r'; >> \dt+ -- Thanks & Regards Dhaval Jaiswal From: Roderick A. Anders

Re: [GENERAL] Installation Error, Server Won't Start

log_statement = none/ddl/mode/all  log_min_duration =     -->> to log query consumes more than set value -- Thanks & Regards Dhaval Jaiswal   From: Raymond O'Donnell To: ray Cc: pgsql-general@postgresql.org Sent: Friday, March 20, 2

Re: [GENERAL] how to specify the locale that psql uses

I had given reply abt windows   From: Shoaib Mir To: Dhaval Jaiswal Cc: Kent Tong ; pgsql-general@postgresql.org Sent: Friday, March 27, 2009 4:47:43 AM Subject: Re: [GENERAL] how to specify the locale that psql uses On Fri, Mar 27, 2009 at 9:35 AM

Re: [GENERAL] difference between current_timestamp and now() in quotes

e information refere the below link. http://www.postgresql.org/docs/8.1/static/sql-keywords-appendix.html -- Thanks & Regards Dhaval Jaiswal EnterpriseDB www.enterprisedb.com   From: Grzegorz Jaśkiewicz To: GENERAL Sent: Thursday, January 22, 2009

Re: [GENERAL] how to avoid that a postgres session eats up all the memory

r_id where you given appropriate condition. --- Thanks & Regards Dhaval Jaiswal EnterpriseDB www.enterprisedb.com   From: Clemens Schwaighofer To: pgsql-general@postgresql.org Sent: Thursday, January 22, 2009 2:21:47 PM Subject: [GENERAL] how to avoid that

Re: [GENERAL] how to specify the locale that psql uses

BASE name     [ [ WITH ] [ OWNER [=] dbowner ]    [ TEMPLATE [=] template ]    [ ENCODING [=] encoding ]    [ TABLESPACE [=] tablespace ]    [ CONNECTION LIMIT [=] connlimit ] ] -- Thanks & Regards, Dhaval Jaiswal EnterpriseDB www.ent