Tom Lane [EMAIL PROTECTED] writes:
Chris Travers [EMAIL PROTECTED] writes:
If I understand the spec correctly, it seems to indicate that this is
specific to the locale/character set.
The spec associates padding behavior with collations, which per spec are
separate from the datatypes ---
Am Mittwoch, den 19.10.2005, 22:04 +0200 schrieb Tino Wildenhain:
Am Mittwoch, den 19.10.2005, 16:29 -0300 schrieb Marc G. Fournier:
I'm CC'ng this over to -hackers ... Tom? Comments?
...
Then we are broken too :)
# select 'a ' = 'a ';
?column?
--
f
(1
HI
I am a new developer and will be trying my habd for the first time at
trying to develop in the open source community.
In postres for some reason its not possible to choose a file structure
while we are creating tables!!! It is possibel while making an index. The
reason might be that we dont
Dann Corbit wrote:
I can see plenty of harm and absolutely no return. We are talking about
blank padding before comparison. Do you really want 'Danniel '
considered distinct from 'Danniel ' in a comparison? In real life,
what does that buy you?
100% YES!
If two values are the same, then
Varun Shingal wrote:
HI
I am a new developer and will be trying my habd for the first time at
trying to develop in the open source community.
Excellent - you might want to check the roadmap/todo list - that lets
you know what features people would like/hope to work on.
沈一枫 wrote:
the basic structures to implement the index is :
1.B- tree or the alike.
2.hash structures
Not only. R-tree, SS-tree, kd-tree, RD-tree etc
So the question is arise:In the tsearch2 model, I thought the general
access method is GiST tree, a tree this like B- tree.
But when
Hello
I found relative good thesis about job scheduling
http://hristov.com/master_thesis_final.pdf
it's implementation j.s. for mysql5. It's can be usefull for somebody
best regards
Pavel Stehule
_
Citite se osamele? Poznejte
Hi ,
This is first time I am trying to do development on POSTGRES.
I am trying to build multi-relational indices. So that when user enters
keyword he will get in which relation in which tuple this keyword occured.
This is also known as inverted indices. I am thinking of adding Index at
On Thu, Oct 20, 2005 at 02:53:39PM +0530, Ajay wrote:
This is first time I am trying to do development on POSTGRES.
I am trying to build multi-relational indices. So that when user enters
keyword he will get in which relation in which tuple this keyword occured.
This is also known as inverted
I think it is a good idea to make the exported symbols clearer.
We should only export the symbols needed. The
output of dlltool --export-all is too big.
AFAIK, we can generate *.def for Win32/MSVC++
from a text file like this.
PQclear
PQfn
FooGlobalData DATA
Neil Conway [EMAIL
On Thu, Oct 20, 2005 at 06:20:37PM +0800, William ZHANG wrote:
I think it is a good idea to make the exported symbols clearer.
We should only export the symbols needed. The
output of dlltool --export-all is too big.
AFAIK, we can generate *.def for Win32/MSVC++
from a text file like this.
Dann Corbit wrote:
Try this query in Oracle, SQL*Server, DB/2, Informix, etc.:
connxdatasync=# select 1 where cast('a' as varchar(30)) = cast('a ' as
varchar(30));
?column?
--
(0 rows)
I see how you can interpret the SQL Standard to make the above response
a correct one. But is it
Tino Wildenhain wrote:
Then we are broken too :)
# select 'a ' = 'a ';
?column?
--
f
(1 row)
experiment=# SELECT 'a '::char = 'a '::char;
?column?
--
t
This does't show anything useful, because the ::char casting simply
takes the first char of any
I want to correlate two index rows of different tables to find an
offset so that
table1.value = table2.value AND table1.id = table2.id + offset
is true for a maximum number of rows.
To achieve this, I have the two tables and a table with possible
offset values and execute a query:
SELECT
Hi
,
I need to insert in one
database archives JPG. I am using C++Builder. How I could make
this?
I created the following
table:
CREATE TABLE
tbimagens( callid numeric(11) , imagem bytea)
E I try to insert given of
the following form:
TQuery
*q; q = new
[EMAIL PROTECTED] writes:
I receive the mesagem from error: Key violation. ERROR: type lo does not
exist.
Have you installed the 'contrib/lo' module that creates that type?
-Doug
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On 10/20/2005 2:17 AM, Greg Stark wrote:
(I can't believe anyone really wants varchar to be space padded. Space padding
always seemed like a legacy feature for databases with fixed record length
data types. Why would anyone want a string data type that can't represent all
strings?)
They must
Hi all,
I tried changing the sleep command in the script to 2, but at boot it
still says [FAILED].
even though the script reports it failed, the db is up an running.
System is a Compaq DL380(2.5gb ram 2.4 dual 2.4gzh Xeon) running CentOS 4.2
I am going to install 8.1beta 3 on another box that
Tony Caduto [EMAIL PROTECTED] writes:
I tried changing the sleep command in the script to 2, but at boot it
still says [FAILED].
even though the script reports it failed, the db is up an running.
This seems to happen for some people and not others. I've been wanting
to find out how the heck
Katherine Stoovs [EMAIL PROTECTED] writes:
There must be something
wrong in the planning parameters after all if a plan that is slower by
a factor of tens or hundreds becomes estimated better than the fast
variant.
Instead of handwaving, how about showing us EXPLAIN ANALYZE results for
both
Dann Corbit wrote:
Try this query in Oracle, SQL*Server, DB/2, Informix, etc.:
connxdatasync=# select 1 where cast('a' as varchar(30)) = cast('a ' as
varchar(30));
?column?
--
(0 rows)
For what it's worth, on Sybase ASE I get:
---
1
(1 row affected)
the tsvectors turned to be the signatures and the signature is composed of binary code"0 OR 1", for such a long " 0010101101..." , how does the user inputquery word(i know it is also convert to signatures) know itself is the word which is in the " 0010101101..."
HELP
想 要
Tom Lane wrote:
Tony Caduto [EMAIL PROTECTED] writes:
I tried changing the sleep command in the script to 2, but at boot it
still says [FAILED].
even though the script reports it failed, the db is up an running.
This seems to happen for some people and not others. I've been wanting
-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
Dann Corbit wrote:
Let me make something clear:
When we are talking about padding here it is only in the context of a
comparison operator and NOT having anything to do with storage.
IIrc, varchar and bpchar are stored in a similar way, but are presented
differently when retrieved. I.e.
Tony Caduto [EMAIL PROTECTED] writes:
Tom Lane wrote:
Are you willing to try strace'ing the postmaster?
I added the strace line like you said and rebooted, it did display the
[FAILED] after the reboot.
Thanks for collecting the raw data. The salient events seem to be these:
-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
Tom Lane wrote:
In short: pg_timezone_initialize() took about 8.2 seconds out of the
total time of 8.73 seconds.
Since pg_timezone_initialize() needs to scan all of the 500-odd files
under postgresql/share/timezone/, it isn't so surprising that it would
take a little bit of time. But 8
Andrew Dunstan [EMAIL PROTECTED] writes:
Tom Lane wrote:
In short: pg_timezone_initialize() took about 8.2 seconds out of the
total time of 8.73 seconds.
Further data points:
I just observed this taking over 20 seconds on my clunky old pII 266.
That's really horrible. But pg_ctl -w start
Look back in the stack and you will find that I have quoted chapter and
verse (see the attached html file in a previous email that I sent).
This is in relation to the comparison operator.
-Original Message-
From: John D. Burger [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 20,
On Tue, 2005-10-18 at 12:24 -0600, Robert Creager wrote:
Robert Creager [EMAIL PROTECTED] wrote:
Simon Riggs [EMAIL PROTECTED] wrote:
Please try this patch and see if it reduces the CS storm:
Sorry, didn't work. Took about an hour, and now it's now at the CS storm
(averaging 94k). I've
Tom Lane wrote:
So there's some Heisenberg effect here. However, I don't think there
can be much doubt that on a machine that is just booting (and has
surely got none of these files in cache) the search through
share/postgresql/timezone could take a few seconds. Hindsight is
always 20/20
Chris Travers [EMAIL PROTECTED] writes:
IIrc, varchar and bpchar are stored in a similar way, but are presented
differently when retrieved. I.e. storage is separate from presentation
in this case. I.e. the padding in bpchar occurs when it is presented
and stripped when it is stored.
This
On Thu, 20 Oct 2005 21:19:18 +0100
Simon Riggs [EMAIL PROTECTED] wrote:
Try this to recreate the problem:
http://archives.postgresql.org/pgsql-performance/2004-04/msg00280.php
Yup, that does it. Three hits the level I see with my application ~100k. Two
hits about 50k, one does nothing (
On 2005-10-20, Douglas McNaught [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] writes:
I receive the mesagem from error: Key violation. ERROR: type lo does not
exist.
Have you installed the 'contrib/lo' module that creates that type?
If he's using bytea columns, then he doesn't want that.
Most
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Thursday, October 20, 2005 2:12 PM
To: Tom Lane
Cc: Chris Travers; Dann Corbit; Greg Stark; josh@agliodbs.com; pgsql-
[EMAIL PROTECTED]; pgsql-hackers@postgresql.org; Marc G.
Fournier;
Stephan Szabo; Terry
Andrew Dunstan [EMAIL PROTECTED] writes:
Something is surely wrong in the timezone lib, though:
[ digs in glibc sources for awhile... ]
The test loop in score_timezone() calls both localtime() and strftime()
for each probe point, and in glibc strftime() calls tzset(), which the
source code
Robert Creager [EMAIL PROTECTED] writes:
Interesting. 7.4.1 is worse for this test, as two jump up to 130k. But, my
app
runs fine against 7.4.1...
Would it still be helpful to try and pull together a test case from my app
against 8.1beta3?
Yes, if you can show a case where 8.1 is much
[EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] wrote on 10/20/2005 03:11:23 PM:
The hard part would be in figuring out how
the output routine could know how many spaces to add back.
The length is in the metadata for the column, or am I being dense?
The output routine hasn't got access
Dann Corbit [EMAIL PROTECTED] writes:
I guess that additional ambiguity arises if you add additional spaces to
the end. Many database systems solve this by trimming the characters
from the end of the string upon storage and the returned string will not
have any trailing blanks.
Can you
On Wed, 2005-10-19 at 14:07 -0700, Mark Wong wrote:
This isn't exactly elegant coding, but it provides a useful improvement
on an 8-way SMP box when run on 8.0 base. OK, lets be brutal: this looks
pretty darn stupid. But it does follow the CPU optimization handbook
advice and I did see
On Thu, 2005-10-20 at 14:59 -0600, Robert Creager wrote:
On Thu, 20 Oct 2005 21:19:18 +0100
Simon Riggs [EMAIL PROTECTED] wrote:
Try this to recreate the problem:
http://archives.postgresql.org/pgsql-performance/2004-04/msg00280.php
Yup, that does it. Three hits the level I see with
Martijn van Oosterhout wrote:
You can't do a pclose in a signal handler, it's not one of the
reeentrant safe functions and could lead to deadlocks. The signal
manpage documents the ones you can use. Just set a flag. Setting the
descriptor to NULL is worse because then we have check before
On Thu, 20 Oct 2005 23:28:21 +0100
Simon Riggs [EMAIL PROTECTED] wrote:
On Thu, 2005-10-20 at 14:59 -0600, Robert Creager wrote:
On Thu, 20 Oct 2005 21:19:18 +0100
Simon Riggs [EMAIL PROTECTED] wrote:
Try this to recreate the problem:
I wrote:
Possibly the glibc boys would listen to a suggestion that strftime()
need not force the file recheck, but my experience with them is that
they're relatively impervious to suggestions :-(
I've filed a bug for this:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=171351
so no need
On Thu, Oct 20, 2005 at 03:42:10PM -0700, Kevin Brown wrote:
Martijn van Oosterhout wrote:
You can't do a pclose in a signal handler, it's not one of the
reeentrant safe functions and could lead to deadlocks. The signal
manpage documents the ones you can use. Just set a flag. Setting the
I see that new timezone data is available at
ftp://elsie.nci.nih.gov/pub/
It looks like the only changes from PostgreSQL's current data involve
Kyrgyzstan and Uruguay. What's the policy on keeping the source
code up to date? Does the data change too often to bother except
just before a
Tom, I also notice that the link I put in ages ago to Kornacker's thesis
is now defunct :(
(GiST indexes Introduction)
A quick search of Google Scholar finds it hosted on Oleg Teodor's site.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 20, 2005 2:54 PM
To: Dann Corbit
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-
[EMAIL PROTECTED]
Subject: Re: [GENERAL] [HACKERS] 'a' == 'a '
Dann Corbit [EMAIL PROTECTED] writes:
I guess
Martijn van Oosterhout wrote:
AIUI, we *do* limit the symbols for Windows (for libpq anyway, see
exports.txt file) we just don't for UNIX since it can't be done
portably. I posted a patch to -patches which does it for Linux and in
principle any platform using GCC but there's no consensus on
Dann Corbit wrote:
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 20, 2005 2:54 PM
To: Dann Corbit
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-
[EMAIL PROTECTED]
Subject: Re: [GENERAL] [HACKERS] 'a' == 'a '
Dann Corbit [EMAIL PROTECTED]
51 matches
Mail list logo