Re: [ADMIN] Performance Issues

Thanks Bruno and Nathan for your responses. The integer column was a SMALLINT and for some reason, postgres doesn't do index lookup for smallint. When we changed the column from smallint to int, it is making lots of differences. Regards, Ravi -Original Message- From: Bruno Wolff I

Re: [ADMIN] Duplicate key ( reindex and vacuum full logs )

just for add informations on the problem: these are the logs received by the reindex and by vacuum full on that table ( before to delete the duplicated rows): = REINDEX === Start Reindex table ua_user_data_exp at Fri Sep 5 07:12:26 CEST 2003 ERROR: Cannot create unique index. Table conta

[ADMIN] How to use pgcrypto?

Hi. I've read some of the documentation on how to use use pgcrypto, but I still can't seem to get it working properly. All I want to do is encrypt a field (using the AES algorithm) before inserting into the table, and consequently decrypt that same field when I pull it out. Example (my table is

[ADMIN] Export to file

Hi, There is a way to export the result of a query into an external DBF or TXT table?   Thank you,     MAGO _  IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí

Re: [ADMIN] upgrade

probably, though do it on a test machine first as sometimes little issues can crop up. Robert Treat On Thu, 2003-09-04 at 08:06, Martins Zarins wrote: > Hekko, All! > > I'm planing to upgrade from 7.2.1 to 7.3.4. > Will pg_dumpall and pg_restore be sufficient for propper data migration? > > Mar

[ADMIN] enabling multibyte ...

okay, this falls under the "stupid question, but want to make sure that I'm right before doing it" category ... When we installed v7.2.4 on our server, multibyte wasn't compiled in ... does enabling multibyte require a dump/reload if only new databases are going to require it, and not existing on

Re: [ADMIN] upgrade

Martins Zarins writes: > I'm planing to upgrade from 7.2.1 to 7.3.4. > Will pg_dumpall and pg_restore be sufficient for propper data migration? If you use pg_dumpall, then you need to restore using psql; pg_restore won't do you any good. Also: save your configuration files, read the release note

Re: [ADMIN] enabling multibyte ...

Marc G. Fournier writes: > When we installed v7.2.4 on our server, multibyte wasn't compiled in ... > does enabling multibyte require a dump/reload if only new databases are > going to require it, and not existing ones? No need to dump/reload. You can even manually change the declared encoding o

[ADMIN]

Hi! I'm looking for someone to do some part time menial tasks in terms of database administration for us. Simple things like back up/restore, this sort of thing. If there is anyone interested, please let me know. Thank, Mickey ---(end of broadcast)--

[ADMIN] How to create schema-specific users?

I'm missing something.  How do I create a user that is just for a specific schema, and not a global user?  I see in the docs how to create schemas and users, but not a schema-specific user.   Thanks, Tom Gordon

[ADMIN] transaction-wraparound data loss

I run the following nightly using cron against my 7.3.3 databases: vacuumdb -a -f -z The other night, I got the following (db names have been changed to protect the innocent): Vacuuming db1 WARNING: Some databases have not been vacuumed in over 2 billion transactions. You may have already suffe

[ADMIN] Problem

Your name : KIRILL Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : AMD Athlon Operating System (example: Linux 2.0.26 ELF) : Windows 2000 PostgreSQL version (example: Postg

Re: [ADMIN] Slackware

Sidar Lopez wrote: Where can I get PostgreSQL for Slackware 9. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) You can download the source

Re: [ADMIN] Performance Issues

A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] ("Ravi T Ramachandra") wrote: > I recently setup postgres on a Linux box with 4GB Ram and 2.5 GHz > processor.   We have created a database with 1.5 million rows in a > table.  When we try to select rows from the table, it is taking > e

Re: [ADMIN] Are 50 million rows a problem for postgres ?

> Hi all, i work in a telco and i have huge ammount of data, (50 million) > but i see a lack of performance at huge tables with postgres, > are 50 million rows the "limit" of postgres ? (with a good performance) I have worked on a datawarehouse (postgresql 7.3) with a pretty standard star schema

[ADMIN] Report Generator Proposal

Hi all, each time that someone say: this query is slow, this query take forever, bla bla bla all our request are: 1) Which version are you running ? 2) May I see your table definition? 3) May I see you configuration file? 4) May I see the explain ? 5) ... sometimes a beginner is scared about

Re: [ADMIN] How to create schema-specific users?

"Tom Gordon" <[EMAIL PROTECTED]> wrote: > I'm missing something. How do I create a user that is just for a specific > schema, and not a global user? I see in the docs how to create schemas and > users, but not a schema-specific user. The only think that you can do is specify on your pg_hba.conf

Re: [ADMIN] transaction-wraparound data loss

"Brian E. Pangburn" <[EMAIL PROTECTED]> writes: > I run the following nightly using cron against my 7.3.3 databases: > vacuumdb -a -f -z > The other night, I got the following (db names have been changed to protect > the innocent): > WARNING: Some databases have not been vacuumed in over 2 billion

Re: [ADMIN] Conditional row grained replication with DBMirror

Hi, any news on applying the patches to dbmirror?? Thanx. On Sun, 10 Aug 2003, Bruce Momjian wrote: > > Sure, send the patches to the patches list and we will get them applied. > I am not sure if I can get them into 7.4. It depends if the dbmirror > author can review them. > >