-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 5:51 PM
To: Jean-Christian Imbeault
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] Duplicate key insert question
On Wed, Jul 02, 2003 at 09:45:23AM +0900,
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 6:37 PM
To: Jean-Christian Imbeault
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] Duplicate key insert question
On Wed, Jul 02, 2003 at 10:25:54AM +0900,
-Original Message-
From: Erick Dennis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 1:27 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Firebird vrs Postgresql
Hello,
had Somebody compared Postgresql vrs Firebird? What is the main
diferent between this DBs?
/*
**
** Not a surprise, to them that knows:
**
*/
#include stdio.h
#include stdlib.h
#include time.h
#define A_LEN 500
static float foo[A_LEN];
static double bar[A_LEN];
int
main (void)
{
long i;
double d;
float f;
srand((unsigned)(double)time(NULL));
for (i = 0; i A_LEN; i++)
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Thomas Kellerer
Sent: Friday, October 13, 2006 2:11 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] more anti-postgresql FUD
[EMAIL PROTECTED] wrote on 11.10.2006 16:54:
Use a sequence and set the initial value of the sequence.
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Maurice Yarrow
Sent: Friday, October 27, 2006 11:51 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] CREATE TABLE initial
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Wednesday, November 08, 2006 7:05 AM
To: redhog
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Stable sort?
redhog [EMAIL PROTECTED] writes:
My question was
And (indeed) that is exactly the answer that you received [within
DLB_DIG units of precision].
I guess that you will be happier with NUMERIC(precision, scale) because
the results of operations will be closer to what you expect.
Suggested reading:
This stuff:
/postgresql-8.2.4/src/test/regress/sql
Should do for starters.
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Kynn Jones
Sent: Friday, July 06, 2007 12:15 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] ISO TESTS
Tsearch2 is used for full text indexing. It won't be any faster than a
btree index like the one you have now (I assume it's unique -- if it
isn't then I think it ought to be). If you cluster the table by your
index it will speed up your queries.
-Original Message-
From: [EMAIL
See:
http://www.postgresql.org/docs/8.2/interactive/app-psql.html
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gauthier, Dave
Sent: Wednesday, August 08, 2007 11:14 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Running a query from
There are some limitations to SQL Server Express:
http://www.microsoft.com/sql/downloads/trial-software.mspx
Download SQL Server 2005 Express Edition
Complete a SQL Server Express download, free. There are no time limits
and the software is freely redistributable (with registration). With a
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, September 06, 2007 12:33 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] an other provokative question??
Relational database pioneer says
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Nathan Wilhelmi
Sent: Friday, November 09, 2007 12:01 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Importance of CPU floating point performance...
Hello - Trying to find out
I see a lot of problems with this idea.
You mention that the database is supposed to be available 24x7.
While you are loading, the database table receiving data will not be
available. Therefore, you will have to have one server online (with
only the old data), while the other one is loading.
-Original Message-
From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
Sent: Monday, June 27, 2005 12:58 PM
To: Dann Corbit
Cc: Ben-Nes Yonatan; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Populating huge tables each day
On Mon, Jun 27, 2005 at 12:43:57PM -0700, Dann Corbit
-Original Message-
From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
Sent: Monday, June 27, 2005 6:55 PM
To: Dann Corbit
Cc: Ben-Nes Yonatan; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Populating huge tables each day
On Mon, Jun 27, 2005 at 01:05:42PM -0700, Dann Corbit wrote
Would it help if you created a trigger that puts a category count into a
statistics table for each table? Perhaps you could gather most of the
information you need from such a process. If an estimate is good enough
and you are using the statistics collector and if you have an index on
that
What is the query that is slow?
What is the schema for the tables involved in the slow query?
What do you see when you do an EXPLAIN ANALYZE on the query?
Is the machine and disk subsystem identical?
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED]
Windows uses the MAC address in GUID generation.
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Scott Marlowe
Sent: Wednesday, July 27, 2005 1:47 PM
To: John DeSoi
Cc: Tino Wildenhain; Riaan van der Westhuizen; Postgresql-General
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.
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Chris
Title: Message
Are you sure that your user account has
been granted DELETE and UPDATE on that table?
If you are sure that the account you were
connected with has permissions, then:
Give the exact command
you did to perform the select.
Give the exact result set
you got back when
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Ben-Nes Yonatan
Sent: Monday, August 22, 2005 9:03 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Query results caching?
Hi all,
I dont know how its called but I noticed
-Original Message-
From: Ben-Nes Yonatan [mailto:[EMAIL PROTECTED]
Sent: Monday, August 22, 2005 1:14 PM
To: Sean Davis; Dann Corbit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Query results caching?
Sean Davis wrote:
On 8/22/05 1:59 PM, Dann Corbit [EMAIL PROTECTED
-Original Message-
From: Ben-Nes Yonatan [mailto:[EMAIL PROTECTED]
Sent: Monday, August 22, 2005 3:28 PM
To: Jim C. Nasby; Sean Davis; Dann Corbit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Query results caching?
On Mon, Aug 22, 2005 at 10:13:49PM +0200, Ben-Nes
Can we see the schema for the tables RDD010 and RES_layers (including
keys)?
12 H for a million rows really sounds brutal (23 rows/sec).
I am guessing it can be done a lot faster using a join but I would like
to see more information about the tables involved in the query.
-Original
If the inserts are all a bunch of data statements like that, a SED
script could turn them into something for bulk load via COPY easily
enough.
Might be an even better solution, depending on what the OP is trying to
accomplish.
-Original Message-
From: [EMAIL PROTECTED]
It is better to send plain text messages instead of html.
It is a pain to respond to emails in HTML format.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Irfan Syukur
Sent: Tuesday, September 13, 2005 6:31 PM
To: POSTGRESQL (E-mail)
http://www.postgresql.org/docs/8.0/interactive/sql-createfunction.html
-Original Message-
From: Irfan Syukur [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 8:37 PM
To: Dann Corbit
Subject: RE: [GENERAL] MS SQL - PostgreSQL
Dear Dann,
Thanks for your answer.
Can
Float provides 6-7 digits of precision.
I see nothing surprising down below.
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Daniel Schuchardt
Sent: Friday, September 16, 2005 5:13 PM
To: pgsql-general@postgresql.org
Subject:
Using SQL*Server, and OLEDB or ODBC data source can be connected as a
linked server. Then, TSQL queries can go against PostgreSQL tables as
though they were ordinary SQL*Server tables (but they have 4 part names
instead of 3 part names).
-Original Message-
From: [EMAIL PROTECTED]
Did you look at the round function?
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Giovanni M.
Sent: Monday, October 03, 2005 11:45 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] strip zeros from fractional part
Hi guys,
[snip]
Knowing all this, what do we need to purchase, what can we do and what
can't we do? It's hard getting a straight answer from anyone that is
why
I am here. If we can't do it, we won't. If we can save our customers
some money while getting them really good options and software, we
would
No. Distributed transactions can cooperate in two phase commit.
I think someone has done some two phase commit work already. IIRC.
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of CSN
Sent: Wednesday, October 05, 2005 11:11 PM
To:
Don't think so.
The author sounds like a PostgreSQL proponent to me.
It also sounds like most of the issues have been addressed with recent
builds.
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Gavin M. Roy
Sent: Thursday, October
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Vivek Khera
Sent: Thursday, October 06, 2005 1:55 PM
To: Postgres General
Subject: Re: [GENERAL] License question
On Oct 4, 2005, at 4:38 PM, Aaron Smith wrote:
I never imagined
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Glen Parker
Sent: Thursday, October 06, 2005 2:41 PM
To: Postgres General
Subject: [GENERAL] MS Access / Postgres ODBC / Outer joins
We're having a problem with Access, Postgres, and
From:
http://www.filmsite.org/whof4.html
Valiant: Come on. Nobody's gonna drive this lousy freeway when they can take
the Red Car for a nickel.
Doom: Oh, they'll drive. They'll have to. You see, I bought the Red Car so I
could dismantle it.
I don't think Oracle has any interest in InnoDB other
Consider what happened to Stak verse MS.
Stak won the court case but still went out of business.
-Original Message-
From: David Fetter [mailto:[EMAIL PROTECTED]
Sent: Monday, October 10, 2005 11:17 AM
To: Marc G. Fournier
Cc: Dann Corbit; snacktime; pgsql-general@postgresql.org
How about something like:
CREATE DOMAIN unsigned_small AS smallint check (VALUE = 0)
CREATE DOMAIN unsigned_int AS integer check (VALUE = 0)
CREATE DOMAIN unsigned_big AS bigint check (VALUE = 0)
The objection might be that we lose one bit of field width.
But the extra safety is probably worth
Rough English request translation:
We are 5th year students studying
computer engineering, we want to have information concerning advanced relational
data modeling and the manipulation of the abstract types from data by the
postquel language and the postgres system. We are need of your
SELECT COUNT(*) FROM table_name;
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of vittorio
Sent: Tuesday, October 18, 2005 10:29 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Number of rows of a table
Using psql how can I
I use ER/Win for that. There are some other tools too. Search the
archives.
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Bruno Cochofel
Sent: Tuesday, October 18, 2005 8:16 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL]
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Marc G. Fournier
Sent: Wednesday, October 19, 2005 9:02 AM
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
On Wed,
From the ANSI/ISO SQL Standard:
3) The comparison of two character strings is determined as follows:
a) Let CS be the collating sequence indicated in Subclause 4.2.3,
''Rules determining collating sequence usage'', based on the declared
types of the two character strings.
b) If the length in
This might be handy:
http://www.databasejournal.com/img/email_val.sql
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Andrus
Sent: Wednesday, October 19, 2005 11:12 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Select all
Yes, clearly that is the wrong result according to the SQL standard.
Here is a SQL*Server query:
select 1 where 'a' = 'a ' AND 'a' = 'a ' AND 'a ' = 'a '
It returns (correctly): 1
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 12:39 PM
To: Dann Corbit
Cc: Marc G. Fournier; [EMAIL PROTECTED]; pgsql-
[EMAIL PROTECTED]
Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
On Wed, 19 Oct 2005, Dann
Would you want varchar(30) 'Dann Corbit' to compare equal to bpchar(30)
'Dann Corbit'?
I would.
If both are considered character types by the language, then they must
compare that way.
Perhaps there are some nuances that I am not aware of. But that is how
things ought to behave, if I were
a space. Is that the case for PostgreSQL? Even
if it is, is seems truly bizarre that the NO PAD attribute would be
applied to string constants.
-Original Message-
From: Marc G. Fournier [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 12:53 PM
To: Dann Corbit
Cc: Stephan Szabo
: Terry Fielder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 1:39 PM
To: Dann Corbit
Cc: Marc G. Fournier; [EMAIL PROTECTED]; pgsql-
[EMAIL PROTECTED]
Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
I agree with you, but...
Actually that's not how the compare
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Doug Quale
Sent: Wednesday, October 19, 2005 1:10 PM
To: pgsql-general@postgresql.org
Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
Marc G. Fournier [EMAIL PROTECTED]
To: Dann Corbit
Cc: Marc G. Fournier; [EMAIL PROTECTED]; pgsql-
[EMAIL PROTECTED]
Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
Hi Dann
Without looking at the internals to see if the 1 column or the other
is
being converted to the other columns type before the compare
of it.
-Original Message-
From: Tino Wildenhain [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 1:05 PM
To: Marc G. Fournier
Cc: Dann Corbit; [EMAIL PROTECTED]; pgsql-
[EMAIL PROTECTED]; pgsql-general@postgresql.org
Subject: Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] [GENERAL
-Original Message-
From: Terry Fielder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 2:05 PM
To: Dann Corbit
Cc: Tino Wildenhain; Marc G. Fournier; [EMAIL PROTECTED];
pgsql-hackers@postgresql.org; pgsql-general@postgresql.org
Subject: Re: 'a' == 'a ' (Was: RE: [pgsql
less than any string under CS.
It boils down to saying NO PAD strings of different length are never
equal. So the correctness of any DB depends on whether the type in
question has the NO PAD characteristic. So, is varchar NO PAD?
That's
the real question.
Rick
Dann Corbit [EMAIL
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 2:34 PM
To: Dann Corbit
Cc: Terry Fielder; Tino Wildenhain; Marc G. Fournier;
[EMAIL PROTECTED]; pgsql-hackers@postgresql.org; pgsql-
[EMAIL PROTECTED]
Subject: Re: [HACKERS
-Original Message-
From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 2:46 PM
To: Dann Corbit
Cc: Terry Fielder; Tino Wildenhain; Marc G. Fournier;
[EMAIL PROTECTED]; pgsql-hackers@postgresql.org; pgsql-
[EMAIL PROTECTED]
Subject: Re
a
blockhead like me can comprehend it easily.
-Original Message-
From: Josh Berkus [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 5:06 PM
To: pgsql-hackers@postgresql.org
Cc: Dann Corbit; Stephan Szabo; Terry Fielder; Tino Wildenhain; Marc G.
Fournier; [EMAIL PROTECTED]; pgsql
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-hackers-
[EMAIL PROTECTED] On Behalf Of Greg Stark
Sent: Wednesday, October 19, 2005 11:17 PM
To: Tom Lane
Cc: Chris Travers; josh@agliodbs.com; pgsql-hackers@postgresql.org;
Dann
Corbit; Stephan Szabo; Terry Fielder; Tino
-Original Message-
From: Chris Travers [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 20, 2005 11:53 AM
To: Dann Corbit
Cc: Greg Stark; Tom Lane; Chris Travers; josh@agliodbs.com; pgsql-
[EMAIL PROTECTED]; Stephan Szabo; Terry Fielder; Tino Wildenhain;
Marc G. Fournier; [EMAIL
, 2005 12:53 PM
To: Dann Corbit
Cc: pgsql-hackers@postgresql.org; pgsql-general General
Subject: Re: [GENERAL] [HACKERS] 'a' == 'a '
[Removed all the non-list addresses]
Dann Corbit wrote:
Let me make something clear:
When we are talking about padding here it is only in the context
Interesting article:
http://coveryourasp.com/ValidateEmail.asp
See also:
http://search.cpan.org/~cwest/Email-Address-1.80/lib/Email/Address.pm
http://www.faqs.org/rfcs/rfc2822.html
http://docs.python.org/lib/module-rfc822.html
-Original Message-
From: [EMAIL PROTECTED]
What exactly do those messages say?
How are you using the functions?
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Bob Pawley
Sent: Wednesday, October 26, 2005
11:42 AM
To: Postgre General
Subject: [GENERAL] Postgresql 8
I am running version 8 on
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of John DeSoi
Sent: Wednesday, October 26, 2005 12:03 PM
To: Bob Pawley
Cc: Postgre General
Subject: Re: [GENERAL] Postgresql 8
On Oct 26, 2005, at 2:41 PM, Bob Pawley wrote:
I am
PostgreSQL has Information Schema
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Patrick Hatcher
Sent: Wednesday, November 02, 2005 3:39 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Data Dictionary generator?
I need
If you only need a cardinality estimate, then pg_class.reltuples may be
of help (it will be accurate to when the last vacuum was performed).
If you need exact counts then there are a couple of problems:
1. An MVCC database cannot store an exact count, because it can differ
by user. Hence, to
PostgreSQL has both array and point data types.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Link to documentation:
http://www.postgresql.org/docs/8.2/interactive/datatype-geometric.html#A
EN5367
-Original Message-
From: Dann Corbit
Sent: Wednesday, March 28, 2007 4:42 PM
To: 'Tom Brown'; pgsql-general@postgresql.org
Subject: RE: [GENERAL] inserting 4800 records at a time
Just do a union and return the min
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Lorenzo Thurman
Sent: Monday, April 09, 2007 7:32 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] NEWBIE: How do I get the oldest date contained
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Rich Shepard
Sent: Tuesday, May 01, 2007 10:42 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] CHECK() Constraint on Column Using Lookup Table
I've seen the syntax for using
For postal addressing, this is a really good reference site:
http://www.columbia.edu/kermit/postal.html
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Have you done a vacuum on the table recently?
I would be curious to see how:
select stuff from table
where index_key = key1 AND non_index_row in ('xyz','abc','def')
UNION ALL
select stuff from table
where index_key = key2 AND non_index_row in ('xyz','abc','def')
...
UNION ALL
select stuff from
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Ashish Karalkar
Sent: Wednesday, May 09, 2007 1:36 AM
To: Andrej Ricnik-Bay; Ron Johnson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Views- Advantages and Disadvantages
-Original Message-
From: Michael Glaesemann [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 09, 2007 12:14 PM
To: Dann Corbit
Cc: Ashish Karalkar; Andrej Ricnik-Bay; Ron Johnson; pgsql-
[EMAIL PROTECTED]
Subject: Re: [GENERAL] Views- Advantages and Disadvantages
On May 9, 2007
: SHA1
On 05/09/07 15:18, Dann Corbit wrote:
[snip]
That is a significant achievement, since many database systems do
not
have that ability.
Maybe (probably!) back in the Oracle 6 days, but cost-based
optimizers have done this for *years*.
I work mostly with legacy database systems, so
SELECT '1st Query' as whichone, col1, col2, col3 from table1
UNION
SELECT '2ND Query' as whichone, col1, col2, col3 from table2
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Robert James
Sent: Thursday, May 17, 2007 12:11 PM
To:
In SQL*Server it is called UPDATE STATISTICS
http://msdn2.microsoft.com/en-us/library/ms187348.aspx
Oracle tuning is a lot more fiddly:
http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci121
3646,00.html
From: [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Lew
Sent: Tuesday, May 29, 2007 6:38 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] optimisation for a table with frequently used
query
danmcb wrote:
SELECT * from
Try using COPY instead of insert select, if that is possible for you.
It is much faster than insert.
Otherwise, you might try dropping the index and constraint, loading the
data, and recreating the index and constraint.
From: [EMAIL PROTECTED]
Where is your actual copy statement?
What is your field delimiter?
Why not post the actual C code for your program, if it is not too long?
I guess from what you have posted that the delimiter you supplied does not
match the delimiter from your copy statement.
-Original Message-
From:
If I create a binary cursor on a recent version of PostgreSQL, how can I
tell if the timestamp data internally is an 8 byte double or an 8 byte
integer?
I see an #ifdef that changes the code path to compute timestamps as one
type or the other, but I do not know how to recognize the internal
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 11, 2007 1:11 PM
To: Dann Corbit
Cc: [EMAIL PROTECTED]; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dumb question about binary cursors and
#ifdefHAVE_INT64_TIMESTAMP
Dann Corbit
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 11, 2007 1:11 PM
To: Dann Corbit
Cc: [EMAIL PROTECTED]; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dumb question about binary cursors and
#ifdefHAVE_INT64_TIMESTAMP
Dann Corbit
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Howard Cole
Sent: Tuesday, December 11, 2007 2:21 PM
To: 'PgSql General'
Subject: Re: [GENERAL] Killing a session in windows
Hello everyone,
I take it from the lack of response that
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Ivan Sergio Borgonovo
Sent: Wednesday, January 09, 2008 1:30 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] count(*) and bad design was: Experiences with
extensibility
On Wed,
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of John Gateley
Sent: Monday, January 28, 2008 2:04 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Table has duplicate keys, what did I do
Somehow I have managed to have two
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Willem Buitendyk
Sent: Wednesday, January 30, 2008 1:15 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Oracle Analytical Functions
I'm trying to replicate the use of Oracle's
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of rrahul
Sent: Tuesday, March 11, 2008 6:48 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgre vs MySQL
Hi,
I am a database professional but have never used Postgre. My
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Albe Laurenz
Sent: Tuesday, March 18, 2008 1:24 AM
To: AlannY *EXTERN*; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Get index information from information_schema?
AlannY wrote:
-Original Message-
From: Erik Jones [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2008 11:51 AM
To: Dann Corbit
Cc: Albe Laurenz; AlannY *EXTERN*; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Get index information from information_schema?
On Mar 18, 2008, at 1:28 PM
___
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pettis, Barry
Sent: Monday, March 24, 2008 6:08 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Make MS Access UPDATE PostGre SQL Table
Note:
Generally, it is best to post in plain text,
A cardinality estimate function might be nice.
SELECT cardinality_estimate(table_name)
If it is off by 25% then no big deal.
It would be useful for the PostgreSQL query planner also, I imagine.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wes
Sent:
What queries are you running?
What sort of a machine are the database systems running on?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of lol
Sent: Tuesday, January 11, 2005 6:47 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL 8 on
You might find something useful here:
http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_suite/
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruno Tenorio Avila
Sent: Monday, January 10, 2005
9:09 PM
To: pgsql-general@postgresql.org
Subject:
Title: Open Source Database Opportunity
A web search turned this stuff up:
http://www.linuxlinks.com/local/business/databases.shtml
http://www.3asoft.com/article/10210.html
http://www.eweek.com/article2/0,1759,1433850,00.asp
I am sure you can find plenty more with a
few well directed
Look at the SQL in the PG Admin III
project source code base.
http://www.pgadmin.org/
Its non-trivial SQL to collect all
the information about a table.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Ken Tozier
Sent: Tuesday, January 18, 2005
9:15 PM
To:
' AND c.oid = i.indrelid AND i.indexrelid
= c2.oid
ORDER BY c2.relname
*
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 19, 2005 12:29 AM
To: Dann Corbit
Cc: Ken Tozier; PostgreSQL
Subject: Re: Getting table metadata
Once per day dump database to disk.
Once per day do a vacuum full.
That should be plenty.
Since there are 1440 minutes per day, you are only looking at 288
transactions per day. Not exactly a taxing transaction load.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Yes, autovacuum is better.
I am a fossil from 7.1.3 days.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 19, 2005 2:10 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.org; [EMAIL PROTECTED];
Mark
Subject: Re: [GENERAL] need an advice
1 - 100 of 345 matches
Mail list logo