PostgreSQL Database Forum

Is there any way in pgsql to measure that how much time a transaction has taken & how many disk accesses it has performed. ############################################# # Monu Agrawal # # Indian Institute of Science # # Bangalore # # E-25 # # 91-80-2932432 #...

Hi I'm upgrading the DB sever hardware and also the Linux OS. My Questions are: 1. What is the preferred FS to go with ? EXT3, Reiseref, JFS, XFS ? ( speed, efficiency ) 2. What is the most importent part in the Hardware ? fast HD, alot of mem, or maybe strong cpu ?

Is it possible to define a table that spans all db's in a cluster similar to pg_database, pg_users? Perhaps by altering relfilenode in pg_class of all db's to point to the same shared table... ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Is there any way to find out how much time & how many disk accesses a transaction has taken ? Make your own way. Monu Agrawal http://people.csa.iisc.ernet.in/monu Indian Institute of Science Bangalore (91)9844090061

Hello everybody, I am very new to PostgreSQL.We are planning to develop a Library Management Package developed on free development tools for a public library,which we want to install free of cost.Here in India there is not much awareness about Open Source. After some search on the net, I found this very helpful. I have very basic questions, 1)...

Is there a way to get a dump of all the DDL and data associated with a single schema within a database? What I tried in attempting to hack this out was \dt consume.* and \dv consume.*

Has anyone gotten GoldMine to use PostgreSQL for its database? I've come across a mysql reference at FrontRange's site...

Hi all, I have two databases set up, one for development and one for production. They are almost identical. I noticed that a query was taking about 6.7 seconds to execute on the development database, but only .08 seconds on the production database. The only difference was there was another key for the production server (I am guessing it...

Hi everyone, My performance on a big mission critical system has recently collapsed, and I've finally traced it down to the postgresql optimiser I think. I'm running postgresql-7.2.1-2PGDG The explains below make it clear I think. If I just change the table declaration order, I get MASSIVELY better performance. I thought the postgres...

Hi, I have two tables, Table A: item_id Table B: item_id, ref_code and i want to list all ref_codes in table B that are not referenced by Table A. Table A has about 3million records./ table B 200 What is the best way to do that ?

Hi, I face the following problem in transferring data from pgsql 7.3.4 to pgsql 7.4 RC1 . I am piping the output of pg_dumpall from 7.3 to 7.4 running on different port. The problem is there is a gist index on txtidx type on a non-public schema and when search_path does not include public the index cannot be created.

Whenever I create a temporary table, with something like CREATE TEMPORARY TABLE temptable1 AS SELECT * FROM paid.ad_hoc_query; New schemas appear, with names like "pg_temp_1". I guess the appearance of these schemas with "temp" in the name indicates that they are "temporary" schemas and related to the temporary table creation, but the...

Hi, I noticed that when using the single commandline: drop database <name>; create database <name>; this sometimes fails due to a pg_autovacuum process running on the background. When this happens, the error returned is:

Hi, I want to remove data that is older that a certain number of months.. only full months. example: today is 11-08 and I want do delete all data that is older than this month - 3 month i.e. i want to delete all information that is older than Aug. 1st. Is there an easy way to do that ? Interval cannot be used and I cannot just pass...

I'm trying to calculate the default values of a column when I insert a row, based on the values of other columns. It's something I thought should be simple enough, but I can't seem to figure out how to do it. Here's a basic example of what I'm trying to do: CREATE TABLE money ( amount numeric NOT NULL, currency text NOT NULL DEFAULT 'USD',...

Any idea why? (no clue I could glean from log file) Thanks bunches, Rob ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Hi all, Just thought I'd mention that I really think this problem needs to be fixed. I I'm patching the 7.4RC1 JDBC drivers as we speak due to this optimiser bug, and it's the third time I've had to do this. I would think this bug causes quite a lot of people to evaluate postgres and decide it has awful primary key performance! I love...

Apparently the Postgres lineage is sufficiently obfuscated to cause people to think that the correct pronunciation/shorthand of PostgreSQL is 'Postgre' and not 'Postgres'. Note the last line in the "What's New in this Version" paragraph: http://www.apple.com/downloads/macosx/unix_open_source/postgresql.html Perhaps all introductory...

Hi all, I have two databases set up, one for development and one for production. They are almost identical. I noticed that a query was taking about 6.7 seconds to execute on the development database, but only .08 seconds on the production database. The only difference was there was another key for the production server (I am guessing it...

Hi, profile_row profile_master%ROWTYPE; in a plpgsql function gives the error below tradein_clients=# SELECT general.create_accounts(); WARNING: plpgsql: ERROR during compile of create_accounts near line 8

Look at the NOTICE: siprebi=> SELECT max(tprestamo.cantmaxpres) FROM tprestamo t,usuarios u,personas p,objetos o, tipodoc td WHERE t.cateusuario = u.cateusuario AND u.persona = p.codigo AND p.docnum = 23622139 AND p.tdocu = td.codigo AND td.nombre = 1 AND t.cateobjeto = o.cateobjeto AND o.ninventario = 29 AND o.uacademi = 4;...

Hello, Can you please help me in understanding how constants are stored in postgresql. How is the datum data structure used for the same. Thanks Shalu ---------------------------(end of broadcast)---------------------------

For those who haven't heard yet, there is now a German "general" mailing list at postgresql.org Für alle, die es noch nicht gehört haben, es gibt jetzt eine deutsche Mailingliste für "allgemeine" Themen unter postgresql.org. Zum Eintragen, schreibt eine E-Mail mit "subscribe" im Text an pgsql-de-allgemein-request@postgresql.org. --...

Hi, This is the wrong mailing list but I don't sent it to pgsql-bugs with success. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Thank you for your help on the trigger question. The RULE worked for most of the cases I had for this, but I have one that is giving me trouble. Here are my table definitions: CREATE SEQUENCE "stat_id_seq" cache 1; CREATE TABLE "ref_status" ( "status_id" integer DEFAULT nextval('stat_id_seq') PRIMARY KEY, "short_name" varchar(5),...