Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

s=0 loops=162974) Index Cond: (master_user_id = d.master_user_id) Filter: ((user_name)::text = 'rdoyleda'::text) Rows Removed by Filter: 1 Planning time: 3.155 ms Execution time: 392962.600 ms (25 rows) Thanks ravi -Original Me

Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

time=0.003..0.003 rows=0 loops=162974) Index Cond: (master_user_id = d.master_user_id) Filter: ((user_name)::text = 'rdoyleda'::text) Rows Removed by Filter: 1 Thanks ravi -Original Message- From: Chris Mair [mailto:ch...@1006.o

Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

ient_id = po.vip_patient_id) -> Index Scan using tblcnaccounts_pkey on tblcnaccounts a (cost=0.08..0.36 rows=1 width=4) Index Cond: (master_user_id = d.master_user_id) Filter: ((user_name)::text = 'rdoyleda'::text) (17 rows) Thanks ravi -Orig

Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

ient_id = po.vip_patient_id) -> Index Scan using tblcnaccounts_pkey on tblcnaccounts a (cost=0.08..0.36 rows=1 width=4) Index Cond: (master_user_id = d.master_user_id) Filter: ((user_name)::text = 'rdoyleda'::text) (17 rows) Thanks ravi From: M

[GENERAL] Queries are taking way longer in 9.6 than 9.5

Index Cond: (master_user_id = d.master_user_id) Filter: ((user_name)::text = 'dd'::text) (19 rows) Regards, ravi

Re: [GENERAL] questions about 2nd index on one column

t work. But looks like it will be worth the time. regards On Tue, Jan 3, 2017 at 12:09 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: On 01/03/2017 11:35 AM, Ravi Kapoor wrote: Please reply to list also. Ccing list. > Yes I am aware of django EOL. However, our company is still usin

[GENERAL] questions about 2nd index on one column

I have a bit strange question. I am trying to figure out how to avoid table locking while creating an index through Django (1.5.1) in Postgres 9.4.7 Django 1.5.1 does not support concurrent indexing. So my thought is to first create a concurrent index using SQL prompt. Then try to update django

Re: [GENERAL] PostgreSQL - The Best Overall Database

is there any details available on this poll ? thanks. On Thu, Aug 13, 2015 at 11:05 PM, Sachin Srivastava sachin.srivast...@cyient.com wrote: Congrats to all PostgreSQL DBA’s for this achievement.. HERE ARE THE WINNERS OF THE 2015 DBTA READERS' CHOICE AWARDS FOR BEST DATABASE (OVERALL):

[GENERAL] Synchronous replication and read consistency

Does sync replication guarantee that any inserted data on primary is immediately visible for read on standbys with no lag. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Synchronous replication and read consistency

Grittner kgri...@ymail.com wrote: Ravi Krishna sravikrish...@gmail.com wrote: As per this: http://www.postgresql.org/docs/current/static/warm-standby.html#SYNCHRONOUS-REPLICATION When requesting synchronous replication, each commit of a write transaction will wait until confirmation

Re: [GENERAL] Synchronous replication and read consistency

Chris/Joshua I would like to know more details. As per this: http://www.postgresql.org/docs/current/static/warm-standby.html#SYNCHRONOUS-REPLICATION When requesting synchronous replication, each commit of a write transaction will wait until confirmation is received that the commit has been

Re: [GENERAL] Postgresql BDR Replication Setup Issue

Hi Ian, Thank you so much for your help. After changing the hot_standby = on to hot_standby = off, everything is working fine. We have copied all parameters from current production environment. Thanks ravi -Original Message- From: Ian Barwick [mailto:i...@2ndquadrant.com] Sent

[GENERAL] Postgresql BDR Replication Setup Issue

, ravi The preceding e-mail message (including any attachments) contains information that may be confidential, be protected by the attorney-client or other applicable privileges, or constitute non-public information

Re: [GENERAL] alter column type

In the above case PG will simply do a dictionary update of meta tables. So all new rows will reflect col-T and as and when the old I will clarify it bit further: All new rows will have space allocated for col-T and no space allocated for col-S, while existing dormant rows are left unmodified .

Re: [GENERAL] alter column type

Why is PG even re-writing all rows when the data type is being changed from smaller (int) to larger (bigint) type, which automatically means existing data is safe. Like, changing from varchar(30) to varchar(50) should involve no rewrite of existing rows. -- Sent via pgsql-general mailing list

Re: [GENERAL] alter column type

On 6/5/2015 11:37 AM, Ravi Krishna wrote: Why is PG even re-writing all rows when the data type is being changed from smaller (int) to larger (bigint) type, which automatically means existing data is safe. Like, changing from varchar(30) to varchar(50) should involve no rewrite of existing

[GENERAL] Automatic Client routing

Are there any plans to introduce the concept of automatic client routing to the principal server in a cluster of N machines. For example, if there is a four node replication cluster N1 .. N4, at any time only one can be principal (the one which does the writing). In Oracle and DB2, client side

Re: [GENERAL] Partitioning and performance

By and large, though, this doesn't really matter, since an empty parent table won't cost anything much to scan. If it's significant relative to the child table access time then you probably didn't need partitioning in the first place. Is there a rule of thumb as to at what size does the

Re: [GENERAL] Partitioning and performance

On Thu, May 28, 2015 at 12:50 PM, Tom Lane t...@sss.pgh.pa.us wrote: Sure, because you don't have a constraint forbidding the parent from having a matching row, no? As suggested by you, I included a bogus condition in the parent table which will prevent any row addition in the parent table and

[GENERAL] Partitioning and performance

I am testing partitioning of a large table. I am INHERITING child tables. It is using a range partitioning based on a sequence col, which also acts as the primary key. For inserts I am using a trigger which will redirect insert to the right table based on the value of the primary key. Based on my

Re: [GENERAL] Partitioning and performance

Have you set up constraints on the partitions? The planner needs to know what is in the child tables so it can avoid scanning them. Yes. each child table is defined as follows CREATE TABLE TSTESTING.ACCOUNT_PART1 ( CHECK (ACCOUNT_ROW_INST BETWEEN 1001 and 271660)) INHERITS

Re: [GENERAL] Partitioning and performance

On Thu, May 28, 2015 at 12:42 PM, Melvin Davidson melvin6...@gmail.com wrote: Generally, when you partition, data should only be in child tables, and the parent table should be empty, otherwise you defeat the purpose of parttioning.` yes of course the parent table is empty. The trigger on

Re: [GENERAL] PG and undo logging

On Sat, May 23, 2015 at 10:12 PM, Scott Marlowe scott.marl...@gmail.com wrote: Ever run an insert with 1M rows, and roll it back in postgresql and compare that to oracle. Time the rollback in both. That should give you an idea of how differently the two dbs operate. A rollback in postgres is

[GENERAL] PG and undo logging

Is it true that PG does not log undo information, only redo. If true, then how does it bring a database back to consistent state during crash recovery. Just curious. thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] PG and undo logging

, Ravi Krishna sravikrish...@gmail.com wrote: Is it true that PG does not log undo information, only redo. If true, then how does it bring a database back to consistent state during crash recovery. Just curious. What does undo mean? David J. -- Sent via pgsql-general mailing list (pgsql

Re: [SQL] [GENERAL] Does PG support bulk operation in embedded C

:13 PM From:Joshua D. Drake j...@commandprompt.com To:Ravi Krishna srkris...@gmx.com, pgsql-...@postgresql.org Cc:pgsql-general@postgresql.org Subject:Re: [SQL] [GENERAL] Does PG support bulk operation in embedded C On 05/19/2015 04:47 PM, Ravi Krishna wrote: To explain pls refer to this for DB2

[GENERAL] Does PG support bulk operation in embedded C

To explain pls refer to this for DB2 http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0002329.html Essentially in one single sql call, we can do -- Add new rows -- Update a set of rows where each row is identified by a bookmark -- Delete a set of rows

[GENERAL] How to clear buffer

I am writing bench mark scripts and as part of it would like to clear the cache programmatically. This is to ensure that when we run select queries the data is not read read from the cache. Does PG provide any easy way to do it other than the obvious way to restart the database. Thanks. --

[GENERAL] Hash function constant in the Hash join algorithm

Hi, As part part of my project, I had to compare the time taken by the Hashjoin algorithm to that of Nested loop algorithm for the inner join and Natural join queries, under two cases. I used six tables to join each other each containing 5000 rows each approximately. The two cases are given

[GENERAL] Error in the connection to the server

Hi, I have installed postgresql-9.4.0 version. I have started the server from eclipse indigo version using Run configurations. There is a table in my database whose name is b. whenever I give a query which is related to this table I get the error *The connection to the server was lost.

[GENERAL] Policy.c program

Hi, I am using the postgresql-9.4.0 version. There is a program policy.c which is there in the previous versions. The following link shows the program. http://doxygen.postgresql.org/policy_8c.html But in the version 9.4.0, I cannot find it. I want to know whether this program being removed

[GENERAL] Relation name stored in Postgres

Hi, I want to know how the relation name is stored in postgres, In which part of the postgres source code could I find the relation name being stored. Thank you -- Regards, K.Ravikiran ᐧ

Re: [GENERAL] Relation name stored in Postgres

: Hi it is in system catalog - table pg_class, column relname Regards Pavel Stehule 2015-04-02 15:52 GMT+02:00 Ravi Kiran ravi.kolanp...@gmail.com: Hi, I want to know how the relation name is stored in postgres, In which part of the postgres source code could I find the relation name

Re: [GENERAL] Relation name stored in Postgres

Hi, Also, could you tell me during which stage(whether parser,optimizer or executor) does the table name gets stored, and if possible could you tell me which program specifically does that. ᐧ On Thu, Apr 2, 2015 at 7:56 PM, Ravi Kiran ravi.kolanp...@gmail.com wrote: Hi, Thank you Sir. Also

[GENERAL] hash function in Postgres

hi, I want to know what kind of hash function postgresql uses while joining. I was debugging through gdb, I found out that it is not using bob jenkins hash function but a different hash function *hash_uint32() and hash_any() *functions if the joining attribute is an integer, and a different kind

[GENERAL] Hash Function

Hi, I want to know what kind of hash function postgres is using currently, can someone please explain the algorithm postgres is using for the hash function in the hash join algorithm. Thanks, K.Ravikiran

[GENERAL] NODE

hi, I am going through the hashjoin algorithm in postgres. I find a function ExecHashjoin , which is called each time a new tuple is required by the hash join *Node.* could someone explain what exactly node mean in postgres. Thanks

[GENERAL] attaching a process in eclipse

hi, I am working with postgresql 9.4.0 source using eclipse(indigo version) in ubuntu 14.04. I am facing a problem of attaching a client process to postgresql server. I am following the steps given in this link

[GENERAL] mysql with postgres

hi all, Is postgres source code compatible with mysql database?? If it is, could someone could give me some links so that I can do that. I want to hack into the postgres source code, but as I am comfortable with mysql, I want to use the mysql database not postgres. any references would be

[GENERAL] debugging with gdb

Hi, I am facing some problem with gdb for the past few days. I want to debug nestloop.c in postgresql , so I followed the below steps. I followed the steps given in the below for collecting the stack trace.

[GENERAL] gdb debugging with postgres

command *psql test *where test is my database. But When I am running that script I am getting two client processes. ravi 13368 13366 0 15:14 ?00:00:00 postgres: checkpointer process ravi 13379 13366 0 15:14 ?00:00:00 postgres: ravi test [local] idle Could any one tell me

[GENERAL] debugging with gdb in postgres

hi, I am trying to learn how postgresql implements the join algorithms. So I am trying to learn about the source code of the executor precisely the file nodenestloop.c . In the executor file I have nodenestloop.o but no binary executor file. I am using helios eclipse to edit the source code.

[GENERAL] breakpoints in eclipse using postgresql

to file '/home/ravi/workspace/.metadata/.plugins/org.eclipse.core.resources/.safetable/org.eclipse.core.resources'. /home/ravi/workspace/.metadata/.plugins/org.eclipse.core.resources/.safetable/org.eclipse.core.resources (Permission denied)* So I started eclipse using sudo, but this time

[GENERAL] debugging with child process

hi, can any one help me with the 4th and 5th steps of the following link which is to debug with a child process in postgres. *https://wiki.postgresql.org/wiki/Working_with_Eclipse#Debugging_with_child_processes https://wiki.postgresql.org/wiki/Working_with_Eclipse#Debugging_with_child_processes*

[GENERAL] Executing nodenestloop.c

hi, I am using the environment Eclipse for the execution of the programs in the executor, whenever I give break points to specific program in eclipse , the control goes to main.c and finally the process never comes back to the actual program. Is there any way that the process be constrained only

[GENERAL] eclipse-gdb

hi, How do we debug specific functions in gdb of eclipse. Whenever I give break points in nodenestloop.c, it goes to main.c and finally the process ends there, The control never comes back to nodenestloop, how can we the proces constrained only to nodenestloop. Thank you

[GENERAL] eclipse-postgres

hi, How to compile and run the files the source code of postgres in eclipse, how to compile a c program in the backend directory of postgres?? I followed the steps in https://wiki.postgresql.org/wiki/Working_with_Eclipse , but when I build the program nodeNestloop.c in the backend directory, I

[GENERAL] Postgress Doubts

Hello, I am Ravikiran, pursuing my third year BITS Pilani, India, I am doing my thesis in postgress technology, The project is about implementing new join algorithms in postgres, Since I am new to postgress, could you help me in which part of source code of postgres should be looking in postgress

[GENERAL] Creating a role with read only privileges but user is allowed to change password

if this is possible. Thanks. Regards Ravi.

[GENERAL] Re: Creating a role with read only privileges but user is allowed to change password

I'm sorry, i forgot to mention my environemnt : Postgresql version 9.1 on Windows 7 (64 bit) and Debian Linux 6.x (64 bit) Thanks! Regards Ravi. On Sun, May 11, 2014 at 7:47 PM, Ravi Roy ravi.a...@gmail.com wrote: Hi Guys, I've created a role named MyRole in posgresql with the following

Re: [GENERAL] Creating a role with read only privileges but user is allowed to change password

error? As soon I try to change the password it give me the error : ERROR: Can not ALTER ROLE in a read only transaction. Thanks! Regards Ravi On Sun, May 11, 2014 at 8:52 PM, Melvin Davidson melvin6...@yahoo.comwrote: Ravi, First, it would be helpful if you indicated the O/S and version

Re: [GENERAL] Creating a role with read only privileges but user is allowed to change password

'myPassword' It first confirm the existing password which is fine and authorization is granted. As soon I try to change the password it give me the error : ERROR: Can not ALTER ROLE in a read only transaction. Thanks! Regards On Sun, May 11, 2014 at 9:06 PM, Ravi Roy ravi.a...@gmail.com wrote

Re: [GENERAL] Creating a role with read only privileges but user is allowed to change password

execute ALTER ROLE in a read-only transaction. Do not understand why. Thanks again. Regards, Ravi. On Sun, May 11, 2014 at 10:12 PM, Melvin Davidson melvin6...@yahoo.comwrote: Ravi, This works for me on Windows XP PostgresQL 9.2 psql -U postgres postgres postgres#: CREATE ROLE userguy

Re: [GENERAL] Creating a role with read only privileges but user is allowed to change password

Thanks a lot Tom, it worked by putting off the read only mode to off before changing the password and putting it on again. SET default_transaction_read_only = off; Worked for me.. Many thanks to you! Regards Ravi On Sun, May 11, 2014 at 10:26 PM, Tom Lane t...@sss.pgh.pa.us wrote: Ravi

[GENERAL] probable pg_hba.conf configuration issues

machine) it gives acess to database without password, i'm surprised as it does not seem to respect pg_hba.conf or i'm terribly wrong in the configuration somewhere. Does somebody have any idea what is wrong? Thank you Ravi.

Re: [GENERAL] probable pg_hba.conf configuration issues

Thanks Sim, Tom David, i'm really amazed with quick answers and insight provided by you all. I found and was a password cache issue under %APPDATA%\postgresql\pgpass.conf; I removed it and everything works as expected. Thank you again guys! Regards, Ravi. On Wed, May 7, 2014 at 8:22 PM, David

Re: [GENERAL] drop view with out cascading the dependents

That's true . it wont work if we add remove the columns. I wanted to add column to view and change the data type to existing column -Original Message- From: Grzegorz Jaśkiewicz [mailto:gryz...@gmail.com] Sent: Tuesday, October 19, 2010 7:50 PM To: Tom Lane Cc: Ravi Katkar; pgsql

[GENERAL] drop view with out cascading the dependents

cascading its dependents, after that I created the view it should have its dependents as to that of older one. Thanks in advance. Thanks, Ravi Katkar

[GENERAL] ODBC and configure

=localhost and xhost+localhost, again Severname=localhost and xhost+localhost nothing is working after re-compiling and running the .c file. Thanks, Ravi Katkar

[GENERAL] resultset metadata libpq

Hi List, I am using libpq c api to connect postgresql server. I wanted to retrieve the below metadata information for a column from resultset. Column name, ( PQfname ) type, (PQftype ) precision, ( ?) scale, (?) nullability(?) Thanks in advance Regards, Ravi Katkar

Re: [GENERAL] resultset metadata libpq

From: Ravi Katkar Sent: Tuesday, July 27, 2010 5:45 PM To: 'pgsql-general@postgresql.org'; 'pgsql-o...@postgresql.org' Subject: resultset metadata libpq Hi List, I am using libpq c api to connect postgresql server. I wanted to retrieve the below metadata

Re: [GENERAL] [ODBC] resultset metadata libpq

Hi, I had referred below link I could not able to locate or identify api to retrieve information like precision, scale, nullability. Thanks, Ravi Katkar -Original Message- From: willfurn...@googlemail.com [mailto:willfurn...@googlemail.com] On Behalf Of William Furnass Sent

[GENERAL] Unable to create a Postgre Datasource from windows With Database installed in RHEL 5.3

From: Ravi Katkar Sent: Thursday, July 15, 2010 2:45 PM Hi List , I have installed PostgreSQL server in RHEL 5.3. I can able to start the database and also able to work on the DB by creating tables etc. When I am trying to connect thru ODBC from windows

[GENERAL] Looking for a PostGre SQL Trainer, Bangalore

Hello, I am looking for a PostGre SQL trainer who can do a training program for a client of mine in Bangalore. If interested please send me a mail. Regards, Ravi 9686554646 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] disable password prompt - command line

of the options avail with PSQL. Thanks, Ravi Katkar

[GENERAL] Global temporary table - schema

or the schema I wish. Any ideas? Thanks in advance. -- Ravi Katkar

[GENERAL] disable password prompt - command line

of the options avail with PSQL. Thanks, Ravi Katkar

[GENERAL] Do ODBC - Posgresql supports refcursor?

guide or document on ODBC guide which can help. Thanks, Ravi Katkar

[GENERAL] handling out parameter

:= 10; vout := 10; perform adf(vout) ; RETURN; END; $BODY$ LANGUAGE 'plpgsql'; I have a couple of questions on above function 1) Why the return type is record after compiling? 2) How to catch the return value of out parameter for above case value of vVar. Thanks, Ravi Katkar

Re: [GENERAL] Transaction with in function

To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Transaction with in function In response to Ravi Katkar : I looking for solution for commit, rollback with in function. You can't use transactions within functions, use savepoints instead. http://www.postgresql.org/docs/current/static/sql

[GENERAL] Transaction with in function

'; Thanks in advance . Regards Ravi Katkar

[GENERAL] returning ref cursor

test_call line 7 at FETCH Thanks, Ravi Katkar

[GENERAL] How can I create a database at a different path and not accessible by others

Hi, I want to store confidential data. I created a user with createdb permission. How can I prevent others accessing tables created by this user? Regards, Rekha. -- Rekha Pai Senior Software Consultant

[GENERAL] pgsql exception.

Hi, while passing util list to Postgres stored procedure getting an exception saying *org.postgresql.util.PSQLException: Cannot cast an instance of java.util.ArrayList to type Types.ARRAY* can you help to resolve it? its urgent Method in Dao public void savePerson(Person person, ListAddress

[GENERAL] DELETE Weirdness

this; Are the contents of the IN query worked out ONCE per outer query and therefore become invalid when DELETE comes along and changes items that were part of the set ? (for e.g.) -ravi -- :wq -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] Need help in copying a table from one database to other

Hi, I want to copy a table say employeedetails from employee database to library database. Can you help me giving the detailed steps to do this. Thanks And Regards, Rekha. -- Rekha Pai Senior Software Consultant

[GENERAL] Multi Lingual problem

I am using the psqlodbc driver to connect to postgresql... But this is not supporting all the languages that UTF should support.. Database is of the correct encoding that is UTF... can you please give a solution so that i can psqlodbc supports multiple languages. Right now there is support for

[GENERAL] query evaluation

Hi all, I have the following query. select part_id, consume_part(part_id) from part where in_use = false; does it: a/ iterate over all parts, calling consume on them and then show the records where in_use is false (i.e. all parts have been consumed by the SP consume_part) or b/ filter

[GENERAL] Code Organisation

Hi, I realise this may be a subjective topic ; however: what does everyone think about grouping a set of functions together, by related it maybe that they call on each other but more so live in the same file on disk (before they get submitted) ... we are trying to use the output of pg_dump for

[GENERAL] using plpgsql debuggers

to then get the proxy to connect to it. Any help / suggestions much appreciated. -ravi

Re: [GENERAL] using plpgsql debuggers

. In the code comments it mentions that any client can be used (psql) ... I don't mind all the extra typing =) Any thoughts on how I may do this? I did have a brief look at the code inside pgadmin's debugger module - but it was a bit hard to figure out how it kicked the whole process off... -ravi

[GENERAL] Returning Cursor

only got the cursor name. We've been trying to access the values for the past one week. Can you please help me by sending me a sample code as to how to get the values in a recordset using this refcursor. Please do reply. This is very urgent. Thanks and regards Ravi Kiran L

[GENERAL] Fwd: Returning Cursor

only got the cursor name. We've been trying to access the values for the past one week. Can you please help me by sending me a sample code as to how to get the values in a recordset using this refcursor. Please do reply. This is very urgent. Thanks and regards Ravi Kiran L

[GENERAL] Fwd: Returning Cursor

only got the cursor name. We've been trying to access the values for the past one week. Can you please help me by sending me a sample code as to how to get the values in a recordset using this refcursor. Please do reply. This is very urgent. Thanks and regards Ravi Kiran L

[GENERAL] Web interface to update/change postgres data.

Hi: I want to create a simple web interface that lists table data, select entries to add/delete/change table data from a table in postgres database. Whatz the best and easiest way to do this? Wondering if there are any modules or code out there already. TIA Ravi

[GENERAL] Not able to install PostgreSQL in my machine

. Kindly help me to solve the installation problems earliest. Thanks - Ravi Kumar B V

[GENERAL] buffer manager

process in freelist. since i'm working on 8-03 and want to change my code as less as possible , is there any version where simple LRU is used with 8-0-3's vacum and BufferStrategyCDB stuff. regards ravi _ 1000s of Sexy Singles online now

[GENERAL] Transactions - Connections and Userrights

hi over there, how am i able to let a transaction exist among several connections, or is just one possible ? cause my phpskript cuts connection from db bevor reloading itself ofcourse :-) -how can i get information about the group which a user belongs to and its rights ? Thanx a lot Ravi