[GENERAL] Postgres not using shared memory

Hi, I can't seem to get postgresql to use shared memory and performance is terrrible. PostgreSQL 7.4.6 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-42) $ uname -a Linux artsdata 2.4.21-20.0.1.ELsmp #1 SMP Wed Nov 24 20:34:01 EST 2004 i686 i686 i386

[GENERAL] Reusable database design

Hi. I can't be the first to think about this. There is a million online shops out there, which all more or less have the same database design. Has anybody thought about creating generic reusable/customizable designs for such cases? Thx, Joachim -- ... ein Geschlecht erfinderischer Zwerge, die

[GENERAL] Create AS question

Hello everyone: If I excute the following: CREATE table Test_backup as SELECT * FROM Test_Scores; it creates my table without the original table's constraints or triggers. Is there a way to preserve them in the copy? Thanks. Bob Powell Database Administrator

Re: [GENERAL] When to encrypt

Daniel Martini [EMAIL PROTECTED] writes: Well, where do you plan to keep the key for your encrypted backup tapes, like you suggested in another post in this thread ;-) That's pretty much the same problem. No it's not. I can keep the key for the encrypted backup tapes in my pocket. I won't

Re: [GENERAL] Performance tuning on RedHat Enterprise Linux 3

On Tue, 07 Dec 2004 07:50:44 -0500, P.J. Josh Rovero [EMAIL PROTECTED] wrote: There are many reports of kernel problems with memory allocation (too agressive) and swap issues with RHEL 3.0 on both RAID and non-RAID systems. I hope folks have worked through all those issues before blaming

[GENERAL] Shared disk

Hi, I would like to use shared disk for two Postgresql database. I mean that two Postgresql Database point to same $PGDATA directory. Is this possible in Postgresql Clarification is appreciated. Thx

[GENERAL] signal 4 recieved when index creation

hi! I am testing postgreSQL 8.0 rc1 compiled with xlc on AIX5.2. I'm trying to create an index on a 4 500 000 raws table and postmaster recieves signal 4. what can I do to resolve it? Thanks Frédéric Germaneau ---(end of broadcast)--- TIP 1:

Re: [GENERAL] vacuum problem?

On Tuesday December 7 2004 5:58, marcelo Cortez wrote: /psql someDatabase vaccum full verbose; but nothing informs. in which cases vacuum do not inform anything? postgresql 7.4 on red hat 9.0 any clue be appreciate. best regards Is your server logging to a file? What

[GENERAL] Sheduler in Postgres

Hi, I should schedule the execution of several stored procedures. Now I use an NT service for this, but as far as I know e.g. the Oracle has such a thing. It would be great if I could fire procedures on a timer basis. Is there a better solution for this than mine? Many thanks, -- Csaba ---

Re: [GENERAL] vacuum problem?

On Tuesday December 7 2004 6:27, Ed L. wrote: On Tuesday December 7 2004 5:58, marcelo Cortez wrote: /psql someDatabase vaccum full verbose; but nothing informs. in which cases vacuum do not inform anything? postgresql 7.4 on red hat 9.0 any clue be appreciate. best

Re: [GENERAL] Postgres not using shared memory

Karl O. Pinc [EMAIL PROTECTED] writes: Hi, I can't seem to get postgresql to use shared memory and performance is terrrible. 1) Linux doesn't track shared pages (which is not the same as shared memory) anymore--the field the in 'free' output is just there to avoid breaking software.

[GENERAL] Postgres 7.4.6 x86_64 RPMS

Hello I am looking for Postgres 7.4.6 x86_64 RPMS for Redhat ES 3.0. I Think 7.4.6 will be included in Redhat ES 4.0 but I am not sure when that will be released and we may not upgrade at that time. I have found RPMS for Fedora Core 3 but they want work. Thanks John Allgood - ESC

Re: [GENERAL] Reusable database design

Joachim Zobel wrote: Hi. I can't be the first to think about this. There is a million online shops out there, which all more or less have the same database design. Has anybody thought about creating generic reusable/customizable designs for such cases? Thx, Joachim Check out your favourite

Re: [GENERAL] Sheduler in Postgres

cron works pretty well in unix. Scheduled tasks on windows have, in my experience, been on the flakey side. On Tue, 7 Dec 2004, [iso-8859-2] Együd Csaba wrote: Hi, I should schedule the execution of several stored procedures. Now I use an NT service for this, but as far as I know e.g. the

[GENERAL] Join on virtual table

Hi. I'd like to return a result set from a plpgsql function constructed out of a 'virtual table' joined to an actual table, and struggling to find a sane approach. I have a table 'recs' with records like this. day | nums --- 2 | 1 5 | 3 2 | 2.5 For a

Re: [GENERAL] migrating from informix

--- Gregory S. Williamson [EMAIL PROTECTED] escribió: Jaime -- Sorry that I didn't respond earler -- been quite busy. don't worry. We have migrated our runtime aspect (which is heavy use of the Spatial Blade/postGIS in a mostly read-only environment); we were using Informix

[GENERAL] Questions on stored-procedure best practices

I'm used to writing C/Java/python type stuff and am a bit new to stored procedures and looking for a few best practices. I'm using plpgsql (as opposed to plpython, etc.) because it offers the most flexibility in terms of data-types, etc. good editor: Usually emacs does a good job, but postgres

[GENERAL] Significado logo PostgreSQL

Amigos: ¿Qué significado tiene el logo de PostgreSQL? Saludos, -- Mirko Coz Berrospi ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Create AS question

Bob Powell wrote: Hello everyone: If I excute the following: CREATE table Test_backup as SELECT * FROM Test_Scores; it creates my table without the original table's constraints or triggers. Is there a way to preserve them in the copy? Only if you create a schema dump of just the table and

Re: [GENERAL] Postgres not using shared memory

Karl O. Pinc wrote: Hi, I can't seem to get postgresql to use shared memory and performance is terrrible. PostgreSQL 7.4.6 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-42) $ uname -a Linux artsdata 2.4.21-20.0.1.ELsmp #1 SMP Wed Nov 24 20:34:01 EST

Re: [GENERAL] postgresql and javascript

On Tuesday 07 December 2004 22:42, Chris Smith wrote: [EMAIL PROTECTED] wrote: Does anyone know how to connect javascript to a postgresql database You can't connect javascript to any sort of database. You need something like php, python etc - it can connect to your database and generate

Re: [GENERAL] postgresql and javascript

Chris Smith wrote: [EMAIL PROTECTED] wrote: Does anyone know how to connect javascript to a postgresql database You can't connect javascript to any sort of database. Actually you can, with server side javascript, although I don't know if it supports postgresql. It does support odbc. -- Until

[GENERAL] Problems with information_schema

Hi all I just copied a rather complex application database together with all tables and triggers to 8.0.0RC1 running under windows (the original 7.4 database still runs on linux). I migrated everyting using pg_dump and then executing the resulting scripts via pgsql. Most things work as

Re: [GENERAL] When to encrypt

On 12/6/2004 6:10 PM, Greg Stark wrote: Martijn van Oosterhout [EMAIL PROTECTED] writes: Actually, hard disk encryption is useful for one thing: so if somebody kills the power and takes the hard disk/computer, the data is safe. While it's running it's vulnerable though... Where do you plan to keep

[GENERAL] Measure the CPU Time per Transaction

Seems explain gives the run time, but not CPU time, right? I did not find such statistics in the Statistics Collector either. How to measure the CPU time per transaction in PostgreSQL? Thanks! Stan __ Do You Yahoo!? Tired of spam? Yahoo! Mail

Re: [GENERAL] Performance tuning on RedHat Enterprise Linux 3

Tom Lane wrote: Paul Tillotson [EMAIL PROTECTED] writes: Does postgres actually do multiple concurrent sorts within a single backend? Certainly. Consider for example a merge join with each input being sorted by an explicit sort step. DISTINCT, ORDER BY, UNION, and related operators

Re: [GENERAL] Performance tuning on RedHat Enterprise Linux 3

Tom Lane [EMAIL PROTECTED] writes: Paul Tillotson [EMAIL PROTECTED] writes: Does postgres actually do multiple concurrent sorts within a single backend? Certainly. Consider for example a merge join with each input being sorted by an explicit sort step. DISTINCT, ORDER BY, UNION, and

[GENERAL] Problem with Insert rules: using nextval: get schema *new* does not exist and other oddities

I am trying to see if it is possible to use rules to create complex updateable views covering two or more tables. Initially I created two test tables: one to hold CD names (cathyscds) and one to hold the track names/numbers/times for each cd (cathystracks) using the following SQL: CREATE TABLE

Re: [GENERAL] Fwd: 8.0 vs. 7.4 benchmarks

On Tue, Dec 07, 2004 at 08:43:03 -0800, Joshua D. Drake [EMAIL PROTECTED] wrote: IMHO 8.0 means, hey all you external developers -- time to test with your applications and report bugs. 8.1 means, alright we got some wide reports -- fixed a few mistakes and now were ready. That should

[GENERAL] test

The list is either down or very quiet ? G ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[GENERAL] any body able to access news.postgresql.org recently?

Hi, I am able to access this news.postgresql.org group two days ago. Now I am not able to access. Is it the news group is down? Thanks, Rosny ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] Postgres 8 and Slony-1

Hi Any news when Postgres 8 will be released? Also, are there any plans to include Slony with it, as part of the same source download, or as part of a group 'matched' source files/rpms/dpkgs etc? Thanks All Simon -- Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599

Re: [GENERAL] Fwd: 8.0 vs. 7.4 benchmarks

I would love to get my hands on any numbers that someone might have. Also does anyone know how long it will take for a stable release of 8.0 to come (any estimates would be good) ? The last target date I saw mentioned was 2004-12-15. If a second release candidate is needed, I don't know if

[GENERAL] Mailing List Problems?

I've not seen a post in days on many of the lists to which I subscribe. --Rick ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] test

just a test ___ Yahoo! Mail - Agora com 250MB de espaço gratuito. Abra uma conta agora! http://br.info.mail.yahoo.com/ ---(end of broadcast)--- TIP 5: Have

[GENERAL] Temporary tables and disk activity

Dear All, I sent a message last weekend asking about temporary tables being written to disk but didn't get any replies. I'm sure there is someone out there who knows something about this - please help! Here is the question again: Looking at vmstat output on my database server I have been

Re: [GENERAL] Fwd: 8.0 vs. 7.4 benchmarks

Bruno Wolff III wrote: On Tue, Dec 07, 2004 at 08:43:03 -0800, Joshua D. Drake [EMAIL PROTECTED] wrote: IMHO 8.0 means, hey all you external developers -- time to test with your applications and report bugs. 8.1 means, alright we got some wide reports -- fixed a few mistakes and now were ready.

[GENERAL] Test

test -- Command Prompt, Inc., home of PostgreSQL Replication, and plPHP. Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL begin:vcard

[GENERAL] table with sort_key without gaps

Hi, i have a table like this: create table array ( account text NOT NULL, id int4 NOT NULL, value text NOT NULL, PRIMARY KEY (account, id) ); values like this: acc1,1,'hi' acc1,2,'ho' acc1,3,'ha' acc2,1,'ho' acc3,1,'he' acc3,2,'hu' id should be positive id should not have gaps

[GENERAL] Strange NOTICE: messages in log file

Hello all, I was digging through my logs the other day and I noticed a bunch of the following log messages: Dec 8 10:50:18 bahamut postgres[7647]: [273-1] NOTICE: \203\304x\361\330k!\244\301\216w\366\000m\300\333 Dec 8 10:50:18 bahamut postgres[7647]: [274-1] NOTICE:

Re: [GENERAL] migrating from informix

Jaime -- Sorry that I didn't respond earler -- been quite busy. We have migrated our runtime aspect (which is heavy use of the Spatial Blade/postGIS in a mostly read-only environment); we were using Informix 9.3 dynamic server. I have some notes I wrote up that I'll post tonight -- they are

[GENERAL] Problems with JDBC site and Postgres mailing list subscription page

http://jdbc.postgresql.org/ seems to be down. Also I can't connect to the mailing list subscription page at: http://webmail.postgresql.org/mj/mj_wwwusr?domain=postgresql.orgfunc=lists-long-fullextra=pgsql-jdbc Can anyone point me to another site where I can download the postgres jdbc drivers?

[GENERAL] Ridiculous load

On Monday we upgraded one of our PostgreSQL instances from v7.2 to v7.4. Yesterday the box (sabine) on which this runs became very unhappy: It runs RHEL ES v3, kernel 2.4.21-20.ELsmp It's generally a very stable box which runs a number of postgresql instances. But last night we hit very high

[GENERAL] replacing a view: bug or feature?

Is the error below a bug? Or a feature? % cat foo.sql SELECT version(); CREATE TABLE foo ( key serial NOT NULL PRIMARY KEY, msg character(100)); CREATE TABLE bar ( key serial NOT NULL PRIMARY KEY, msg character(100)); CREATE VIEW baz AS SELECT * FROM foo UNION ALL SELECT * FROM bar; CREATE OR

Re: [GENERAL] RC1, missing -lpthread when building with --disable-shared on i686

I just confirmed that the same goes for: Linux 2.6.5-7.111.5-default, i686 i686 i386 GNU/Linux (SuSE v9.1) Makefile.global holds: PTHREAD_CFLAGS = -pthread -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS PTHREAD_LIBS= -lpthread Would you like confirmation for

Re: [GENERAL] migrating from informix

--- Gregory S. Williamson [EMAIL PROTECTED] escribió: Jaime -- Sorry that I didn't respond earler -- been quite busy. don't worry. We have migrated our runtime aspect (which is heavy use of the Spatial Blade/postGIS in a mostly read-only environment); we were using Informix 9.3

[GENERAL] using postgresql functions from php

I have created a function in postgresql CREATE OR REPLACE FUNCTION public.insert_vpn_masteraccount(varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar) RETURNS varchar AS ' DECLARE BEGIN insert into masteraccount(fname,midint,lname,username,atype)

[GENERAL] using inheritance in production application.

How 'ready for prime-time' is the table inheritance feature? I've seen some postings about particular issues (lack of full FK support, for example), but would like to get an overall sense of the stability and robustness of the feature. Also, is there a performance hit in using inheritance? For

Re: [GENERAL] Query is not using index when it should

On Fri, 10 Dec 2004, Tomas [iso-8859-1] Skäre wrote: I have a table that looks like this: Table public.cjm_object Column | Type| Modifiers ---+---+--- timestamp | bigint| not null jobid | bigint| not

[GENERAL] What's faster

Option 1: create table a (id serial, hosts text[]); OR Option 2: create table a (id serial); create table hosts (id int references a, host text); Table 'a' will have about 500,000 records. There will probably be about 20 reads for every write. Each id has approximately 1.1 hosts. If I use the

Re: [GENERAL] any body able to access news.postgresql.org recently?

There have been some difficulties with servers; it appears as though most if not all of it has been resolved. -- let name=cbbrowne and tld=gmail.com in name ^ @ ^ tld;; http://www.ntlug.org/~cbbrowne/postgresql.html I'm not switching from slrn. I'm quite confident that anything that *needs* to

[GENERAL] information schema extra fields

I was just reading the PostgreSQL documentation about Information Schemas. Some of the tables have fields which are described as Applies to a feature not available in PostgreSQL What does that mean? -- Ron Peterson Network Systems Manager Mount Holyoke College

Re: [GENERAL] Sheduler in Postgres

The world rejoiced as [EMAIL PROTECTED] (Egyd Csaba) wrote: Hi, I should schedule the execution of several stored procedures. Now I use an NT service for this, but as far as I know e.g. the Oracle has such a thing. It would be great if I could fire procedures on a timer basis. Is there a

[GENERAL] No mailing list posts

Hello, I have received no posts from GENERAL since yesterday morning; is the list broken? Thank you. Don ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to

Re: [GENERAL] Postgres 8 and Slony-1

Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Simon Windsor) would write: Any news when Postgres 8 will be released? If things go well, there's a release candidate hoped to be suitable for a Dec 15th date. But releases will _actually_ be ready when they are ready. Also, are

Re: [GENERAL] Natural ordering in postgresql? Does it exist?

Quoth [EMAIL PROTECTED] (Clark Endrizzi): I have a field that I'll be ordering and I noticed that ordering is done logically and would confuse my users here (1,12,16,4,8, etc). I'm writing an application in PHP that connects to Postgres and while I know that PHP has some powerful natural

Re: [GENERAL] trouble with on insert rule via libpg-perl

On Fri, Dec 10, 2004 at 11:26:09PM -0500, rpeterso wrote: I should have mentioned... PostgreSQL versions 8.0.0beta5 and 7.4.6 libpq-perl 2.0.2 perl 5.8.4 -- Ron Peterson Network Systems Manager Mount Holyoke College http://www.mtholyoke.edu/~rpeterso ---(end of

Re: [GENERAL] postgresql and javascript

There is this from Mozilla: http://www.mozilla.org/projects/sql/ On Tue, 7 Dec 2004 10:27:05 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Does anyone know how to connect javascript to a postgresql database Please send example if anyone has done it -- Mike Rylander [EMAIL

[GENERAL] trouble with on insert rule via libpg-perl

I have a simple table, a view, and an on insert rule. These work fine, ordinarily. But when I attempt to to insert a value into thesis_ps_v via libpq_sql, nothing happens. If I capture the sql string I'm sending (as per code sample below), print it to a file, and paste it into a psql session,

Re: [GENERAL] information schema extra fields

On Sat, Dec 11, 2004 at 11:58:31AM +0900, Michael Glaesemann wrote: On Dec 9, 2004, at 12:46 PM, Ron Peterson wrote: I was just reading the PostgreSQL documentation about Information Schemas. Some of the tables have fields which are described as Applies to a feature not available in

Re: [GENERAL] Sheduler in Postgres

OK, thank you. Yes we have a more native tool - the at service on NT/2K. I wanted to boundle it into the application because I don't like to place parts of the application outside the application. I wrote a scheduler service sepcialy for the applications tasks. It works fine, but I thought this

Re: [GENERAL] Scheduler in Postgres

Thank you Ben, I already have known these tools. I was wonder if Postgres has an integrated tool for scheduling sp's (like Oracle has!). OK it doesn't have. No problem just tried to make world more simpler... :) Bye, -- Csaba -Original Message- From: Ben [mailto:[EMAIL PROTECTED] Sent:

Re: [GENERAL] Mailing List Problems?

Fixed On Fri, 10 Dec 2004 [EMAIL PROTECTED] wrote: I've not seen a post in days on many of the lists to which I subscribe. --Rick ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] Marc G. Fournier

Re: [GENERAL] gborg.postgresql.org

On Wed, 8 Dec 2004, Tatsuo Ishii wrote: It seems gborg does not accept new projects any more. Does anybody know what happens with it? Also it's really slow and sometimes does not respond. I need an open source development web site which can safely hosts pgpool. Recently I'm getting lot of mails

Re: [GENERAL] any body able to access news.postgresql.org recently?

Fixed On Wed, 8 Dec 2004, Sehat Rosny wrote: Hi, I am able to access this news.postgresql.org group two days ago. Now I am not able to access. Is it the news group is down? Thanks, Rosny ---(end of broadcast)--- TIP 7: don't forget to increase

[GENERAL] ERROR: relation table does not exist - HELP

when I run select * from "table" I get this error. ERROR: relation "table" does not exist Itamar Reis Peixoto+55 34 3238 3845+55 38 9107 1250http://www.ispbrasil.com.br No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.5.0 - Release

Re: [GENERAL] information schema extra fields

On Dec 9, 2004, at 12:46 PM, Ron Peterson wrote: I was just reading the PostgreSQL documentation about Information Schemas. Some of the tables have fields which are described as Applies to a feature not available in PostgreSQL The information schema is a part of the SQL standard that allows

Re: [GENERAL] How to get rid of notices for create table?

On Fri, Dec 10, 2004 at 06:31:15PM -0300, Pablo Santiago Blum de Aguiar wrote: I'm getting boring notices when creating tables: [snip] NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index pk_cliente for table cliente NOTICE: CREATE TABLE / UNIQUE will create implicit index

Re: [GENERAL] Natural ordering in postgresql? Does it exist?

On Fri, Dec 10, 2004 at 02:47:53PM -0700, Clark Endrizzi wrote: I have a field that I'll be ordering and I noticed that ordering is done logically and would confuse my users here (1,12,16,4,8, etc). I think you mean that the ordering is done lexically and you want it done numerically. If

Re: [GENERAL] Performance tuning on RedHat Enterprise Linux 3

Does postgres actually do multiple concurrent sorts within a single backend? Certainly. Consider for example a merge join with each input being sorted by an explicit sort step. DISTINCT, ORDER BY, UNION, and related operators require their own sort steps in the current implementation.

Re: [GENERAL] No mailing list posts

Don Isgitt wrote: Hello, I have received no posts from GENERAL since yesterday morning; is the list broken? Thank you. Don ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [GENERAL] Natural ordering in postgresql? Does it exist?

Numbers as text are ordered like that. Integers are ordered as you would like. The best hack I have seen if you are stuck with text is ...order by length(numbers_as_test), numbers_as_text which sorts first by number of digits then by text order. Ian Harding Programmer/Analyst II

Re: [GENERAL] Significado logo PostgreSQL

On Fri, Dec 10, 2004 at 04:02:42PM -0500, Mirko Coz wrote: ¿Qué significado tiene el logo de PostgreSQL? Questions in Spanish should probably go to pgsql-es-ayuda. An elephant is Big, strong, reliable and never forgets...: http://archives.postgresql.org/pgsql-general/1998-07/msg00306.php

Re: [GENERAL] postgresql and javascript

[EMAIL PROTECTED] wrote: Does anyone know how to connect javascript to a postgresql database You can't connect javascript to any sort of database. You need something like php, python etc - it can connect to your database and generate javascript. Regards, Chris Smith Suite 30, 45-51 Huntley St,

Re: [GENERAL] Performance tuning on RedHat Enterprise Linux 3

But isn't the problem when the planner screws up and not the sortmem setting? There was my case where the 7.4 planner estimated 1500 distinct rows when there were actually 1391110. On 7.3.4 it used about 4.4MB. Whereas 7.4 definitely used more than 400MB for the same query ) - I had to kill

[GENERAL] How to get rid of notices for create table?

Hi, I did a search for this issue but don't seem to find anything reasonably satisfactory. I'm getting boring notices when creating tables: test=# CREATE TABLE cliente ( test(# idINTEGER NOT NULL, test(# id_indica INTEGER NULL, test(# email VARCHAR(40)

Re: [GENERAL] vacuum problem?

On Tue, Dec 07, 2004 at 06:35:39PM -0700, Ed L. wrote: On Tuesday December 7 2004 6:27, Ed L. wrote: On Tuesday December 7 2004 5:58, marcelo Cortez wrote: La traducción de Babelfish de mi mensaje anterior era hilarante, e indica que mi español es lejos peor que pensamiento de I. Tends to

[GENERAL] Natural ordering in postgresql? Does it exist?

Hi all, I have a field that I'll be ordering and I noticed that ordering is done logically and would confuse my users here (1,12,16,4,8, etc). I'm writing an application in PHP that connects to Postgres and while I know that PHP has some powerful natural ordering functions it would be much

[GENERAL] Clustering in the presence of hierarchies

I'd like to ask you about the clustering strategy that postgres implements. Exactly: I have created a hierachy of tables using 'inherits' relationship. I have populated tables with a huge amount of data and then I cluster each table according to an attribute that exists on Root table (hence,

Re: [GENERAL] Shared disk

On Thu, Dec 09, 2004 at 09:02:51AM +0530, Nageshwar Rao wrote: Hi, I would like to use shared disk for two Postgresql database. I mean that two Postgresql Database point to same $PGDATA directory. Is this possible in Postgresql Not at all. You can of course create two databases within one

Re: [GENERAL] Get diagnistic (row_count) 7.3 vs. 7.4 changes

Hello. Seeking further clarity regarding GET DIAGNOSTICS behavior in 7.4. As described previously GET DIAGNOSTICS in the following example does not work in 7.4.5: CREATE OR REPLACE FUNCTION public.rowcount_test () RETURNS bigint AS' DECLARE base_hits bigint; BEGIN base_hits := 0;

[GENERAL] Loading data from tab delimited file using COPY

Hello everyone, I have had a long term problem loading tab separated data from a text file that has prevented me from migrating my enterprise application from MySQL to PostgreSQL. With version 2 of this application I am making the move to PostgreSQL but am still running into the problem even

Re: [GENERAL] postgresql and javascript

# Does anyone know how to connect javascript to a postgresql database # # Please send example if anyone has done it Maybe you mean Java? Javascript runs within the browser and AFAIK has no facilities for dealing with a database connection. FWIW, you can accomplish what you're probably

Re: [GENERAL] Detecting Temporary Tables

What i want to be able to do is create a tempory table and when i need a value stored in the table i want to check that the table has been created if it has not do a create temp table or just do an update. Michael Fuhr wrote: On Tue, Dec 07, 2004 at 09:22:51AM +1100, Jamie Deppeler wrote:

[GENERAL] Simple function

Hi guys, I have a table with two integer fields (field1 and field2)... I would like to construct a function that perform an operation with this two fiels (field1 + fields2), and return the string value A if the sum is 20, B if the sum is =20 or =50, and finally return C if the sum is 50. So I

[GENERAL] Spanning tables

Hi ALL, Im wondering sooner or later my disk will be filled-up by postgres's data.. Can anyone give some suggestion on how to deal with this. In oracle you can just assign tables on a diff partition. TIA ---(end of broadcast)--- TIP

[GENERAL] gborg.postgresql.org

It seems gborg does not accept new projects any more. Does anybody know what happens with it? Also it's really slow and sometimes does not respond. I need an open source development web site which can safely hosts pgpool. Recently I'm getting lot of mails regarding pgpool and need mails lists,

Re: [GENERAL] Performance

Werdin Jens wrote: Hello, Ich have a big performance problem. I'm running postgres 7.4.2 on Suse Linux 9.0 on a dual Xeon 3.0 GHz with 3 Gbyte Ram. In postgres.conf I'm using the defaults. That's the place to start. See the guide at:

Re: [GENERAL] postgresql and javascript

Hi i don't see any practical use of _javascript_ with Postgresql, since a _javascript_ is on the client side. Unless you want each client machine to have its own database ! Najib. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]

Re: [GENERAL] postgresql and javascript

The world rejoiced as [EMAIL PROTECTED] (Najib Abi Fadel) wrote: i don't see any practical use of javascript with Postgresql, since a java script is on the client side.   Unless you want each client machine to have its own database ! Actually, there _is_ a practical use for

Re: [GENERAL] Postgres 8 and Slony-1

If things go well, there's a release candidate hoped to be suitable for a Dec 15th date. But releases will _actually_ be ready when they are ready. Also, are there any plans to include Slony with it, as part of the same source download, or as part of a group 'matched' source files/rpms/dpkgs

Re: [GENERAL] any body able to access news.postgresql.org recently?

A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Sehat Rosny) wrote: I am able to access this news.postgresql.org group two days ago. Now I am not able to access. Is it the news group is down? There have been some difficulties with servers; it appears as though most if not all

Re: [GENERAL] postgresql and javascript

Geoffrey wrote: Chris Smith wrote: [EMAIL PROTECTED] wrote: Does anyone know how to connect javascript to a postgresql database You can't connect javascript to any sort of database. Actually you can, with server side javascript, although I don't know if it supports postgresql. It does support

Re: [GENERAL] postgresql and javascript

You might want to look at this : https://bugzilla.mozilla.org/show_bug.cgi?id=81653 This project is a native Postgresql connection in XUL (an XML based language that describes the Widgets in Firefox). I have not had time to play with this but it looks like the Firefox client could connect

Re: [GENERAL] Spanning tables

On Thu, Dec 09, 2004 at 01:07:43PM +0800, JM wrote: Im wondering sooner or later my disk will be filled-up by postgres's data.. Can anyone give some suggestion on how to deal with this. In oracle you can just assign tables on a diff partition. In PostgreSQL 8.0 you'll be able to

Re: [GENERAL] Loading data from tab delimited file using COPY

On Wed, Dec 08, 2004 at 09:17:12PM -0700, Jason Sheets wrote: Sample Data is available at http://www.idahoimageworks.com/sampledata.txt I'm using the command: COPY residential FROM 'file' WITH DELIMITER AS '\t'; I'm receiving the error: ERROR: missing data for column builder When opened

Re: [GENERAL] Natural ordering in postgresql? Does it exist?

Clark Endrizzi [EMAIL PROTECTED] writes: Hi all, I have a field that I'll be ordering and I noticed that ordering is done logically and would confuse my users here (1,12,16,4,8, etc). Sounds like you're storing a number in a text field. Numeric fields sort in numerical order. -Doug

[GENERAL] Servers live ... news at 11 ...

I just wanted to get a quick note out now that I can ... I'll send a longer note out explain what happened later this evening when I get a spare breath to write one ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!:

[GENERAL] Query is not using index when it should

I tried to subscribe to pgsql-performance, but there seems to be something wrong with the majordomo, so I'm sending to general too, where I'm already subscribed. My problem is this, using PostgreSQL 7.4.6: I have a table that looks like this: Table public.cjm_object Column |