PostgreSQL Database Forum

I am designing something that may be the size of yahoo, google, ebay, etc. Just ONE many to many table could possibly have the following characteristics: 3,600,000,000 records each record is 9 fields of INT4/DATE Other tables will have about 5 million records of about the same size.

Guys, I have an opening currently for the following position. If interested, email me at john.wells__replace_this_with_at__timco.aero. Although relo is stated as not covered, I may be able to fight for that given a very qualified candidate. Company: TIMCO Aviation Services Location: US-NC-Greensboro Base Pay: N/A

Hello all I've been approached by the development people about removing the 'public' schema. They complain about having to manually remove the 'public_' tag from table names generated by their development software whenever they link to PG via ODBC. Renaming or using another schema is not what they're after either. 1. If it is...

Hi Folks, I'm looking for something that is completely independent of the MSVC++ Dev Studio environment, something that will compile and run under win32 using the mingw distribution. A class that allows schema definitions to be made and recordsets to be queried and updated would be wonderful. It doesn't have to include the kitchen sink!...

Hello, I appreciate very much the readline functionality on the psql client. However, I'd like to ask if it is possible for the readline functionality to gobble up even table names and field names: For example, if have tables `table1' with 3 fields `field1', 'field2', and `field3'

Hi all, has anyone implemented row versions/timestamps in PostgreSQL or any thoughts on this? Did I hit the right term? What I want to achieve is optimistic concurrency beyound transaction boundaries. When retrieving data I would also retrieve the row version and later on, in a different transaction, before updating the data, I could check...

I have a project where it is necessary to determine Outliers of lab results and looking for some pointers on the best way to handle this type of calculation with PostgreSQL. Possibly an operator? I have no experience with that. I found some info on the web for calculating Outliers, here is one of them... ...

Hello MySQL has information about several storage engines. MEMORY to handle temporary tables, InnoDB to handle transactions and which also can split its table data over several files/partitions. Splitting of storage is something which according to the following article, PostgreSQL does not support: http://www.devx.com/dbzone/Article/20743

Hello, I am looking for some modeler to create a database structure - tables, relations etc. I use DBDesigner, but it is primarily designated for MySQL. What tool do you use for PostgreSQL? - sheets and crayons? -- Jiøí Nìmec, ICQ: 114651500

I have 5 corrupted page headers as evidenced by these errors: ERROR: Invalid page header in block 13947 of ... The corruption is causing numerous queries to abort. First option is to try to salvage data before attempt restore from backup. I want to try to edit the file to zero out the bogus headers. I realize there may be data lost...

Hello ! I have two tables (which contains individual months' data). One of them contains 500 thousand records and the other one about 40k, 8 columns. When I do a simple query on them individually it takes milli-seconds to complete (see gory details below). For some querys I want to include data from multiple months so I created a view using...

My question is it possible to speed up a query doing preselects? What I'm working on could end up being a very large dataset. I hope to have 100-1000 queries per second (0r more?), and if very large tables are joined with very large tables, I imagine that the memory would be get very full, overfull? So in the schema below the following queries,...

I know this is kinda a debate, but how much ram do I give postgres? I've seen many places say around 10-15% or some say 25%....... If all this server is doing is running postgres, why can't I give it 75%+? Should the limit be as much as possible as long as the server doesn't use any swap? Any thoughts would be great, but I'd like to know...

Is the ON COMMIT syntax available to temporary tables created using the CREATE TABLE AS syntax? If not, is there a way to drop such a table at the end of a transaction? -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC

Hi! I'm from Italy, and sorry about my english... I have a question that I know it is already said in the groups but I have however some doubts I have seen it is technically possible to use OID as PRIMARY KEY and as FOREIGN KEY but it is correct to do so for the database's logical integrity? Is it better I use in any case other keys and...

Hi, I have a question about sequences. I need a field to have values with no holes in the sequence. However, the values do not need to be in order. My users will draw a number or numbers from the sequence and write to the field. Sometimes, however, these sequence numbers will be discarded (after a transaction is complete), and thus...

Hi, I have a question about sequences. I need a field to have values with no holes in the sequence. However, the values do not need to be in order. My users will draw a number or numbers from the sequence and write to the field. Sometimes, however, these sequence numbers will be discarded (after a transaction is complete), and thus...

cc me please: ---------------- I can't find in the HTML documentation the max length of a bit string. Anyone know where it is? ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

I got a table with oid 25459. The file is 1073741824 bytes big. I did some more inserts, and now I have this two new files: size/name: 1073741824 25459.1 21053440 25459.2

is there a way to create a table with a certain type? CREATE TYPE typename AS (id integer, name varchar); and something like CREATE TABLE names OF TYPE typename. Is there a syntax to support this?

I was attempting to set up my psql client on the Win32 version of postgres 8.0 beta 2 to be able to use an external editor. I set the environment variable in windows like so: PSQL_EDITOR="c:\progra~1\Textpa~1\Textpad.exe" which does appear to work correctly. However, I get the following when attempting to edit the query buffer: ...

IM trying to build the ppostgres ODBC driver for MacOSX. I thought id try and build it as a bundle from XCode. All compiles no problem but then at the end of the compile i get an undefined symbols error, here it is: ld: Undefined symbols: _CurrentMemoryContext _MemoryContextAlloc _pfree

Hello, We have been working on migrating oracle database to postgres for one of our client. We have a stored procedure in oracle which uses varray and I have to convert this stored procedure to postgres. Any help with respect to this will be greatly appreciated. Thanks in advance. Best Regards, Arvind Purohit...

Hi, I have a question about sequences. I need a field to have values with no holes in the sequence. However, the values do not need to be in order. My users will draw a number or numbers from the sequence and write to the field. Sometimes, however, these sequence numbers will be discarded (after a transaction is complete), and thus...

I am using 8.0 beta 1 on an RH 8 Linux server. I have a union query that I am converting from access (where it worked) and it is returning duplicates. The only difference between the two rows is the Row field, which is returned automatically. and an example of a row that it has returned duplicate. I have verified that the row only shows...