[GENERAL] Backup and Restore mechanism in Postgres

gards, Vinita Bansal _ Special offer for NRIs! http://creative.mediaturf.net/creatives/citibankrca/rca_msntagofline.htm Get a zero balance account for next 20 years. From Citibank ---(end of broa

[GENERAL] generating statistics

following tables should contain this information: pg_stat_user_indexes, pg_stat_all_tables. But, these tables are not getting populated. Do I need to set something else to be able to get this information?? Regards, Vinita Bansal _ Get

[GENERAL] what's wrong with postgres 8

Postgres 8 driver I am getting an error java.sql.SQLException: ERROR: operator does not exist: smallint = boolean. FYI: I have runstats on all tables both for Postgres 7 and 8 after doing a restore. Regards, Vinita Bansal

[GENERAL] importance of bgwriter_percent

bgwriter_maxpages or there's a problem with the other settings and I need to change one of them?? What will be a good value of bgwriter_percent for such a big database (running 4 processes in parallel here which write to the database all at once and which is the major bottleneck in my case)? Regards, V

Re: [GENERAL] importance of bgwriter_percent

shared_buffers, checkpoint_segments etc). I am trying to change these parameters one by one and then see how things are getting affected. Regards, Vinita Bansal From: Scott Marlowe <[EMAIL PROTECTED]> To: vinita bansal <[EMAIL PROTECTED]> CC: pgsql-general@postgresql.org Subject:

[GENERAL] reorder table data

rows are getting accessed in a table for a particular run?? Regards, Vinita Bansal _ Find,Compare,Buy & Sell! http://adfarm.mediaplex.com/ad/ck/4686-26272-10936-265?ck=Register Do it all on eBay! ---(en

Re: [GENERAL] reorder table data

another schema when required. I want this to be handled at database level wherein everything in database itself is organised to make access faster. Regards, Vinita Bansal From: "Joshua D. Drake" <[EMAIL PROTECTED]> To: Richard Huxton CC: vinita bansal <[EMAIL PROTECTED]>

Re: [GENERAL] reorder table data

ince it is very complex and changing it will require lots of effort. Regards, Vinita From: Richard Huxton To: vinita bansal <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED], pgsql-general@postgresql.org Subject: Re: [GENERAL] reorder table data Date: Wed, 20 Apr 2005 11:03:19 +0100 vinita bansal wro

[GENERAL] RAMFS with Postgres

the fact that a failure like this happens very rarely. The most imp. thing for me is the **data** which should not be lost under any circumstances. Has anyone used Slony replication before. How good is it. Is there anything else available which is better then Slony Replication? Regards, Vinita

Re: [GENERAL] RAMFS with Postgres

d Slony is? How much time does it take to replicate database? If the time taken to replicate is much more then the perf. improvement we are getting by putting tables in memory, then there's no point in going in for such a solution. Do I have an alternative? Regards, Vinita Bansal From: M

[GENERAL] default index created for primary key

Hi, I want to turn off the default setting in postgres for index creation on primary key of a table. Is it possible and how? Regards Vinita _ Citibank Suvidha account at No Minimum Balance! http://creative.mediaturf.net/creatives/su

Re: [GENERAL] default index created for primary key

that there is already a primary key defined and would not allow to add this constraint since a table cannot have two primary keys?? Thanks, Vinita Bansal From: "Sander Steffann" <[EMAIL PROTECTED]> To: "'vinita bansal'" <[EMAIL PROTECTED]>,<[EMAIL PROTEC

[GENERAL] default index for primary key of a table

Hi, Postgres automatically creates index for Primary key of a table. I want to turn this off, so that the default index is not created for primary key. How can I do this?? Regards, Vinita Bansal

[GENERAL] error : syntax error at or near $1 for over select rows

T_LOWEST_DATE where tril_gid = vQuotaInstanceGID; end if; END LOOP; RETURN 0; END; ' LANGUAGE 'plpgsql'; I know the problem is that we cant use a variable name in a select query. But then how can I use this variable

[GENERAL] function in postgres

Hi, The function "CHAR in db2" returns a fixed length character string representation of an integer number.What is the corresponding function in Postgres? Regards, Vinita Bansal _ NRIs send 10 photos FREE to In

[GENERAL] function corresponging to over in db2

Hi, I have a query of the form "select min(tab1.a) over(partition by tab1.b tab2.a tab1.c) from . in db2. What will be the corresponding query for postgres. Does Postgres have a function which provides the same functionality?? Regards, Vinita B

[GENERAL] equivalent in postgres of over(partition) function in db2

col2, col3..) in postgres.What will be its equivalent in postgres?? Regards, Vinita Bansal _ Manage information better. Optimise your tasks. http://www.microsoft.com/india/office/experience/ Experience MS Offi

[GENERAL] update queries taking lot of time

ne suggest what all can be done to improve it. These queries are being executed from within a pl/pgsql function. Regards, Vinita Bansal _ Try the all-new MSN Search! Find exactly what you want. http://search.msn.co.in Get more valu

[GENERAL] postgres 8 settings

used with Postgres 7.4 gave me good results but they don't seem to work with Postgres 8.0. Am I missing out on something?? Regards, Vinita Bansal _ Click, Upload, Print. http://www.kodakexpress.co.in?soe=4956 Deliver in

Re: [GENERAL] postgres 8 settings

all settings, I am not too sure on why it should be a problem and how in any way it can affect me? Also can you clarify what max_fsm_pages,bg_writer actually is since it is not clear from the documentation. Won't turning bg_writer on affect my overall run. I am too bothered about that since I