Re: [ADMIN] [PERFORM] Tables Without OIDS and its effect

2003-12-12 Thread Neil Conway
Sai Hertz And Control Systems <[EMAIL PROTECTED]> writes: > I have created my tables without OIDS now my doubts are : > 1. Will this speed up the data insertion process Slightly. It means that each inserted row will be 4 bytes smaller (on disk), which in turn means you can fit more tuples on a p

Re: [ADMIN] pg 7.4 on debian

2003-12-12 Thread Erwin Brandstetter
Hi NG! Getting *apt-get update* to work with the above mentioned package turned out to be tricky. What I supplied in my last posting was incorrect of course. The line in sources.list needs a distribution after the URI. Failed: deb ftp://ftp.postgresql.org/pub/binary/v7.4/debian/ main non-free

Re: [ADMIN] PostgreSQL features

2003-12-12 Thread Bruno Wolff III
On Thu, Dec 11, 2003 at 16:27:25 +0100, arnaud Betoule <[EMAIL PROTECTED]> wrote: > Hy, > I'm a newbie and i'm looking for several informations of PostgreSQL to help me for > the choice of my next > database. > - What's the number max of keys ? By default the limit is 32 keys on a single mult

Re: [ADMIN] pg 7.4 on debian

2003-12-12 Thread Erwin Brandstetter
[EMAIL PROTECTED] (Oliver Elphick) wrote: > Peter Eisentraut has copied the binary packages to: > ftp://ftp.postgresql.org/pub/binary/v7.4/debian/ > > These are the md5sums of the woody release of 7.4: (...) Thank you for making it availiable again, Peter and Oliver! I assume the correct line for

[ADMIN] PostgreSQL features

2003-12-12 Thread arnaud Betoule
Hy, I'm a newbie and i'm looking for several informations of PostgreSQL to help me for the choice of my next database. - What's the number max of keys ? - Is thre a max lenght for the name of database, table, index, column ? - Is it possible to make partions of a table ?and how ? Thank's E-mail,

Re: [ADMIN] Help---- Urgent

2003-12-12 Thread Contact
Create a new column alter add column varchar(25); Then copy the old column into the new column: update set = ; Drop the last column: alter drop column ; Rename the column: alter rename column to ; Take care for INDEXES if there are any. This should do it. Best regards. - Origin

Re: [ADMIN] ODBC Driver generates a too big "windows swap file" and

2003-12-12 Thread scott.marlowe
On Fri, 12 Dec 2003, Rhaoni Chiu Pereira wrote: Hi, is there a switch in your pgsql/odbc connector to enable cursors? If so, try turning that on. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Reindex database

2003-12-12 Thread scott.marlowe
On Fri, 12 Dec 2003, Greg Spiegelberg wrote: > Any rule of thumb for REINDEX DATABASE? Once per month? > Per x transactions? You shouldn't need to reindex databases for the most part. If there's lots of catalog updates / delete, it might be occasionally useful to down the database and reindex

[ADMIN] Tables Without OIDS and its effect

2003-12-12 Thread Sai Hertz And Control Systems
Dear all , I have created my tables without OIDS now my doubts are : 1. Will this speed up the data insertion process 2. Though I have not written any code in my any of the pgsql functions which depend on OIDS 1. Will without OIDS the functions behave internally differently 2. Will my applica

[ADMIN] Tables Without OIDS and its effect

2003-12-12 Thread Sai Hertz And Control Systems
Dear all , I have created my tables without OIDS now my doubts are : 1. Will this speed up the data insertion process 2. Though I have not written any code in my any of the pgsql functions which depend on OIDS 1. Will without OIDS the functions behave internally differently 2. Will my appli

Re: [ADMIN] pg_dump failed

2003-12-12 Thread Tom Lane
Milan Krajnak <[EMAIL PROTECTED]> writes: > psql# \d > getTables(): SELECT failed. Explanation from backend: 'pqReadData() -- > backend > closed the channel unexpectedly. Standard questions: what shows up in the postmaster's log (stderr or syslog depending on your setup) when this happens? Is t

[ADMIN] Reindex database

2003-12-12 Thread Greg Spiegelberg
Any rule of thumb for REINDEX DATABASE? Once per month? Per x transactions? -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: [EMAIL PROTECTED] Cranel. Technology. Integrity. Focus. ---(end of br

[ADMIN] ODBC Driver generates a too big "windows swap file" and it's too slow

2003-12-12 Thread Rhaoni Chiu Pereira
Hi List, First of all, I tried to subcribe the ODBC list but it seems that the subscription's link is broken ! So here it goes: I have a delphi software use ttable components that converts dbf information to PostgreSQL an Oracle Databases. My problem is that PostgreSQL is too slow, t

[ADMIN] pg_dump failed

2003-12-12 Thread Milan Krajnak
hello, i've got the following problem: OS - Solaris 8/9 on Sun SPARC PGSQL 7.1.3 when i try to dump the database with pg_dump command i've got the following error: -- last builtin oid is 18539 -- reading user-defined types -- reading user-defined functions -- reading user-defined aggregates

[ADMIN] How to disconnect a user?

2003-12-12 Thread Olivier Hubaut
I'm wondering how to cleanly disconnect a user from the DB. For the moment, the only way I found is to kill the pid of the user but I found it quite ugly. -- Ci-git une signature avortee. ** RIP ** ---(end of broadcast)--- TIP 9: the planner will i