[ADMIN] Using Explain

Hi All, I was looking for extensive tutorial for Explain, Plan-reading. The postgres manual is not exhaustive enough. It would be great if somone has a link to some documentation which gives some more in depth information about EXPLAIN / Plan Reading Thanks Vishal ___

Re: [ADMIN] Using Explain

Vishal Arora написа: > > Hi All, > > I was looking for extensive tutorial for Explain, Plan-reading. The > postgres manual is not exhaustive enough. > > It would be great if somone has a link to some documentation which gives > some more in depth information about EXPLAIN / Plan Reading > http

Re: [ADMIN] Using Explain

From: "Milen A. Radev" <[EMAIL PROTECTED]> To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Using Explain Date: Wed, 25 Jul 2007 14:26:57 +0300 Vishal Arora написа: > > Hi All, > > I was looking for extensive tutorial for Explain, Plan-reading. The > postgres manual is not exhaustive

[ADMIN] Backup Scheduler...

Dear Ashish/Vishal, How are u .. Here i am fine... I need a help from u ... In Windows, I have created new postgresql server & installed pgAgent scheduler also..The pgAgent service is running, But when I try to schedule the backup job, it is not running. The script seems to be ok since I ex

[ADMIN] Searching in a string with index

Hi, When I search some words into a varchar column and this column has an index. Does Postgres use index?? The search is done this way: create table tb_gen_person ( pes_nro_doc numeric(14) not null, pes_name varchar(150) not null, constraint pk_person PRIMARY KEY(pes_nro_doc) ); create inde

Re: [ADMIN] Backup Scheduler...

Can you send your batch file pls. What is the time you are setting. Hope u r not doing the same thing as earlier. -- Vishal From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]> To: "Ashish Karalkar" <[EMAIL PROTECTED]>, Subject: [ADMIN] Backup Scheduler... Date: Wed, 25 Jul 2007 18:12:

[ADMIN] Localisation

Hi all! I have a postgresql sever running on RedHat EL 4.0 Update 2. the following locales applies to my database: lc_messages = 'fr_FR.UTF-8' # locale for system error message # strings lc_monetary = 'fr_FR.UTF-8'

[ADMIN] Running "create database" using dblink_exe and gets locked forever

The statement is perfectly legal. Danny Abraham CTM&D BU 972-52-4286-513 [EMAIL PROTECTED]

Re: [ADMIN] Searching in a string with index

Index will not be used if your string has "wild card" (%) in the beginning. It should be used, if you change your query to: select * from tb_gen_person where pes_name like 'albert%'; Igor -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alexander B. Sent

Re: [ADMIN] primary key and foreign key

--- Jessica Richard <[EMAIL PROTECTED]> wrote: > Just want to be very clear that: > > 1. adding a primary key will have an implicit index automatically on the > column(s). > > 2. Adding a foreign key will NOT have an index created automatically, it only > does the > referencing work. If an in

[ADMIN] primary key and foreign key

Just want to be very clear that: 1. adding a primary key will have an implicit index automatically on the column(s). 2. Adding a foreign key will NOT have an index created automatically, it only does the referencing work. If an index is needed on the F-key column, it has to be created, right?

Re: [ADMIN] Localisation

"Martial Elise KIBA" <[EMAIL PROTECTED]> writes: > I have a postgresql sever running on RedHat EL 4.0 Update 2. > ... > But postgresql steal respond in english, and TO_CHAR(date, 'Day, DD Month > ') return a date in english What PG version is this? Are you sure it was built with --enable-nls?

[ADMIN] granting acces to an external client

Hello! I'd like to ask you what line should be added in pg_hba.conf file in order to grant access to a user with ip 139.100.99.98 to a db named "myDB" with user "scott" with password "mikepwd"? After modifying this file is enough to issue pg_ctl reload or should I restart postgres? Thank you Wi

Re: [ADMIN] Using Explain

On Wed, 25 Jul 2007 12:38:31 + "Vishal Arora" <[EMAIL PROTECTED]> wrote: > > > > >From: "Milen A. Radev" <[EMAIL PROTECTED]> > >To: pgsql-admin@postgresql.org > >Subject: Re: [ADMIN] Using Explain > >Date: Wed, 25 Jul 2007 14:26:57 +0300 > > > >Vishal Arora написа: > > > > > > Hi All,

Re: [ADMIN] granting acces to an external client

Sorin N. Ciolofan написа: Hello! I'd like to ask you what line should be added in pg_hba.conf file in order to grant access to a user with ip 139.100.99.98 to a db named "myDB" with user "scott" with password "mikepwd"? After modifying this file is enough to issue pg_ctl reload or should I res

[ADMIN] PL/SQL dynamic update error

I have a table with informations that change every month, and I have to update the monthly data in a new column. To do that, I try to find out wich months are being trated and I perform an update in my table for every month. So what I'm trying to do is to change the month column for a fixed name,

Re: [ADMIN] Backup Scheduler...

Dear Visha/Ashish, My batch file is content of below script. @echo off "C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f D:\test\test1.sql -F p -C -d -D postgres @echo on I check the scheduler also.. That is also running ... Kindly give me the solution... Thanks & Regards Jaya