Re: [GENERAL] Memory consumption for Query

Outlook<http://aka.ms/weboutlook> From: Albe Laurenz <laurenz.a...@wien.gv.at> 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 che

[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 <pgsql-general-ow...@postgresql.org> on behalf of dhaval jaiswal <dhava...@hotmail.com> Sent: Monday, November 21, 2016 11:04 PM To: Kevi

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 <kgri...@gmail.com> Sent: Friday, November 18, 2016 3:49 AM To: Alvaro Herrera Cc: dhaval jaiswal; Adrian Klaver; David

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

:29 PM To: dhaval jaiswal; David G. Johnston Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_class (system) table increasing size. On 11/16/2016 07:08 PM, dhaval jaiswal wrote: > >>> Because you are creating (specific) objects. > > I have gone through the link and how

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 <david.g.johns...@gmail.com> Sent: Thursday, November 17, 2016 8:13 AM To: dhaval jaiswal Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_c

[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 PATH %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

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: [GENERAL]

[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,

[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,

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:

[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

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

I had given reply abt windows   From: Shoaib Mir shoaib...@gmail.com To: Dhaval Jaiswal bablu_postg...@yahoo.com Cc: Kent Tong k...@cpttm.org.mo; pgsql-general@postgresql.org Sent: Friday, March 27, 2009 4:47:43 AM Subject: Re: [GENERAL] how to specify

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

log_statement = none/ddl/mode/all  log_min_duration = value    -- to log query consumes more than set value -- Thanks Regards Dhaval Jaiswal   From: Raymond O'Donnell r...@iol.ie To: ray ray.jos...@cdicorp.com Cc: pgsql-general@postgresql.org Sent

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 'table_name' and a.relowner=b.oid and relkind = 'r'; \dt+ -- Thanks Regards Dhaval Jaiswal From: Roderick A. Anderson raand...@cyber-office.net To: PostgreSQL

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: Raymond O'Donnell r...@iol.ie

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

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

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

appropriate condition. --- Thanks Regards Dhaval Jaiswal EnterpriseDB www.enterprisedb.com   From: Clemens Schwaighofer clemens.schwaigho...@tequila.jp To: pgsql-general@postgresql.org Sent: Thursday, January 22, 2009 2:21:47 PM Subject: [GENERAL] how

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

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 gryz...@gmail.com To: GENERAL pgsql-general@postgresql.org Sent: Thursday, January 22