Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 01, 2004 5:53 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Get diagnistic (row_count) 7.3 vs. 7.4 changes
>
>
> Maksim Likharev <[EMAIL PROTECTED]> writes:
> > consider
Hi,
Just trying 7.4.5 and bumped into a problem.
consider following code:
CREATE OR REPLACE FUNCTION rowcount_test() RETURNS bigint AS '
DECLARE
base_hits bigint;
BEGIN
CREATE TEMP TABLE ltbl_temp AS SELECT 1 AS data;
GET DIAGNOSTICS base_hits = ROW_COUNT;
RETURN base_hits;
E
You mean
"My queries are slow or don't make use of the indexes. Why?"
may be better just fix that stone age requirement?
It just ridicules,
could statistic be build during index build, if no statistic available?
-Original Message-
From: Karsten Hilbert [mailto:[EMAIL PROTECTED]
Sent:
>Don't think of this as a troll, because I really don't know, even
>though I do know that MVS, OpenVMS & Solaris can. (I won't even
>ask about toys like Windows and FreeBSD.)
What so toy in Windows?
With some experience on huge DBs,
one on Windows ( MS SQL 2K ) works x1.5/2 faster, than one on L
y exercise will be even
considered by core team...
So guess not really an answer
-Original Message-
From: Dennis Gearon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 11:00 AM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Sorting Problem
total agreement,
If you are talking about everything that lies under so called LATIN-1 (
ISO-8859-1 )
en_US encapsulates ( at least suppose to ) all those sorting rules,
do not remember about accents tho.
-Original Message-
From: Kathy zhu [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 4:43 PM
en_US locale skips? punctuation from sorting index,
so in your case
RM-791
RM-AV2100
RM-PP401
RM-PP402
RM-PP404
RM-V10
RM-V11
RM-V12
RMT-D10
RMT-D108A
RMT-D109A
RMT-D116A
RMT-V402
==>
RM791
RMAV2100
RMPP401
RMPP402
RMPP404
RMV10
RMV11
RMV12
RMTD10
RMTD108A
RMTD109A
RMTD116A
RMTV402
-Origina
prod.t_results.docid =
r.docid;
BTW, what it's doing in a first place, looks up tuples generated in FROM
clause
against prod.t_results table?
-Original Message-
From: Mike Mascari [mailto:[EMAIL PROTECTED]
Sent: Friday, July 25, 2003 5:25 PM
To: Maksim Likharev
Cc: Stephan Szabo; pgsql-ge
docid;
is standard SQL-92 update FROM form?
just trying to understand.
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: Friday, July 25, 2003 4:12 PM
To: Maksim Likharev
Cc: pgsql-general
Subject: Re: [GENERAL] Wacky query plan, why?
On Fri, 25 Jul 2003, Maksim Lik
data access.
-Original Message-
From: Luis Magaña [mailto:[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 2:43 PM
To: Maksim Likharev
Cc: Postgresql General Mail List
Subject: ODBC query problem AGAIN
Hi,
After having moved all of the data to a new database initializaed with
es_MX as locale
Yes it is most likely locale,
if you have core,
try to use on Solaris
pstack you_core_file, should be "pretty distinct" back trace
-Original Message-
From: Luis Magaña [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 11:06 AM
To: Andrew Sullivan
Cc: Postgresql General Mail List
Su
Forgotten to ask, what is locale for DB cluster?
-Original Message-
From: Luis Magaña [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 10:37 AM
To: Andrew Sullivan
Cc: Postgresql General Mail List
Subject: Re: [GENERAL] ODBC query problem
I've compiled postgresql in 32bit mode, a
It very much looks like a problem I had before
do you have back trace, I will say for sure.
-Original Message-
From: Luis Magaña [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 10:12 AM
To: Andrew Sullivan
Cc: Postgresql General Mail List
Subject: Re: [GENERAL] ODBC query problem
, NO WARRANTY, NO NOTHING, just for you information.
Regards.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 3:58 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG crash on simple query, story continues
&qu
Hi,
I just found very interesting situation,
statistic ( n_distinct in particular) records for one of my columns,
greatly under calculated it saying:
49726, but in reality 33409816.
So planer never choose index but rather using table scan, and query
never returns,
is it any way how I can improve
I would referrer dump that gar.xxg, and put PG on Linux,
but this is not up to me.
Thanks for the help.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 3:58 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG
m on SunOS 5.8,
BTW on Linux it works
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 11:45 AM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG crash on simple query, story continues
"Maksim Likharev
mlen + 1);
}
pfree(val);
val = xfrmstr;
}
-Original Message-
From: Maksim Likharev
Sent: Tuesday, July 08, 2003 9:35 AM
To: 'Tom Lane'
Cc: [EMAIL PROTECTED]; '[EMAIL PROTECTED]'
Subject: RE: [GENERAL] PG crash on simple query, story continues
main (2, ffbefccc, ffbefcd8, 2e9d88, 0, 0) + 2e4
00032da8 _start (0, 0, 0, 0, 0, 0) + 5c
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 29, 2003 3:25 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG crash on simple query
, 2003 3:59 AM
To: Alvaro Herrera; Maksim Likharev
Cc: PostgreSQL List
Subject: Re: [GENERAL] Datatypes and performance
First of all, disable FSYNC... that will speed things up a lot!
/M
- Original Message -
From: "Alvaro Herrera" <[EMAIL PROTECTED]>
To: "Maksim Likhar
char under 4K
if you want to read it fast.
Pretty useful detail, thank you.
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Friday, July 04, 2003 2:54 PM
To: Maksim Likharev
Cc: PostgreSQL List
Subject: Re: [GENERAL] Datatypes and performance
On Fri, Jul 04, 200
comparing with disk reads/writes.
-Original Message-
From: Andrew Sullivan [mailto:[EMAIL PROTECTED]
Sent: Friday, July 04, 2003 1:24 PM
To: PostgreSQL List
Subject: Re: [GENERAL] Datatypes and performance
On Fri, Jul 04, 2003 at 01:14:52PM -0700, Maksim Likharev wrote:
> How postg
How postgres internally stores text fields, in a separate table?
-Original Message-
From: Andrew Sullivan [mailto:[EMAIL PROTECTED]
Sent: Friday, July 04, 2003 12:55 PM
To: PostgreSQL List
Subject: Re: [GENERAL] Datatypes and performance
On Fri, Jul 04, 2003 at 09:10:41AM -0700, Jay O'Co
values, commit transaction.
(B
(B-Original Message-
(BFrom: Jean-Christian Imbeault [mailto:[EMAIL PROTECTED]
(BSent: Tuesday, July 01, 2003 5:47 PM
(BTo: Maksim Likharev
(BCc: [EMAIL PROTECTED]
(BSubject: Re: [GENERAL] Duplicate key insert question
(B
(B
(BMaksim Likharev wrote:
(B
Is there any way to see what really happened?
I mean more exhausted debug info.
It seems like other server running same PG 7.3 and more or less
identical hardware is not affected by that.
Info starts here:
--main table
CREATE TABLE prod.t_documents (
documentid int4 NOT NULL,
docid char(16)
Hi,
I have consistent PG crash on some query,
so I was able to isolate a simple query that crash postgres...
SELECT p.docid FROM prod.t_documents AS p
INNER JOIN t_tempdocs AS t
ON p.docid = t.docid
LEFT OUTER JOIN prod.t_refs AS ct
ON ct.docid = p
Thanks Tom,
works, have to test performance
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 7:36 AM
To: Maksim Likharev
Cc: GENERAL
Subject: Re: [GENERAL] Query plan question
"Maksim Likharev" <[EMAIL PROTECTED]> write
27 matches
Mail list logo
