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]> wri
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
> -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:
>
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.
http://scholar.google.com/scholar?hl=en&lr=&safe=off&q=Marcel+Kornacker+Access+Methods+for+Next-Gener
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 release?
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. Settin
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 nee
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:
> > > http://archives.postgresql.org/p
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, 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 leve
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
"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 yo
[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
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 m
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 cl
> -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; Te
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
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
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.
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 9
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, 2
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
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 seco
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:
12:57:52
> -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; [EM
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. stor
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 wantin
> -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; Ti
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 input query word(i know it is also convert to signatures) know itself is the word which is in the " 0010101101..."
HELP
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 aff
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 h
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
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
b
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 h
[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
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 = n
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 value,
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 s
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 t
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 th
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 PR
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 inver
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
database
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 ne
沈一枫 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 I
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.
http://www.postgresq
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 a
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 kn
49 matches
Mail list logo