[GENERAL]

2011-05-07 Thread caglar aksu

[GENERAL] Urgent Order

2011-05-07 Thread Bob Wilson
Hello This is Bob and I will like to order ( Indexing Table )Do get back to me with the types and cost for the ones you do carry and let me know if there is an extra cost when using visa or master Card.Kindly get back to me with your name Are you the sales manager or the Owner? Regards Bob Wil

Re: [GENERAL] PostgreSQL and XA Distributed Transaction Protocol

2011-05-07 Thread Christian Ferrari
>> Writing a specific stub to wrap-up PostgreSQL is not a too >> difficult task, but I would be sure I am not re-inventing the wheel. >> How can I am sure the standard XA interface is not availble? >> Do you know if there is any document about this matter? > I searched the archives and found som

[GENERAL] Error in the 9.1 documentation?

2011-05-07 Thread Thomas Kellerer
Hi, while going through the 9.1 new features, I think I have discovered an error in the manual regarding the CREATE TABLE command. It says: CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [ { column_name data_type [ COLLATE collation ] [ co

Re: [GENERAL] Error in the 9.1 documentation?

2011-05-07 Thread Thom Brown
On 7 May 2011 15:24, Thomas Kellerer wrote: > Hi, > > while going through the 9.1 new features, I think I have discovered an error > in the manual regarding the CREATE TABLE command. > > It says: > > CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT > EXISTS ] table_name

Re: [GENERAL] Error in the 9.1 documentation?

2011-05-07 Thread Thomas Kellerer
Thom Brown wrote on 07.05.2011 16:28: while going through the 9.1 new features, I think I have discovered an error in the manual regarding the CREATE TABLE command. The DEFAULT declaration was moved into the column_constraint section. Ah thanks, didn't see that (and I wouldn't expect the DEFA

Re: [GENERAL] Urgent Order

2011-05-07 Thread John R Pierce
On 05/07/11 6:08 AM, Bob Wilson wrote: Hello This is Bob and I will like to order ( Indexing Table )Do get back to me with the types and cost for the ones you do carry and let me know if there is an extra cost when using visa or master Card.Kindly get back to me with your name Are you the sales

Re: [GENERAL] Cannot reproduce why a query is slow

2011-05-07 Thread Tomas Vondra
Dne 5.5.2011 17:02, John Cheng napsal(a): > Hi, > We have certain types of query that seems to take about 900ms to run > according to postgres logs. When I try to run the same query via > command line with "EXPLAIN ANALYZE", the query finishes very quickly. > What should I do to try to learn more a

Re: [GENERAL] multiple group by on same table

2011-05-07 Thread Leonardo Francalanci
> I am not sure if this could apply to your case, but maybe - unless you have >done it before - > > you could look at windowing functions Ciao Gabriele, the problem is that the only thing the N queries have in common is the base table; everything else is different, because the different "gro

[GENERAL] FILLFACTOR and increasing index

2011-05-07 Thread Leonardo Francalanci
Hi, the doc pages are somehow "cryptic" regarding FILLFACTOR. (well, at least they're cryptic to me, since I don't know a lot of btree stuff...) I have an index on a timestamp value that is inserted, for 90% of the inserts, in increasing order. No updates, no deletes on the table (appends only).