[GENERAL] Fw: UUID vs Serial or BigSerial

All, >From a performance standpoint what is the downside to using a UUID column? >Our current database with 25 locations after 5 years is only about 2.5 gig. >We do about 200,000 orders per year so we are not getting hit with a huge >amount of data. Much of our data is static or onc

[GENERAL] Postgres as the embedded database

I am looking to hear from people that are using PostGres as their backend in a commerically available product and how much work would be needed to ensure that our configurations are optimized for each platform along with normal database routines? What has the stability factor been once installe

[GENERAL] Using PostGres general distribution

We currently use SQL Anywhere 9.0.2 as our database in our current product. The main reason is the low maintenance that is required and the installation is a breeze. All we need to do is to ship 3 dll's and a db and log file. I understand that with PostGres that the installation will end up bei

[GENERAL] Partitioned tables and views

I have several tables that we have partitioned by physical location. This seems to give us the best overall performance when doing location specific queries. I have a few questions. 1. Is the planner/optimizer intelligent enough to know when we are not doing a query based on location? For ex

Re: [GENERAL] Data Types

Thanks for all of the replies. Best Regards, Michael Gould, Manager Information Technology All Coast Intermodal Services, Inc. 904-226-0978 _ From: Tom Lane [mailto:[EMAIL PROTECTED] To: Roberts, Jon [mailto:[EMAIL PROTECTED] Cc: [EMAIL PROTECTED], pgsql-general General [mailto:[EMAIL PR

[GENERAL] Data Types

We are converting our system from using Sybase's SQL Anywhere 10 to PostGres 8.3. In SQL Anywhere there technically isn't any difference in how a char and varchar is stored. They are all an array of char[1]. So we always just defined everything as a char since right truncation is the default.

[GENERAL] SERIAL and Primary Key

CREATE TABLE "fav5"."batchnumber" ( "batchnumberid" SERIAL NOT NULL, "processtype" SMALLINT NOT NULL, "termloc" CHAR(3) NOT NULL, "batchno" INTEGER NOT NULL ) WITHOUT OIDS; With the above table definition, is batchnumberid by default also defined as the primary key or do I still need

[GENERAL] feature requests

I would like to see a CREATE Variable dataname datatype added. The scope of these variables would be global. Along this same line I would like to see a way to have a trigger or rule fired upon connection initialization. This would allow for these type of variables to be SET along with other de

[GENERAL] Trigger Priority

Is there a way to determine the order that triggers are executed? We are converting from SQL Anywhere 9 and one of the features that they have is the ability to add a order statement to triggers. This allows from a programmatic way to control how triggers are fired if there is more than o

[GENERAL] Another conversion from ASA to PostGres how to

All, As the subject says we are converting from Sybase's SQL Anywhere to PostGres 8.2.4. One of the features in ASA is a SET OPTION PUBLIC.login_procedure='DBA.login_check'. After a user is authenticated on a connection, if this setting is set, then the database automatically triggers this p

[GENERAL] Distributing PostGres database to various customers

All, I am new to PostGres 8 (using 8.2.4 windows version). We have for several years been using iAnywhere's SQL Anywhere product with our commercial transportation software. With ASA there are 2 files that must be distributed for the database, a filename.db and a filename.log. When we do a n