Re: [GENERAL] Real vs Float & 32bit vs 64bit CPU Performance Question

Depending on how your version of PG was built, there will probably be hardly any difference in speed as far as the CPU is concerned as the FPU should be happy with both, and I think MMX/MMX2/SSE/SSE2/3dNow! have some relevant optimisations for that sort of thing as well. You will be transfe

Re: [GENERAL] GUID for postgreSQL

Dann Corbit wrote: There is a "privacy hole" from using the MAC address. (Read it in the WIKI article someone else posted). Probably, it would be better to use a one way hash of the MAC address. The chances of MAC addresses colliding (through some low-end network card vendor's sloppy manufac

[GENERAL] postmaster

Hi Im running postgres on OS X 10.4.2. Im having a problem starting postgres though... but its maybe something dumb im doing... So i su -l postgres and cd to my /opt/local/bin where postmaster is... But i always get a: -su: postmaster: command not found Its there. Anyone know what im doing wron

[GENERAL] Questions about Views, Rules and DBLink

Hi! I'm using dblink with some DBs and i'm having a few problems, more precisely with the dblink_current_query() function. First I create the following views on a DB: - create or replace view users as select * from dblink('hostaddr=127.0.0.1 dbname=teste user=postgres password=postgres','se

Re: [GENERAL] Tool for database design documentation?

I use a combination of the gnome-based diagraming application Dia (http://www.gnome.org/projects/dia/) and the tedia2sql diagram-to-DDL SQL translation script, which is written in Perl (http://tedia2sql.tigris.org/).It's a bit awkward, but:    1) Dia is a wonderful, open source diagramming tool I c

[GENERAL] Disconnect sessions and session timeouts

Hi, I'm looking to solve a problem where a client application is leaving idle sessions open, eventually filling up the maximum connections and stopping anyone from connecting. It seems like there's no way to disconnect sessions after a given idle timeout. There is a statement timeout, but that

Re: [GENERAL] postmaster

eoghan <[EMAIL PROTECTED]> writes: > Im running postgres on OS X 10.4.2. Im having a problem starting > postgres though... but its maybe something dumb im doing... > So i su -l postgres and cd to my /opt/local/bin where postmaster is... > But i always get a: > -su: postmaster: command not found >

Re: [GENERAL] Questions about Views, Rules and DBLink

Joao Afonso <[EMAIL PROTECTED]> writes: > So (finally), my question is why does this happen? Using instead on > the users_util insert rule shouldn't discard the original query and > rewrite it according to the specified on the rule?? Is this a problem > of dblink? I hadn't noticed the dblink_cur

[GENERAL] New MySQL to PostgreSQL Migration Guide

Hi; I have just posted a MySQL to PostgreSQL migration guide at http://www.metatrontech.com/wpapers and it is free for pretty much any use (I do have a somewhat toned-down advertising clause in the copyright license). It is a first draft and formatting and other stuff will be likely change

Re: [GENERAL] Questions about Views, Rules and DBLink

Tom Lane wrote: Joao Afonso <[EMAIL PROTECTED]> writes: So (finally), my question is why does this happen? Using instead on the users_util insert rule shouldn't discard the original query and rewrite it according to the specified on the rule?? Is this a problem of dblink? I hadn't noticed th

Re: [GENERAL] [pgsql-advocacy] New MySQL to PostgreSQL Migration Guide

PDF not found? Chris Travers wrote: Hi; I have just posted a MySQL to PostgreSQL migration guide at http://www.metatrontech.com/wpapers and it is free for pretty much any use (I do have a somewhat toned-down advertising clause in the copyright license). It is a first draft and formatting